Recent content by Confusion

nobody got any ideas? still stuck!

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

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!!!

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

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

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

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!!

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: )

cheers mate, appreciate that :D

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

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

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

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

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

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