Recent content by lollyjar

Perfect KarMac21, thanks. Lollyjar

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

Is there any other way to do this? ... I have a rows in the continuous form for display only. I want the user to be able to approve each row, one by one by typing Yes/No in a text box and then clicking an Approve button in the Form Header to trigger a function to pick up each approved row and...

Hi Guys, Thanks for the tips, it looks like it will work but... I've never used conditional formatting on a text box on a form. How do I do this (if it is available in Access97)? Cheers

Thanks for the response, I will clarify the second quote above. Some rows in the subform have extra information stored elsewhere. The buttons are used to open a form to view this extra information. Many of the rows, however, do not have any additional information and therefore the details button...

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

Brilliant ... thanks!

Does anyone know how to delete a module programatically? Cheers

Is this also possible in DAO? Cheers

Out of interest, also see thread181-27567 with a similar problem, at this time with no solution.

I've tried a couple of PC's with an identical installation to mine and I do not get the error. Would a re-install of excel possibly fix it? Out of interest, I just found another thread that has come to a similar dead end ... (for completeness, how do I insert a link to the other thread?)...

If I use the following code, using variant, myRange actually returns the text that is in the cell, I guess as a string, instead of a range. Sub subTest() Dim myRange As Variant myRange = Application.InputBox(prompt:="Sample", Type:=8) End Sub If I try to do the following and use...

Yes it is in Excel. Have you seen this before?