Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. owens2k

    Bypass shift key

    i added the referance now i get type missmatch.
  2. owens2k

    Bypass shift key

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

    Bypass shift key

    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?
  4. owens2k

    Backing up my database...

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

    Backing up my database...

    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
  6. owens2k

    Backing up my database...

    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
  7. owens2k

    Backing up my database...

    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...
  8. owens2k

    Backing up my database...

    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?
  9. owens2k

    Backing up my database...

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

    Backing up my database...

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

    Delete Query Question

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

    Delete Query Question

    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!
  13. owens2k

    Delete Query Question

    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...
  14. owens2k

    Delete Query Question

    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...
  15. owens2k

    Delete Query Question

    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...
  16. owens2k

    Delete Query Question

    i am trying to delete some data but am having trouble. First of all i am appending data in tblCustomers where the field "end of stay" (in a different table (tblBookings)) equals the current date. Using the same SQL in a new query but changing the query to a delete query, should in...
  17. owens2k

    Where am i going wrong with this?

    im trying to achieve a command button which copies a record from one table to another and then deletes the original once it has been copied. The code i have used is as follows: ------------------------------------------------------- Dim strSQL As String strSQL = "Insert Into tblresults...
  18. owens2k

    copying records from one table to another?

    does anybody know how i can use a query or command button to copy a record from one table to the next at a given date? if its only possible without the given date bit then thats fine!. thanx

Part and Inventory Search

Back
Top