Search results

Also, you shouldn't design your tables structure around your forms. Your tables should be designed along the rules of normalisation (there are many posts in the forum along normalisation).

I suspect the problem is with the "OpenArgs" part of the code. Have a look at the code that opens the form. Better still, ask whoever wrote it ;-)

http://icons.deviantart.com/

Are you tied to using the XP Compression utility? I couldn't find anything either, but there are alternatives. 7zip is a completely free utility you should be able to get working in this scenario.

Is it a function or a subroutine?

LOL. Well it is known as the "Windy City" isn't it? I have never been to Chicago, but I feel as if I know it from far too many hours on "Midtown Madness" ;-)

Firstly, no attachment. Secondly, use a Pivot Table on sheets other than your "All Employees" sheet. This way you can easily filter/update the information.

BeforeUpdate

The number of posts is no indication of their usefulness, which is what the thread ratings and poster reputations are trying to represent. For example, someone may only post once a month, but that one post may answer something no one else can.

You did. Computers are extremely stupid. They will only do exactly what you told them to; no more, no less. As the previous poster said, it would seem you have no used fully qualified pathnames. Either use them in your batch file, or "cd" to the correct directory (I use this method myself...

I was thinking of you and your regular flame fests with the Americans. Quite frankly, I don't care much about my "reputation", people can take my advice or leave it (sorry, don't mean to undermine Jon's efforts, I can see how most people would appreciate this, I'm just a contrary git). A quick...

Thats a good idea. I had a copy of the Access '97 Version when I first started. It was very helpful.

I named all my text entry fields "CostCentre_Something. I simply then loop through all form objects begining with CostCentre because I am too lazy to write code for each field name ;-) In that case, you need much less code; If GateArea.Value <> GateArea.OldValue Then GateArea2.Value...

...and if so can it be turned off in the Watercooler? ;-)

Yes. You can compare .Value and .OldValue on your fields. I use the following code; by naming your fields, you can just check the relevant ones; Private Sub Form_BeforeUpdate(Cancel As Integer) ' Create an audit trail to track changes to cost centres Dim frmObjCC As Object Dim...

LOL, I wish Sergeant. Its my brain that has been plotting against me... I had actually been using the ALT tag to get a "tool tip" for images. This works in IE, although its not really what it was intended for. FF didn't give a tooltip, but as I had seen FF do tooltips elsewhere, I went off to...

Same here. Don't know what I was doing before :confused:

Noticed that this morning Jon, I was just going to ask about it. How does it work?

Thanks Barry. I was going to search out one of the many "How to ask a question" links, but I don't think it would of done any good. My first forays on the internet ten years ago were on usenet. I learnt the hard way :-)

Give it a try and see? ;-) You can even call it from VBA, getting the time with a debug.print, running the SQL, then getting the time again.