Results 1 to 3 of 3

Thread: Access: Forms

  1. May 18th, 2005, 07:47 AM #1
    john tindell
    john tindell is offline

    Thread Starter
    <?="Moderator"?> john tindell's Avatar
    Join Date
    Jan 2002
    Location
    Brighton, UK
    Posts
    1,099

    Access: Forms

    Hey im using access to enter auit project forms into an access database. The tables have been setup and now i want to enter the data. I have created a form that lets the user enter the data. I only want them to be able to enter one record each time. but when the user uses the mouse scroll it moves to the next record. How can I stop this? I am using Access 2002 if that helps. Thanks
    [MindlessAnt.co.uk] [MSDN] [Paging Records With MS SQL] [Virtual CD-ROM Drive From Images] [WorldOverRide.co.uk] [Create PDF's using pure PHP] [PHP.net Search Bars]
    [PHP: Check Password Strength][PHP: BB Code] [PHP: Date Select]

    If you Question has been answered please mark the thread as [RESOLVED]
    Mediocre post? Please Rate it.
    Reply With Quote Reply With Quote
  2. May 18th, 2005, 09:00 AM #2
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: Access: Forms

    You made the forms bound.

    You could make them unbound, but you'd need code to update to the tables.
    Possibly there is a form property to only edit the record you are on and no others, but you'd again need to use some code (under a button) to make the change between editting and viewing...

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
  3. May 18th, 2005, 09:25 AM #3
    john tindell
    john tindell is offline

    Thread Starter
    <?="Moderator"?> john tindell's Avatar
    Join Date
    Jan 2002
    Location
    Brighton, UK
    Posts
    1,099

    Re: Access: Forms

    cheers, if im adding the values to the DB by using code can i just use ADODB from createobject? Thanks
    [MindlessAnt.co.uk] [MSDN] [Paging Records With MS SQL] [Virtual CD-ROM Drive From Images] [WorldOverRide.co.uk] [Create PDF's using pure PHP] [PHP.net Search Bars]
    [PHP: Check Password Strength][PHP: BB Code] [PHP: Date Select]

    If you Question has been answered please mark the thread as [RESOLVED]
    Mediocre post? Please Rate it.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width