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 :
---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 :
With Warm Regards,
---In MS_Access_Professionals@yahoogroups.com, <dbalorenzini@yahoo.com> wrote :
---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
http://www.thatlldoit.com
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---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: Art Lorenzini <dbalorenzini@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (8) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar