Thanks for the replies...
Yaracadian - yes I have created the update query and tried to make it run after Word opens if the user selects yes. The problem is that Word needs to get to Access to do the merge and once I do the messagebox Access stops and waits for user input. I guess what I need...
Hi -
Here is what I am trying to do...
After a user enters information into a form a message box pops up and asks if he/she would like to print follow-up letters (based on the data just entered).
If the user clicks 'Yes' a query runs (to select records that don't have a follow-up letter) and...
Hi -
I have an Excel 97 spreadsheet that lists measurements in both English and metric. I would like to replace the '.' with a ',' for decimal in the metric values? Does anyone know how to do this without re-entering all the data as text?
Thanks -
Lee
Thanks for your help but when I try to run this query I get an error message "Syntax error in INSERT INTO statement"
This is my query (using the one you gave me)
INSERT INTO [New Customers] (SELECT * FROM [4-24 customer list] where ShipToID not in (select ShipToID FROM [12-9 customer list]))...
Okay so I'm new to this Access stuff... so go easy on me!
I have two tables of Customer Data in the same database, one from December one from April. The April table includes all the records from the December table and additional new records. The field names in both tables are identical and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.