Guus2005's latest activity
-
I settled on the tempvars alternative with the use of the criteria I explained above for two reasons. The VBA is about as simple as it... -
I don't recall where I found it, but I found a technique using a function which I blogged about on my website here:-...
-
I get that, but this example was pulled from a demo that I wanted to be fully explicit. In most cases I would not specify the table as...
-
I like the look of that, but I can't quite grasp how it works! Seeing as your query is based on a single table you could take out the...
-
I use a series of helper functions in VBA, rather than the basic TempVars!lngPublicationID for a couple of reasons. One is that it...
-
One of my favorite techniques for filtering queries that are used as recordsources for forms and rowsources for list and combo boxes...
-
You've got to see this excellent video on tempvars by Daniel Pineault:-
-
SEPTEMBER 27, 2010 Power Tip: Maximize the use of TempVars in Access 2007 and 2010 By the Access team
-
Guus2005 posted the thread Results pane in SSMS shows output and Return Value from which query? in SQL Server.USE [databasename] GO set nocount on DECLARE @return_value int EXEC @return_value = [alg].[spGenerateFile4Process]...
-
