& "'" & stafid.Text & "', " _
& "'" & rooid.Text & "', " _
& "'" & date1.Text & "', " _
& "'" & time1.Text & "', " _
& "'" & areq.Text & "')"
...

Am trying to print a report and also save it to a snapshot.

The problem is that it runs off a query which works off two date fields (user entry).

When I run it, it asks for the date twice,...

Thanks will try both

Should have explained what I was doing better.

Am running an update system over network to 2 remote TabletPC (when they get connected) been trying to show what was going...

Public sfso

Set sfso = CreateObject("Scripting.FileSystemObject")

If sfso.FileExists(RemoteDatabase) Then
If dbRemoteDatabase.State = 0 Then
dbRemoteDatabase.Open "Provider =...

is there a way to disconnect a user/s from a database and/or display a msgbox to the users telling them that there are about to be disconnected?

ms access 2003

Is there a way to enter a pause state between commands running?

Not completely sure what you exactly want.
Here is my code to disable some user input and enable other

Instead of keypress use keydown

Select Case KeyCode
Case 0 to 7
KeyCode = 0
Case...

Try to do 3 things.

The 1st see if a database exists in a certain location:
if it dose then connect.
else show error message.

The 2nd see if the database is open:
if open the display a...