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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Delete Record - need Question asked first
Unless you are using an old version of Access, you should change these to the newer RunCommand -- it's also a lot easier to understand. DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 becomes RunCommand...- SJFoust
- Post #3
- Forum: Microsoft: Access Forms
-
DLookup
Try changing your DLookup to read: DLookup("[Booking]", "tblHolidays", "[Booking] = #" & Format$(varStartDate, "mm/dd/yyyy") & "#") The error you are receiving simply informs you that there is *something* wrong within the DLookup call -- either the field you reference doesn't exist, the table...- SJFoust
- Post #4
- Forum: Microsoft: Access Forms
