Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / November 2007

Tip: Looking for answers? Try searching our database.

Disabling Navigation

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Abdul Shakeel - 03 Nov 2007 05:42 GMT
Hi All,

I want,  

1. disable any type of navigation (PageUp PageDown, Enter, Tab Button Etc.)
on my Access form
2.when I open the form its open in add mode i.e. all the feilds of form
remain blank.
3.After clicking the save button a msg box appears and ask for saving data
"yes or No" in both the cases hide all the data after click "yes or no"
Al Campagna - 03 Nov 2007 14:34 GMT
Abdul,
  Well, not sure what you mean by Add Mode.  I think you mean DataEntry
mode, and that should accomplish most of what you want to do , by itself.

  In Data EntryAdd mode, the user can not acess any previous records...
only enter data into a new record, an  then move to another new record
.
  1.  If you feel you must kill all your navigation buttons, you'd have to
use the Key Preview and Key Press to cancel those keys.
       But, those keystrokes all have legitimate uses within an individual
record.  Since Add mode doesn't allow browsing... there should be no
"critical" need to
disable commonly accepted navigation keys.  Particularly the Tab key which
is universally used to But... that's your call...
       *(also... realize that if the form's Cycle property is set to
Current Record, you won't be able to Tab to the next new record.)
   2. Data Entry mode only allows adding new records, so... if you don't
have Default values for any fields... you'll only see blank fields.
   3.  Placing a button on your form that triggers a...
           DoCmd.GoToRecord , , acNewRec
will Update the current record, and move to a new record.

  Why don't you just try the DataEntry mode, and see if that works for you,
and only defeat navigation if you still feel you have to.
Signature

   hth
   Al Campagna
   Microsoft Access MVP
   http://home.comcast.net/~cccsolutions/index.html

   "Find a job that you love... and you'll never work a day in your life."

> Hi All,
>
[quoted text clipped - 7 lines]
> 3.After clicking the save button a msg box appears and ask for saving data
> "yes or No" in both the cases hide all the data after click "yes or no"
Abdul Shakeel - 05 Nov 2007 07:01 GMT
Dear Campagna,

Thanks for your reply, I try your technique & its really works thank you
very much, Now I have an other question for you, I want that when I update
record its shows to grid control under the form so a user can't a navigate
the record but looks all the record in Grid control.

> Abdul,
>    Well, not sure what you mean by Add Mode.  I think you mean DataEntry
[quoted text clipped - 31 lines]
> > 3.After clicking the save button a msg box appears and ask for saving data
> > "yes or No" in both the cases hide all the data after click "yes or no"
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.