Search results

Thanks but it doesn't work, and I really don't know why. now the code for my button is Private Sub Command100_Click() DoCmd.OpenQuery "UniqueCompany" DoCmd.OpenQuery "JobTitle" DoCmd.OpenQuery "PublicationDate2" DoCmd.OpenQuery "ClickThrough" Me.Requery End Sub Is it correct?

I have sorted out the criteria, my problem is just the button on the form it's just I want to run the query by clicking the button after I change the value of combox. currently, I need to click 'refresh all' button on the datasheet every time after I change a value of the combox, I want to...

so it's exactly what you've described, my combo box drives your form, i.e. when you select a value in your combo box you want your form to be filtered based on the value in the combo box. so was my coding correct based on that?

sorry I guess it was my mistake, I didn't mean criteria those 4 combo box contain a list of values that I can choose and then click the button to run the query to get my results datasheet

I put criteria in the combox, so I can choose whichever criteria i want from the list of my combox.

Thanks guys However, it doesn't work. here is the code for my button, could you please have a look and let me know if it's correct? Private Sub Command100_Click() DoCmd.OpenQuery "UniqueCompany" DoCmd.OpenQuery "JobTitle" DoCmd.OpenQuery "PublicationDate2" DoCmd.OpenQuery "ClickThrough" If...

Thanks My form is actually based on my query, and it is set to datasheet view. if I have to use Me.query, where should I put it? I have tried put me.query in the VBA code under the button on my form, but it doesn't work.

Hi all I have a form with a 4 combo boxes that I can choose different criteria to get my query results. I also have a button at the bottom of my form, when I click this button, it will runs all queries to get the results datasheet. now I want change the criteria in the combo box and I was...

Hi All I want to count multiple fields from a table. The table has fields like name (john, marry etc) Date (12/08/2012, 10/08/2012 etc) Articalread (xxxx, xxxx, xxxx) what I want is how many times did john read artical xxx on 12/08/2012 basically I want to take account all three fields...

Sorry to trouble you again, so I added this message box and it worked, but still my queries were not runned properly, what I should do now?

Thanks Pre-eugin I have tried, but it still doesn't work. not sure why though Please see attached image, that's the code I use, let me know if there's any wrong with my coding. Thanks again!

I just added button from the tool bar and it lets you to choose the function of the button and also to link to the query you want to run. I don't know the DoCmd at all I'm afraid, where should I add this DoCmd code to? Thanks

Hi all I have a very simple question I have added a button on a form to run queries, appearently the button only runs one query, what should I do to make it run multiple queries? If I need to use VB code, can someone give me an example of code as I have no idea how it works:-( Thank you...