Search results for query: *

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?

Thank you for your response. As a programmer, my finger is permanently afixed to the shift key, but I'll the import/delete/re-import thingy.

I just spent 3 hours on a form, and now it won't open (not even in design mode). No error message or anything. Has anyone else experienced this? Another programmer told me that happens quite often with Access 2000. (If that's true, I'll find another career .. I just lost 3 hours worth of...

I put it in a separate, password-protected .mdb altogether that the users aren't even aware of, called AllowDisallowShiftKey.mdb, since I, as the programmer, would be the only person who would need to disable the shift key in the main application (for quick code changes/fixes). This .mdb has...

bcastner: I have the exact problem as the threadstarter, and I followed your instructions to add the network adapters to the trusted zone in Zone Alarm on each computer, and still my two computers cannot see each other in Network Neighbourhood. What else could it be? File and printer sharing...

Thank you, she'll check it out.