Solved

Control Groups through VBA

Posted on 2004-09-08
5
534 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

840 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