Search results

  1. C

    How to call a function that is in a module.

    I had tried that and it did not work... but my function had a type that i had declared as.. Private Type myDimension height as long weight as long End Type Public Function myFunction As myDimension qwertyuiop End Function So i made the type a public type and then i was able to...
  2. C

    How to call a function that is in a module.

    Yes, I get : runtime error. Object required. Im guessing that means that my function isnt defined, the procedure doesnt know to look n the module? im not sure the syntax i am supposed to use
  3. C

    How to call a function that is in a module.

    I tried searching from this with no luck. I am a novice so this might be easy to others. I have a module called myModule. Inside this module I have a function called myFunction Private Function myFunction() As Long myFunction = 100 End Function I would like to be able to call this function...
  4. C

    Filtering a subform using a combobox in the main form

    I did this... A And B And (C Or D or E) But its reading it like this... (A And B And C) Or D Or E. I am going to try this C Or D Or E And A And B, hopefully like this it reads from left to right
  5. C

    Filtering a subform using a combobox in the main form

    pbaldy, If i have a string of AND parameters and OR parameters how would i connect them. Im sure its something like example "Oranges AND Orange AND (Peeled or Rotten)"... so what gets displayed are both Peeled and Rotten Oranges... strOr = " OR " strAnd = " AND " strSQLAnd= "WHERE...
  6. C

    Filtering a subform using a combobox in the main form

    pbaldy, I have improved my form in access. Now i would like to have a search bar that searches a string in multiple fields. At the moment im having problems adding the OR clause to the syntax. I can search on text in one field but not one text in multiple fields. This is what i have so...
  7. C

    How to email a report to a list of emailusing outlook

    I tried implementing the info from the link you sent me but it didn't work. Or maybe i just wasn't able to get it to work. Also I dont want it to automatically email, I would like for outlook to open then the user can press send themselves in outlook.
  8. C

    How to email a report to a list of emailusing outlook

    I would like to email a report or form to a list of contacts. I currently have the simple button that when clicked it opens access and i have to put the contact info, the subject, etc. myself. this is the simple macro for EmailDatabaseObject. But i would like the recipient info to be...
  9. C

    Filtering a subform using a combobox in the main form

    Thats what did. I made a fxn, then when either cboBox is updated it calls the function. As opposed to having a search button.
  10. C

    Filtering a subform using a combobox in the main form

    I looked through your sample file. That helped a great deal. Not only did I learn how to implement this on my main form which has 3 subforms, I learned from your style of coding. I like how each new field added to the search of the previous field. At first i was just going to write a million...
  11. C

    Filtering a subform using a combobox in the main form

    pbaldy, When I say a secondary filter, what I mean is... Once the first filter is applied, the focus would be set to the secondary filter. Then you can use this next combo box to narrow the search even further. So the the first cboBox had A,B,C. Now cboBox2 has 1,2,3. Therefore you can search...
  12. C

    Filtering a subform using a combobox in the main form

    Thank You so much i was finally able to get this to compile. My next step was to fix the "All" tab in the cboBox. So if "All" is clicked i want all filtering cleared. This is what I did (It doesnt clear the filter it just includes all three, the point is that it works :) ).... "IF "All" =...
  13. C

    Filtering a subform using a combobox in the main form

    this is what i have now and it kinda works... Private Sub cboBox_AfterUpdate() Dim MySQL As String MySQL = "Select * FROM myTable WHERE field = " & Chr(34) & Me.cboBox & Chr(34) Me.subForm.Form.RecordSource = MySQL. It doesnt fully work because my query shortens the table to less objects...
  14. C

    Filtering a subform using a combobox in the main form

    Also my cboBox is UNBOUND so in my code I have it as "field", I know this is wrong... How can I label the Control Source so that i can call it in VB.
  15. C

    Filtering a subform using a combobox in the main form

    can i use a query for the SQL?
  16. C

    Filtering a subform using a combobox in the main form

    I tried... Private Sub cboBox_AfterUpdate() Dim MySQL As String MySQL = "Select * FROM Me.subForm WHERE field = " & Chr(34) & Me.cboBox & Chr(34) Me.subForm.Form.RecordSource = MySQL but i get "error 3024" saying it can not find "Me.subForm.Form.RecordSource"
  17. C

    Filtering a subform using a combobox in the main form

    I am having trouble filtering my subform. mainForm, subForm, cboBox My cboBox has a list, "All, A, B, C" When All is selected I want the subForm category to display A,B and C... So when A is selected, i would like for the AfterUpdate() function to compare "A" to the Category field in the...
Back
Top Bottom