Replies

I ended up going with NovaBACKUP; not cheap, but I liked the UI (both simple and deeper – you choose). Took about 30 min, but that included an incremental Documents only backup as well. I had been using Easeus, but had some issue so I did the switch.

Thanks to all who chimed in! This is the ONLY place to go when you need a hand; way better than any support money can buy.

Bill

First, thanks for the suggestions.

I left the locked-up login running last night (I can be cranky like that), and, of course, found everything locked up this morning. No screen saver on, no desk top, nothing but a blank screen – had to force a power down. Tried to reboot anyway with Shift | F8 and got Safe Mode (surprise!).

I didn’t really see much wrong there, so I just re-downloaded and burned Win 8 to do a re-install. When I booted again (just for kicks, and before re-installing) I got the Windows startup tune and then the login. What!? I actually logged in with my fingerprint reader and Metro showed up!! It’s actually working!!

My only issue now (and a bit worrisome) is that a Win 8 backup failed after 2 hours of running so I don’t have a current backup. Is “Image” the same thing? Should I try that (I have a 2T external drive).

Thanks Bill, I right now I can’t do much of anything but will try in the morning.

Haha, worked without it. But I changed it anyway.
BTW (in case anyone’s watching) that’s “#” and not ‘#’

Thanks again RG!

SWEET!

Your first solution wasn’t exactly what I was going for, but wow what an improvement :bananas:
Now I can actually open the document (as opposed to the mere folder). Thanks RG (you da best), very cool.

Hahahaha, waaaay over my head :confused:

Thanks, once again, Jerry but Method 4 did not work and Method 5 (as far as I can tell) does not reveal any downloads that can be used with SP-2. I tried several anyway on the MS site, but got messages on version incompatibility. Just a thought, but can I revert back to SP-1, re-install Installer, and then update to SP-2 again? Not sure how to do that, but would that be a valid consideration?

jwitalka,

Thanks man, but I can’t get past the first step; “Windows Installer” is not present in the list of services.

Thanks Clint, I actually tried that (among other things) but the problem persists.

Geez . . . .
That did it Patt :clapping:

Dare I ask why (and why the wizard didn’t work either)? In any case, thanks so much for this solution!!

Ooops, yes, that’s “data” and not “file” type mismatch John. The Data Type is AutoNumber Long Integer (it is the record ID number). The Lookup Wizard was used for three combo boxes when the table was built (all text format). Here’s the code:

Code:

Private Sub Provider_DblClick(Cancel As Integer)
On Error GoTo ErrHandler


    Dim stDocName As String
    Dim stLinkCriteria As String


    stDocName = “Frm_Event_EOB”
    
    stLinkCriteria = “[ID]=” & “‘” & Me![ID] & “‘”
    DoCmd.OpenForm stDocName, , , stLinkCriteria


ExitErrHandler:
    Exit Sub


ErrHandler:
    MsgBox Err.Description
    Resume ExitErrHandler


End Sub

29526-11-29-2011-1-30-27-PM

Awesome, simple​, and it works too! Thanks RG! :cheers:

RG

I thought maybe I broke something when I added a .gif image to the folder, and the Access form did not reveal that there was anything in there.

I then realized that the code only looks to see if there is a .pdf file present (which was all I had considered in the beginning). Is there a “simple” way to look for any kind of file there, or must they all be defined? (i.e. pdf). Surely there would be far too many types to define, so if not then, I will have to convert any images to pdf. That’s not an immense chore, but one I would have to remember to do.

I love this new functionality in the db, and it really makes life so much better even as it is, but I couldn’t help but see if there was a way to improve it even more. I am deeply grateful for all your help thus far and even satisfied as is.

Perfect John! I did end up using RG’s solution in this case, but I just tried yours for another “popup” form in the same db and it’s perfect. Thanks for the help and taking the time to nurse me along. All testimony to the uniqueness of this Lounge and the awesome people who selflessly help the “saber-toothed squirrels” of the world. Thanks again! :cheers:

:thewave::thewave:

Awesome RG! That’s more than I was asking for and just what I need!

Thanks for the hand-holding man I really appreciate it. Now I will create a text box with conditional formatting to appear any time the check box (hidden) is checked. Very cool man, very cool!