Pull Table field value in a macro variable

  • Thread starter Thread starter MarkusJohn
  • Start date Start date
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

retrieve only data where field name (not data) is like current mon 3
Eliminating Dates based on a measure 1
Access Macro Repeat Expression using value of a field in table 0
Appending records to new table using field names as values 2
Pulling data from a linked SQL table 2
Populate a table 2
How to reference a field of a recordset with a variable 4
Macro Variables 4

Back
Top