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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Looping puzzle
It's me again, here is the module: Public Function MailToShipToAddresses() Dim dbs As Database, r As Recordset, r2 As Recordset Set dbs = CurrentDb 'Open the source table EXTRACT850 Set r = dbs.OpenRecordset("EXTRACT850", dbOpenDynaset) Set r2 =...- dantomi
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Looping puzzle
Very close to figuring this out. Can you help? The code below works beautifully in extracting addresses for the AddressData table, but it always ends on an error. After the last record is "posted" to the table it cannot find another "ST" record. I have tried numerous ways...- dantomi
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
HELP!!!! comparing dates ina variable
I'm stumped. This has got to be easy, so why does it seem so hard? How do you accomplish the comparison of the date in a variable (TempDate) to the date in the field [Holiday] in a the table GDLSHolidays? Could it have something to do with the focus of the recordset? I have two recordsets...- dantomi
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
