Recent content by sumoalex

Ooops, I revisited the code and it WAS a misnamed field. Thanks Crowley!

Crowley: Did that, no nulls or mis-named variables. At first I thought it had to do with the named range, but that's fine to. I'm STUCK! Argh.

I've got a table in Access with 14 fields that I'm trying to send to an Excel spreadsheet using VBA code in an Access module, and I'm getting "3265 - Item not found in collection" error. It creates the workbook fine, places the first value from the first field in the spreadsheet, then craps out...

Michael: I appreciate your responses, but my thread was about nesting "IIF(nz... " in a query, and I've received great responses that I've put into production). I'm not sure that your code "To return the MINIMUM or a series of values" is appropriate to this thread.

PHV: Nice tight code. I like that. Thanks!

cmmrfrds: Cool! Thanks for that.

I appreciate your response, Michael, but would this work in a query?

Thanks a million guys!

Can I actually substitute the "nz" with "IsNull" (This is in a query)

I need to modify the following: IIF(nz([Date1],0)=0,[Date2],[Date1] to say: if Date1 is null, use Date2 but if Date2 is null use Date3 but if Date3 is null, use Date4. Is there a nested IIF(nz syntax guru out there?

To clarify... when the .mdb is used in Access 2002, it does give a message to indicate that it knows it's in "Access 2000 file format".

We are pair-programming using Access 2000 and 2002. We have a form that has a list box that gives different results on an Access 2000 machine versus an Access 2002 machine (Access 2000 seems to filter or limit the results inconsistently, as opposed to Access 2002 giving us all of the results.)...

I've checked all my references and they all seem OK. It's just on this one machine that I get this error message. Does anyone have any idea why this might be happening?

I can't thank you enough. I believe it's exactly what I'm looking for! It looks like it works for one-day bookings on the tblSchedule, but with with a little code-tweak, I should be able to get it to go through date ranges on a table.

I'm developing an equipment booking system, and my client would like to have a calendar display to show availability, i.e. for days a particular piece of equipment is already booked, colour those days on the calendar red. Has anyone here done anything like this with Calendar Control?