Replies

Don,

Try this:

Ctrl+Shift+I – Opens the Explorer Bar
Click & Drag the little icon to the left of the address in the Address Bar and drop it on the favorites folder you want to store it in.
Ctrl+Shift+I – to get back your screen real estate!

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Dick,

Just so we’re using the same frame of reference IDE = PATA {IDE=Integrated Drive Electronics and used to be refered to as ATA drives, when SATA drives came along {the S=Serial} they renamed ATA to PATA {P=Parallel}.

My guess about your problem is that the Dell’s builtin disk controller is for PATA drives based on the model number and age! You most likely have an add-in card to provide the SATA connection. Given that, the drivers needed to run the SATA add-in card are not on the Acronis Recovery CD, thus Acronis can’t see your SATA drive.

I hope this makes sense.

Edit: I forgot to say that when you boot the computer normally {not from the CD} the drivers for the SATA are loaded so if you run Acronis from within Windows it will see both drives.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Amanda,

1. Which machine is giving you the problem, XP or Win 7?
2. What versions of Access are on each machine, i.e. 2003, 2007, 2010?
3. What is the current extension on the database file, ex: .mdb or .accdb?

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Neal,

You might want to try UbitMenu a free download to get back the 2003 menus. Another option would be to download Open Office, also free, which can read & write MS Office file formats.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Amanda,

Don’t attempt to open the form.
After you start the DB press Alt+F11 to open the Visual Basic Editor {VBE}.
In the Project Explorer on the left, find the form in question.
Right click on the form and select View Code.
Look for the On_Load Event Procedure to view the code.

Good Luck.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Note: Windows Live Mail is a desktop client.

Joe

Joe,

Thanks for the correction. I thought all the “Live” stuff was web based.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Graeme2,

I notice that you are referencing My Documents. I’m assuming here that you are using a system where you have either done an in-place upgrade or you, like me, have moved your My Documents folder off the C: drive in a previous version of Windows. The reason for this assumption is that in Win 7 now calls the folder just Documents.

If this is the case have you added your My Documents folder to the Documents Library?

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

RR,

I try to always log out just so things get cleaned up properly. Of course sometimes my mouse pointer is just sucked in by the blackhole in the center of the BIG RED X!

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

I would doubt it. Since both of those are web based email clients vs programs {Outlook, OE, Thunderbird} on a local machine. Sorry.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Ken,

What CD software are you using. I had a problem with Roxio where the drives would not recognize disks in the drive even when I wasn’t using Roxio. I uninstalled Roxio and problem solved. Maybe you’re experiencing a similar problem?

Good Luck!

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Jefferson,

Thanks again!

Works like a charm.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

PS: To RG – I really like the Specs in your signature. Are there instructions somewhere on how to do that?

Tim,

It’s an option built into the Speccy program from Piriform {the people who make CCleaner} it’s a free DL.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

I tried dragging a Draft item to Outbox and pressing F9. That didn’t work…

VBA could automate opening and sending the messages, assuming there is no shortcut.

Jefferson,

Yeah! I tried draging 9 items to the outbox hoping….
My problem is that I am totally unfamiliar with the Outlook Object Model which makes it very hard to use online help or the object browser to find what you need. Know of any good books on the subject?

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Jefferson,

I found thison the MSDN site. However, I have a sample of the stationary already in Outlook I created a new email with it and tried to save it as an .OFT file but there is no option to do so on the Filetype dropdown in Outlook 2003 using Word as my Email editor. The stationary is basically a letterhead with text and a graphic. So how do I get this existing stationary saved as an .OFT file?

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Jefferson,

Thanks much works great. Surprisingly enough that works just fine in Windows 7 64 Bit with Office 2003 32bit! I read here #3 that the 64 bit version has both 32 & 64 bit versions of the API and automatically selects the proper code?

I also wound up keeping my old code, slightly modified with another sleep call, because even after bumping the wait up to 1.25 seconds {1.250} I would still get to renaming the file before PDFCreator was done with it and get an error 75. So I modified the Error Handler code to tack on another 3/4 second wait if the err.number was 75 and to display a message if it wasn’t. it now looks like this.

Code:

On Error GoTo Waitforpdfcreator
Try_Again:

       Do While Dir(zBillPath & "rptAnnualBilling.pdf") = vbNullString
         Sleep 1250           '** wait 1.25 secs before trying again **
       Loop
       
       Name zBillPath & "rptAnnualBilling.pdf" As _
            zBillPath & "Bill" & Format(rst![OwnerID]) & ".pdf"
On Error GoTo 0
    .
    .
    .
   GoTo GetOut

Waitforpdfcreator:
   Select Case Err.Number
         Case 75
             Sleep 0.75  '*** Wait another 3/4 second. ***
             Resume Try_Again
         Case Else
             MsgBox "Module: BillingsCode" & vbCrLf & _
                    "Routine: EmailMailBills" & vbCrLf & _
                    "Error: " & Err.Number & " " & _
                    Err.Description, vbCritical + vbOKOnly, _
                    "Unexpected Error:"
             Resume GetOut
   End Select
   
GetOut:

Thanks again!

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs