Solved

Tab Control and Combo Box Issue

Posted on 2014-02-21
13
504 Views
Last Modified: 2014-02-25
Hi Experts,

I have created a tab control on a form with a subform on the tab control and a combo box the subform (please see frmMenuCreator on attached db).  I have three issues that are probably related to not selecting the correct control to change, but I just don't have a clue at this point.  Any help would be greatly appreciated!

1.  The combo box in form view doesn't display the formatting I've designated

2.  The combo box shows filtering options in each column's heading.  I'm assuming this is being "inherited" somehow from the query but can't seem to find a solution to disabling it

3.  All the pages of the tab control display the subform and combo box.  How do I create different controls on the separate pages?

Thank you!
Menus-Working-version.accdb
0
Comment
Question by:Skip Sleeper
  • 6
  • 5
13 Comments
 
LVL 61

Expert Comment

by:mbizup
ID: 39877202
1 & 2:  Which combo box(es)?  It might help to post a screen shot or two to clarify the issue you are having.

3.  The problem is that your subform is on top of the tabcontrol, not "in" any of the tab pages.  Correct placement is a little tricky.  You have to
    - Click on the tab page you want the control(s) on
    - Click the edge of the page to select it (so that the page, not the whole tab control is outlined showing that it is in selection)
    - Click your heels together three times
    - Paste or place your controls onto the tab page.

I've done it here... just for demonstration I've placed it on the lunch tab (you can move it as needed)
Menus-Working-version.accdb
0
 

Author Comment

by:Skip Sleeper
ID: 39877247
Hi Mbizup-

Thank you for responding so quickly!  Attached please find the requested screen shot.  Also, is the heel clicking a special utility I can download? :)

Also I've got the tab control now--knew it must have been something "easy"!
frmMenuBuilder-Screen-shot-of-he.docx
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39877304
<<
Also, is the heel clicking a special utility I can download? :)
>>

I wish!

<<  Attached please find the requested screen shot. >>

I see what you mean... looking into it now, and scratching my head along with you at the moment.  It doesn't seem to be controlled by the properties I would normally use for this.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 61

Expert Comment

by:mbizup
ID: 39877313
Hmm... Actually it is working as I would expect I was just looking at it wrong.

Open your subform in Design View, select one of the checkboxes, and change its  Data Sheet Caption property,

Datasheet Caption
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39877390
<< 2.  The combo box shows filtering options in each column's heading.  >>

I missed this earlier.  

To get rid of the sorting/filtering options drop-down in the column headers,

- Open the form in design view
- Open the form's property sheet
- Under the "Other" tab, set the Shortcut Menu Property to NO
- Save the changes (the change wont be apparent if you immediately switch back to Form View)

Change this to NO
0
 

Author Comment

by:Skip Sleeper
ID: 39877493
Hi,

How do I format those headings and have the formatting for the combobox take affect (e.g. font/size/weight)?  Am I looking at the wrong control?

Also, do you know of a source that defines/explains what the various properties are?


Thanks!
0
 
LVL 36

Accepted Solution

by:
PatHartman earned 500 total points
ID: 39877770
You can't format the headings in the datasheet view using the interface.  You might be able to format at run time with VBA but I doubt it.  I had a list of properties that you could reference in datasheet view from VBA but I don't have it with me so couldn't post until tonight or over the weekend assuming I can find it.

If you change the view to continuous, you will be able to format the headers but you'll probably need to rebuild the form since the two form types are built differently.  The datasheet form view wizard builds the form with the fields listed in the detail section vertically with labels attached.  To use continuous view, you would want the labels in the report header section organized horizontally and the textboxes in the detail section also organized horizontally.
0
 

Author Comment

by:Skip Sleeper
ID: 39877776
Thank you so much--I really appreciate it!
0
 

Author Comment

by:Skip Sleeper
ID: 39879562
I've requested that this question be closed as follows:

Accepted answer: 0 points for fargus47's comment #a39877776

for the following reason:

Quick, Very thorough and precise!
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39878106
Glad to help out!

Check the way you are closing the question though, it looks like you are accidentally accepting your own comment as the solution.  :-)
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39879563
Posting an Objection to stop the pending closure and to get a Mod to help you out with this.
0
 

Author Closing Comment

by:Skip Sleeper
ID: 39882342
Very thorough, timely and precise as well extremely gracious when I awarded myself 500 points for accepting the solution!
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
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…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

828 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