Search results

I am getting a error that says "Operation must use an updateable query" and I did convert it to a Update query

Hello, I have one memo per change (user input)...I need to have the comment the user inputs to copy into other records that were queried. I tried insert. My coding does one of the records or all of the records ..I need it to copy just to the queried records ...and I have a query but no...

I am getting a syntax error now...please help!!! I just want it copy the remarks in the Comment box to the rest of my queried records

Here is my code...if I take out the where statement..it copies the remarks all the way down my table to all the records...with the where statement..it's prompting in for parameters.. Private Sub Remarks1_Click() Dim strMsg As String, strQry As String, strRemark As String strMsg =...

Hello, I have a crosstab query which i would like to append to my table..can't change it to a append query...it changes the structure. Anyone?

Hello JHB, How would I get OrgLookID into my other table and how would they correlate..

Hello, I told my boss the data should be in one table for uniquiness. But the OrgLook table is used in several other DB and she wants to be able to save the user input into the final table. This DB is getting to be a headache and I am not an expert.

the sunrise in

I tried and it didn't work for me for some reason

So ..I don't see anything that is unique in either table. What do I do at this point?

I am pretty new to this to..I only have one record showing in my subform instead of continous...if that helps

Also JHB can you please answer my thread from the Nov 19th..I was out with an injury.

Are you an expert

Are you new to access

Can you help me

How do I also get rid of the repeating data. I just added a dropdown menu and no matter what I choose..that choice is the same in all the queried records

Hello JHB....Is there a limitation to how many fields that a table can have??

Also is having a join in the query the same as a relationship?

Sorry I have been out with a cracked Kneecap...So I set my relationship after creating OrgLookdId in both tables..One to many Relationship...will it work??

Hello JHB, The field that I am having issues with is BC1_Change..1-4 even though I don't have all of them on the form yet...working with one at a time. Please let me know what you think...I still have not been able to figure out why I can't enter data into those fields. Name of the frm is...