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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by cautionbug
-
trying to use Dlookup to prevent records from importing twice
PPS: A case of mild retardation: i misspelled the lookup field. Works fine. Dammit!- cautionbug
- Post #16
- Forum: Microsoft: Access Modules (VBA Coding)
-
trying to use Dlookup to prevent records from importing twice
PS: Have determined this appears to be DLookup's fault. i've tried several methods to get around it, including avoiding the IsNull function, using Nz to replace a Null return with something else, assigning DLookup's results to a variable and testing the variable, etc. Each effort has thrown the...- cautionbug
- Post #15
- Forum: Microsoft: Access Modules (VBA Coding)
-
trying to use Dlookup to prevent records from importing twice
i'm having the exact same error with the exact same type of statement: If IsNull(DLookup("[field]", "table_name", filter1)) Then filter1 is a variable generated by a form control. For testing, i've deliberately entered a value that should return Null, but the error described above keeps...- cautionbug
- Post #14
- Forum: Microsoft: Access Modules (VBA Coding)
