introduction access training - default value access

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » introduction access training - Default value in Access

introduction access training - Default value in Access

resolvedResolved · Low Priority · Version Standard

Sabine has attended:
Access Intermediate course

Default value in Access

Hi, How can i get the default value in the column "input by" to pick up from the computer's user?

RE: default value in Access

Hi sabine,

Thankyou for your question

The key here is how your users log into the system.

I assume they have their own windows accounts. If this is the case, then is this the value you wish returned.

Alternatively, do they have unique logins for the database. If this is the case then do you wish this data to be captured?
Thanks

Stephen


 

Access tip:

Relationship maps

It is important to create proper relationships between tables. You can use Access to help check your designs and evaluate them by printing them in graphical format to help with design purposes


Click on the Tools menu, click Relationships.
On the File menu, click Print Relationships. View or print as required

View all Access hints and tips


Server loaded in 0.09 secs.