Search results

  1. G

    How to Query that will accumulate totals for each day of the Month

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

    How to Query that will accumulate totals for each day of the Month

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

    Need help with Graphs can anyone help

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

    Is it possible to set Printer settings using VBA

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

    Is it possible to set Printer settings using VBA

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

    Is it possible to set Printer settings using VBA

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

    This should be easy but?

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

    This should be easy but?

    Yes your probably right, lesson learnt. Thank You!
  9. G

    This should be easy but?

    I could but I am not sure how to do it?
  10. G

    This should be easy but?

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

    This should be easy but?

    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?
  12. G

    Selecting all Yes/No fields at once

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

    Selecting all Yes/No fields at once

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

    Changing Page Size settings in VBA

    "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...
  15. G

    Changing Page Size settings in VBA

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

    Changing Page Size settings in VBA

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

    Changing Page Size settings in VBA

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

    Changing Page Size settings in VBA

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

    Having trouble with Crosstab query

    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?
  20. G

    Having trouble with Crosstab query

    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
Back
Top Bottom