Search results

I have a form called JobtrackingHome with a subform called jobtrackingsubform. Within this jobtrackingsubform is another subform in a datasheet view to enter in dates and times for employees on specific jobs. When I click "New job tracking" button which updates the jobtrackingsubform to a new...

I am having a hard time getting a sum without an #error. I have a query named Qry_orderdetails. Within it there is a field called ExtendedPrice, where I have an expression as ... ExtendedPrice: ([Quantityordered]*[vpPrice]) The form for this query is in datasheet view and is being used as a...

Hello, I am having trouble with designing an order form for this database because of the way that the tables are designed. Situation: There are tables "Parts" and "Part details" and "Vendors". I have created 2 one-to-many relationships here, with each Part description having multiple...

I have a continuous form with my record source as a query. The query has been set up so that the criteria for the field named "Inventory Type" is being defined by a combo box. I have this working just fine by using this in the criteria. [Forms]![Search Inventory]![combotype] OR...

This may sound confusing, however, I will try to make it as clear as possible. I am creating an inventory database system. I have an inventory table made with all of the information we need about each part, including the "type" that it falls under. (the type being "inventory type") There are...

Hi Everyone, I am new to access and currently teaching myself how to create a database for the company that I work for. So far everything has gone terrific and almost everything I've learned has been from this forum or YouTube. You guys are awesome! Now I am at a halt with confusion and...