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 / July 2008

Tip: Looking for answers? Try searching our database.

fields in a form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
EdH - 17 Jul 2008 22:56 GMT
I have a form that is has several memo fields, so it is more than one page.  
But there are several key fields that I want to remain showing on the top of
the page, as I scroll down to fill in the other fields.  In essense, it would
be as if the key fields are remaining stagnant like in a title.  On excel, it
would be a matter of freezing panes.  Is there a way to do this?
Pete D. - 17 Jul 2008 23:07 GMT
Put the fields in the header for the form.
>I have a form that is has several memo fields, so it is more than one page.
> But there are several key fields that I want to remain showing on the top
[quoted text clipped - 4 lines]
> it
> would be a matter of freezing panes.  Is there a way to do this?
EdH - 17 Jul 2008 23:43 GMT
Wow - no wonder I couldn't figure it out.  I assumed it would be difficult &
it was that simple.

> Put the fields in the header for the form.
> >I have a form that is has several memo fields, so it is more than one page.
[quoted text clipped - 5 lines]
> > it
> > would be a matter of freezing panes.  Is there a way to do this?
John W. Vinson/MVP - 17 Jul 2008 23:30 GMT
>I have a form that is has several memo fields, so it is more than one page.  
>But there are several key fields that I want to remain showing on the top of
>the page, as I scroll down to fill in the other fields.  In essense, it would
>be as if the key fields are remaining stagnant like in a title.  On excel, it
>would be a matter of freezing panes.  Is there a way to do this?

One way - which avoids scrolling altogether - is to use a Tab Control.
Put the static data in textboxes or other controls on the top of the
form, and put a Tab Control below those controls; put a textbox for
the memo fields, one on each page of the tab control.

--

John W. Vinson/MVP
Linq Adams - 18 Jul 2008 00:18 GMT
Lkie John, I would recommend using a tabbed control, as well. Here's a quick
little tutorial I give people on the use of Tabbed Pages. It addresses some
of the more common problems experienced in using them:

First thing to remember is that the Tabbed Pages are all part of a single
form; think of it as a really long form turned on its side. Because it is all
one form, all referencing to any control on it is done in the same manner as
if they were all on one single screen. Create a form in Design View. Goto the
toolbox and click on the Tabbed Control icon; it actually looks like several
manila file folders. Place it on your form and adjust the size to your liking.
If you need more than the two tabbed pages it initially gives you, click on
the tabbed control to select it. Goto Insert and click on Tabbed Control Page
and another tabbed page will be added. Do this as many times as necessary.

This is the really important part: when you go to add a control to a tabbed
page, you must first click to select one of the pages, then add the control.
Otherwise, the control will be added to the form itself, and will show thru
on all tabbed pages!

Once you have the form's Control Source (your table or a query) set up, you
simple add controls as you normally would, heeding the above paragraph.

Also important to understand! If you go to move a control from one part of
your main form to a tabbed page, cannot drag and drop it! You must cut it,
select the tabbed page, then paste it! And if the control has any code behind
it, a GotFocus, OnClick, etc, after dropping it on the tabbed page, you'll
have to "re-connect" it to its code. Select the control, goto Properties,
click to the right of [Event Procedure] on whatever event to bring up the
ellipsis (...) then click it to go to the code window. Exit the code editor
and the control and its event code will be connected.[/font] [font=Shruti]One
last thing. When trying to access the Properties of the Tabbed Control, such
as the BackStyle, people complain that they can't find property. The problem
is that they haven't selected the Tabbed Control, they've selected one of the
pages of the Tabbed Control! The best way to be sure of selecting the Tabbed
Control itself is to click to the right of the last tab. If you have 2 tabs,
for instance, click in the blank area where Tab 3 would be, if you had a
Tab 3.

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

John W. Vinson/MVP - 18 Jul 2008 01:26 GMT
>Here's a quick
>little tutorial I give people on the use of Tabbed Pages.

VERY nice, Linq! That clarified some confusion that I've had, and I've
been using Tab Controls for years. Do you have this available on a
webpage somewhere? If so I'll add it to my "neat links"...

--

John W. Vinson/MVP
Pete D. - 18 Jul 2008 01:39 GMT
I have to appoligize, I also usually use the tab control, I should of been
flamed. Must be thinking about Friday.   Pete D.

>>Here's a quick
>>little tutorial I give people on the use of Tabbed Pages.
[quoted text clipped - 6 lines]
>
> John W. Vinson/MVP
 
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.