access form design templates

Video instructions - Access Form Design Templates

Instructions and Help about access form design templates

And I woke up to access 2013 tutorials in this video I'm going to be talking to you about temp variables so if you want to play long follow the link below the video to the download section a website and download access 2013 DB 21 and open of 2013 okie dokie so in the last video what we have done was we created a report called report guest activity which listed guest and and it listed any activity that the guest has been doing so any bookings so if we drop down to print preview will actually get a better sense of that so here you've got the guest and then down here you've got the information and as you scroll along guest and information now what I want to do today is I want to be able to restrict the information that's shown in that subform which is called report booking details by guests up because at the moment everything that's in table booking details is coming up this is based on query booking details extended and what I want to do is on a restrict the date so I want to give a date range and I want to say to the query that I want all these fields but I only want records where the check-in date and check-out date fall within this date range and to do that I'm going to use temporary variables so what are temporary variables three variables are variables I can store data and are globally available to the application so you might have a template variable called temp start date and you store a date of the first of June 2013 if you access temp start date that information which in this case is the first of June 2013 is available from anywhere in the application so you can access that temper variable from a form from a report from a macro from a query and I'm going to be using the ability to access it from a query definitely think about temporary variables are you can set them and remove them with macros and with VBA to set them with a macro user set temporary variable organ which we'll be looking at to removed there's three ways to remove a temporary variable you can either use the remove temporary variable argument parser name you can use to remove all temporary variable arguments or you can close the application all three of those will remove at least one specific temporary variable and the max amount of temper variables you can have at any given time is 255 I do believe so random information okay so what are we going to do we're going to let's close this for a second we've got a report which is report guest activity let us create a form I'm going to call this form report a form report guests and it's the form we're going to use to house guest reports so press.