Recent content by owens2k

i added the referance now i get type missmatch.

i get the error "user defined type not defined" and the text "db As Database" in my code gets selected

Does anybody know how i can make my database so that even if shift is held when it is opened the database window is not shown?

Bob i have done this. Is there no way to keep it hidden from the taskbar too whilst the database is open?

I ran the .bat through a shortcut AND the actual .bat file. What i mean is when i run the .bat file, Access opens my database but the cmd.exe window thing is in the background (minimized) Is there anyway where the user canot see this at all? -Sean

Bob my man, that works a treat! One more problem though, the command prompt box stays open as long as the database is open, is there anyway of having it not open or hiding it at least? Many thanks -Sean

You're welcome! - I'm at home on eastern time, now. How about this: I see the path to your database, where do you want the backup copy to end up? It has to be a different folder, otherwise it would just try to overwrite the original. Also, use Windows Explorer to find out exactly where you...

Hey man i really do appretiate the help! I can get the bat file to run my database but not copy it on exit. my txt file b4 i renamed it to a bat file read "C:\Documents and Settings\Sean Owens\My Documents\Copy of Recipe collection database.mdb" XCopy where am i going wrong?

sorry im new to all this!! how in the heck would i go about doing this. I wouldnt even know where to start!

Is there a way that i can have my database be backed up to a certain directory everytime it is closed?

now i get "syntax error (missing operator) in query expression 'tblCustomers.Customer ID'"

im getting the same error still. Maybe i should rename my fields so that there are no spaces. Although this may mess up the rest of my database!

there is a space in customer ID should i get rid of the space? there are also spaces in the field "end of stay" i now tried... DELETE * FROM tblCustomers WHERE tblCustomers.Customer ID in (SELECT tblCustomers.Customer ID FROM tblCustomers INNER JOIN tblBookings ON...

i used delete FROM tblcustomers WHERE tblcustomers.customer id in (SELECT tblcustomers.customer id FROM tblCustomers INNER JOIN tblbookings ON tblCustomers.Customer ID = tblbookings.CustomerID where tblbookings.endofstay=#1/2/97#); and it says missing syntax. also wouldnt this only filter...

Well the SQL is the same as the append query except its a delete query, but i keep gettin an error for some reason. Here is my SQL DELETE tblCustomers.*, tblBookings.[End of stay] FROM tblCustomers INNER JOIN tblBookings ON tblCustomers.[Customer ID] = tblBookings.[Customer ID] WHERE...