Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Aximboy

    How do I reference a control in an active subform?

    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...
  2. Aximboy

    How do I reference a control in an active subform?

    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
  3. Aximboy

    carry previous data within a criteria

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

    carry previous data within a criteria

    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...
  5. Aximboy

    How to wait for record count before copy

    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!
  6. Aximboy

    How to wait for record count before copy

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

    How to wait for record count before copy

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

    How to wait for record count before copy

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

    How to wait for record count before copy

    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...
  10. Aximboy

    Change SQL property of saved query

    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...
  11. Aximboy

    Change SQL property of saved query

    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...
  12. Aximboy

    Data type mismatch

    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...
  13. Aximboy

    How do I change a table name from a query using VBA?

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

    How do I change a table name from a query using VBA?

    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...
  15. Aximboy

    Find the latest records on duplicate tables

    @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.
  16. Aximboy

    Find the latest records on duplicate tables

    I have created an access database in a shared drive so that employees can enter their production data, and the bosses to view the report. One of the employee drag and drop this access file to his folder on his computer creating a duplicate database. He has entered over a thousand new record on...
  17. Aximboy

    Different sizes control elements. Why?

    If he or she is the only one having that problem, check to see if he or she is using the same exact database.
  18. Aximboy

    Not recognizing as a valid expression?

    It works!!! But it took me awhile to figure out how to use the Parameters properties dialog. Again, thank you so much!!!
  19. Aximboy

    Not recognizing as a valid expression?

    I have a query that filters the years based on a form input. Here is how the filter looks like: WHERE (((Format([Request Date],"yyyy"))=[Forms]![frmStatus]![txtStatusYear])); When I click Run... The query runs fine. The union query runs fine. However, the crosstab query gives me an error. It...
  20. Aximboy

    How do I create a query for...

    Thank you Andrzejek, I never noticed that feature before. Now that you mentioned it, I owe dhookom big time!!!

Part and Inventory Search

Back
Top