Access Parameters Using TempVars

Access TempVars are like using query parameters.

TempVars seem to be like Session variables for your Access application.

In the past I was using hidden forms to store parameters for my queries, but
TempVars can be useful to do the same thing. I have seen this in use and wanted
to share it with you.

TempVars.Add “LoginID”, 0

TempVars![LoginID] = [Form value]

intLoginID = TempVars!LoginID

If you want to destroy the Tempvar when closing the form or database you
can use TempVars.Remove “LoginID”

Watch it in the video:

You can download the database here:

Click here for the database and the code:

If you have a suggestion for a future video, contact me on my contact form, and I will seriously consider it.

Offsite Related Information:

“Go Fund Me” Page

($5 suggested amount)

(…10% of your gift amount will go to charity)

Free! Subscribe To Our YouTube Channel!

Free MS Access VBA Programming Course

Facebooktwitterredditpinterestlinkedinmailby feather
Tags: , ,