Search results

  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...
  16. C

    Passing data to query from form driving me insane!

    I will post it at night !
  17. C

    Passing data to query from form driving me insane!

    I have managed to fix it by rebuilding it from scratch. Weird issue though! Thanks for your replies
  18. C

    Passing data to query from form driving me insane!

    Ok I 'm making a copy and post it
  19. C

    Passing data to query from form driving me insane!

    Double checked and the same thing happens !! When I open Access 2007 with security content disabled I can pass data from a form to a query , (or a combobox data to another combobox ) but when I enable content a get a prompt for value ??
  20. C

    Passing data to query from form driving me insane!

    MyForm and FormCommand used just to give an example! And yes the form is open when I run the query.I also tried to update a combobox based on other and used in the Row Source of the second combo in the criteria row the same [Forms]![Myform]![FormCommand]. Then when I open the form it prompts...
Back
Top Bottom