Posts by debasisdas

try log in as

sys/ as sysdba
password----change_on_install

If you are planning to reinstall better use any advance version .
Current version for windows is 11.1

try something like this

rs.open "select count(student_id) from students where student_id=" & std_id

if it returns >0 then proceed further.

Try to use DELETESETTINGS to delete any entry from registry.

Are you sure a non-existing application is still running ?

do for the device that has inbuilt file locking system.

as already discussed you just need to use that as a plug play device like any keyboard.

what playable ?

all mp3 files are playable , if your usb drive is a player it will definately play the file.

are you talking about any application developed in VB 6.0 ?

do you have the password for sys or system account ?

do u know how to open a recordset in code by using SQL ?

there are number of tools for the purpose. Just use google with proper keyword for effective search.

that has nothing to do with database connection . check your other code.

you need to open the recordset by passing the value at runtime dynamically. Use count to find the number of records in the recordset. If it is >0 then process further else display your message box

You don't have the user name password ?

All things changes with the pass of the time but true love expands in the heart of the faithful.

Are you getting something like SQL WORKSHEET under application development ?

No

Have you ever shop lifted ?

unknown--->ignorance

skid

Just try adding a GROUP BY statement to your existing query.

Sorry, we do not solve home works /assignments here.

The error message is self explanatory.

Being lonely is not necessarily the same as being alone.

Try this sample code for taking backup and restore of access database

Dim DBTempSource As Database
Dim DBTempDestination As Database

Dim RecTempSource As Recordset
Dim RecTempDestination As Recordset

Sub MBackup()

Set FSO = CreateObject("Scripting.FileSystemObject")
On Error GoTo Errors
If OptBackup Then
    TxtRemarks = "Backup Started at " & Time
    TxtRemarks = TxtRemarks & vbCrLf & "Closing Connection ...!"
    GCnnGeneral.Close
    TxtRemarks = TxtRemarks & vbCrLf & "Checking Destination ...!"
    If GFileExists(TxtDestination) Then
        Kill TxtDestination
    End If
    
    TxtRemarks = TxtRemarks & vbCrLf & "Compacting Source ..."
    DBEngine.CompactDatabase TxtSource, TxtDestination, , , ";pwd=Debasis"
    TxtRemarks = TxtRemarks & vbCrLf & "Destination Created ...!"
    TxtRemarks = TxtRemarks & vbCrLf & "Connecting Database ...!"
    With GCnnGeneral
       .Provider = "Microsoft.Jet.OLEDB.4.0"
       .Properties("Jet OLEDB:Database Password") = "Debasis"
       .Mode = adModeReadWrite
       .Open App.Path & "\" & Trim(GFileName) & ".MDB"
    End With
    'GFileName = Trim(LstDatabase.Text)
    TxtRemarks = TxtRemarks & vbCrLf & "Backup Created at " & Time
    MsgBox "Backup Created."
    TxtSource = GEmptyStr
    TxtDestination = GEmptyStr
ElseIf OptRestore Then
    'GCnnAccts.Close
    TxtRemarks = "Restoring Data Started at " & Time
    GCnnGeneral.Close
    TxtRemarks = TxtRemarks & vbCrLf & "Connection Closed ...!"
    Kill TxtDestination
    TxtRemarks = TxtRemarks & vbCrLf & "Destination Checked ...!"
    Call FSO.CopyFile(TxtSource, TxtDestination, True)
    TxtRemarks = TxtRemarks & vbCrLf & "Data Restored ...!"
    With GCnnGeneral
       .Provider = "Microsoft.Jet.OLEDB.4.0"
       .Properties("Jet OLEDB:Database Password") = "Debasis"
       .Mode = adModeReadWrite
       .Open App.Path & "\" & Trim(GFileName) & ".MDB"
    End With
    TxtRemarks = TxtRemarks & vbCrLf & "Connection Complete ...!"
    TxtRemarks = TxtRemarks & vbCrLf & "Data Restored at " & Time
    MsgBox "Data Restored." …

I think you are trying to redefine SQL with your own bunch of syntax. What are those WHILE and WHEN in your code ?

What happens when you click on the parent node . Does it not open the child nodes with its icon ?

Most of the barcode scanners are plug and play devices and you do not need any extra driver to install. If you need one contact the vendor whose scanner/device you are using.

you should get correct output with your code. there is nothing wrong with it.

as the name is icon it needs to be an icon (*.ico) or a cursor (*.cur) file. The size/dimension of the file should be 32 x 32 pixels.

You need to pass unique values for the scheduled_num field.

schedule_num should be the PRIMARY KEY and semester should be having an UNIQUE constraint.

Try to use the insert statement in a procedure and use a SEQUENCE to generate the schedule_num.

what you get when you try the following

select purchase,sales,purchase-sales as balance from table_name

The winner’s wish is the loser’s command.

Love, a lovable insanity.

if you use timer at a particular time interval that will use a lot of system resources irrespective of any database changes.

Better use a refresh button , so that the use can get the updated list at their will.

then download some ebooks and go through that.

If their smile warms your heart, embrace eases you, and kiss distills all wrong done to man, then you know that you have found true love.

you want to build the database or the search functionality using any front end tool ?

True love is friendship caught on fire.

You can't disable the windows key.

It is always better to store the DB file in the application path and set the property of the control using code in the form load event.

You cannot plan the future by the past.

what the user is supposed to do after s/he logs in and gets the list of complaints.

If you simply want to display use any grid control for the purpose.

Then no need to copy the tables at all. simply open the recordset from access table and insert the same to mysql table using another connection.

You just need to store all the required file in specified folders before creating the setup and specify the same in the code as well. Next create the EXE from the file menu and then use the packager and deployment wizard to create the set up

I Love my God.
My Love is my God.

What exactly the existing product does .

You need to post more details.

you need to use some 3rd party tool for the purpose.

what exactly is a inbox that you are trying to create ?

Never take failure to your heart and never take success to your brain.

Weight your words before you speak them out.
They are the pearls of your life, Don't throw them; don't loose them for nothing.

Let us never negotiate out of fear; but let us never fear to negotiate.

Use the following if you want the same in PL/SQL code.

BEGIN
DBMS_OUTPUT.PUT_LINE(UTL_INADDR.GET_HOST_NAME); -- Local machine/host name
DBMS_OUTPUT.PUT_LINE(UTL_INADDR.GET_HOST_ADDRESS); -- IP address of host
END;

The above code works oracle version 10(g) onwards