trying to insert into access from a select menu

[Codeman0013]

Hey guys..

Here's what my delima is. I have 2 select menu's side by side and they work fine you can move one item from one to the other and thats what i want my problem comes into play where after you get the things into the left menu called CURRENTDEPT_ID how do i get them inserted into the data base. I have a field they need to go into and it needs go to by the departments_contact.DEPTCONTACT_ID and doctor_matrix_DEPTCONTACT_ID this data needs to go into the dr matrix table and check if there is anything there and if there is a record delete it and add a new one based on that DEPTCONTACT_ID and also if the user leaves the list blank it needs to go into the database in the doctor_matrix table and delete all instances with the DOC id the url is passing into the code. Also on another page i have an add section with the same thing how do i take the values and insert them into the doctor_matrix table based on what ones they put into the left menu

please help me i'm lost and have no idea where to go to next in this process!!!



Remember free things are fun but they can come with an emotional price tags..

 

[kjv1611]

First question: Is this an Access database application, since you are talking about an Access table, or is it an Excel spreadsheet referencing/updating a table in Access? If the latter, then you might want to consider using a user form directly in the database as apposed to having an Excel spreadsheet update the database table in real time. It just seems to me it would run faster and cleaner.

If this is totally an Access question, then I would suggest posting the question in the appropriate Access forum, such as the Tables forum or User Form forum.

 

[Codeman0013]

its on a webpage i'm trying to code it to insert it when the submit is clicked its just access maybe i have the wrong one i dont know i'm just lost lol


Remember free things are fun but they can come with an emotional price tags..

 

[kjv1611]

Hmm, maybe you could try:
forum181 Microsoft: Access Other topics Forum.

I would just think you'd possibly get more help there, as the Office forum tends to be moreso answers to general usage, and maybe some more advanced for other Office Apps, but Access has its own group of forums.

Or, since it is web programming, you might could search for a forum for the specific web design application you are using, or the technology (PHP, ASP, HTML, etc)

Just a guess. But, I'd definitely think that the forum listed above would be the way to go.

If nothing else, maybe someone would see your post there, and tell you for sure the best forum in which to ask the question.

Another point: I am not sure I can tell from your question whether this web page/site is based off of the Access database (Access pages) or if you are just trying to connect to the database.