Search results

You would want to Group By month and Sum whichever field it is you want the total of. Thanks for your reply, Yes that gives me a total for the month, but what I am trying to do is have a running total for the month. eg day One has 100, total as at day One = 100 day Two has 50...

Hi, I need to write a query that will give me an accumulative total for each day of the month. Can this be done? I know it can be done in MSExcel so I assume it can be in Access, but I don't know how. Gezza

I have a graph the looks fine when I view it as a report but when I go to Disign View all I get is a blank square the graph is there but I can see it, which means I cannot edit it. Can anyone help Thanks Gezza

I think we are getting close, but I have limited knowledge of the actual code to use or how to construct it. The links you have attached don't explain it enough with my limited knowedge. I did find a list of available paper sizes but the page size I am looking for is not in the list.

Thanks for your reply, I am currently running, Access 2001 is there a way to do it pre 2002?

I have a need to be able to change Printer settings, specifically the Page Size, using VBA code. These are not standard Page Sizes but specific to a Sticky Label Printers attached to multible computers. Is this possible? And if so how. I have seen some code that nominates a specific printer...

Hi Again John Big Booty, Thank you, but I have consequently fix the problem I had by recreating the combo box from scratch, (originally I copied and pasted one from another combo box on the same form). Once I had done that the problem has gone. It is now all working fine. Thanks again Gezza

Yes your probably right, lesson learnt. Thank You!

I could but I am not sure how to do it?

Hi John Big Booty, Thank for your reply No only on closing

Hi, I have a form that on closing comes up with a input box asking for "Enter Parameter Value" for a combobox on the form. How can I stop this from happening?

Thank you, Too simple, I should have thought of it Gezza

Hi All, Is there some code that can select all Check Boxes in a table as Checked or Unchecked at the same time?

"A single front end that overwrites the one currently on the user's desktop each time it is run?" "On the other hand, the link that the users select could be a script that copies their FE from a secure area to the user desktop." Yes this is what is happening. Updates have been frequent...

Hi, Thanks for your response, It's a bit complicated but I'll try to explain. The Access file is on a shared network which is used by multible users. Every time the user runs the file it creates a local copy on there PC from the "master" on the network drive. This allows updates of the file to...

Thanks for your response, What you suggest is true and I can set the printer settings up that way, but for my particular application I need to be able to set the printer settings using code each time the application is run. Gezza

Its Page Size I am trying to change from A4 to A3 for example

Hi, Can anyone give me some code that changes Report Page Size settings in VBA code Thanks

Thanks again, I have entered in the Parameters but the query is still giving me all the data (not filtered by the contents of the Combobox). Is there somthing else I need to do?

Hi, DCrake thanks for your response "When you get the error is it happening when the form is open or when it is closed?" When the form is open, with an item selected in the Forms Combo Box