Prev: trigger an event by changing pages in a tab control form
Next: casting call for models in buffalo
From: Ant on 21 May 2010 19:57
Hello,

I am using Access 2007 on a Vista machine. The database I am designing is in
the 2007 format.

I have a form that uses the Tabular type of Control Layout with Labels in
the Form Header and data in the Details Section of the form. There are 16
Label and data boxes and the data is numerical.

The two things I am trying to accomplish are:

1. In the Form Footer I have added 16 boxes which total each column. I am
now trying to add each of these boxes into the grouping so that it is linked
to its parent Label and Data boxes which makes it easier to size the boxes
and to re-arrange the form.

2. In the Form header, I have added more labels that are like "headings" for
groups of data. For exampe, there are two columns titled "Day" and "Night". I
have placed on top of those two labels another box titled "Command". I want
to link that heading box to the Day/Night boxes.

I am trying to do this because it is becoming quite time consuming trying to
correctly size up and align these new boxes. Also when I re-arrange my
layout, it is becoming frustrating trying to realign the extra boxes.

Any suggestions will be greatly appreciated.

Regards
Ant
From: Peter Hibbs on 22 May 2010 03:55
Ant,

It sounds to me as if it would be simpler to use a single Flex Grid
ActiveX control instead of all those separate fields (boxes) on your
form. Have a look at the Flex Grid Demo at :-

http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=21&SID=5debzz2c87c6957859f13b1d2zcccfb4

for some examples. You will need to write some VBA code to do this
though.

HTH.

Peter Hibbs.

On Fri, 21 May 2010 16:57:01 -0700, Ant
<Ant(a)discussions.microsoft.com> wrote:

>Hello,
>
>I am using Access 2007 on a Vista machine. The database I am designing is in
>the 2007 format.
>
>I have a form that uses the Tabular type of Control Layout with Labels in
>the Form Header and data in the Details Section of the form. There are 16
>Label and data boxes and the data is numerical.
>
>The two things I am trying to accomplish are:
>
>1. In the Form Footer I have added 16 boxes which total each column. I am
>now trying to add each of these boxes into the grouping so that it is linked
>to its parent Label and Data boxes which makes it easier to size the boxes
>and to re-arrange the form.
>
>2. In the Form header, I have added more labels that are like "headings" for
>groups of data. For exampe, there are two columns titled "Day" and "Night". I
>have placed on top of those two labels another box titled "Command". I want
>to link that heading box to the Day/Night boxes.
>
>I am trying to do this because it is becoming quite time consuming trying to
>correctly size up and align these new boxes. Also when I re-arrange my
>layout, it is becoming frustrating trying to realign the extra boxes.
>
>Any suggestions will be greatly appreciated.
>
>Regards
>Ant
From: Ant on 27 May 2010 16:19
Hi Peter,

Thank you for your response.

I have downloaded the Flexgrid demo and perused the VB Code.

Unfortunately this is well beyond my capabilities.

Regards
Ant


"Peter Hibbs" wrote:

> Ant,
>
> It sounds to me as if it would be simpler to use a single Flex Grid
> ActiveX control instead of all those separate fields (boxes) on your
> form. Have a look at the Flex Grid Demo at :-
>
> http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=21&SID=5debzz2c87c6957859f13b1d2zcccfb4
>
> for some examples. You will need to write some VBA code to do this
> though.
>
> HTH.
>
> Peter Hibbs.
>
> On Fri, 21 May 2010 16:57:01 -0700, Ant
> <Ant(a)discussions.microsoft.com> wrote:
>
> >Hello,
> >
> >I am using Access 2007 on a Vista machine. The database I am designing is in
> >the 2007 format.
> >
> >I have a form that uses the Tabular type of Control Layout with Labels in
> >the Form Header and data in the Details Section of the form. There are 16
> >Label and data boxes and the data is numerical.
> >
> >The two things I am trying to accomplish are:
> >
> >1. In the Form Footer I have added 16 boxes which total each column. I am
> >now trying to add each of these boxes into the grouping so that it is linked
> >to its parent Label and Data boxes which makes it easier to size the boxes
> >and to re-arrange the form.
> >
> >2. In the Form header, I have added more labels that are like "headings" for
> >groups of data. For exampe, there are two columns titled "Day" and "Night". I
> >have placed on top of those two labels another box titled "Command". I want
> >to link that heading box to the Day/Night boxes.
> >
> >I am trying to do this because it is becoming quite time consuming trying to
> >correctly size up and align these new boxes. Also when I re-arrange my
> >layout, it is becoming frustrating trying to realign the extra boxes.
> >
> >Any suggestions will be greatly appreciated.
> >
> >Regards
> >Ant
> .
>
From: Peter Hibbs on 28 May 2010 07:01
Ant,

