Search results

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

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

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

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

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

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

This will be hard to explain. I have created my first database and ready to roll it out but stuck on a couple of things. I want to create an invoice report with the total after the Workorder is completed. But my invoice query works only if there is 1 entry in each subform. (I uploaded a stripped...

Access newbie here. I’m using Access 2010 and trying to create my first database. I want to create a work order and inventory DB. I have the following tables listed. Employee Table 1.EmplyeeID 2.Employee name 3.Employee Title 4.Employee Hourly Rate Equipment Table 1.EquipID...