Search results

  1. Z

    Track changes in a field with the date

    Thanks a lot guys, but I've decided to let this project go; my boss doesn't think it's necessary. Maybe some time in the future. I have looked into what you guys suggested, and I kind of got the hang of it, so I'll be able to do it in the future with less help.
  2. Z

    Make a non-print section of the form

    Sorry I meant RIGHT. Currently, my form is big enough that it's one A4 page wide. I want controls on the right side of the form but I don't want to expand the form for print, coz otherwise, I'm left with extra space that prints on 2 pages.
  3. Z

    Make a non-print section of the form

    Is this not possible?
  4. Z

    Make a non-print section of the form

    Bumpity bump
  5. Z

    Create a multi-field search box that goes to the record in a form

    So, I need to redraw my entire form for this?
  6. Z

    Make a non-print section of the form

    I want controls on the left of my form, but when I do it this way and then print a record, it displays a big blank section. How do I make the left side a non-print section for my controls?
  7. Z

    Track changes in a field with the date

    I want a field in my table (called 'ContactTotal') that tracks the total number of times the date was changed in the field 'LastContacted' - through either table or a form, but it should exclude any changes made on the same day. I'd also like a second field (called 'Popularity') that does the...
  8. Z

    Create a multi-field search box that goes to the record in a form

    My form is bound to a table (3 in fact). How can I do it on a table-based form.
  9. Z

    Short text fields with scroll buttons?

    Thank you both. It works!
  10. Z

    Short text fields with scroll buttons?

    Where is that? I can't find it in the property sheet
  11. Z

    Short text fields with scroll buttons?

    That removes the scroll bars but it still doesn't act like it should. A normal short text field allows you to press return to jump to the next control in the tab order.
  12. Z

    Short text fields with scroll buttons?

    Most my short text fields on my form are normal, but some have scroll buttons like a memo box and it's annoying, especially because the user can't jump to the next field by pressing return. How do I make them normal? Thank you.
  13. Z

    Create a multi-field search box that goes to the record in a form

    I'm sorry, I tried to look into the stuff but just didn't understand how anything related. Please walk me through your suggestion of making a search box just on basic terms and I'll look into the stuff I don't quite understand.
  14. Z

    Create a multi-field search box that goes to the record in a form

    That's not close to what I'm looking for. It's a query-type search. I want something that jumps to a record in a form.
  15. Z

    Create a multi-field search box that goes to the record in a form

    My vba is very noobie, but I'm good at recognizing patterns and whatnot, so if you explain to me what happens in the code, I'll be able to understand it. The instant search part isn't very important, but it would be pretty nice to have.
  16. Z

    Create a multi-field search box that goes to the record in a form

    I presume this is a popular question, but I couldn't find a decent one that works for me. This is what the search box must do: - Searches 3 fields (StudentID, FirstName, LastName) and jumps to the relevant record. The closer to the search box in the navigation bar below, the better, so this is...
  17. Z

    Text field (with formula) displays "#Name?"

    Okay thank you.
  18. Z

    Text field (with formula) displays "#Name?"

    Thanks, it seems to work, but this code is really inconsistent. Sometimes, it'll work and other times it won't. Will this work all the time?
  19. Z

    Text field (with formula) displays "#Name?"

    Sorry, what do you mean?
  20. Z

    Text field (with formula) displays "#Name?"

    I've got the following formula in the control source of a text field (txtAge). It automatically calculates age from txtDOB. It worked fine before, but now, every time I close the database and reopen it, the field doesn't work; it displays this: "#Name?". When I create a copy of this field...
Back
Top Bottom