Populating Default values of Forms using queries to Access

C

Cindy

Hello. I'm not finding specific infomation on something I'm trying to do in
the numerous books and web sources I've been using. I was hoping someone
could tell me if this is even possible before I spend too much more time.

Here is my situation: I have an Access database that contains the following
informaiton for each user: UserId, Email Address, A list of which documents
they wish to be notified when/if altered.

I've been successful opening up a connection and even posting only the
results for the Userid that someone enters. (For instance, they enter their
UserID and if it's found, it posts the info on their ID from the database.)

What I want to be able to do is use the informaiton to set default values in
a new form so they can change and update their subscriptions and press
"update/submit" and have it overwrite their data in the database.

Is this possible?


This will only be accessed internally on our intranet, so security is really
no big deal. I just want to be able to do this interactively rather than
have the users send me an email anytime they want a to change their
informaiton (which is how I'm using it now.)

Thanks in advance.
Cindy
 
S

Stefan B Rusynko

Or see http://www.asp101.com/samples/login.asp and http://www.asp101.com/samples/db_edit.asp




| Cindy....
|
| Yes... it is just a matter of finding the record and providing an edit
| screen. You can probably find lots of code examples at some of the asp
| sites.
|
| www.planet-source-code.com
| www.hotscripts.com
|
| You can do it!!!!
|
| Tom Gahagan
|
| | > Hello. I'm not finding specific infomation on something I'm trying to do
| > in
| > the numerous books and web sources I've been using. I was hoping someone
| > could tell me if this is even possible before I spend too much more time.
| >
| > Here is my situation: I have an Access database that contains the
| > following
| > informaiton for each user: UserId, Email Address, A list of which
| > documents
| > they wish to be notified when/if altered.
| >
| > I've been successful opening up a connection and even posting only the
| > results for the Userid that someone enters. (For instance, they enter
| > their
| > UserID and if it's found, it posts the info on their ID from the
| > database.)
| >
| > What I want to be able to do is use the informaiton to set default values
| > in
| > a new form so they can change and update their subscriptions and press
| > "update/submit" and have it overwrite their data in the database.
| >
| > Is this possible?
| >
| >
| > This will only be accessed internally on our intranet, so security is
| > really
| > no big deal. I just want to be able to do this interactively rather than
| > have the users send me an email anytime they want a to change their
| > informaiton (which is how I'm using it now.)
| >
| > Thanks in advance.
| > Cindy
|
|
 
C

Cindy

Thanks to you both. I think I have found examples that are going to help.

Appreciate it!

Cindy
 
Top