Recent content by durdle17

Thanks for trying. Chris

Hey MileO, I have attached another version of the db. I just wanted to ask another question not related to the previous post. When you load up the frmDailyStats form, you will notice the Mouse Pointer with flicker between an hourglass, this is due to the hidden queries. Do you know how to...

Hey Mike, I have that done in this sample but how can I tell the charts were to get the data. I can use the query but if the user enters 3/2/03 & 3/8/03 and I want to say have a separte chart for 3/3/03 I do not know how to set that up. So I was thinking I would have to use a separte query like...

Finally.

Hey, I copied it and removed pretty much all of the data. Still the same size. Chris

Hey, I was looking for some advice but I am unable to post due to the size of the database after I zipped it up. So I started to trim it down but when I zipped it up again, and it was the same size. Any ideas?

Point Taken Thanks Pat

Great Idea Pat. Not sure how I would set it up. Currently I have 6 charts which are based on queries(May have to add another 12 charts to the form). A field in the queries(txtstdate) points to the value on the form. How could I devert those queries to the pop up box which I would prompt the...

Rich, I don't load them at runtime they are just hidden on the form. So when I open the form those charts will look at the null value in the textbox and put null values in all the charts. This is what causes the hourglass to show up for 10 or 15 secs. Thanks Chris

Thanks Vassago, But I don't I explained it clear enough. So I will try again. When my form loads it has 6 graphs hidden which run based on a textbox on my form. I want to prevent this 6 graphs from running, sort of like turning of Screen Updating similar to Excel. Since this 6 graphs are really...

Hi, I just want to expand on this a little. When I load my form my mouse changes to an hourglass(for a few seconds) due to "not visible" graphs running in the backround. I was wondering if there is a way to stop this from happening meaning the to turn off the screen updating. I have tring using...

Hey pdx I tried the or action just after I posted and that didn't work either. Thanks for the suggestion. Chris

Hey, I have a query with the following code which runs great SELECT tblstj.hhmm, Sum([tblstj]![acd_calls]+[tblstj]![abn_calls]) AS Total FROM tblstj GROUP BY tblstj.hhmm, tblstj.fdate, "All" HAVING (((tblstj.fdate)=[forms]![frmDailyStats]![txtstdate])); I want to include this code is the last...

Thanks ghudson The Requery worked great. Chris

Pat, Just want to say Thank You for those very helpful links Greatly Appreciated Chris