Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Data Access Page and Macros (Access 2000)

    How can I assign a macro to a command button in a Data Access Page?
    Nannette
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Data Access Page and Macros (Access 2000)

    Unfortunately you can't. I've not played with DAPs enough to get beyond the very basics, but neither Access macros or VBA will transfer directly to DAPs. I believe the process that is used is to convert VBA to VB Script which is sort of a brain-damaged version of VB. The basic problem of course is that any code must be recognizable in Internet Explorer (other browsers won't support DAPs), so you are stuck with VB Script. Hope this helps a bit - unfortunately I can't recommend a good resource for learning the intricacies - sorry.
    Wendell

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data Access Page and Macros (Access 2000)

    OK Wendell, Thank you. How about this one? How many people can access a DAP at the same time if it's on the server? I wouldn't think that it had a limit.
    Nannette
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

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

    Re: Data Access Page and Macros (Access 2000)

    Posted in a separate thread. I am locking this one to avoid duplication and confusion. Reactions in the thread starting with <post#=296969>post 296969</post#>, please.

Posting Permissions

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