Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Is DLookup the correct option on this...
suggest that you use if statement first like Me.txtZoneID =iif(DLookup("ZoneID", "tblZipCode", "ZipCode = '" & [ServiceZip] & "'") is null,"enter some value",dlookup("ZoneID", "tblZipCode", "ZipCode = '" &...- lakb
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Code to send report by email or fax
HI I have to run the report 180 times with each branch getting only their required information. I will test the docmd lines. Thanks for the advice. Bernard- lakb
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Code to send report by email or fax
Hi I have some 100,000 data lines that need to be sent to approx 180 branches around Australia on a weekly basis. I have developed the queries and created a suitable report. However, I was wondering how I might develop coding that could run this report 180 times and for each time email the...- lakb
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
