Recent content by rgbanse

RcdSt01SqlString = SELECT dmacs_item.im_division, dmacs_item.im_site, dmacs_item.im_item_nbr, dmacs_item.im_int_desc FROM dmacs_item; when used with Set Rcdst01 = ThisDatabase.OpenRecordset(RcdSt01SqlString, dbOpenDynaset), it creates a dynamic record set

SQL strings used to create the recordsets

I've created 2 recordsets Set Rcdst01 = ThisDatabase.OpenRecordset(RcdSt01SqlString, dbOpenDynaset) Set RcdSt02 = ThisDatabase.OpenRecordset(RcdST02SqlString, dbOpenDynaset) I would like to create a 3rd recordsset joining the first 2. The resulting recordset would contain Fields 1,2,3 from...

This is what I use In your macro use RunCode - Establish_Connection() Public Function Establish_Connection() Dim db As Database Dim dbcurr As Database Dim ds As Recordset Set dbcurr = CurrentDb() 'Logs on to Your Database Set db = OpenDatabase("", dbDriverComplete, False...

check the size of the database - may be max'd - empty work tables and compress or set compress on close option

Defrag made no diff These are databases that are started by scheduling software. They run a macro that runs reports, then closes db. These db's are all set to compact on close. The original db is still intact, but did not compress.

db's are realatively small - not even close to max started defragging - will let you know if there is improvement thx RGB

this is a recent 'happening' any idea what might have changed to cause this thx RGB

Recently, and randomly, the Db#.mdb files are not being deleted. I am at a total loss. Any thoughts? thx RGB

Scanning a 2d barcode post to fields properly but also transmits - How do I turn off the transmit? Symbol - MC3090 thx RGB

I'm running a mass update of all of our databases using the following - Call Shell("""C:\Program Files\Microsoft Office\Office11\msaccess.exe"" """ & DatabaseName & """ /x """ & MacroName & """ ", 1) works fine except for those databases with an autoexec macro or a startup form. is there an...

I'm running a mass update of all of our databases using the following - Call Shell("""C:\Program Files\Microsoft Office\Office11\msaccess.exe"" """ & DatabaseName & """ /x """ & MacroName & """ ", 1) works fine except for those databases with an autoexec macro or a startup form. is there an...

I'm running a mass update of all of our databases using the following - Call Shell("""C:\Program Files\Microsoft Office\Office11\msaccess.exe"" """ & DatabaseName & """ /x """ & MacroName & """ ", 1) works fine except for those databases with an autoexec macro or a startup form. is there an...

I'm using to following commmand line to print PDF files. Shell "C:\Program Files\Adobe\Reader 8.0\Reader\AcroRd32.exe /p /f" & XsomeFile, vbHide When printed they're only filling half of the page. What is the command line setting to 'Fit to Page. thx RGB

Geez - has it been that long - answer is exactly what I was looking for. thx and a star RGB