Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update Access Database, based on Checkboxes

Status
Not open for further replies.

JenNeedsHelp

Technical User
Apr 14, 2002
1
US
I'm trying to create a code management system. I want people to be
able to search for codes by email address (their's or anyone else's -
this part is no problem, I have that working fine). But I'd also like
them to be able to create a master list for themselves of whatever
code they choose. They can add any code in the table to their list.

I have an Access table with the following fields:
email_to, code (text), primary(text - yes or no is it's populated
with), updatedate (timestamp), primaryremoved (text field - yes or no
is what it's populated with)

In one page I have database results that shows the code for every
email_to (searchable by drop down email address).

I want people to be able to check a box that makes them primary (this
means they are the primary owner of that code, so when they do that,
they must turn the other person off - so the checkbox has 2 functions,
1. to make themselves the primary owner and 2.turn the other person
off)

I also want them to just be able to add themselves to that code
without making themselves the primary owner, this will involve
inserting a record with the primary field being "No" and keeping
whoever is the primary owner, still the primary owner.

So I'd like a total of 3 checkboxes - one to make them the primary
owner - which will also add them to the list, one to add the code to
their list without making them the primary owner, and one to delete
the code from their list.

So far, I've added checkboxes to the database results rows and I'm
trying to pass them to an update page with a few update queries on it,
but it's just not working.

Any suggestions/help/ideas?

Thanks so much!
jen
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top