Search results

Is there a good book or resource in MS Access VBA which shows you how to properly program? I don't want the usual school book approach. I want to be able to have the correct syntax with examples to access and manipulate form controls for example. I want to programmatically create forms with out...

This is not want I want to accomplish. I want to click on the menu button and have the tabs appear. If it is not selected then it is in hide mode. Does someone have the right coding for such a request. I have tried but it is not working.

Once I click on my menu button it brings up a specific form with information. Hence, the case statements. Then I want to proceed in opening and hiding tabs based on that selection. When I press on a Menu button entitled project it opens a main form with 2 tabs opening at the same time. Once...

I am trying to activate and hide tabs but my code is not working...can someone assist? The following is the code written: Private Sub frmtab_Change() Select Case Me.frmtab.Value Case 0 For j = 0 To subTab.Pages.Count - 1 If Left(subTab.Pages(j).Name, 2)...

I was successful in using the conditional formatting. Thanks

I understand what you are saying. I just used it to create a list from a table. It was completed within seconds. Now I am trying to see if I can use colors to distinguish if a task is new (active), pending or completed off of a datasheet view. Wish me luck! I am thinking once information is...

Indeed, no more tabs for multiple tables, I acquiesce. I've been up changing my thought process on how to address this problem. I have decided to use another alternative. I am using the traditional method of subforms and binding the information directly. I have also changed my ERD to encompass...

They are on separate tables

I will clear the info and post

They are on separate tabs

Arnelp, it is not as simple as creating a master child relationship. I built Dynamic menus whereby each tab corresponds to the totality of information for one user. A particular user can be selected by using the combo box. What I am having trouble with in particular is trying to create the...

I am using the tab control. Can I use an event to load the Tabs with information from my query. Then use an event to filter using the combo box to obtain the information. Can you demonstrate how this can be done?

I am trying to create a form based on the tab control. I have 12 tabs, each with various controls and I am trying to filter these tabs using a combo box. For example "When I click on the combo box and select " A person" I want the tabs to be filled with the associative information. I have tried...

lol..I am not offended...

If you ever have time, I would love to know how you would have done it

Thank you for your assistance: I figured it out, another way to skin the cat: The following code worked: Dim Ax As Single On Error Resume Next Ax = CSng(Right(Me.ActiveControl.Name, 2)) If Err Then Ax = CSng(Right(Me.ActiveControl.Name, 1)) End If On Error GoTo 0

The Screen.ActiveControl generates another error message: Method or data member not found In order to give more context: I am developing an application with dynamic submenu's which upon selection brings up various tabs with additional controls. My dynamic menu works correctly when I set my...

I understand what you are asking for, however, when I attempt to do that as I go past my first breakpoint, it kicks me out of the function and displays the same error message. The following is the line I am referring to: Ax = CSng(Right(Me.ActiveControl.Name, 2))

The following is my code and I am having problems in making my Menu expand from 9 buttons items to 12. I am getting a "The expression after update you entered as the event property setting produced the following error:" It's a issues that arises when I click on my menu buttons. To whom ever...

Hey everybody! Nice to be in this community.