Replies

Thanks to you both. I used HansV’s instructions and all went well

I don’t understand why other usb 2.0 devices work and this one does not. Is there an explanation ? The Device manager shows 1 Enhanced controller – under the heading “Universal Serial Bus controllers” titled (VIA usb 2.0 Enhanced Host controller)

I don’t understand why other usb 2.0 devices work and this one does not. Is there an explanation ?

The disk Management just shows my internal hard drive, nothing else

I have numerous usb items , external drive, other flash drives (kensington 1 gig, and a 256 meg flash drive) , all work just fine.

USB 2

Thanks Hans. That does allow editing of the Excel file. I was hoping that it would open in the slide instead of opening Excel.If that is the only way … so be it.

Thanks Hans. I’ll do that.

Sorry, it’s a datasheet layout.

Hans,
There must be a difference in the placement of the wild cards * & . I had them after the input request, and you show them before. Works fine
Many thanks.

What I would like to do is enter the two digit year in the “like” box, and retreive all records in that year, even if the date in the field is 8/12/05, or 8/12/2005 How do I set up the qry to do that?

Will that code require the user to input the password, or will it automatically open the file without any further prompt? I need it to require an input

Private Sub Command106_Click()
On Error GoTo Err_Command106_Click

Dim stAppName As String

stAppName = “C:Documents and SettingsDadMy DocumentsSales Information.mdb”
Call Shell(stAppName, 1)

Exit_Command106_Click:
Exit Sub

Err_Command106_Click:
MsgBox Err.Description
Resume Exit_Command106_Click

End Sub

All I Get is an error message “Invalid Procedure call or argument”

Thanks Much. It Works Just like I planned Maybe sometime I’ll learn enough VB to be dangerous. Thanks again..

OK here it is.
1. When you open the DB, open the switchboard, choose “Data Entry Form”, You will be asked to enter a city, then a state.(this is no good)
hit enter both times. The form will open with the results shown in the subform. (this is good), Then click on the QRY button and hit enter both times. Instead of placing the results of the qry in the subform, another datasheet opens. (This is no good).
I would like to have the Data entry form open, then if needed, use the qry button and have the results appear in the subform.