pass variable to criteria

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

anonymous_at_discussions.microsoft.com
Date: 04/19/04 

Date: Mon, 19 Apr 2004 07:48:54 -0700

Hi all,

Is there a way to do this? I've listed some of the code
I've set up for what I want to accomplish but I get error
messages.
---------
Public Type BeginEndMonth
     BeginDate As Variant
     EndDate As Variant
End Type
---------
Global PassDate As BeginEndMonth
---------
PassDate.BeginDate = "4/1/2004"
PassDate.EndDate = "4/30/2004"
---------
Between [PassDate.BeginDate] And [PassDate.EndDate]
(This is the criteria in the query. I've even tried
passing this as a function)

Relevant Pages

  • Re: Nz function.
    ... if it is Null doesn't accomplish much. ... what exactly do I do about the date data type ... Do I declare them as Variant in the Dim statement, ... > Dim dDate as string ...
    (microsoft.public.access.formscoding)
  • Re: 5 years now since last release
    ... really accomplish much other than split the consumer group. ... to stick with vanille because it's vanilla, ... That's fine for those who like each variant but it's not ... really any kind of progress without either popular or dev support. ...
    (rec.games.roguelike.nethack)
  • Re: GetStdPictureFromPicData ?
    ... THe code to accomplish this is on my site somewhere but I cannot think of ... LoadPicture method to load and return a handle to a StdPic object. ... Function GetPicDataFromStdPictureAs Variant ... StdPicture ...
    (microsoft.public.access.formscoding)
  • Re: Where to find std_arith?
    ... >+<One of the most popular chips to accomplish that function is the ... Which is a variant of FISH - First In Still Here. ...
    (comp.lang.vhdl)