Recent content by Confusion

  1. C

    Question Simplest way to produce Excel spreadsheets from forms(acc 97)

    nobody got any ideas? still stuck!
  2. C

    Question Simplest way to produce Excel spreadsheets from forms(acc 97)

    Many years ago I created a database to generate end of month reports in Access 97. 7 separate queries filtered the information from 2 large tables and placed it into 7 separate forms. Each form then had totals calculated on it within the forms code: e.g. Table Field: "Gross income" Client1: 20...
  3. C

    Pass string from Access 97 to Word?

    OK, can anyone tell me if this is even possible even if not sure how to do it? keep trying, keep failing, beginning to think I might be wasting my time!!!
  4. C

    Pass string from Access 97 to Word?

    A few days ago I got some help creating a string so that a database would get its own residing directory to look for a word document I wanted to merge. It worked beautifully..... until I needed to move the entire content of the directory to another PC. The Access part still works perfectly -...
  5. C

    Mailmerge Word problem in VBA with change of location/machine.

    Oooops..... Hi Sportsguy, Many thanks for that, unfortunately I forgot to mention that this needs to work in Access 97 :o so the currentproject.path bit wont work. You have however given me the important idea of making the path automatically inserted - Just trying to see if I can come up...
  6. C

    Mailmerge Word problem in VBA with change of location/machine.

    On a database run on a server system the following code was given to me to make a mailmerge word document open and print... If Me![TerrorCover] = True Then DoCmd.SetWarnings False Dim objword As Word.Document DoCmd.OpenQuery "MaketblTerror", acNormal Set objword =...
  7. C

    determine word is open?

    Not sure if this is what you need or not - I found this a while ago while searching out a similar problem and kept it for future reference!!
  8. C

    Accessing Public variables

    LOL, good at coding, and a mind reader too :D Nearly finished putting it in, got sidetracked as another "issue" has arisen (I made the classic mistake of underestimating how stupid other users can be :rolleyes: )
  9. C

    Accessing Public variables

    cheers mate, appreciate that :D
  10. C

    Accessing Public variables

    LOL, yeah I did, because when I wrote the majority of this bit of software I had about 1 week to learn and programme it :p my boss seemed to prefer a few annomolies to paying someone who knew what they were doing :D I did try to get the DateDiff function to work, but couldn't quite grasp...
  11. C

    Accessing Public variables

    LOL, OK, OK, I meant I'll ask a mod to :D Can you see the word "dumb" written accross my forehead from there? :o :rolleyes: In my defense, I've not been doing this long, it's been a very steep learning curve and I was trying to work this after 17 hours solid in front of the PC :p Now...
  12. C

    Accessing Public variables

    Not sure if this is the right place to post this or not - if it's in the wrong place please let me know and I'll shift it! Basic problem... In a forms class module some calculations are made, the result of one of which is then passed to a publically declared variable in the modules header...
  13. C

    globally running a rounding code

    Just to let you guys know that I finally finished implementing all the rounding code in the couple of hundred places it was needed at about 2.30am :D Big thank you to you both for your help. So far so good, all appears to be running smoothly - couple of minor glitches with passing from forms...
  14. C

    globally running a rounding code

    Rich - many thanks for that code, LOL looking at that I can see why my attempts have not been tooooo successful :rolleyes: FoFa - that's what I was trying to attempt a while back, but I couldn't work out how to get the query to call the function, apply it and use the values. Maybe I was...
  15. C

    globally running a rounding code

    LOL - Rich, thanks for the vote of confidence, but my attempts at creating a round function have not been overly successful :p FoFa I'm OK as far as what is actually there, this is very much an in-house DB and the accountant is not worried about which way they round, as long as he stops...
Back
Top Bottom