Form layout question: How move controls in a Form to (in) a Tab Control?
I created a form with a lot of controls on it. (textboxes, pulldown's
Because the form is a little full I want to move the controls to
different pages on a tab control.
HOW can one do this?. If I drag them the tab control is not
'activated' if the mouse pointer is above the tab control.
(if one creates a new textbox and place it on the tab control this tab
control page turns black to show it's activated)
This does not work while dragging??!
Thanks in advance, Eddie Smit
Holland. (The Netherlands)
>Because the form is a little full I want to move the
>control...Controlling order of processing controls on a form
I am using a RecordSet to assign each persons name from the RecordSet as the
ControlSource of a TextBox. There are about 50 names and about 84 controls,
so there intentionally will be blank controls.
These controls are arranged as a seating plan in a dining room.
All works OK except I cannot establish in which order the controls are
accessed in a loop:-
For Each Ctl in Me.Controls
I Assumed the sequence would be in TabIndex order, but it isn't.
Does anyone know how order they are processed in is workrd out, or more
importantly how I can force them to be ...copying controls from a form to a tab control
I have copied approx 20 controls from a form to a tab control for
reasons of space.
i now cannot run code triggered by the events of these controls.
for example, the following will not trigger the message box when
Private Sub cboA_Change()
MsgBox "combo A changed"
the controls are all disabled and are only enabled when the previous
control has a value set.
Instead of copying and pasting, try cutting and pasting. If you copy and
then paste, the original controls stay on the form so when you paste the new
controls get ne...enable controls on tab control form
I am trying to enable controls based on the value of a checkbox, i.e.
if value = true then enable.
I have a tab control form with controls on 4 tabs. I have some code
(below) on the tab control "on change" event.
This works for the 'first tab' but then does not work for any other
Private Sub TabCtlPage2_Change()
'set the focus to exit button
Select Case TabCtlPage2.Value
Case Is = 1
For Each c In Me.Controls
If c.Tag = "PREABY" Then
c.Enabled = Nz(Me.checkbox_PREABY.Value, True)
E...Lock a Sub-Form from a Form control
** Any assistance you can provide would be greatly appreciated **
I have a main form with multiple sub-forms. On the main form, I have a
checkbox that corresponds with each sub-form, and this checkbox will
express the users desire to lock the ability to edit a corresponding
sub-form. To do this, I figure that each checkbox will have :
(1) the AfterUpdate property call a Macro or VB Module to execute the
setting of the Allow Edits property of the sub-form and
(2) the On Current or On Load property of each corresponding sub-form
will also check the value of the checkbox in the main form to
dete...How to Automatically Resize Form Controls When Resizing a Form
I am an experienced developer with other languages and applications, but a
neophyte when it comes to MS Access forms. Can someone please help get me
with a solution for the following issue: On a form, I have an object
(ImgEdit control from MS Imaging) that needs to automatically grow and
shrink when a user resizes the form. The object *does not* need to grow and
shrink based on the size of the image that is being displayed. Rather the
object needs to grow and shrink so that it occupies the maximum possible
screen real estate as the size of the form window is adjusted by the u...Resize Form Controls and Subform Controls at the same time
In terms of resources, wondering if it makes a difference in adopting
one of the three options below for resizing controls on a form and
controls on a subform at the same time.
option a.) Put the code all in the main form and refer to the controls
on the subform in the main form's OnResize event.
option b.) Put the code for the main form controls in the main form's
OnResize event and put the code for the subform controls in the
subform's OnResize event.
option c.) Put all the code in a module and call it on the OnResize
event of the main form.
What this code is doing is positio...Set form.control equal to subfrm.control before update
Here is what i have:
tblOne: SampleNumber,LinkNumber,LinkSchedule (and other misc)
tblTwo: EmpID,LinkNumber,LinkSchedule (and other misc)
frmOne recordsource = tblOne
subfrmTwo recordsource = tblTwo
When i enter a LinkNumber in frmOne, it filters all of the records in
subfrmTwo with the matching LinkNumber. LinkSchedules will be
different, so there will be multiple entries with the same LinkNumber
in tblTwo. After i enter a LinkSchedule in subfrmTwo, i would like it
to update tblOne.LinkSchedule.
Any thoughts or suggestions?
...KDE 3.51 / Missing Energy Control in Control Center
System: SuSE 9.3 / Intel Pentium 4
After the update to KDE 3.51 I'm missing the option to control acpi events
in the control center. In 3.5 and earlier there was a module 'energy
control', where you could change settings for acpi events.
Also a kcmshell --list doesn't list a module laptop any longer. Is there a
replacement or is this a bug. BTW the kdeutils3-laptop installed fine.