Search results

  1. L

    auto fill or enter new

    Ok guys this has probably been addressed many times, I seen similar question but most deal with my situation with combo boxes. Here is my problem. I have a table for customers with Lastname, firstname, etc. I have an order form where i want the user to enter the cutomer last name and first name...
  2. L

    Little Problem

    I cant get my queries to work. Queries for single tables i have no problem, but when I include another table, I dont get any records. Im thinking it has to do with relationship but not sure i tried every type of relationship with no luck. Needless to say Im new at Access, so any help will be...
  3. L

    help with lookup

    How can i acomplish this? I have a form to enter customer information, first and last name, address etc. I want that when i enter the last and first name, if the customer is allready in, to auto fill the rest of the information, but if its not to then let me fill all of it. Now keep in mind the...
  4. L

    rookie here, so bare with me - 2?

    probably very simple: 1.- I have a form to enter orders, what i want is that, when i enter the customer name (first and last name - 2 separate fields) if the customer is not on record a msg box pops up letting me know it and asking me if i want to add it. Then if i click yes, the "enter new...
  5. L

    Date control

    I have a field where i enter the date. Now the defaultValue is set to =Date(), but that enters the system date automaticly. What i want is to enter a date and that date stays in the field , so i dont have to enter the date over and over as i enter different records with the same date. I also...
  6. L

    Validation

    Ok when i enter a new record(RX numer) i want it to validate it by checking if there's anothere record(RX number) with the same date, if there is then get an error or msg stating that record exist with that date if not then record get entered. thanks in advance
Back
Top Bottom