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

Compare textbox value to record in table

P: n/a
Hi All,

Win XP, Office XP
What I am trying to do is create a login form. The problem is that I am
going to set the database up using Access security so that only admin users
can read the tables. I plan to have all info coming from stored queries with
"With OwnerAccess". With this in mind, what I am trying to do is: In the
afterupdate event of the username and password fields, look for the
existence (either true or false) of the username for the userid textbox and
the username & password for the password textbox.

My understanding of VB is very limited but from what I can make out, I need
to reference the result stored query/s.
Could anyone point me in the right direction please.

My table layout (Tbl_Users) is as follows:
Userid text PRIMARY KEY
Name text
Pwd text
Disabled yes/no
Security_level number
Ixxluda date/time

TIA

Mark
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.