Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Defeating mousescroll on data entry form (2k3)

    I have a data entry form that I've been lazy with....I don't want to add a record via DAO or anything else; the form's record source is an updatable query. I do not want to capture the mouse scroll event by using a third-party solution (I've seen it around, but don't want the hassle of installing the .dll).

    Is there a way to set the form to only show the "new record", or modify the query to only show the "New Record" option?

    Edit: I modified the query criteria for one field to equal an impossible entry (that is, a jumble of letters and numbers nobody in their right mind would type). Anyone know any potential pitfalls of this?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Defeating mousescroll on data entry form (2k3)

    If you set the form's "Data Entry" property to "yes" it will open at a new blank record, then only show any records added while it is open.
    Regards
    John



  3. #3
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Defeating mousescroll on data entry form (2k3)

    <hr>then only show any records added while it is open.<hr>

    I knew about the data entry for new blank records, but that is news to me. <img src=/S/cool.gif border=0 alt=cool width=15 height=15> and <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

Posting Permissions

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