[mso] Re: RE-VALIDATION ON ACCESS DATA BASE :VSMail mx3
- From: "James LaBorde" <jlaborde@xxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 4 Dec 2006 16:30:04 -0800
Steve,
You can actually use DLookup to lookup the value in another table. What =
I would do in your example is set up an on lost focus event that ran a =
dlookup against your original table. Then if it finds it (I am assuming =
you want to verify that the item exists in your original table) you can =
simply allow the focus to shift to the next field. If it fails to find =
a match, then you can pop up a form that tells the user that the partno =
is invalid.
Just a note on your table and form names. Be very careful and make sure =
to use brackets around the names in any coding you do. It is generally =
not a good idea to use spaces in names of tables, queries, forms, fields =
etc....
James
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
Behalf Of Steve Moghaddam
Sent: Sunday, December 03, 2006 9:38 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] RE-VALIDATION ON ACCESS DATA BASE :VSMail mx3
I have designed a data base for excess inventory.
This data base file consists of several tables; one of these tables =
contains
part number, price and specification, and other pertained information
regarding the part identification.
This file is called "MATERIAL DATA BASE" and part number is the primary
field in this table.=20
This table is my permanent data base file and I use this table to =
retrieve
pertinent information about the part number.
I have another table called "PART UTILIZATION" that shows part number,
quantity and date that parts have been used. There is no primary field =
in
this table.=20
Currently I enter data in to "PART UTILIZATION FORM" and perform query =
to
retrieve pertinent information about the part number.=20
After the query is done I have to check and see if all the part numbers =
that
I have entered in "PART UTILIZATION FORM" are in the query list.
Problem is if I make a mistake and miss type a part number I will not =
know
about this data entry error till the query is done.
I was wondering if there is a code or expression that I could put in my
"PART UTILIZATION FORM" to validate part number that I enter in to this =
form
against the "MATEIAL DATA BASE" table instantly and provide immediate =
feed
back prior to execution of full query.
Currently I have an intermediate step for validation prior to query
execution, this is very time consuming.
I am looking for a short cut.
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx =
or MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the =
dropdown menu at the top. This will allow you to unsubscribe your email =
address or change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
If you are using Outlook and you see a lot of unnecessary code in your =
email messages, read these instructions that explain why and how to fix =
it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
- » [mso] Re: RE-VALIDATION ON ACCESS DATA BASE :VSMail mx3
