Search results

  1. M

    Re-prompt search criteria if no result

    I have a form that is based on a search query where a prompt is displayed for the user to enter their search criteria. The form then displays the associated records with that search criteria. This is working great with one exception. If the user enters no criteria or searches for something that...
  2. M

    Change button properties based on criteria

    I'm not sure if this is even possible in Access. But I would like to change the properties of buttons based on if data is entered in specific fields of the tables the buttons are associated with. Specifically, change either the button color or the text color on the button. Does anyone know if...
  3. M

    Help with conditional statement

    This is basically what I'm trying to do. if RecordID does not exist in TableA, I want to run a save process and then continue on with my code. If RecordID does exist in TableA, I want to skip the save process and continue on to my code. This seams to be a pretty simple If..Then..Else...
  4. M

    passing value from query for as search parameter to another query

    passing value from query form as search parameter to another query I have a form that is based on a query. The query allows the user to enter a String and will search several fields of the Parent table for any instance of that String and will return the entire table. I have a button on the...
  5. M

    Update multiple tables from one the value on a form

    I have a database that has one parent table and multiple child tables. The parent table has a RecordID field (primary key) that is an AutoNumber. All the child tables have RecordID field with a one-many relationship to the parent RecordID field. What I am attempting to do is have the RecordID...
Back
Top Bottom