I would like to save the name of a variable within a string saved in a field. I would then like to retrieve the string value within a procedure and use the string/variable concatenation as if written in the procedure itself.
So for example...
Value saved in field = "There are " & varNumber & " days to go"
The procedure where used has a variable varNumber which has a value (eg 3)
The field value is then retrieved (via DLookup for example) and thus the string them reads...
There are 3 days to go
Is this possible and if so what is the correct syntax?
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
I see at least one EE question a week that pertains to using temporary tables in MS Access. But surprisingly, I was unable to find a single article devoted solely to this topic.
I don’t intend to describe all of the uses of temporary tables in t…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…