Recent content by chris89

  1. C

    Nested functions in form

    Thank you for your responses!!
  2. C

    Nested functions in form

    That is what I am asking! lol
  3. C

    Nested functions in form

    I don't know how to code this...
  4. C

    Nested functions in form

    Hello everyone! I have one form with Clear_button that has onClick Event Procedure like this: Private Sub Clear_Click() Me.text1="" Me.SearchForm_subform.Requery End Sub I want to call this function on an other private sub Is there a way on doing this?? Thank you in advance
  5. C

    Select statement in VBA

    Thank you !! This is exactly what I was looking for
  6. C

    Select statement in VBA

    I m trying to write the following SQL statement in VBA: SELECT ID,Product,Size FROM Products Where Product ='A' AND Size = '1' I want to use the values from combobox 1(cmb1) for 'A' and combobox 2(cmb2) for '1' I know how to code it without the AND Operator like this: "SELECT ID,Product,Size...
  7. C

    Access Quit Command not working in Macro

    I know this is a very old post ,but has anyone a solution for this?
  8. C

    Dynamically load textbox based on user input

    Thank you for your replies I will try to redesign my database
  9. C

    Dynamically load textbox based on user input

    And the real scenario is this: I have to enter for each ProductType ,Products everyday. I know the ProductType and its value ,and based on the ProductType there are specific Products that must also be entered. So because of many Products I have to : 1.find what Products there are for each Type...
  10. C

    Dynamically load textbox based on user input

    Ok I have attached another pic of the procedure and a sample database (form1 and query1 were created only for presentation - they are not functional).
  11. C

    Dynamically load textbox based on user input

    I don't know where to get with Dlookup() , as from what I understood it is used for query type operations .. I'm trying to achieve it through a query that gets the needed records according to user's input in form1 and append this to Matchtable . Please advise me if I am in the correct...
  12. C

    Dynamically load textbox based on user input

    I don't know exactly where to use Dlookup(). I mean I could use it like a :select,from,where statement . And this in my case would be the recordsource for what? Thanks again
  13. C

    Dynamically load textbox based on user input

    First of all thank you for your reply! I upload an updated .accdb for better explanation. My problem is this: In table3 I have written the values from table1 that goes with table2. When a user selects from form1.tbl1field1 a value , I need the MatchTbl1WithTable2 textboxes to have (EACH) a...
  14. C

    Dynamically load textbox based on user input

    Anyone please?
  15. C

    Dynamically load textbox based on user input

    Ok here is a tough one!(I don't even know if this might be possible) I have uploaded a sample database to show better what I want. 1.User selects from tbl1field1 a value. 2.He enters a value in ValueToTbl1EnteredFormUser In table3 I have preseted a what goes with what from table1 and...
See more
Back
Top Bottom