Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

Geek Culture / Need MS Access help!

Author
Message
DJ Almix
19
Years of Service
User Offline
Joined: 25th Feb 2006
Location: Freedom
Posted: 16th Jun 2011 20:47 Edited at: 16th Jun 2011 20:55
Link
Hi,

I've never met anyone who can use access, and this is the geek forum, so I figure i'd ask here.

My employer wants me to create the following:

A data base that a user can sign into, check boxes relating to why there there and other options related to the user signing in. Then once they've entered it all in, then press accept and it dumps it all into a data file and resets itself for the next user. Eventually you would get a big data file of info as to why people where there, etc. like one giant sign in sheet, instead of manually entering in data from a piece of paper.

Basically, a digital sign in sheet, that I can access the data of who logged into it.

Any suggestions?

[center]
Back to top
Profile PM Email Website
Van B
Moderator
22
Years of Service
User Offline
Joined: 8th Oct 2002
Location: Sunnyvale
Posted: 16th Jun 2011 21:03
Link
That should be really straightforward. The form wizard can do it all, you could make a table with the fields you need, name etc, all the tick boxes as true/false fields. Then make a form based on the table, and add a button for creating a new record.

Once that's done, tidy things up, maybe set the form to data entry, so other records aren't shown. It is really easy to use though, you'd get it done in no time.

Health, Ammo, and bacon and eggs!
Back to top
Profile PM Email
DJ Almix
19
Years of Service
User Offline
Joined: 25th Feb 2006
Location: Freedom
Posted: 16th Jun 2011 21:30 Edited at: 16th Jun 2011 21:35
Link
So...I got to here:



,but how do I make a button to dump the data?

And..(sorry for all the questions), how do I make a drop down box with options? The box will ask for your location that your signing in and I want predefined locations.

[center]
Back to top
Profile PM Email Website
Kendor
22
Years of Service
User Offline
Joined: 31st Jan 2003
Location: Malta
Posted: 16th Jun 2011 23:30 Edited at: 16th Jun 2011 23:31
Link
As VanB mentioned, you need to set the Form as data entry (so that users won't see other records). In design view, select the form and under the Data Tab in properties, set "Data Entry" and "Allow additions" to Yes and the remaining to No.



For creating the buttons, there is the command button wizard. Once you create a button, the wizard will pop-up and under "Record Operations", there are the 2 functions you require: 1) "Save record" for saving 2) "Undo Record" for cancelling that record.


Attachments

Login to view attachments
Back to top
Profile PM Email Website
Back to top

Login to post a reply

Server time is: 2025-05-21 09:57:14
Your offset time is: 2025-05-21 09:57:14