Search results

Hello I have been creating a database to help manage call off products from suppliers and until now I have built a structure that works, as far as the flow of data is concerned. I am able to enter all the data directly in the tables cascading down from entering a PO with a Supplier to Calling...

Hi I have a Main Form that has information about contracts, one of the fields is ContractQty, linked to this is a subform based on a query that enters receipts against the contract and in the subform footer there is a field that totals the receipts. What I want do is display the contract...

I have two tables called LabSamples and Results that have a 1 to Many relationship using a LabSampleID field. Each LabSample can have many Results what I want to achieve is for the Status field in the LabSamples table to be updated from "On Test" to "Completed" once all the Results for that...

Hi everryone I am working on a system for recording lab sample results, so far I have created tables, forms and queries to input the data and this works OK. What I would ideally like to do now is create a query to list all the samples that are due for reading to be listed in order of...

Hi Everyone I am having difficulty getting a text box to update from a combo box selection on a form. The cbo is called Stage1 and the text box is called S1LengthDays, both are fields in the same table. I am getting an error message in the code window. "Compile error. Method or data method not...

Hi Everyone I am currently working for a Jam and Marmalade manufacturer in Manchester, UK. Occasionally I need to use access to help with my role as a planner / materials scheduler and although I am fairly OK with the basics I find that I need some help with vba and more complex functions. My...