Zermoth

[CODE]& "'" & stafid.Text & "', " _ & "'" & rooid.Text & "', " _ & "'" & date1.Text & "', " _ & "'" & time1.Text & "', " _ & "'" & areq.Text & "')"[/CODE] rename rooid.Text to roomid.Text also stafid.Text to staffid.Text if thats not the …

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, there by eliminating my backup of the file. There only …

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

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 message to the users that they are going to get disconnected. pause …

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

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 Is = 8 KeyCode = KeyCode Case 9 to 31 KeyCode = 0 Case 32 …