A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Control Layout



 
 
Thread Tools Display Modes
  #1  
Old May 22nd, 2010, 12:57 AM posted to microsoft.public.access.forms
Ant
external usenet poster
 
Posts: 65
Default Control Layout

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 a

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
  #2  
Old May 22nd, 2010, 08:55 AM posted to microsoft.public.access.forms
Peter Hibbs
external usenet poster
 
Posts: 871
Default Control Layout

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/f...3b 1d2zcccfb4

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
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 a

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

  #3  
Old May 27th, 2010, 09:19 PM posted to microsoft.public.access.forms
Ant
external usenet poster
 
Posts: 65
Default Control Layout

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/f...3b 1d2zcccfb4

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
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 a

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

.

  #4  
Old May 28th, 2010, 12:01 PM posted to microsoft.public.access.forms
Peter Hibbs
external usenet poster
 
Posts: 871
Default Control Layout

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/libr...=VS.60%29.aspx

Good luck.

Peter Hibbs.

On Thu, 27 May 2010 13:19:28 -0700, Ant
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/f...3b 1d2zcccfb4

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
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 a

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

.

  #5  
Old May 31st, 2010, 11:56 AM posted to microsoft.public.access.forms
Ant
external usenet poster
 
Posts: 65
Default Control Layout

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/libr...=VS.60%29.aspx

Good luck.

Peter Hibbs.

On Thu, 27 May 2010 13:19:28 -0700, Ant
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/f...3b 1d2zcccfb4

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
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 a

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
.

.

  #6  
Old June 1st, 2010, 02:57 AM posted to microsoft.public.access.forms
Ant
external usenet poster
 
Posts: 65
Default Control Layout

Hi Peter,

I am trying to decipher the code. I am using you "frmTimeSheet" form which
seems to best suit my needs.

I entered the Design View and tried to copy flexigrid subform to a form in
my own database. This did not work. I then tried importing the entire form
and this did not work either.

The error message I receive is as follows:

"You do not have the licence required to use this ActiveX Control.

You tried to open a form containing an OLE object or an ActiveX Control or
you tried to create an ActiveX Control.

To obtain the appropriate licence, contact the company that provides the
licenced OLE object or ActiveX Control."

Where do I get this lincence? Is this not part of Access?

Hope you can help.

Regards
Ant

"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/libr...=VS.60%29.aspx

Good luck.

Peter Hibbs.

On Thu, 27 May 2010 13:19:28 -0700, Ant
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/f...3b 1d2zcccfb4

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
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 a

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
.

.

  #7  
Old June 1st, 2010, 12:28 PM posted to microsoft.public.access.forms
Peter Hibbs
external usenet poster
 
Posts: 871
Default Control Layout

Hi Ant,

Glad to see you are trying this out.

Regarding the license problem, if you have a look at the Word document
(Using the Flex Grid Control in Microsoft Access.doc) that comes with
the demo, the References section near the end of the document explains
the procedure.

If you still have problems then post back.

Peter Hibbs.

On Mon, 31 May 2010 18:57:01 -0700, Ant
wrote:

Hi Peter,

I am trying to decipher the code. I am using you "frmTimeSheet" form which
seems to best suit my needs.

I entered the Design View and tried to copy flexigrid subform to a form in
my own database. This did not work. I then tried importing the entire form
and this did not work either.

The error message I receive is as follows:

"You do not have the licence required to use this ActiveX Control.

You tried to open a form containing an OLE object or an ActiveX Control or
you tried to create an ActiveX Control.

To obtain the appropriate licence, contact the company that provides the
licenced OLE object or ActiveX Control."

Where do I get this lincence? Is this not part of Access?

Hope you can help.

Regards
Ant

"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/libr...=VS.60%29.aspx

Good luck.

Peter Hibbs.

On Thu, 27 May 2010 13:19:28 -0700, Ant
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/f...3b 1d2zcccfb4

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
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 a

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
.

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:35 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.