Dir function in 2007

[Hadi]

Thanks for the directions on creating a new function.

I am comfortable with changing registry values so I went ahead and went to
\\HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\engines\SandboxMode. the
value was already at 2. I went ahead and changed to 0 but still did not make
a difference. It looks like I have Jet 4.0. Not sure if I needed to do
something else with the sandbox mode. I have modified my trusted locations in
Access and enabled all macros to run.

thanks again

 

[Ken Snell \(MVP\)]

I'll have to ask more people to see what other suggestions we might
identify.

 

[Ken Snell \(MVP\)]

Did you try the public function approach?

 

[Hadi]

Yes I did and it works fine but the question I have is do I need to create a
publc function for each month. I have different folders for each month on the
network drive. How can I have one module for all months?

 

[Ken Snell \(MVP\)]

How would your query know which month you want to use?