Solved

Control Groups through VBA

Posted on 2004-09-08
5
527 Views
Last Modified: 2012-06-27
Is there any way that controls can be grouped through VBA code? To clairify what I mean by grouping, I am refering to the Format / Group menu option.
0
Comment
Question by:wetwitched
5 Comments
 
LVL 34

Accepted Solution

by:
flavo earned 250 total points
ID: 12012337
I dont have that option, but in 97 you can only group Option Buttons (the yes / no circles) so that it only allows 1 to be chosen (like a mulitchoice exam or something....)

Dave
0
 
LVL 1

Assisted Solution

by:flocken
flocken earned 250 total points
ID: 12015231
IMHO, no. Or at least, there is no easy way to do it - in MSDN Library it was not found.

I tried to do it with the .Parent property (similar to the way to find which lable is bound to wich text/listbox), but it seems not to work.

The only way I can imagine in general to find, if such possibility exists or not is the following:
1. to make a new db1 (f.ex.) with a sample form with some elements on the form.
2. to close this db1
3. to copy it to db2
4. open db2, select some controls and then group them using menu.
5. to close db2
6. to buy FMS-Detective or Comparer from SourceBin, which allow detailed comparison of 2 Access databases and to compare db1 with db2
7. if the comparison programms do find the difference, then to try to use the corresponding properties in VBA code.

I would do it myself, but I don't have neither FMS-Detective nor SourceBin Comparer, unfortunately :(

flocken
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now