Recent content by somedeadguy

make it "readable?"

Thanks! How'd you do that? use quote?

This is an address field that I am parsing out to get the street number separate from the street in a query. Here is my expression: DoNum: Switch(IsNull([dbo_Daily_Students]![DOSTRT]),'No...

Great, Thank you!

You are correct, I just checked it out in Print Preview and it worked. Strange, but I guess if there is no other way, I will open it in print preview for the user. Kinda hard to do a print audit trail that way, is there any way to use the ON FORMAT in regular view?

Thanks! I'm sorry, yes I am using 2007. Should I use a different view? The idea is for the user to look over the report ( I have it as popup so it's dummy proof) and then print.

I cannot get the ON FORMAT event to fire! I have even tried so much as adding a msgbox to make sure that it is firing and it will not. I can get my unbound label to populate in the ON PAINT event, but in a big report this causes everything to freeze. The ON PAINT event isn't the right event...

All of these mothods work great. Thanks everyone. PS DropDown is a very vague name for that Method, but it works great. Classic Microsoft! I should have noticed the method icon in the smart complete thing. After all of this data entry my eyes are crossing! Thanks all

That actually works perfect! Was not aware! Thanks!

Hello, I have made a simple data entry form. The goal of the form is speed, and the ability to tab through the form without having to bother using the mouse. We are using the native autocomplete in 2007 which works well. The dropdown lists names, id, and address. The names are not unique...

Hah, unfortunately 9/10 times the username is Administrator. I will go search for a Novell login API. Thanks for the help!

Yay It works! Thanks a lot!

Thanks! I have been using the GetComputerName api for a while, and by the time we find out where the ambiguous comuter name actually resides, the person has quit! This will come in very handy! I am going to try to find a way to place it in the OnDirty of all of the fields that will be edited...

Hmm DCrake, may I ask how you were able to get the computer Tag? I have the problem you were describing, we are all assigned DHCP Ips, which does no good. Is there a VBA function to retrieve this info from your LAN systems, or is it something available through the LAN? We use Novell, and I...