Search results

Hi all This is an old post that I still cannot resolve, and was hoping for some input. The main query does a count of various options on a Customer Satisfaction Survey. I created a blank form, unbound and placed a chart within it based on the query, when the query fires it asks 3...

One query collects the data, I created a standard report hit the Chart Wizard to place the chart on the Report, based on the query. That works fine. As i said previously, when your open the report you get asked the 3 Questions and the Graph shows up on screen ok, it's when I try to print it it...

Thanks for replying. Think I should have said that the report is printing a Chart, which is based on a query. So the report is unbound, but the chart within it is based on the query.

Hi Everyone I have a query thats drives a report. When the user selects the report they get asked 3 questions Reason, Dept and Category all driven from the underlying query. The report then displays on the screen. I placed a Print button on the report with the following code...

Your initial code. I needed to add a couple of more things to it, but when I saw how to do it and all fell into place.

vbaInet, You code worked like a dream and absolute dream. I am forever in your debt. Your code also enlightened me on how to improve another db too. Thanks also for everyone else's input. Best Regards Gareth aka StemDriller

I am trying to count various entries for various departments, so rather than creating several queries I was just hoping to get the user to input what they specifically want with the one query, which can then go on and create a chart

The following is an exert from a query in Access Poor: DCount("Ratings","tblRatings","Ratings = 1 and Reason =2 and Dept = 3 and Category =1") I am trying to make it a generic Query so when the query is run it will ask the user What Reason and What Dept and What Category? Pretty much like [...

Hi Everyone I really struggling with this. If one of you kind soles would open up the DB i have attached. There are 2 querys called qryCSTRQuality and qryCSTRQualityCount. I need to get qryCSTRQualityCount to Count the individual inputs. eg How many users have put Good or Fair so I can...

Yep Attached frmQuality

Thanks for replying Yes a straight forward tick box does allow tick and untick. What I have got is a Customer Satisfaction Survey, so I created an Option Group with a tick box. So the user selects 'Technical' and has an option for Fair, Good, Very Good etc, I did this to enable me to give...

Evening Everyone I've just completed a nice Form with various Tick Boxes in. It's only now that I have realised that the user cannot untick, if they want to change their mind or have made a mistake. Could one of you experts enlighten me. Many Thanks Gareth

OK, Screenshot attached Hope you can help

I just cannot get my head around this. Could you not update the test database that I have attached so that I can see what everyone is getting at. A really do appreciate your time and expertise, vbaInet Regards Gareth

Would you put the DCount in the criteria of the query?

I have a attached a test database, Can someone try and get 'Query1' to return a value of 0

Thanks for replying Ran the code and got 'Compile Error' User-defined type not defined. It doesn't like Dim appAccess As Access.Application

Bob Thanks for replying Ran the code and got 'Compile Error' User-defined type not defined. It doesn't like Dim appAccess As Access.Application Gareth

Jesse Thanks for your input I don't really understand what your saying. If the result of the query is an empty set or blank, just would like it to return a Zero so another MasterQuery can take the value and add it to it's final count that gets used for a Pie Chart. It would appear that if...

Thanks for responding The table the query is querying may not yet have any entries, so quite rightly the query is not returning any records. I am trying to get the query to display a 0 if there are no records. If the query comes back with a zero, I am then hoping to be able to Count this...