Copy of database
I am so sorry for the lateness of this reply. I just started back on the project and would be very greateful if you could look at this for me again.
I hope you can open this one, Let me know.
thank you,...
Brandi Mills
Last Activity: Jan 12 '11, 12:44 AM
Joined: Dec 30 '10
Location: Lakeland, Fl
-
:(
Of course! I think I saved it in 2010 instead of older version. I am ridiculous. I will reload it again this evening. thank youLeave a comment:
-
Copy of database
okay,
I need the frm_DH and multiselect lst_region to populate the qry_DH and subsequently the tbl_Questions column regions table.
The user may select to remove a region from the record or add the region to the record at any time. They should have to have at minimum one region and they could have a possible choice of "ALL". If "ALL" is selected then they should not...Leave a comment:
-
ADezii,
I was thinking about that, but was unsure how involved you wanted to get. I am being blocked by my companies security rules. I have sent home the file and will upload it this evening for review. I have stripped down to example data and removed all company logos.
thank you and will upload this evening.Leave a comment:
-
oh boy, okay - I am getting an error on the SQL INSERT INTO statement. I guess because the [ID] on tbl_questions is the primary key on that table. It is calling duplicate record and stating unable to update the table based on no duplicates allowed. Which makes perfect sense except now I royally confused on how to get the information into the table.
Maybe I am going about this all wrong. I was Attempting to keep only one table. Maybe...Leave a comment:
-
ADezii,
I appreciate your response and code snip, but this did not work for me.
I need the form to update the table and the information is not being updated or saved once I leave the form. As a novice to this I am unsure how else to explain it.
I will try again.
Table Name: tbl_questions
Query Name: qry_DH (Select Query)
Split-Form Name: frm_DH being fed by qry_DH
...Leave a comment:
-
ADezii
I am sure you are reading it correctly. I appreciate your assistance and will get back to it in the AM. I will post the outcome.
Thank you,Leave a comment:
-
Multiselect Listbox
I have a table named
tbl_Questions
with a column called Region
I have a total of 8 regions
I am attempting to set an Unbound multiselect listbox on a form called frm_DH
I need the user to be able to select and deselect any combination of 8 regions and the record to show in the splitform datasheet and update the questions table.
So far I can select the data but it does not populate...
No activity results to display
Leave a comment: