Recent content by cafe_jay

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

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

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

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

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

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

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.

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

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

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

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

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" =...

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

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.

can i use a query for the SQL?