That is a shame then. Do you mean that writing VBA code is 'well
beyond your capabilities', if so then perhaps it is time to study VBA
(it's not difficult) and you will be able to do a lot lot more in
Access when you have mastered it.

If you mean that programming the Flex Grid control is 'beyond your
capabilities' then perhaps this Web site will help -

http://msdn.microsoft.com/en-us/library/aa228849%28v=VS.60%29.aspx

Good luck.

Peter Hibbs.

On Thu, 27 May 2010 13:19:28 -0700, Ant
<Ant(a)discussions.microsoft.com> wrote:

>Hi Peter,
>
>Thank you for your response.
>
>I have downloaded the Flexgrid demo and perused the VB Code.
>
>Unfortunately this is well beyond my capabilities.
>
>Regards
>Ant
>
>
>"Peter Hibbs" wrote:
>
>> Ant,
>>
>> It sounds to me as if it would be simpler to use a single Flex Grid
>> ActiveX control instead of all those separate fields (boxes) on your
>> form. Have a look at the Flex Grid Demo at :-
>>
>> http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=21&SID=5debzz2c87c6957859f13b1d2zcccfb4
>>
>> for some examples. You will need to write some VBA code to do this
>> though.
>>
>> HTH.
>>
>> Peter Hibbs.
>>
>> On Fri, 21 May 2010 16:57:01 -0700, Ant
>> <Ant(a)discussions.microsoft.com> wrote:
>>
>> >Hello,
>> >
>> >I am using Access 2007 on a Vista machine. The database I am designing is in
>> >the 2007 format.
>> >
>> >I have a form that uses the Tabular type of Control Layout with Labels in
>> >the Form Header and data in the Details Section of the form. There are 16
>> >Label and data boxes and the data is numerical.
>> >
>> >The two things I am trying to accomplish are:
>> >
>> >1. In the Form Footer I have added 16 boxes which total each column. I am
>> >now trying to add each of these boxes into the grouping so that it is linked
>> >to its parent Label and Data boxes which makes it easier to size the boxes
>> >and to re-arrange the form.
>> >
>> >2. In the Form header, I have added more labels that are like "headings" for
>> >groups of data. For exampe, there are two columns titled "Day" and "Night". I
>> >have placed on top of those two labels another box titled "Command". I want
>> >to link that heading box to the Day/Night boxes.
>> >
>> >I am trying to do this because it is becoming quite time consuming trying to
>> >correctly size up and align these new boxes. Also when I re-arrange my
>> >layout, it is becoming frustrating trying to realign the extra boxes.
>> >
>> >Any suggestions will be greatly appreciated.
>> >
>> >Regards
>> >Ant
>> .
>>
From: Ant on 31 May 2010 06:56
Hi Peter,

I mean both. I have recently purchased a VBA for Access book to teach myself
from, but only upto chapter 3. Slowly getting there.

Don't worry, I am keeping your references for future use once I have a
better understanding of the coding.

Thank you for your time and help.

Regards
Ant
Australia

"Peter Hibbs" wrote:

> Ant,
>
> That is a shame then. Do you mean that writing VBA code is 'well
> beyond your capabilities', if so then perhaps it is time to study VBA
> (it's not difficult) and you will be able to do a lot lot more in
> Access when you have mastered it.
>
> If you mean that programming the Flex Grid control is 'beyond your
> capabilities' then perhaps this Web site will help -
>
> http://msdn.microsoft.com/en-us/library/aa228849%28v=VS.60%29.aspx
>
> Good luck.
>
> Peter Hibbs.
>
> On Thu, 27 May 2010 13:19:28 -0700, Ant
> <Ant(a)discussions.microsoft.com> wrote:
>
> >Hi Peter,
> >
> >Thank you for your response.
> >
> >I have downloaded the Flexgrid demo and perused the VB Code.
> >
> >Unfortunately this is well beyond my capabilities.
> >
> >Regards
> >Ant
> >
> >
> >"Peter Hibbs" wrote:
> >
> >> Ant,
> >>
> >> It sounds to me as if it would be simpler to use a single Flex Grid
> >> ActiveX control instead of all those separate fields (boxes) on your
> >> form. Have a look at the Flex Grid Demo at :-
> >>
> >> http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=21&SID=5debzz2c87c6957859f13b1d2zcccfb4
> >>
> >> for some examples. You will need to write some VBA code to do this
> >> though.
> >>
> >> HTH.
> >>
> >> Peter Hibbs.
> >>
> >> On Fri, 21 May 2010 16:57:01 -0700, Ant
> >> <Ant(a)discussions.microsoft.com> wrote:
> >>
> >> >Hello,
> >> >
> >> >I am using Access 2007 on a Vista machine. The database I am designing is in
> >> >the 2007 format.
> >> >
> >> >I have a form that uses the Tabular type of Control Layout with Labels in
> >> >the Form Header and data in the Details Section of the form. There are 16
> >> >Label and data boxes and the data is numerical.
> >> >
> >> >The two things I am trying to accomplish are:
> >> >
> >> >1. In the Form Footer I have added 16 boxes which total each column. I am
> >> >now trying to add each of these boxes into the grouping so that it is linked
> >> >to its parent Label and Data boxes which makes it easier to size the boxes
> >> >and to re-arrange the form.
> >> >
> >> >2. In the Form header, I have added more labels that are like "headings" for
> >> >groups of data. For exampe, there are two columns titled "Day" and "Night". I
> >> >have placed on top of those two labels another box titled "Command". I want
> >> >to link that heading box to the Day/Night boxes.
> >> >
> >> >I am trying to do this because it is becoming quite time consuming trying to
> >> >correctly size up and align these new boxes. Also when I re-arrange my
> >> >layout, it is becoming frustrating trying to realign the extra boxes.
> >> >
> >> >Any suggestions will be greatly appreciated.
> >> >
> >> >Regards
> >> >Ant
> >> .
> >>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: trigger an event by changing pages in a tab control form
Next: casting call for models in buffalo