I appreciate that your web synch seminar was produced a long time ago, but it is just as relevant today.  There are however two questions I would ask.
1.  If I am entering a protected page on the web where I have to put in a password and/or name, can I program the vba to do that automatically?  If so, how?
2. My website has historic and new data, and I only wish to upload the new data.  To achieve this I have set an unique ID with no duplicates in my database, so that when that and subsequent lines of data are about to be imported I get an error message to advise that the import is not allowed as that would create duplicates.  Great that is what I want, but can I suppress that error message and jump out of the While not eof(1) - Wend loop when that message occurs?  If so, how?
A great seminar which has revolutionised my use of my database, but these extra requirements would make it even better.
Many thanks
David

---

Reply from Richard Rost:

1. This depends on the kind of form it is. If it's a Windows logon form then I don't think so. If it's an HTML form, then you should be able to.

2. How are you getting the error message? Is it the popup warning in Access? If so, just turn warnings off (Docmd.SetWarnings)