Using a DLookup Function with the System Date

[jaaret]

I know there must be multiple threads on this: how do you use the system date in a VBA fuction? The following results in, "Invalid use of null."

Dim DateToday As Date

DateToday = Date

RemDayNum = DLookup("RemDays", "tlkpRemDays", "DateCal=" & DateToday)

Thank you,
Jaaret

 

[dhookom]

Where/how did you Dim RemDayNum? Why are you creating a date variable with the value of Date?

Have you confirmed there are matching records? You could use a query like:

SELECT RemDays FROM tlkpRemDay WHERE DateCal = Date();

You may need to use something like:

RemDayNum = DLookup("RemDays", "tlkpRemDays", "DateCal=#" & DateToday & "#")

Duane
Hook'D on Access
MS Access MVP

 

[jaaret]

Thanks, Duane. The VBA suggestion with the hashtags did the trick.

Jaaret

 

[Andrzejek]

jaaret, if you have found dhookom's post helpful, especially if it solved your problem, it is customary on TT to use
[blue]
Like this post?
Star it![/blue]

To show appreciation for the help received, and also the little star help others to see which post was the solution.


Have fun.

---- Andy