Search results for query: *

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

this appears to be looking at the ldb file and would give me the number of users in a specific data base. I'm trying to find how many sessions of msaccess.exe are running on a give pc. I need to limit that number. Follows some code I use to limit to one seccession but I want to allow, say, 5 max...

having trouble with Declare Function LDBUser_GetUsers Lib "MSLDBUSR.DLL" _ (lpszUserBuffer() As String, ByVal lpszFilename As String, _ ByVal nOptions As Long) As Integer Compile Error: Only comments may appear End Sub, End Function or End Property

I need to restrict the number of access sessions on a group of scheduling machines. I can determine if at lease one session is running but not how many are running I need a way to determine the count. thx RGB

I'm using Application.FileSearch to find all mdb's stored on a series of hard drives. No problme here but also need to know what version of access each db is. We have 97 thru current. thx RGB

Worked great !!! Thx - Star to ya RGB