Search results

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

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

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

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

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

Thank you, used the dcount, worked great. I'll be posting other questions as i keep working on this DB. Thanks

Thanks guys for the prompt reply. Maybe I didn't explain myself correctly. I have two fields on the table Date and Rxnumber I made a form to input this info. What i need is that i can have duplicate dates and Rxnumbers but not in the same record. no two records can have the same date and...

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