Search results for query: *

Can Access be set up to keep track of who accesses a particular database and when?

KenReay, I should have started a new thread - this is getting confusing! Instead of just arranging my records in descending order, I would rather only display the most recent records, but click a button to display all of the records if I need to see all of them. My database is a little hard...

OhioSteve, I'm not sure we're on the same wavelength here. My subform within a subform contains multiple records, each record consisting of a few fields, the main one being a date. I have entered the following code into the form's record source to display only the most recent dates. SELECT...

Unfortunately, OhioSteve, your post goes a little over my head. I do much better with step-by-step instructions . . .

I tried putting the code from BGrego into the BeforeUpdate event, and it seems that the value is still saved in the field. What I probably want to do is create a validate macro . . . So, what is the proper way to write this condition: if ApptType from tblAppointments is "IPD" then a...

Thanks so much for your help, Rick! I will follow your advice!

Eric, thanks! Your code now works! Richard, I changed "YourPassword" to the password of my choice. Isn't this sufficient? (The people I am protecting this form from are NOT computer literate and won't think to open the form in design view or even look at the table.) I am...

Luceze, I copied and pasted your code into my form (but changed the password), but when I open the form I get "Variable not defined" and "Pword = InputBox..." is highlighted. What did I do wrong?

Thanks so much for your advice/information! It's very helpful!

Roy-Vidar, I finally got your code to work! I did have some formatting thingies on that field that were preventing the code from working. Thanks so much for helping me out! When I first created my Access program, I knew nothing about Access and I created really badly named fields which...

My database consists of multiple forms. I am wondering if it's possible to password protect one of the forms in my database (and not the whole database). How do I do this?

RoyVidar, I'm still having trouble with your code! I am wondering if it's because of the name of my field, which is "AxisI(1)." Maybe the fact that it has parentheses screws it up? Anyway, it's not working, and neither does Missingling's suggestion of puting ">" in the...

RoyVidar, your code works, except it does something I find annoying. When the cursor leaves the field, the letters are capitalized, but when I put the cursor back into the field, the letters are shown lowercase. I need a code that converts lowercase letters into capitals and saves them as...

I tried putting the ">" in the input mask, but then it wouldn't let me type ANYTHING into the field!

I have a form field in which I enter codes that are a combination of letters and numbers. The codes vary in length and sometimes don't include any letters. How can I use VBA to force the letters in the field to be capitalized, even though there are not always letters in that field?

How can I program Access to pop up an error message box upon LostFocus if an inappropriate value has been entered into certain field? For example, if [ApptType](my field) of [tbleAppointments](my form) = "IPD" then I want an error message to pop up with wording of my choice, but if...

Okay, I have another idea. Would it be possible to program my sub-subform to display only the records entered in the last year, but have a button on the form that can be used to display all records? That way my list won't be so long, but if I need to see older records, I can just click the...

I really appreciate you trying to help me, Mikee! Unfortunately, I still can't get it to work. I am wondering if it doesn't work because the list of records in the subform are filtered according to the the value chosen in a combo box. It might help if I describe what I use my forms for. I...

This (DoCmd.GoToRecord , "", acLast) didn't seem to work with my program. My Access program consists of a main form which contains a button that, when clicked, opens a subform. This subform contains another subform that displays small records of three fields each in a list view...

Can someone please tell me how to program Access to show me the last record upon opening the form?