Search results for query: *

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.

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

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

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

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

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

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

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

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

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