|
Subject:
|
newby
|
|
Posted By:
|
Tyler
|
Post Date:
|
12/13/2005 6:14:25 PM
|
Hello. Very new to VBA but I need to get two things done for a DB I am working on. The first is to be able to click or dbl click (don't care which) to automatically insert the date and time the rest of the info is going in.
Second, I need to develop a way to look up individuals either by last name or membership number.
Both seem pretty straight forward and I think in time I could figure it out, but I'm only on chapter 2 of Access for beginners and I need this done in a couple of weeks.
Any suggestions would be helpful and appreciated.
|
|
Reply By:
|
leehambly
|
Reply Date:
|
12/14/2005 6:29:27 AM
|
Tyler... couple of questions:
To be able to click or dbl-click to automatically insert the date and time... do you want to have to click or do something, or do you just need a datestamp on the record? If it is a datestamp, then you are better off with a default value in your table. Set the default of the date field to be "=NOW()"
If you want someone to make an action to do this, simply add a bit of code to the controls event handler... OnClick or OnDblClick, something along the lines of
me!ctlName = now()
where ctlName is the name of your control.
Secondly, to be able to look up individuals details... I am assuming you have these details in a table somewhere? If you do, open up a new form (just for practice) and put a combobox (from the Toolbox menu) on it... it should fire up a bit of a wizard... navigate to your user table and, well, probably best to just play with it for a bit... best way to learn, though happy to give more depth if you need it.
|
