By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

Auto Lookup & Populate

P: n/a

In A97, WXP, I have an employee form which, among other things, has a
textbox for that employee's assigned access card number [CARDID]. The form
also has two (2) Yes/No checkboxes. One checkbox is to indicate whether this
is a new number (in the entire system) that needs to be added ("Yes") to a
list to be emailed to the property manager [WCCADD] and the other checkbox,
if checked "Yes", is the basis for another list to have a receipt printed
[PRTRCPT] in the employee's name for the new access card.

Presently, the person entering the data "knows" if this is a new card she is
entering and then manually 'checks' both check boxes ("Yes"). Since I've
caught some mistakes of entering newly assigned card numbers without adding
them to the list for the property manager and also not including them on the
'Print Receipt' list, I'd like to have Access automatically do a lookup to
determine if the [CARDID] is 'new' (not already in the system) and if it is
'new', check both checkboxes (Yes/-1), so I no longer must 'hope & pray'
that the boxes were checked upon initial data entry.

I would sincerely appreciate any help in showing me how to accomplish this.

Thx...
Earl Anderson
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Mon, 19 Apr 2004 17:21:21 -0400, "Earl Anderson" <is*****@rcn.com>
wrote:

In A97, WXP, I have an employee form which, among other things, has a
textbox for that employee's assigned access card number [CARDID]. The form
also has two (2) Yes/No checkboxes. One checkbox is to indicate whether this
is a new number (in the entire system) that needs to be added ("Yes") to a
list to be emailed to the property manager [WCCADD] and the other checkbox,
if checked "Yes", is the basis for another list to have a receipt printed
[PRTRCPT] in the employee's name for the new access card.

Presently, the person entering the data "knows" if this is a new card she is
entering and then manually 'checks' both check boxes ("Yes"). Since I've
caught some mistakes of entering newly assigned card numbers without adding
them to the list for the property manager and also not including them on the
'Print Receipt' list, I'd like to have Access automatically do a lookup to
determine if the [CARDID] is 'new' (not already in the system) and if it is
'new', check both checkboxes (Yes/-1), so I no longer must 'hope & pray'
that the boxes were checked upon initial data entry.


You are on the right track. Leaving things to the user which are
pre-defined processes is a nightmare waiting to happen. You'll want
to investigate the DLookup function.

Note, however, that the DLookup function is slower than molasses
running uphill in the winter time.

Hence, if you find the response time intolerable, you might want to
investigate an alternative lookup function, such as the one described
here:

http://www.mvps.org/access/modules/mdl0012.htm, courtesy of Trevor
Best.

mike
Nov 12 '05 #2

P: n/a
Setting the DefaultValue property of a textbox will place the selected value
in that field in all new records (unless changed) and does not affect
existing records.

Robert Crouser

"Earl Anderson" <is*****@rcn.com> wrote in message
news:40***********************@news.rcn.com...

In A97, WXP, I have an employee form which, among other things, has a
textbox for that employee's assigned access card number [CARDID]. The form also has two (2) Yes/No checkboxes. One checkbox is to indicate whether this is a new number (in the entire system) that needs to be added ("Yes") to a
list to be emailed to the property manager [WCCADD] and the other checkbox, if checked "Yes", is the basis for another list to have a receipt printed
[PRTRCPT] in the employee's name for the new access card.

Presently, the person entering the data "knows" if this is a new card she is entering and then manually 'checks' both check boxes ("Yes"). Since I've
caught some mistakes of entering newly assigned card numbers without adding them to the list for the property manager and also not including them on the 'Print Receipt' list, I'd like to have Access automatically do a lookup to
determine if the [CARDID] is 'new' (not already in the system) and if it is 'new', check both checkboxes (Yes/-1), so I no longer must 'hope & pray'
that the boxes were checked upon initial data entry.

I would sincerely appreciate any help in showing me how to accomplish this.
Thx...
Earl Anderson

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.