Search results

  1. K

    Help! Left join driving me crazy!!

    Can't figure this one out. I have a left table with field "Product". I have a right table also with field "Product", but also many other fields. If I left join on "Product", I want all products from left table to show. If no match in right table, I want nulls. Has worked a dozen times before...
  2. K

    Relinking a lot of tables at once

    Access 2003, Windows XP Here's the problem: I have a ton of table (200) that are linked IN to database X. They are linked from: \\ a \ many different levels of folders here \ database.mdb As of today, they migrated my A drive to the B drive. So all the links are broken in database X. Is there...
  3. K

    Text Box Validation Rule Doesn't Quite Work

    Hello, I can't seem to find a solution to my problem. I have a text box on a form were the user inputs a date. If they skip this, then that's bad. So, in design view of the text box, I have set a validation rule of "Is Not Null", and validation text of "A date must be entered". It works...
  4. K

    Want error message if value exists in table

    I have a date field in a table (tbl_BO_CIC_Open_Recv) named "RepMo". I have a date field in a form (FormMaster) also named "RepMo". Now, when the user enters a value in FormMaster for "RepMo", I want Access to check and see if the value already exists in tbl_BO_CIC_Open_Recv (again, the...
Back
Top Bottom