Results 1 to 11 of 11
  1. #1
    chibearsfan6 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    18

    Access Database Help

    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.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    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.

  3. #3
    chibearsfan6 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    18
    How could we do this by flash drive then? So it looks professional.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    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.

  5. #5
    chibearsfan6 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    18
    If we do this will the table, queries, and forms be on the side? We just want the form screen to be present.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    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.

  7. #7
    chibearsfan6 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    18
    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.

  8. #8
    chibearsfan6 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    18
    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?

  9. #9
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    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.

  10. #10
    chibearsfan6 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    18
    Thank you that worked! No the ID numbers are not generated by an autonumber field, just a number field.

  11. #11
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 09-06-2012, 09:50 AM
  2. Restricted Access on Access 2010 Navigation Form
    By need_help12 in forum Security
    Replies: 6
    Last Post: 05-02-2012, 10:35 AM
  3. Replies: 6
    Last Post: 02-18-2012, 07:20 AM
  4. Replies: 9
    Last Post: 08-07-2011, 11:21 AM
  5. Replies: 5
    Last Post: 03-11-2011, 10:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums