Recent content by C.F.

Thanks for the feedback, Plog. 1. Yes, I have Googled, and recently found a site that may hold promise... http://msdn.microsoft.com/en-us/library/gg251104.aspx . 2. The particular trouble is the following error message when opening Access 2003 database with date functions in Access 2010...

How do I get my date functions -- created in Access 2003 -- to work in Access 2010? (I sense this is a common problem.)

JPaulo -- I'm a novice at this, so the simplicity of your code was appealing to me. Form my database, I translated your code into the following as a Event Procedure "On Open" for the report, Rpt EA ITAR Dashboard v4 THIS ONE rpt: _____________________ Private Sub Report_Open(Cancel As Integer)...

JR - Thanks a million! I took your excellent 3rd suggestion one step further for simplicity and just recalulated; then moved the focus to the next field. the code THAT WORKS looks like this: Private Sub Text140_AfterUpdate() 'After Update of textbox 'recalculate the entire form 'move focus...

I entered my database's version of this same code as follows: Private Sub Text140_AfterUpdate() 'After Update of textbox 'move the focus to the main form, 'refresh it, then move the focus 'back to the subform. Form![Frm Testy for Cond Too w Tabs frm].SetFocus DoCmd.RunCommand.acCmdRefresh...

Re: Applying conditional formatting to a tab control based on its own value? I mirrored your information and tried this.... 'On current event of main form ‘Check if Text66 is empty is True ‘Then nothing ‘Otherwise add the picture to Page62 Dim Location As String Location = “K:\Access...

John - Thanks for the feedback! As you can see in the attached pdf, I can add a picture "check box" to the tab "EA Notes" by going to design view, clicking on the tab title, going to its properties, selecting picture and then selecting check box. I can do this. What I need help on is how to...

The tabs' labels just have the name of each tab. I know I can manually add a picture of a check box to a tab label. I was just trying to have the check box added if there was info in the tab's text box; otherwise, the tab label would just show the name of the tab.

I am a every 6-8 month Access novice. I have a database that I share with a handful of others that I'd like to be more "user freindly". There is a tab control that has four tabs. When a user moves to a different record, I'd like for the tabs to show the Check Box picture with the tab name...

dkinley - Thanks very much for the sample database! It works great! My problem is that I cannot figure out how you make it work -- how the "SomeOtherNumber" gets its information. I see where the information comes from, but I can not for the life of me figure out how it does the calculation...

Thanks dK! I'm getting #Name? What I want is in a subform. To make it simple (for me), I'm just trying to get the acqusition Number to work first. I copied from your entry the code = Me.Parent!ControlName I copied the Control Name and added brackets =Me.Parent![Acquistion Number] and I...

I'm very much a novice and still stuck. Would anyone give me a clue about the use of "Me", or any other tip to getting my Condition number created? By the way, I used & ".01" to address one aspect of the numbering at a time.

Inserted the following in the default value of the control in the subform: =[Me].[Forms]![Frm Testy for Cond Too w Tabs frm]![Acquistion Number] & ".01" I got the error "The object doesn't contain the Automation object 'Me'. Also, I've been cautioned about spaces in my control names --...

I want to have Access generate a number that includes: a) an Acquisition Number, provided by the parent form; and b) a sequence of numbers for Conditions – 01, 02…, 11, 12, etc.. The number, to reside in a subform, will look like “9147.01” where 9147 is the Acquisition Number and .01 is the...

Thank you, Paul! The brackets appeared to be the problem, although I just bracketed the field name and not the table name.