Search results

are you saying thta if i enclose a curdate variable in #'s it will treat it as a number? i'm a bit confused, can you offer an example?

i haven't looked into this, but does anyone know if and how i can use dates in formulas? do standard operators work? does it calculate properly (diff't numbers of days in months, etc) will something like curdate = 21 jan 03 curdate - 30 (days) = 22 dec 02 and dare i ask about leap...

i don't know that i entirely understand your plight, but here was a similar situation i had awhile back: i had a list box of all names in a form, and sevveral boxes of data bound to that names record. anyway i wanted to click on a name and load their data into that box, here's the code i came...

Environ("Username") was exactly what i needed. i updated the audittrail module and it works fantastically now, now i can remove all those pain-in-the-ass securities. thanks guys!

er the only way i can get audit trail to accurately display which user made a chnage is by setting up security, etc. how do i do what you're proposing?

i'm afraid i'm a bit vexed as to how the security features work. I have a database saved on a shared drive accessible by about 6 people. when i log into the database from my pc everythings fine and everybody is happy and i get prompted for a password and woo. however, when i or anyone else...

i downloaded the necessary dll's for appuser, and when i open my db (it is secured), i get a permissions error. now, i have admin priveliges, what's with that? anywho, it seems to work fine (except for a subscript out of range error i get) except i'm not getting user names. the about says i...

oh i've imp'd audit trails and it works awesome. what i was hoping was a sort of user management so i could see , realtime, who was accessing (no pun intended) what at any given time, as well sa what users have the database open.

Ok, so i set up workgroups, permissions, etc for my database. Im wondering if there's anyway to manage user accounts? ie, viewing who is currently accessing what, who has accessed what when. If there aren't any built in menus or anything is there any other way to do it? Regards,

that was the problem i wasn't referencing the form properly. thanks a lot guys!

=IIf(IsNull(DLookUp("[Rater]", "RaterSchoolTable", "[Rater] = """ & Me.cboRater & """")), "No", "Yes") so what i gather from that is that if the name in cboRater is not in RaterSchoolTable than its a 'no', if the name is present than its a 'yes'. is that accurate? either way...

i hate wasting space with simple syntax errors, but i'm afraid i dont see what's going on here enough to spot the error. i get a syntax error "May have entered operand without operator" =If(IsNull(DLookUp("[Rater]", "RaterSchoolTable", "[Rater] = '" & Me.cboRater "'")), "No", "Yes") Anyone...

this is wonderful ghudson. exactly what i was looking for. now i just have to implement user priv's and what not so i can track who changes what. thanks so much ghudson!

is there any way to determine what field out of a list of fields was updated last? ie i have a tracking form with 6 locations, all with the date the paperwork last arrived at that location. i need a way to determine, either by latest date in series or by last-updated which one the paperwork...

It seems as though for every problem solved two more rear their ugly heads. This one seems like the answer would be simple i just can't quite grasp it. So every member of my squadron has a rater. That rater may or may not have attended training. I have a form that displays rating...

ok so my users dont have any concept of uniformity throughout a database so i can't rely on them to keep all entries in all capital letters. i dont know a damn thing about validation rules; how would i go about making 'allcaps' a validation rule? also for the existing 350+ records, is there...

That's perfect, that's exactly how i have it. anything that has a standardized format is a menu box linked to another table (or just hardcoded in if its like 5-6 options). thanks guys!

a lot of it is jargonish so let me sum it up Office (dept) Rank deros (when they're leaving us) address (where they physically live) mailing address (this will always be a po box) home phone duty phone cell phone status (whether they're not here yet, are here, on leave, hospitalized, etc) DOB...

Guten tag, I have 2 questions about tables: first is primary key. i have a table featuring all the personnel in my squadron, and i've set the social security # as primary key for obvious reasons. the problem is i have a form that lists everyones names and you can select it to load their data...

You save the day again, Namliam!