Search results

Thank you! this seemed to do the trick. Thank you very much!

Howdy all. Been a while since I have been on. I built a basic database that totals hourly rates to hours worked. Work fine except when I run a report from a query, some totals will round down. In the example in the document attached, you see that project 1801 total rounds down and the 1615 is...

Perfect! That works. Thank you very much!

Sorry about that. I put the code under the subform in the On Current. Me!Project_Number.requery. I have attached an example of what is happening. So, the Project Number that has 1501 or 1607, you should only be able to type in the TIBHrsWorked fields. But this is not the case until you create a...

Thanks for the reply but that didn't work.

I have subform in a Main form that has Drop down field named Project Number and two Hours text fields Hrsworked and SPHrsworked. I have it set when you select a specific Project Number, one Hours field is active and the other not active. Example, select Project Number 1, you can add entries in...

Ding, ding ding... Winner. Parent was what I needed. Thank you so much for your information and time. I spent days trying to figure this out. You are awesome!

This is where I get stuck. If I try the update event in the project combo, I type in me.full_name = me.. How do i select the Employee_name in the main work order. I tried me.fullname = me.workorder_main!employee_name but that didn't work.

Great! That worked. One more issue. It fills the name only in the highlighted row in the subform. If I add another Project_Number (another row in the subform), it doesn fill unless I go back to the main form and re-select the name. Thank you so much! You are helping a lot.

Thank you for the reply. The problem that I'm having is when I use the Me.TextboxName = Me.ComboName.Column(2) code, it fills in all of my Full_Names in the subform to the last person I added to the main form. So, all of my other records in the subforms now have the last person's name filled in...

Hard to search on something I can't even explain. Attached is the database I'm working on. I want have the Employee_Name to be in the Full_Name in the subfolder. Which the only way I could think of is to have the Full_Name control Source =[Forms]![WorkOrder_Main]![Employee name]. I want to be...

This works great but if an field is empty in the table, it only shows results of rows that have all columns filled in. For example, if you remove the School from ID 4, (Ross), You will only get results of the top three. I'm running into this problem with a search that I'm working on. Any...

Thanks GinaWhipp! Looks like the query way is not the best way to do this. I will research a different/better way to do this multiple search form. Thank you for the link.

I’m running Access 2013. I have created a search form with about 10 different categories from a single table. I will only show 5 fields for this example The form is called FrmSearch with Description CarNum SerialNum Category Condition In the query, I have the criteria, Like "*" &...

I have a single table database for inventory. Every 3 months or so, some records get changed or updated. My manager wants to keep an archive of all of the records that have been changed so we can go back and look at an history of all of the records. So, My thought is to create an "Archive"...

Yup! I just figured that out myself and was ready to delete this thread. Wonder if I should keep this up here for future reference? Thanks a lot!

Access 2010. This has worked before but I don't understand why this is not working for me now. When i select an item in a combo box in a form and click on a button to run a query with the results, the query is blank. If I run the query alone, it prompts for an item, I can type it in and it...

Found a fix. I had a pro on the phone and he fixed it for me. The proper code for the search after update is. Me.Recordset.FindFirst "[ClaimID]=" & Me.ClaimSearch (the ClaimID is what the query is searching on)

Hope this makes sense. I have the main form open up where the Data entry is set to YES so it opens in New Field. I created a button to change the value of form's Data Entry to NO. It works. Changed the form so I can navigate through entered fields. I have created a drop down to filter a specific...

I got this resolved. I was unaware of subreports until someone mentioned it in a different forum. So, I created 3 new queries (Emp_invoice…etc) I have the totals in each query grouped by SUM. I was able to add a subreport if each query with the results I wanted.