Hi Art
I'm with Duane on this one – I would use a tab control with two pages (more if necessary) and set the Style property to "None". The user will not be able to see the tabs or change pages through the UI, and all you need to do to hide one set of controls and display another is change the value of the tab control in your VBA code.
Best wishes,
Graham
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, 3 October 2017 10:12
To: wrmosca@comcast.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Subject: Re: [MS_AccessPros] Re: Grouping controls together in Access
From they way it is described it sounds like it... i am going to give it a whirl...
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
"Valar Dohaeris"
On Monday, October 2, 2017 01:27:11 PM, wrmosca@comcast.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Sorry, that should hae been "Tag", not "Tsg"
-Bill
---In MS_Access_Professionals@yahoogroups.com, <wrmosca@comcast.net> wrote :
Sounds like the Tsg property will work exactly like you want. In fact, it has long been a substitute for the VB6's control array.
---In MS_Access_Professionals@yahoogroups.com, <dbalorenzini@yahoo.com> wrote :
I have 2 sets of 10 controls that I need to show dependent on the mode the screen is in. If its in search mode I display a set of 10 comboboxes that have table data in them and each of the combo labels contain the name of the field pulled fro the table. eg. Vendor (label), ABC, Inc, BBC, etc would be inthe comboboxes). Now if the screen is in Add mode then a set of 10 textboxes is displayed and the user adds appropriate data, Vendor, Addresss, Phone, etc. If the screen is in data enty mode, again 10 textboxes is diplayed and the user enteres the data for each of the fields (ABC< 123 Main Street, 605-272-2222, etc).
The orginal project was written in vb6 and is now being rewritten in VBA and Access. It uses a lot of control arrays which no longer exist.
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
"Valar Dohaeris"
On Monday, October 2, 2017 10:16:28 AM, wrmosca@comcast.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Art
What is the reason for grouping? I always use the control property Tag and set a string so I can loop through controls in a section like this:
Private Function MyFunction()
Dim ctrl as Control
For each ctrl in Me.Detail.Controls
If ctrl.Tag = "Tax Group" Then
'Do something
End if
Next
End Function
Regards,
Bill Mosca, Founder - MS_Access_Professionals
My nothing-to-do-with-Access blog
---In MS_Access_Professionals@yahoogroups.com, <dbalorenzini@yahoo.com> wrote :
I need a way to group a set up textboxes and comboboxes together. Does Access have a container control that wil ldo this besides the Tab control. I know Vb has a Panel and Frame Control and I teste The Option Group but it is just for options buttons. Is there away to achieve this effect, in most case the group of controls would be visible on not visible. But there are a few variance here also.
Thank you for any ideas you may have.
Art Lorenzini
SD
Posted by: "Graham Mandeno" <graham@mandeno.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (9) |
Tidak ada komentar:
Posting Komentar