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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Myron60

  1. Myron60

    How to populate combobox from subform entry

    Thanks, that worked beautifully. I had tried a lot of different events but not the On Enter, I did the CODE(Me!<controlName>.Requery)and it worked the way I wanted it to right out of the gate. Thanks again.
  2. Myron60

    How to populate combobox from subform entry

    Hi y'all, I have been trying to populate a subform combobox with a select query. I have a main form text box called [JobNumber] and a subform called JobRates, you choose the SSN# from a combobox that populates the rest of the subform (viewed as datasheet). I have another subform called...
  3. Myron60

    Query using Year in 2 unrelated tables

    Thank you for responding so quick, I'm not sure I understand. SELECT Jobs.EntryDate, Jobs.JobNumber, Year([EntryDate]) AS JobYear, Year([MileageYear]) AS RatePerYear FROM Jobs LEFT JOIN MileagePerYear ON Jobs.EntryDate = MileagePerYear.MileageYear GROUP BY Jobs.EntryDate, Jobs.JobNumber...
  4. Myron60

    Query using Year in 2 unrelated tables

    Hello, I have a table called "Jobs" with JobNumber and EntryDate fields and I have a table with MileageYear and MileageRate fields. What I am trying to do is use a query to take the EntryDate and link it to the MileageYear and show me the MileageRate for that year. I have tried everything I...
  5. Myron60

    Merging different database years

    Thanks for the quick response. I want to use the new forms and old tables, adding the new table data to the old. The new tables have new fields and records that the old does not have. The old tables have 3 times as much info that is needed. So I was thinking it would be easier to put the...
  6. Myron60

    Merging different database years

    Hi all, My company has a database that was created in 1995 and it quit working properly when we updated to Access 2010, so not know much about access I created a new database with new tables, forms everything I thought I needed. Then while searching the web trying to learn more I learned I...
  7. Myron60

    Working with Word and Access?

    Thank you for your response and time. I will try it.
  8. Myron60

    Working with Word and Access?

    Thank you for your quick response. My contract has an automatic date, Contractor Name Combo Box, SSN Form-Field, Pay-rate Form-Field, Over-time Form-field and a Signature Line. My Access database has field for all of this. I want to be able to click on the Combo Box and select a name an...
  9. Myron60

    Working with Word and Access?

    Hello, I am very new to programming of any kind. I have Contract that I saved as a Word 2010 Template and an Access 2010 database with a query table. I want to open the contract template and select the contractor's name in a drop box then save the contract and email it. I have been trying to...
  10. Myron60

    Trying to populate a Word 2010 combo box with Access 2010 data query

    Hello, Thank you for your time and patience. I have a word document with a combo box that I want to populate from my access data query. This combo box will have all my employee names listed in drop down list when you click or start typing, then when your single choice is made it will fill in my...
See more

Part and Inventory Search

Back
Top