Search results

couple of different choices, the easiest being link the tables through Access and you would reference them just as you would a local table. The second choice would be using pass through queries to allow the server to do the heavy lifting. search the forum for linked tables or pass through...

Tim Roth -- Pulp Fiction

ok, found the other with (hint: use the code tags...formatting and indentation are essential to debugging code) before moving to the next record in the recordset, issue the save command for the Workbook...the next iteration redefines the worksheet.

'fraid he wasn't in the RHPS...

Richard O'Brien -- The Rocky Horror Picture Show

there's an extra End With...FYI, I've always found nested With statements to be somewhat unpredictable. You should also save the sheet before you try to add another.

that would be my fault...too early in the morning:o put it in the click event of the check box. chkLocked is what I called the check box in my example. Private Sub reconciled_Click() Me.Inc_Due.Enabled = Not (reconciled) Me.inc_due_less_VAT.Enabled = Not (reconciled) End Sub

first off, spaces in object names are a bad idea. second, locked is also an object property, you should change the name of this object. third, on the On_Update event for your checkbox, simply set the two fields to the inverse of the check box: incDue.Enabled = not(chkLocked)...

establish a recordset containing the tableNames, cycle through it, and replace the static refrences to the table name with the field from the recordset (and don't forget to move to the next record at the end of the loop): Set rec = currentDB.OpenRecordset("SELECT * FROM tableList") While...

Oliver Platt -- Flatliners

Rip Torn -- MIB

It will open with IE if you specify that in a command line argument. (Look here) suggestion: If you open a .doc with IE, you will still have the Word toolbar inside your Explorer window, though. I would recommend changing the help file to a .pdf for a more professional look.

you must also use the OpenDatabase command: Set db = OpenDatabase(BackEnd)

:eek: Now that's funny! I'm guessing: budgerigar: small Australian parakeet usually light green with black and yellow markings in the wild but bred in many colors

gelukkige verjaardag I'll hoist a few in celebration from this side of the pond:D

SELECT field1 FROM table1 WHERE field2 = (SELECT x FROM table3 WHERE [Criteria]) OR field3 = (SELECT x FROM table4 WHERE [Criteria]) Alternatively, if you are checking the same field from both of the nested...

remember that when you execute a pass through query, all processing takes place on the server... IIF is an Access function that the server won't be able to interpret. You need to construct an SQL If-Else section or complete work on the recordset after you get the return from the server.

Richard Dreyfuss -- Jaws

A few examples of ADO connection strings here better yet, just Google "VBA, Connection Strings" In my example: OraOLEDB.Oracle = the Oracle Driver I want the connection to use UID= The user ID to be used (if there is no username and password required, then this is obviously not needed) pwd=...

Because I don't know how large the actual SQL statement is, how many parameters are involved, or how many other programmers are involved. I would thank you for your kind words, but, never mind...I'll just be over here wasting time and memory.:rolleyes: