Recent content by Aximboy

Thank you for your reply but that doesn't help me. Here's what I'm planning to do... I have several mainforms with subforms and several controls with the same functions to all the mainforms. I renamed all the controls similar through all the mainforms so I can call them from a module to save...

I know this is how to reference a control in an active parent form. Forms([Screen].[ActiveForm].[Name])!txtFirstName.Visible = False But how do I reference a control in an subform of that active parent form? TIA

Thank you for replying. Yes it is normalized. The 1st table is... ID Patient ...and the 2nd table is... PatID Visit Flu MMR Polio

I have a query question. I have a table with Patient Name, Date of Visit, and Flu, MMR & Polio vaccinations. The flu vaccine is good for 1 year only. MMR vaccine is good for 2 years. Polio is good for 3 years. How do I create a query to show example#2? example#1 Here's what I have.... ID...

OMG, I did not thought of that! The only reason I'm loading Form2 is to get a record count. Thank you so much Mr. dhookom!

It loads but record count doesn't calculate first before copying to Form1.

So from Form1, I have... Command16_Click () DoCmd.OpenForm "Form2" Forms!Form1!Text3 = Forms!Form2!Text4 End Sub

Thank you for responding. Isn't the calculation of record count built in the forms? So I don't know where it is.

I have a Form1 with a command button that opens Form2. Form2 displays the record count in the form footer. Then I have a code that copies the record count on Form2 back to a textbox in Form1. My problem is, Access copies the record count right away before the Form2 even calculates the record...

Thank you all for responding. I was sick and wasn't able to work and check this forum until this evening. So upon trying your suggestions, I found that... Requery doesn't work "Me.RecordSource = Me.RecordSource" doesn't work However, assigning the SQL directly to the recordsource did worked...

I am using this Change SQL property of saved query (DAO) function by Mr. dhookom (faq701-7433) on my form. However the new strSQL won't load until after I reopen the form the second time around. Any idea why it isn't loading the first time? Or is there a work around on this? I am using Access...

I have a query. In one of the fields I have this expression… Expr1: IIf(InStr([FieldName],"(")=0,[ FieldName],Left([FieldName],InStr([FieldName],"(")-1)) Then on the criteria, I have… Like [Forms]![FormName]![txtFieldName] But when I run it I get an error “Data type mismatch in criteria...

Mr. dhookom Thank you, thank you & thank you!

I need to run a report based on the selected year on the form. I have 5 tables with different years worth of data; (I know this is a bad idea but this is what my manager wants) tblYear2011 tblYear2012 tblYear2013 tblYear2014 tblYear2015 I also have a form with combobox where a user can...

@SkipVought, I wouldn't either but my boss told me to fix his mess. @dhookom, I'll do that next time. @MajP, thanks for the tip, I'll give it a try.