Search results for query: *

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...

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

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

Is it possible to append all fields from a recordset into a table using this type of code or something similar .Addnew RcdSt1.Fields! = (RcdSt2!*) .Update thx RGB

I've used this type of code to determint the value for that field in that record. What will tell me the Ordinal position of that field within that record. I know I've seen it before but can't bust the code. Thx RGB

After converting from 97 to 2003, the sort order has changed. It appears that Access doesn't see any " ' " in names. It sorts by the character following the " ' ". Any thoughts. Thx RGB

I'm using DoCmd.OpenReport... with the necessary criteria and conditions - opens fine. At this point, is there a way to test the report for a 'No Data' state using VBA. I've tried creating a constant and usnig the 'On No Data' function within the report to pass a value to the variable with out...

is there a global setting or code to set Subdatasheet to NONE by default thx RGB

Can a laptop with XP Home Edition be networked on an XP Pro networkk thx RGB

I have created a multi-record recordset using vba. How can I use it as a source in a 'Continuous Forms' form to show all records. thx RGB

I'm using Application.filesearch to read thru a folder. Is there a way to determine the Access Version of the databases in the folder? thx RGB

I'm using Application.filesearch to read thru a folder. Is there a way to determine the Access Version of the databases in the folder? thx RGB

Reports run from a given Db throughout the day. Rather than compress every time, is there code to compress only when criteria is met. thx RGB

Is the a way to add references (ie; Microsoft Scripting Runtime) to a Database using VBA. thx RGB