Replies

Fantastic! Thanks.

Turns out that it’s not even necessary to save a named query – SQL statement in the form’s recordsource is OK. With either method, the form’s RecordsetType must be set to Dynaset (Inconsistent Updates). I had never used that property before; learn something new every day!

Thanks Hans. Worked 100%

Ignore it — I accepted some Track Changes items, and the numbering went back to the proper sequence.

Hans and Wendell

Woo hoo!!! Once again, you guys amaze me with the depth of your knowledge and willingness to help. I’ve been putting up with this stupid limitation of Access for as long as I’ve been using ESRI shapefiles. My solution has always been to rename the shapefiles with 8.3 names. Now, with this little trick, I can use long filenames for the shapefiles, and simply link Access to the “hidden” shortfilename. It’s such an easy and (dare I say it!) elegant solution. Done in the true spirit of a workaround!

Short filenames… great idea, but no joy. They are not present in the folder under Vista or XPPro. Is there a way to force them to be created? I could not find anything after a few minutes of Googling.

Yeah, I was afraid of that. Usually I can work around it, but in this particular case the file is already used by some other processes, and renaming would be a problem. Drat.

Thanks for the info about MouseUp.

Turns out that resizing the controls every time the Resize event fires is not a drain on performance. I thought it would have been slow, but it works just fine on my form.

Thanks, Hans. At least that confirms it’s not unique to one computer.

I just returned home and found some additional documentation on my home computer. One file makes reference to a PROJ_LIB environment variable. The offending computer is back at the office, but I will try this on Monday.

PROJ 4.4.6 WIN32 Binary Release
===============================

This is a package of pre-built binaries for PROJ 4.4.6 for Win32 systems.
After the package is unpacked the PROJBIN directory should be added to
your path.

eg.

C:> set PATH=%PATH%;C:PROJBIN

If you unpack the distribution somewhere other than C:, you will also
have to set the PROJ_LIB environment variable so that PROJ can find
initialization files.

eg.

C:> set PROJ_LIB=C:SoftwarePROJNAD

Once these steps are complete, you should be able to use the various PROJ
utilities from the commandline.

eg.

C:> proj.exe -I +proj=utm +zone=11 +ellps=WGS84
332000 4000000 (input)
118d52’1.182″W 36d7’48.593″N (output)

C:>

See the PROJ.4 web site for more details on PROJ.

http://www.remotesensing.org/proj

Those wanting to use PROJ.4 DLLs for other applications like MapServer
can just copy the PROJBINPROJ.DLL file, and ignore the .EXE files.
However, the PROJ_LIB environment variable will still need to be set to
enable use of initialization and datum grid shift files.

As always, I appreciate your help.

Argus

Thanks for the reply. Some good info.

It applies to all file types: .doc, .zip, .exe, .ppt, etc etc.

I had not seen that setting in the Internet options previously, but it was already set to the Promp (Recommended) setting.

After reading more about the MSRT, I realized that it’s very unlikely to have any part in this problem. I had **assumed** that it worked continually, when in fact, it’s a one-time, run-at-startup program. It’s probably a strange coincidence that the problem went away when I re-installed all the updates and controlled the order with which they were loaded.

The real fly in the ointment is that the problem occurs with every flavour of browser I have used, and with every file type, and apparently with both AVG and Avast. Call me suspicious, but I think that the common denominator is Windows.

I think I was off-base with the Malicious Software Removal tool. It *seemed* to have something to do with the behaviour, but after reading more details, it does not sound likely.

No I have not emptied FF caches — but the behaviour transcends Firefox. It’s present with FF, IE, and Maxthon.

No – different problem that applies to XP instead of Vista. Thanks anyway.

Independent of this forum, I searched online for other people having similar problems. Probably spent 20 hours looking for and trying solutions. Found quite a community of people with identical issues. A general concensus was that AVG was involved, and that’s what lead me to delete AVG and install Avast. And as I said, the download problem re-emerged this morning after having been absent since installing Avast. The Windows Update was on Thursday night, and going back to the previous restore point on Saturday morning removed the problem.

http://www.microsoft.com/communities/newsg…=&cr=&sloc=&p=1%5B/url%5D

Other software? Windows Security Centre reports that Avast is running as both virus protection and spyware/malware protection. Nothing else is reported. I *have* installed other programs on the computer(Windows Defender, Search & Destroy, and Adaware), but none of them are running.

I agree with your assessment that some software on my computer is is part of the problem. But the proximity to the Windows Update and the ease with which the System Restore eliminated the problem leads me to conclude that something in the most recent package (in combination with something on my computer) was also involved. I don’t doubt for a second that you haven’t had problems, but as the old saying goes: absence of evidence is not evidence of absence. I would dearly love to know what particular software on my computer is colliding with Windows Update.

An update…

Finally tracked down the issue about one month ago. It was AVG Anti-virus… or so it would seem. Deleted AVG completely, installed Avast, and the problem went away. Until today when it appeared again. So, what’s changed…???

Two days ago, I did the monthly Windows Update. There were 15 updates, which I dutifully installed. So I rolled back to the latest Restore Point, and the problem went away. Aha! Next, I installed the 15 updates more-or-less individually. There were a bunch of MS Office 2007 updates, plus some others that looked innocent enough. I retained the Malicious Software Removal Tool until last. Tested the download success after each installation and NEVER HAD A PROBLEM. I was almost hoping that ONE of the updates would trigger the problem, but that was not the case.

So I am no better off than before, although I know it was caused by Windows Update, and I have a hunch that the sequence of installations had something to do with causing the download problem. I will be more careful next time when installing the Windows Updates, and I plan to always keep the Malicious Software Removal Tool until last. I really don’t know how it works or what it does, but the very nature of its name makes me suspect it has something to do with the problem. I realize that’s not a very scientific approach, but *something* in that collection of 15 updates caused the problem.

I was kinda afraid of that. But I awoke in the middle of the night with the stupid problem on my mind, and a solution popped into my head. If the group is based on a constant instead of a field from the recordset, then it effectively disables the grouping. Pulling out my trusty copy of Access 2002 Developer’s Handbook, I found I could manipulate the ControlSource of the grouping during the report’s Open event. Came up with this code in a report that normally shows ALL detail:

‘ hide Terminal info
If Not (Forms![frmEstimateFutureInventories]![chkDetailProduct]) Then
Me.Section(5).Visible = False
Me.Section(6).Visible = False
Me.GroupLevel(0).ControlSource = “=’x'”
End If

‘ hide zone info
If Not (Forms![frmEstimateFutureInventories]![chkDetailZone]) Then
Me.Section(7).Visible = False
Me.Section(8).Visible = False
Me.GroupLevel(1).ControlSource = “=’x'”
End If

It seems to do the trick, and now I need only one report instead of four.

I went into the Windows Services setup and disabled two services with “AVG” in their names. Rebooted the computer, and now the AVG User Interface indicates that no AVG components are active. Same result with downloading a file — delete about 5 seconds after it is created in the folder. I can’t see anything in the FF configuration setup that pertains to virus scanning. Also, the behaviour is almost identical in my other browser (Maxthon), which is based on IE.

Much as I hate to say so, I think it’s time to admit defeat and just put up with this goofy behaviour. At least I can used the Maxthon Download Manager to successfully download files. Maybe one day it will fix itself just like it broke itself (yeah, right…)

I appreciate all your input.