Search results

also, if their was also a table within my DB that would show me login history (who has logged in @ what time and logged out @ what time, as well as who is currently logged in). the DB i mentioned before that i had found had far too many moving parts for my liking, something short and sweet would...

i searched through previous threads and did not come across exactly what it was i was looking for. i am interested in creating a multi user login for a database that i will be distributing to a large group of people. what i am looking for is some coding to make this happen. maybe a nice how-to...

Thank You! This will be a huge help.

Basically what i am looking for is if the number 1 is inputed, a specific word would be returned. the number 2, a different words, and so on...

that is an interesting alternative. I have never heard of the switch functiom. Do you have any additional info about SWITCH? Also, in your line you had, "[Example]=1, "Example 1"", that would return Example 1, right?

funny thing now is for records yet to have any values in them, the "None" is populating, but nothing else

I am running into a problem with the IIf function. Below is my code, what i am trying to do is in a text box on a form, with the control source applied to another field, i want to take the numeric value and convert that into a word. =IIf([Example]="1"...

i am pretty confident that i can follow steps. especially macro related. what i have is a form in datasheet view, one of the collums in this datasheet view is a check box. my goal is to make that check box (which is not enabled and is locked) become checked once 1 of 4 options are selected...

sorry, uploading it is something that i am not able to do. the description i gave originally is about as clear as i could get. i am open to suggestion on running a query in a macro. that may be something that works for me???

do you have any suggestions on how to construct this macro?

could you give me an example of a .value? i am unable to share my db, sorry.

i have a check box on a form that is not enabled and is locked, my goal is to have that check box become "checked" when a certain action is performed on another form. for example: if the check box is on "form1" it is unchecked by default. i open "form2" and trigger any one of 4 option buttons...

ugh, once again an easy fix to a problem that i missed. thank you very much. also, HiTechCoach, i was hoping you would take a look at another thread of mine that references another thread you were previously instrumental in: http://www.access-programmers.co.uk/forums/showthread.php?t=192704...

i am getting the following error in an on click event for a login form i have created. Run-Time error '2447': There is an invalid use of the . (dot) or ! operator or invalid parenthesis. the debugger highlts the following field: ![computer_login] = Me.txtUser_hidden now, this is in...

nevermind, thanks to any viewers though. i found it in another thread: http://www.access-programmers.co.uk/forums/showthread.php?t=173881&highlight=real+time+date

i know this is an old thread, but i found it quite interesting, the clock works great for me but the date is giving me nothing, i have this located in my main switchboard, so there are other codes already in the on open event procedure. and i did take liberties with the text box names, but they...

i have a form being used as a sub form that is in datasheet view. it basically looks as if i have a table as my sub form. it is exactly what i want, except for one minor detail, like in your tables, you can right click on the record selectors and choose to delete row. i want this specific...

duh, easy fix. thanks a bunch!

Thanks for the input, but i found the answer i was looking for in another forum: http://www.access-programmers.co.uk/forums/showthread.php?t=118268&highlight=clear+record+command if anyone viewing this thread has a bit more time, i would appreciate any help you can provide on another issue i...

also, it may be worth noting, some of these fields i am looking to clear are option buttons.