Search results for query: *

How do I check if an array has any elements in it. If I hover over an array with no elements, the pop-up box says that the value is 'nothing', but if I try to use ubound(array()), then I get a 'Subscipt out of range' error. There must be some way? Cheers, Lollyjar

Hi, I am running an update query via ADO, followed shortly afterwards by a select query, and since ADO is asyncronous, the select is picking up the old values rather than the new ones set by the update query. How do I deal with it so that the first update command does not return control to the...

I have a Form with a Subform (continuous). The Subform displays rows of information, the number of which varies depending on values on the subform. Each row also has a button which is used to bring up another form with more detail for that row. The trouble is that for some rows, no details are...

Hi, I am having a problem with a mail merge (I am creating a catalogue) hanging at record 195. There is definately nothing wrong with the records. I know this because I have tried to following test. I deleted a chunk of records from the begining of the data set, and it made it past the 'old'...

Does anyone know how to delete a module programatically? Cheers

How do I open up a select cell dialogue box in excel to allow the users to select a specific cell (in much the same way the user can select a cell to reference against in conditional formatting)? Cheers, Lollyjar

Hi All, I tried this post in the Access VBA forum but got no response so I thought I'd try it here too. I have a small Access 97 database storing descriptive fields for codes that exist in a number of other systems. I have very little knowledge of XML (just what I have picked up from the...

I have a small Access 97 database storing descriptive fields for codes that exist in a number of other systems. I have developed a template (in Access97) for users to request updates to the data (including an approval process through lotus notes - since most requests will come from users that...

Is there a way to check if Lotus Notes is open and that the user is logged on (Access97)? I am e-mailing succesfully, but if the user is not logged on to notes, I get the following two errors: "The NOTES.ini file cannot be found on the search path (PATH): notes.ini" (This one appears to be a...

I am programatically doing the following (in MSAccess97): 1. creating a table 2. populating the table by importing from a text file 3. updating a field in the table For some reason, I am getting the Run-time error '3011' (table cannot be found) within the third step. If I choose the debug...