Results 1 to 12 of 12
  1. #1
    Star Lounger
    Join Date
    Mar 2004
    Location
    White Oak, Pennsylvania, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Alpha Designator (2002-SP3)

    How do I produce a listing in the page footer of a report that shows the alpha beginning and ending records that is on that page? (Abel-Baker), (Beryl-Cunningham), etc?

    Thanks in advance,

  2. #2
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Alpha Designator (2002-SP3)

    Not exactly what you want but may get you started

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Alpha Designator (2002-SP3)

    John, I can't open the file at all. First I get a security warning and then when I actually try to open it, I get a message that the file is located outside my intranet or on an untrusted site. Since I copied it to my machine and unzipped it there, I'm at a loss to know what's going on. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Alpha Designator (2002-SP3)

    Download the Solutions.mdb file (http://support.microsoft.com/?kbid=248674) and take a look at the CustomerPhoneList report in the Solutions database. It does what you're trying to do. Solutions.mdb was part of Office 2000 but was pulled from XP for some inexplicable reason. The code will work just fine in XP.
    Charlotte

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Alpha Designator (2002-SP3)

    Try This

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Alpha Designator (2002-SP3)

    Nope, same problem. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Alpha Designator (2002-SP3)

    I can open the databases from both John's replies without problems, in Access 2002 and in Access 2003 (in Access 2003 I get the usual macro security warning).

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Alpha Designator (2002-SP3)

    I'm at a loss, Hans. I don't have 2003 installed, so I wonder if that has any bearing on the problem. I haven't run into this with other mdbs posted as attachments here, so I have no idea what's going on. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
    Charlotte

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access File Block Resolved

    I found an answer to the irritating and baffling message:
    <hr>Microsoft Access cannot open this file. This file is located outside of your intranet or on an untrusted site. Microsoft Access will not open the file due to potential security problems. To open the file, copy it to your machine or an accessible network location.<hr>
    This article at PCMag.Com explains that the problem is with the Attachment Execution Services feature in Windows XP, which marks files received as attachments with an attribute that identifies them as having come from a nonsecure zone. After unblocking the file in the properties dialog, I was able to open it with no problems. This is the first file that has caused me this grief, but now I know how to deal with it!
    Charlotte

  10. #10
    Star Lounger
    Join Date
    Apr 2006
    Location
    California
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access File Block Resolved

    Have you found any other solutions to this problem?

    I've just discovered this problem on my home network. If I attempt to link a back-end database across the network I get the "untrusted site" message. As none of my db's have been emailed I don't have the property setting which worked for you. I also tried copying the files out to a FTS thumb drive and then back per the PC Mag suggestion ... still doesn't work. I turned off my firewall and set all the internet security settings to their lowest value ... no change.

    In desperate need of suggestions.

  11. #11
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access File Block Resolved

    What do you mean by "across the network"? Is the backend in the subdomain?
    Charlotte

  12. #12
    Star Lounger
    Join Date
    Apr 2006
    Location
    California
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access File Block Resolved

    My home network is a peer-to-peer and its simply on another machine.

    I have since run across solution: I set the back-end computer as a Trusted Site in the Internet->Security properties ont the machine wiht the front-end. Now able to link in the back-end tables.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •