Search results

  1. R

    How to pu the result of a SELECT MAX(value) FROM table_name into a TextBox

    Hello, I have two comboboxes. After the selection is made in each combobox, I input an ordering number in a textbox. The number must start with 1 for each new value of the pair combobox1.value+combobox2.value. When the user want to add a new record, I want to put in a textbox the last number...
  2. R

    I need to save in a table an information that is not bounded on a field in the table

    The problem is solved! When I mad the combobox with 4 fields(columns) in query I set up the Column Width to 0, except the column that I wanted to be displayed. When I changed and I gave 3 cm to each column he started to fill my textbox. Weird!
  3. R

    I need to save in a table an information that is not bounded on a field in the table

    I tried exactly like you said. If I remove the CmbTitle.Column (3) from the ControlSource of TxtAp and I put this in AfterUpdate event of CmbTitle, the price is no more displayed when I select a title from combobox and I move focus on the next object. In this case, even if I set the...
  4. R

    I need to save in a table an information that is not bounded on a field in the table

    I work in Access 2007
  5. R

    I need to save in a table an information that is not bounded on a field in the table

    Hello, I have a form where, when I select an item from the combobox, a textbox is filled with [comboboxname].[column](3). I set up the control source of the textbox with [comboboxname].[column](3) Because this information can change during the time, I need to save it in a table as it is at the...
  6. R

    problems with combobox Requery

    I already did that before sending the message. The same result.
  7. R

    problems with combobox Requery

    Hello, I have a form with 4 comboboxes, each of them based on a query from a table, so, queries from 4 tables. If the user does not find the information on the combobox, he push a button and the corresponding form opens. He enter the data, close the form and returns to the form where is the...
  8. R

    fill a value in a textbox when an item from a combobox is selected - Access 2007

    I need "Table1FieldNumber" data in the Table2 because it can change and I need to know what was the value in the moment when the record was created.
  9. R

    fill a value in a textbox when an item from a combobox is selected - Access 2007

    Thank you all, it works when I set the ControlSource of the textbox. Thank you again, Robert
  10. R

    fill a value in a textbox when an item from a combobox is selected - Access 2007

    Hello, I have a problem and I don't know how to solve it. I have a table, Table1, with three fileds: Table1FieldId, Table1FieldName, Table1FieldNumber. I have another table, Table2 with: Table2FieldId, Table1FieldId, Table1FieldNumber On the form attached to Table2 the Table1FieldId is...
Back
Top Bottom