Recent content by Kozbot

I am grouping because without "Total" the query returns 5200 repeating values rather than just the dozen or so tests specific to the product I want to append. Looking at it further I don't need to join tables. Now I have INSERT INTO tblCOATestResults ( TestName ) SELECT...

I have the table that have the tests associated with material. The SQL for my code is INSERT INTO tblCOATestResults ( TestName ) SELECT tblCOASpecifications.TestName FROM tblCOASpecifications, tblCOALots INNER JOIN tblCOATestResults ON tblCOALots.COALotNumber = tblCOATestResults.COALotNumber...

I am developing a Certificate of Analysis (COA) database that will contain the test results of all incoming raw materials we use. Each raw material always has a certain number of tests in each of their respective COAs. I have a table of all the raw materials we use and their tests. I want the...

When I try to drop in a continuous subform into the footer section of a continuous form I get "You cannot do this"

But can I nest continuous forms within each other?

Hello, I am attempting to make a product formulation database for my company. The current formulations are stored in word docs in the format attached. I am attempting to make a clean and user friendly entry form to enter in the product formulation data. Attached is what I have so far. You can...

No. The aggregation is being done at the report level.

Hello, I have gotten to the format attached. It is almost what I want. How do I get the raw material options to go horizontally across the page? Thank you!

Is there a specific report format I'd need? I would need to sub reports? Potentially a sub report nestled in a sub report?

Hello, The formulations for my company's products are contained in individual word documents. I want to enter this data into an Access DB and recreate the format of the formulation sheet as much as possible. Each product has multiple raw material ingredients that each can have multiple...

No I defined it as the control source. I defined the default value of the source controls as a numerical zero. Do I have to specify the control recalculate on a certain event. the value only remains displayed in the calculated control after I enter a record in the subform source control.

There is none. it just has =[QuantityOrder]+[QuantityStock]+[QuantityPartial]+[QuantityDowngrade]+[frmOtherMaterialProduced].[Form]![Othermatsubtotal] as the control

Hello I have a calculated control on a form that is summing other controls and then a subtotal on a subform. This is access 2007 The calculated control does not display the value until I enter a value other then the default in all of the source controls. If I hit the "refresh" button, the...

Hello I have a query that is returning material used for production runs. Originally I wanted the query to only return unique lot numbers for raw material used by setting the count criteria=1. However this isn't working anymore because sometimes the same lot will sometimes be entered multiple...

Hello I am attempting to split an Access 2007 database. My company has two locations. From my location we are remote connecting into the server. While down there they are connecting directly. When I split the database, people in my location can use it fine. When people down there use it, they...