Search results

Hi all, I am attempting to do something that I'm not sure is possible, so if there are any alternative suggestions on how to find the end result please feel free to tell me where I should be looking. Basically I have a form where a start date is inputted (Inputfrm , StartDate) and a form...

Hi all, I have found a number of guides/instructions online on how to create a user security on Access 2010 which I have managed to do by creating Login tables with password and security levels. I have a login screen which opens when the database is opened and the on click command of the...

Hi there. I have a form (PostProductionForm) which is used to input data about finished goods which come off a production line. There are three possible outcomes which can occur after the production: Passed, Reprocessed, Failed and the numbers for these are entered in 3 text boxes on the form...

Hi there, I am attempting to make a system where the lifespan of baskets in a production process can be tracked. In order to do this I am looking to create a form to input when a new basket is introduced. Each basket has a 'disc' associated with a number on (BasketNumber), however these...

At the moment I have a form (InputFrm) for operators to enter production processes into the system. Each one of these has a certain weight which the operators enter and it all stores in InputTbl, which works great. However I am trying to have a running total of the kilograms inputted on each...

Hi, I have a query (MonthlyInputQry) which calculates the total input into a production process by month (where month is a number 1-12) and there is a year (2013, 2014, etc). This query is based off a table (InputTbl) which records each individual order which goes through the process and then...

Hi there, I have a form (Packing) which feeds into a table called "Inputs". I have managed to make it so that when a checkbox is ticked, a "Date Packed" appears signalling the time it was picked. At the moment I am pleased with the layout of my form (currently in a database view) and how it...

Hi, I am trying to use a DLookup to search to find what block goes into the production of an item. In a table called "dbo_vw_MCE_job_with_materials", each item contains a list of the parts which go into its production in a column titled "Expr1". However there are always more than one parts...

Hi, I have a form and was wondering if it was possible to set it so that a user is not able to click the submit [Submitcmd] unless certain text boxes are filled (however SampleOuttxt needs to be able to remain blank). Any help would be appreciated J

Hi everyone, Basically what I have is a form where operators can input certain information about a production process, in particular the kg input which has gone into the 'basket'. However this is divided by customer order number and sometimes more than one customers order is placed into the...

Hi, I have a form which a order number is put in and is compared to data which has been pulled from the system. The issue I'm having is that that on the software we take the orders on it adds zeroes in front of the numbers to make it up to an 8 digit sequence, but generally when people input...

Hi everyone, I have been trying to find a solution to why I can't get a Dlookup with multiple criteria to return the value I need. Essentially I am trying to use an Order Number to find the item number which is contained within another table. However the order number has multiple lines...