Search results

Thanks Husky. I did figure out the string null syntax. But I cannot, for the life of me, get it to work because there is an if.. then situation. See if you can figure this out. Global strDiv as string Public Function ReadDiv() If strDiv="ALL DIVISIONS" then ReadDiv="'PAC' OR 'PRF' OR...

Nevermind, I got it to work. But I do have one more question for you. I also have to create this global variable for a string. What's the equivalent syntax for a string, i.e. for a date, you showed me the syntax "readdatefrom = nz(datefrom,0)". My global string variable is strDiv. If I...

This is exactly what I was looking for. Thank you! Call me stupid, but when you say "whateverdate1" and "whateverdate2" what is this referring to? Shouldn't I be calling the read dates functions on my button click event in my form?

Hi All, If anyone has any ideas here for me, I'd really appreciate it. I have MENU1 and MENU2 that each have 2 user input text boxes - begin and end dates. User inputs begin and end dates and query runs for records between those dates. Here's what I need to do: 1. Determine if MENU1 or...

I found a demo database that is supposed to auto logoff users. It seems to work well for those in this forum that have tried it, but I cannot seem to figure out why it only works on MY PC and does not flash the shutdown message or shutdown other users on the shared database. Any ideas? Click...