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 / New Users / June 2006

Tip: Looking for answers? Try searching our database.

Next Question--hiding records bar

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SteveC - 17 Jun 2006 21:38 GMT
Ok, I am getting better at this.  I now have renamed things, rewritten
macros, and I am feeling powerful.  Do I know what I am doing?  Not really.

I have two subforms on my database.  One has the records bar at the bottom
but the other doesn't.  I would like to hide it on the other; how do I do
that?  Since the record is indexed to the data item on the form, I want only
to edit that one item; it includes additional infor about the record (being
edited in the form as whole) and there is no reason to have more than one
record on the subform.  Right now it allows that and I don't care to do
that.  There is no need to be able to go forward or backward to another
record either.  Also since the entire form has a records bar below the
subforms records bar, the two of them there is confusing.

What do I do?

If I am calling the records bar the wrong thing; forgive me.
Ed Robichaud - 17 Jun 2006 22:38 GMT
Open your subform in design view, select properties and set the "record
selectors" and "navigation buttons" format properties to NO.

-Ed

> Ok, I am getting better at this.  I now have renamed things, rewritten
> macros, and I am feeling powerful.  Do I know what I am doing?  Not
[quoted text clipped - 13 lines]
>
> If I am calling the records bar the wrong thing; forgive me.
SteveC - 18 Jun 2006 08:22 GMT
Thanks!  I didn't connect navigation buttons to that.
> Open your subform in design view, select properties and set the "record
> selectors" and "navigation buttons" format properties to NO.
[quoted text clipped - 19 lines]
>>
>> If I am calling the records bar the wrong thing; forgive me.
tina - 18 Jun 2006 16:02 GMT
note that even with the navigation buttons removed, the user can tab through
all the controls in the subform and automatically tab from the last control
to the first control in the next record - unless you set the subform's Cyle
property to CurrentRecord. the user can also use the PageUp and PageDown
buttons on the keyboard to move from one record to another in the subform
(or use the scroll wheel on a mouse, i believe). to stop PageUp/PageDown
capability, you'd have to capture those keystrokes and "erase" them. to stop
the scrolling, there's code available at
http://www.lebans.com/mousewheelonoff.htm

hth

> Thanks!  I didn't connect navigation buttons to that.
> > Open your subform in design view, select properties and set the "record
[quoted text clipped - 20 lines]
> >>
> >> If I am calling the records bar the wrong thing; forgive me.
 
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.