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 derfloh 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. mabaulza

    COPY TABLE STUCTURE IN SQL

    Hi, does anyone know how to copy a Tables sturcture using SQL?!?!?!
  2. mabaulza

    RUN TIME ERROR '3197' ?!?!?!?!?!

    I have tried leaving the target DB open when i run the main DB, but still not luck. Thing is, this DB has been working perfectly right up until a few days before new year! would this have anything to do with the problem??
  3. mabaulza

    RUN TIME ERROR '3197' ?!?!?!?!?!

    Hey, I have a database that tracks and logs all work that we have in our department. when i try to save a record a runtime error '3197' appears, and when i click debug the following code is highlighted: DoCmd.TransferDatabase acExport, _ "Microsoft Access", _ "R:\Jobs...
  4. mabaulza

    RUN TIME ERROR '3044': ?!!?!?!??!

    Sorry, i missed out the last line of the error, the code is: DoCmd.TransferDatabase acExport, _ "Microsoft Access", _ "R:\HCP Finance Jobs Database\BACKUP.MDB", _ acTable, _ "TblJobList", _ "Backup_" & Format(Date, "mmddyyyy") & "_" & Format(time, "hhmmss")
  5. mabaulza

    RUN TIME ERROR '3044': ?!!?!?!??!

    Hey, Yes, i tried putting both the databses on my desktop and change the code to the new location for the backup and for some reason, exactly the same error comes up! (with exception for a different path, which now referes to the desktop location). The backup database works perfectly... alone...
  6. mabaulza

    RUN TIME ERROR '3044': ?!!?!?!??!

    I have ajobs database that tracks and logs all jobs. A database called 'backup' has been created which backups all the neccessary data. Now, when i save a form on the jobs database a runtime error '3044' appears saying "r:\job\backup.mdb isnt a valid path. Make sure th path is spelled correctly...
  7. mabaulza

    BOOTING OUT DATABASE USERS!!!!

    Great Thanks alot for all your contributions! They were all very helpful.
  8. mabaulza

    BOOTING OUT DATABASE USERS!!!!

    We have a multi user database system, and every now and then we need to perform maintainance on the database. It can only be done when no one is in the database. Is there any way of "booting out" these users by creating a button for admin users?
  9. mabaulza

    Login screen

    I have a login screen created by the follwing VBA coding on the command button: Private Sub cmdLogin_Click() 'Check to see if data is entered into the UserName combo box If IsNull(Me.cboEmployee) Or Me.cboEmployee = "" Then MsgBox "You must enter a User Name.", vbOKOnly...
  10. mabaulza

    Multi User login for Access 97

    I have a multi user DB with no login at the moment. There are 2 types of users, Admin (3 members of staff) Users (40+ staff). I would like for the users to input their personal login details and once accepted, for one form to automatically open and maximise (Request_form) but dont want them to...
  11. mabaulza

    Access 97 DBMS on XP machine.

    Thanks alot for your help lupins46. You advice was very helpful.
  12. mabaulza

    Access 97 DBMS on XP machine.

    I have a multi user DBMS on a windows 98 machine. Some of the users on the LAN have Windows XP with Access XP installed. Each time these users access the database from their machines, a dialogue box appears saying that the user has an older version of Access and tries to upgrade it. As most of...

Part and Inventory Search

Back
Top