Replies

Yea, I do a lot of pasting and tweaking from pre-existing code or converted macros but I’m not really DAO or ADO literate.
Thanks for the reply

Thank you for your excellent columns. I have a question about your recent article “A quick test checks whether Java is current”. At least 2 applications in my Adobe CS5 Creative Suite (Dreamweaver, Flash Catalyst) along with Adobe Acrobat 9.5 use archaic java.exe, dll, etc. files located in their …/JRE/BIN folder, evidently for updating purposes. Since these do not appear in the default JAVA installation location, these never get updated. My best defense has been to rename the java.exe file until I need to run the updaters. Is this sufficient protection?

After spening half the day trying to figure out my problem, I remembered that I had installed the ability to print from a virtual machine running in XpMode. Removing all printers from XpMode restored my ability to print multiple copies. So, I guess this is just a FYI for anybody who stumbles into the same problem.

Can you post an image of Task Scheduler ?
Instructions of how to, available on request.

Strange as it may seem, I just opened Task Scheduler and it all works well now. Maybe monkeying around, I clicked something that needed to be clicked. Anyway, thanks for your willing ear. Sorry to take up your time.

Hi bradym, type defrag in start menu search box, hit enter, to show:-

Here you can set it how you want. Personally, I prefer Auslogics Defrag, it is used only if needed after analyzing my drives.

Actually, when I do as you said, Disk Defragmenter opens saying Scheduled Defragmentation Is Turned On to run at 7am on day 1 of every month and all disks show 0% fragmented. However, whenever I open Task Scheduler, it opens with the above error message. Clicking Close and then the Refresh button makes the error msg re-appear. Under both Task Status and Active Tasks (after the description) it says Reading Data Failed… Any thoughts?

Thank you for ALL your articles over the years! I decided to take your advice and see whether my Defrag was working properly. However, when I first open Task Scheduler, I received the following message: The selected task "{0}" no longer exists. To see the current tasks, click Refresh. When I do, the msg box does a repeat performance. When I follow the Task Scheduler Library>Microsoft>Windows>Defrag tree, I get the same msg box. Although I have Win7 Pro (for the XPMode feature to run an old program), it is not necessary for me to manually log on as a User. The machine fires up to me as the default User each time I start Windows afresh. My WinZip backup software will not run a scheduled backup for this reason. Could this be the same reason my Defrag is not scheduled? This leads to a second question; Since this same message appears when I first open Task Scheduler, does this mean that many or all of Windows’ default tasks are not being run?

In the next to last paragraph of your article you mentioned about Gmail or Hotmail, "You can protect yourself to some degree from Internet monitoring by using HTTPS versions of these programs". Could you please clarify?

Dear Susan, thank you for your consistently excellent articles. I guess I’m one of the brave and foolish who did not wait for your "go" but hopefully others can benefit from my ordeal. Post Win 7 SP-1 upgrade, everything went smooth until I tried to open my XPMode virtual machine. A msg box appeared saying "Updates for Windows Virtual PC Integration Components are available". However, the wizard failed saying "Setup Interrupted". To make a long story short, advise anyone who faces this dilemma to go to Microsoft Answers forum: http://social.technet.microsoft.com/Forums/en-US/w7itprovirt/thread/12d97708-a439-43fd-b556-1f646aee8068

Finally found a fix at Microsoft Answers site http://social.technet.microsoft.com/Forums/en-US/w7itprovirt/thread/12d97708-a439-43fd-b556-1f646aee8068. Hope this helps anybody frustrated by the same problem.

Is it possible that this is all that it takes???:
********************************************
Private Sub cmdPaint_Click()
On Error GoTo cmdPaint_Click_Err

Shell “C:WINDOWSsystem32mspaint.exe”, vbNormalFocus

cmdPaint_Click_Exit:
Exit Sub

cmdPaint_Click_Err:
MsgBox Error$
Resume cmdPaint_Click_Exit

End Sub

********************************************

Incredulous! Does anything need to be added for the sake of memory or other considerations?

Also, any way of adding a line to have Paint automatically open (Ctrl+O) to a specified FOLDER (not file)?

Your code to open Excel is using OLE Automation, but unfortunately MS Paint does not support that kind of operation. Your best bet would probably be to use a “Shell” command to start Paint. See the thread Can we Automate Paint at CodeGuru for similar discussion.

Thank you for the explanation Wendell. However, what I found there is a little over my head. Was the code mentioned there VBA? I am only a beginner when it comes to writing code for Access. I usually do a lot of snip-and-fidget from other code I come across.

It appeared to me that the solution you mentioned was for opening a FILE in Paint rather than just opening PAINT itself. I want to add photos of personnel to an already existing database. After editing the .jpg files using Photoshop, I found that the copying the results directly to the database would save the OLE as a Photoshop image and could not double-click to open unless unless Photoshop was already running. When I closed the .jpg file and then copied the image by opening it first in MS Paint, it opened fine from Access.

I would like to save all the edited photos to a folder and then just click a command button on my form to open Paint and manually open the desired files from there for copying. I already have another button on the form to paste from the Clipboard. Do you know how to just open Paint itself rather than a specific file using Paint?

Thank you Mark, it works great! I’m sure you know but FYI for everyone else who views this thread…

DoCmd.OpenReport “REPORTWeeklyFirstSchoolCounselSheet”, acViewNormal, “”, “”, acHidden

…enables you to print the report directly without having the extra usually useless step of the Print dialog box appearing.
Thanks again!

Yes Peter, FYI in the end Adobe’s updater would not work due to removing the jre folder contents. The only fix was to restore by unziping the contents and then re-install Dreamweaver from the original DVD- then apply the update- then everything worked. Although I have still been unable to get anything definitive from either Adobe or Sun, from a previous thread at Secunia’s forum, it seems that is is ‘plausible’ that the JAVA used at CS5’s scattered locations are purely for the installer/updater. The fix (if you can call it that) with the least impact offered was to rename the java.exe files and leave the rest of the folder in place. I just need to remember to take off and then put back on the disguise again each time new updates are released. Time will tell if this works any better than unzipping. Too bad Adobe hasn’t indicated that they want to take time to make their customer’s life simpler. There are many complaints about this issue on their forum.

Well Peter, when trying to update to Dreamweaver’s version 11.0.2, the update failed. It may have something to do with zipping the JVM folder. I will keep you posted

Yes, you seem to be correct about JVM. It does not seem to include JDK,

I checked all the folders inside bin and lib and only came up with one PNG file that said jdk_header (in the lib folder)

And Dreamweaver has no errors. Neither does Flash Catalyst. Only Flash Professional (by the way, all three were installed on a separate physical drive D:).

I reinstalled Flash Pro from the installation disk and updated. Afterward, C:ProgramDataAdobeCS5jrebinjava.exe changed to version 6.0.180.7, (however, Java’s latest version is 6.0.200.2). I fired up Flash Pro… no errors. When I zipped and deleted the jre folder though, the error returned on opening Flash Pro. So this the culprit!

When I pasted the latest C:Program FilesJavajre6 folder (CONTENTS) into the CS5 jre folder (since, obviously the folder name is different) everything works fine now when opening Flash Pro. So, it seems that Acrobat 9, Dreamweaver and Flash Catalyst can live (or at least open) without the jre contents OR they are smart enough to follow the JAVA_HOME system properties entry… but Flash Pro is the exception. I will just have to remember to patch it manually when future Java updates are released. That’s live-able. But I sure wish that Adobe Support was more wiling to listen to this glitch, so that they can update it themselves.

Thanks again Peter for all your help!