Pull Table field value in a macro variable

M

MarkusJohn

Hello friends,

I have in my Access DB a table where I store time constraints.
There is one field where I enter just the current month (=10)

When executing a macro I produce with that several files that should
contain in the name the current month.

At present I have created in the "Sub Function" a constant (Const
Monat As String = "10") that I use.
How can I link the value from the above mentioned table with my
constant declaration?
Table Name is Date and the field is called CurrentMonth (DT number)

Thanks for your support!
markus
 
M

MarkusJohn

Markus

I don't understand what you mean by "link the value from the ... table with
my constant...".

What will connecting your table value and constant allow you to do?

--
Regards

Jeff Boycewww.InformationFutures.net

Microsoft Office/Access MVPhttp://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentorhttp://microsoftitacademy.com/
Click to expand...

I just want to have the value that is stored in the table linked to
the variable that I have decalred in the macro.
 
Top