Search results

  1. G

    Lock form edit under criteria

    I have a form with 5 text boxes. A, B, C, D and F. Text boxes A, B, C, D have numeric values. Text box F is date. I want when text boxes A to D have the value 0 and text box F is filled with the date to lock edit for this registration and the corresponding row on the table. I want it to...
  2. G

    Fill text boxes on form based on combo box selection

    I have a combo box on a form that has the model of the product. I want when I select the type of model on the combo box to fill automatically the text boxes on my form with the quantities of the accessories for this model. For example… I select model A on the combo box I want to be displayed...
  3. G

    Increase the value of the next record from last record +1 on click

    I have a text box on a form that I need for every new entry to be automatically increased by 1 on click event. My first value would be 520000001 and when the user makes a new entry and clicks on the text box I want automatically to take the value 520000002 and for the next record the value...
  4. G

    Update query to fill blank fields with corresponded value

    I am relatively new to Access and I want to make an update query that will fill blank records of a field with the corresponded value based on another field. Let me give an example to understand what I mean. Table: ID COLOR 0025 black 0036 white 0074 red 0025...
Back
Top Bottom