UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> From: Current Date In VBA, From Topic ID: 2047947    
 
   
zaxbat
post Feb 23 2018, 08:51 AM
Post#1



Posts: 1,184
Joined: 26-January 06
From: .....the wiregrass (either you know or you don't)


SEA = DLookup("SeasonID", "SeasonTbl", Date() BETWEEN #" & SeasonFrom & "# And #" & SeasonTo & "#")

This should work, though I did not actually test it. So easy to get one little quote or poundsign out of place.
Go to the top of the page
 
ranman256
post Feb 26 2018, 12:14 PM
Post#2



Posts: 875
Joined: 25-April 14



i doubt that will resolve. Try:

SEA = DLookup("SeasonID", "SeasonTbl", "#" & Date() & "# BETWEEN #" & SeasonFrom & "# And #" & SeasonTo & "#")
Go to the top of the page
 
zaxbat
post Feb 26 2018, 12:36 PM
Post#3



Posts: 1,184
Joined: 26-January 06
From: .....the wiregrass (either you know or you don't)


Nice catch....possibly right....I did not test it....
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    25th September 2018 - 10:37 PM