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

I have tried putting this in the next record command on my form and this works better when there is just the Reprocess Reason - but I also would like to do exactly the same for a Failure reason but am not sure how to link the two in a way that compares them seperately. For just RP I currently...

So this sort of works, when I don't touch the QtyReprocessedTxt box, (which contains a 0 as default value from the table it is linked to). However if I type in a 3, and then change it back to 0 it will get stuck giving me the message box unless I choose somethng in the Reason for RP Combo box...

I tried putting this in: Private Sub Form_BeforeUpdate(Cancel As Integer) If Len(Me.QtyReprocessedTxt & vbNullString) = 0 Then MsgBox "You need to fill out Reason for R/P" Cancel = True Me.QtyReprocessedTxt.SetFocus End If End Sub But I'm assuming there should be something in there...

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

Hey thanks for the reply. Not sure where I'd put all this? Pretty new at Access! Think I have come up with something of a solution I just don't know how to do the code. I have created a query based on the table (ListOfActiveBaskets), which only shows baskets are active (i.e. don't have an...

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

Both dates are in the 'Medium' format "06-Mar-14" at the moment I think it is something to do with how the date is stored though, as I have another text box on my form which displays the average increase in weight through the production process for that material, and this works perfectly...

Actually thinking about it I wasn't sure, so tried to run everything through a query instead and it works much better, thanks.

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

^ Would there be any way to get these values for the pot weight to update/appear in the table/on the form? The production manager asked if it was possible so that operators could see relatively up to date information on how close they were getting to the maximum efficiency.

The aim would be to find the total weight of 8000 to use in a percentage formula yeah. The problem is that the Disc Number is re-used in the production process [it's basically a piece of metal that doesn't melt so we know which basket contains who's stuff] roughly once a week, so with this...

Here are a few pictures from my database which hopefully make it easier to understand. I also released I forgot to mention each order submitted has an ID number (just +1 from the last record) http://i1350.photobucket.com/albums/p777/JPed1/accessproblem1_zps736d7327.png So in this small...

Apologies! Basically the production process runs with orders being contained within baskets of a certain capacity. More often than not, 1 basket = part of 1 order and thats fine, however sometimes too smaller orders will be put in the same basket. In my form, these two orders are put through...

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

Do you know how it would be possible to write it so it has the same effect for multiple option boxes? I tried copying out the code twice but I receive an error message "The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing Microsoft Access from...

Brilliant, thank you!