We want to put our whole database on a cd. Once it starts we want the navagation form to pop up so the user can enter their information. Can anybody guide us on how we can do something like this or give us info on how to. Please and Thank you.
We want to put our whole database on a cd. Once it starts we want the navagation form to pop up so the user can enter their information. Can anybody guide us on how we can do something like this or give us info on how to. Please and Thank you.
Where would the data entered by user be saved? Couldn't be back to the CD. A USB flash drive is another matter.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
How could we do this by flash drive then? So it looks professional.
You want to automatically open Access database when disc or drive is read by computer? Never seen this. Review http://www.samlogic.net/articles/aut...lash-drive.htm
If the data is on disc or drive then it is not shared. Is this what you want? Only one person at a time entering data then pass the drive to someone else? Hope you have backup of the file somewhere.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
If we do this will the table, queries, and forms be on the side? We just want the form screen to be present.
Be on what 'side'? Is this a split database? This thread describes how I manage a split database http://forums.aspfree.com/microsoft-...ue-323364.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
We figured out what we needed to make it look more professional. We just had to go under file then go to options, then click current database and deselect what we did not need.
I just have 2 more questions. Is there any way a navigation form can show up without any records already in it. In our navigation form the person with id#1 keeps displaying. Also is there any way would could add an error message if someone has used an id number already?
One way is to set the form DataEntry property to Yes.
These ID numbers are not generated by an autonumber field?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thank you that worked! No the ID numbers are not generated by an autonumber field, just a number field.
Autonumber field not an option for this ID? Generating custom unique ID means code and can be tricky in a multi-user database. Common topic, search form and Google.
Here is one https://www.accessforums.net/forms/a...rms-14756.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.