Search results

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

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

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

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

Hello I have a material usage table that tracks material going into products Oftentimes the same material will be used and multiple records will contain that material. I want my query to return only records with unique material used. I'm clicking the "Unique Values" and "Unique Records"...

Hello I have a table of raw materials that have two fields, their stock code and longer description. I have another table that is tracking the usage of these materials. I want both the stock code and longer description to be recorded in the usage table. I want the "Description" field in the...

Is it possible for a report's displayed decimal places to be conditional. I have field that has a lab test's name a field that displays the result of the test. For some tests I only want 2 decimal places, for others I want 4. Is this possible within the same field?

Hello I have a field that is text format. However many of the records in that field contain numbers. I want to delete all the records that are numbers in this text field, leaving only records with textual data. is this easily possible? Thank you

Hello I have a field in a table that is comprised of mostly numerical data but some records are text. I want to convert this field to numerical only and make a new field to put the textual data in. However converting the field will delete the textual data. What is the easiest way to convert...

Hello I have a report with 4 sub reports. I want to center them so it looks nice. IS there a way to easily center objects in the middle of the page? thank you

Hello I have an append query that currently looks like this http://i.imgur.com/PYHxqjs.png?1 This query automatically adds the machine parameters for a product code and lot number into the running condition log. This is so the user does not have to manually go in and tediously select each...

Hello I have a query that is returning running conditions for a machine over multiple shifts. the table is set up like this date shift parameter condition 09/13/13 1 front 500 09/13/13 1 middle 450 09/13/13 1...

Hello I have a Machine Running Conditions database that records running conditions for 2 machines. The table is set up like this LotNumber Parameter Condition 130506m11 Screwspeed 100 130506m11 StockTemp 50 130506m11 KniveSpeed 75 In reality...

Hello I have a report that is looking up min and max quality specifications for a product. The table with the specifications has a Yes/No check box field for when the specs are defined as "Internal". So the table looks like Product/MinValue/MaxValue/Internal I want the report to display "TEST...

Hello I have a database that is being shared on a network folder. I have about 4 different people using it at the same time. Occasionally, someone gets the message "The database has been placed in a state by user "admin" on machine MDSOUTH (our server) that prevents it from being opened or...

Hello. I am designing queries to return averages for quality test data. I have this query that functions as I want it too http://i.imgur.com/K0f7ZLD.png It returns the averages of all the values received for different tests for a lot number (the lot number criteria should be filled out as well)...

Hello I have a training log that has 4 tables, the employee table, the training course table, and the department table. These tables all contain the names of employees, training courses, and department in one field and their respective ID codes in the other. The 4th table is the actual log...

Hello I have a report with 4 subreports. The report contains calculated fields that use the totals field in the different sub reports. My issue is when one or more of the subreports does not have data in it. The sub report dissapears while in print preview, removing the totals row and ruining...