Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Minuet

    Logging access to Access

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

    Show last record upon opening

    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...
  3. Minuet

    Show last record upon opening

    ...one being a date. I have entered the following code into the form's record source to display only the most recent dates. SELECT tblAppointments.* FROM tblAppointments WHERE ((tblAppointments.ApptDate)>=DateAdd("d",-365,Now())) ORDER BY tblAppointments.ApptDate ASC Sometimes...
  4. Minuet

    Show last record upon opening

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

    Message Box

    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...
  6. Minuet

    Message Box

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

    P/w protecting a form

    ...into my form, I always go for that option! (I didn't quite understand your notes about "password forms," etc.) The only problem I have with Eric's code is I'd rather not have the password showing as it is typed, but have *'s appear instead. Is there any way to accomplish this?
  8. Minuet

    P/w protecting a form

    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?
  9. Minuet

    AllCaps Question

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

    AllCaps Question

    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...
  11. Minuet

    P/w protecting a form

    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?
  12. Minuet

    AllCaps Question

    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...
  13. Minuet

    AllCaps Question

    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...
  14. Minuet

    AllCaps Question

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

    AllCaps Question

    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?
  16. Minuet

    Message Box

    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...
  17. Minuet

    Show last record upon opening

    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...
  18. Minuet

    Show last record upon opening

    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...
  19. Minuet

    Show last record upon opening

    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...
  20. Minuet

    Show last record upon opening

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

Part and Inventory Search

Back
Top