Search results for query: *

I updated my machine to version 20H2. When I look at the "review update history" in settings there is no entry showing the update took place. I thought maybe the log file was corrupt so I ran sfc /scannow and repaired the log file. Rebooted and still no change in the view update history. Is...

The attached file is what I use regarding Dymo in Access 2016. Hope it helps.http://files.engineering.com/getfile.aspx?folder=c8eba158-325d-45c6-9ffb-93b095fdfa98&file=DymoLabel.txt

I am using SyncBackPro/SE/Free V7.6.74.0 and there are no adverts or reminders asking you to buy. The software works very well and I have used it for many years with no problems. Not sure this helps goombawaho but it is my suggestion.

strongm you are correct. I missed the part about no images. Sorry about that.

I use the freeware tool Reduce PDF Size on all my Access generated .pdf files. It works great at reducing the size of .pdf files. http://reducepdfsize.com/http://files.engineering.com/getfile.aspx?folder=317e3494-5f40-4ccc-8abe-c7c37d66d7fc&file=Capture.PNG

I have this tool for years and it works perfectly. The free download is all you will need. https://www.2brightsparks.com/freeware/index.html

sxschech You are so correct. I was looking for the changed data to show and when it did not I figured (wrong) that it did not work. Learn something new every day. I still love Access[dazed]

OK. Solved. This is what worked. UPDATE tblMaster INNER JOIN FixedAddress ON tblMaster.ID = FixedAddress.ID SET tblMaster.ADDRESS = [FixedAddress].[Address], tblMaster.CITY = [FixedAddress].[City], tblMaster.ZIP = [FixedAddress].[ZIP]; When you run an update query and view the data before...

Anyone?

That did not error. It gave me results or each row.

Ok. I am now simply trying to do an update on one field. And it fails on the Join syntax error and it points to the BOLD field in the SQL. I have deleted the table and recreated it without a space in the name. It still does not work. I even put in a where tblMaster.ID = FixedAddress.ID and...

Andy, I spoke too soon. That did the opposite of what I needed done. I don't understand how it updates in one direction and not the other. Totally confused.

Andy, thanks for your help. What I did is as follows and it seems to be working as planned. UPDATE tblMaster INNER JOIN Fixed_Address4 ON tblMaster.ID = Fixed_Address4.ID SET Fixed_Address4.Address = [tblMaster].[ADDRESS], Fixed_Address4.City = [tblMaster].[CITY], Fixed_Address4.ZIP =...

I get an error on the join. On [Fixed Address4].ID

Thank you for looking at this. UPDATE [Fixed Address4] INNER JOIN tblMaster ON [Fixed Address4].ID = tblMaster.ID SET tblMaster.ADDRESS = [Fixed Address4].[Address], tblMaster.CITY = [Fixed Address4].[City], tblMaster.ZIP = [Fixed Address4].[ZIP];

I did what you suggested but it seems to be selecting the old data not the new from Fixed Address4.

I have a master table (tblMaster) with ID, Address, City, and Zip and many other fields. I also have a spreadsheet with corrected information I imported into a table named "Fixed Address4". The imported table contains ID, Address, City and Zip. I can join the two tables via the ID which is...

Update. I did the following. I closed Outlook and Access. I then only opened Access and ran the same code. It worked fine. I opened Outlook and could see all the email being sent. Not sure why letting Access call Outlook vs. having Outlook already open caused the problem. Very confusing...

The code below has worked for several years. I am using Office 2010 and have been for a couple of years and this code always worked until yesterday. I now get an error on the line "Set MyOutlook = New Outlook.Application" in red below and have no idea why. The error is Run-Time error 429...

Thank you again. That was it. It now works perfectly. You both get a star.