MS Access Parameters Using TempVars

Ron this is Eric with VBA how to die calm and I just want to show you something today about how to use tempers kind of a practical application in the past I was easing parameters to reform strong perimeter for my queries and I want to show you gotta use Templars I saw this cool little technique done and maybe he can may be able to prove helpful to you so here I have my form if I select my login let's say login six I'm just gonna see selections for number six so I'm setting the Templar with this open query and I sing just just results for number six I've let me I can make this a bit bigger Wow supplier six and then if I want to go ahead and close this and choose somebody else so said open query break and let the wheels your wheels turned and see where you can apply this these are products for that and you could use this as login for certain builders of her certain people this this is how it works I'm gonna go ahead and close out of this so if I'm going into my database here this is basically all it is whenever I click the set button I'm setting dimensioning a variable your IAT login and lying to you login it's taking you could and get to this little of it but they say what I'm doing is adding a temp are called login ID and I'm assigning the value of this a my ending login if you decide you're gonna put this straight in me dot CBO logins straightened into this argument you're gonna have an error so I sign that a variable first assignment you have variable like this it's just integer it's real simple and then sign that is a value to 10-4 okay so back here let's see where am I go back to my form of course so if I go ahead and open this up let's see what I'm doing in this query here for my parameter for my parameter here I'm just using should look down here I'm using dip bars it's like a session variable so whenever I open up the application it's like okay well that is by such a variable and it knows where I'm using I can use Templars login under by a supplier ID and that's the only only criteria I have for this year query and I'm gonna close it out so again when I put these together seventeen let's say I have to go ahead to set the set the temporal bigquery and I'm just seeing items with they belong to a supplier 17 I might close this out and close the database bang and save yeah and anyway that that's about it the database is called Templars Don accdb go ahead on out there to VBA how to calm I'm gonna have the database this particular database and go ahead and apply it you this concept in drones situation of this shown as example be able to play it leave a message or subscribe and like if this video is helpful to you and if you have a idea for a future video or a question leave it in the comments below and I will take it into consideration and make it make a video for it so thanks a lot for watching and have a great afternoon

Channel: LoeblComServices

Views: 5,692

Rating: 4.75 out of 5

Keywords: TempVars, MS Access, Parameters

Id: N6nOHMAOUd0

Length: 5min 0sec (300 seconds)

Published: Fri Oct 07 2016