Recent content by Sean Illingworth
-
S
Import Null Fields To ADO Recordset
If IsNull(DLookup("[Processor name]", "querySophia", "[property_id] = " & Me![allocationProperty])) Then This line create the error- Sean Illingworth
- Post #3
- Forum: Modules & VBA
-
S
Import Null Fields To ADO Recordset
Hi Everyone. When I use ADO to import value form a query, Access pop up "invalid use of NULL" The code is : If Not IsNull(DLookup("[Affiliate code]", "querySophia", "[property_id] = " & Me![allocationProperty])) Then If IsNull(DLookup("[Processor name]", "querySophia", "[property_id] = "...- Sean Illingworth
- Thread
- Replies: 3
- Forum: Modules & VBA
-
S
How to use DLookup in form
I tried to change the control name, that worked. Thanks a lot Best Regards- Sean Illingworth
- Post #3
- Forum: Modules & VBA
-
S
How to use DLookup in form
When I use DLookup like: ? DLookup("[Processor name]", "querySophia", "[property_id] = 39") It gives me correct answer: Dave Irvine But When I am using a form and want set value automatically: ? DLookup("[Processor name]", "querySophia","[property_id]= " & Me![property_id]) System Error...- Sean Illingworth
- Thread
- Replies: 2
- Forum: Modules & VBA
-
S
Check table to see if record exists, if not -INSERT
When I use DLookup like: ? DLookup("[Processor name]", "querySophia", "[property_id] = 39") It gives me correct answer: Dave Irvine But When I am using a form and want set value automatically: ? DLookup("[Processor name]", "querySophia","[property_id]= " & Me![property_id]) System Error...- Sean Illingworth
- Post #10
- Forum: Modules & VBA