I apologize; I didn't know. And I can't have a table of batch numbers because we receive the batch numbers from our supplier, so it could be any number.
But I'll take a look at the sub form and see what I can do.
devarts
Last Activity: Jul 17 '14, 04:13 PM
Joined: Feb 19 '14
Location:
-
I've attached a database that only concerns the issue at hand. I hope this might clear up a few thing. If you hit the previous button you'll see what I am talking about.
Dylan...Leave a comment:
-
How to move to next record that isn't based on key id?
I have a form that operators fill out every time they finish a sample for a particular batch. We do test multiple samples for each batch but the number of samples vary depending on certain criteria.
In the form, I have placed a sub form of the table that the data in which hold this information so its being directly entered in. The operators are able to put all the samples connected to that batch right into the sub form. Naturally,... -
Not exactly... everything is correct until you get to "so that
[tblDrumResults]![Batch_Number] = 11
then
[tblDrumResults]![Kiln_xref] = "A... etc"
Just to point out the Batch Number in tblKilnData is called Gen3Run. I am not sure why but thats the naming convention that was put for that field. So that may help a little.
But essentially I would like to do this:
Form with txtBatchNumber...Leave a comment:
-
1) I'm sorry I didn't explain that I linked the tale called tblKilnData from the other database to the Gen3 database. That is why I did not define in the code, but If I still need to define it, even though its linked, I can do that.
2) I had a feeling that could be the case. I didn't quite know how to go about do that part. I want to find the value of the Batch number that matched the batch number in the Gen 3 database. Once it found...Leave a comment:
-
Record Set will not set new value to allocated field
In a form I have a bound object that is related to a field (Batch Number) within this table called tblDrumResults.
What I would like for it to do is by choosing a batch number to automatically populate the next field underneath batch number which is kiln.
The criteria for this is that I need to find the batch number that is equivalent to the current batch number I have in another database, in another table called "tblKilnDat a",... -
Access Query Question
I have six check box type fields. I would like to have a field in my query that says the following:
If one of the six fields are true then show me the data for that record
but if all the boxes are false then do not show me the data for that record
I am only interested in data that has at least one of the check boxes checked. -
I'm trying to pull information together but I only know where to find it on a form. I need the information off the query or table that it is connected too.Leave a comment:
-
How do I find origin of table from a form?
I am trying to find the origin of some data from a form; specifically, what table or query it points to. Is there any way to know what table is being used? The control source tells me what fields are being pulled but not from what table. -
I usually do back my databases up but it seemed like an easy fix from the beginning because I've seen people do this before. But I have learned my lesson.Last edited by zmbd; Feb 25 '14, 10:57 PM. Reason: [z{it's my standard warning for most things that might damage your data (^_^)}]Leave a comment:
-
Thank you so much! I completely forgot that one could do that! It solved all my issues!
Thanks!Leave a comment:
-
Form Problem with Field
Our company likes to keep track of when we calibrate certain pieces of machinery. A form was created to log that data in a table. I was asked if I could add another piece of machinery to the list because it was just purchased. I found out that someone manually put in the Row Source (looking at the property sheet). My thoughts were to create a table so if they need to add another piece of machinery that all they needed to do was add it to the table.... -
Sorry guys I'm not a big VBA programmer, clearly by my display above, but I thought I knew how I could make the code written for me work with my database.
Going back to the original thread (( Access Form Question about record verification )), the apples and oranges was referring to the [SourceMaterial] (Didn't want to bore you with specifics and the [Tagcheck] refers to the checkbox that is used.
For example, I want...Last edited by zmbd; Feb 25 '14, 06:36 PM. Reason: [z{inserted link to the referred to thread, inserted some whitespace (^_^) }]Leave a comment:
-
When I remove one of the End If, I know get a Loop without Do error, which does not make sense because I have a do statement.Leave a comment:
-
End If without Block If Error
I'm getting an "End if without Block if" error with the following code:
...Code:Private Sub Command42_Click() Dim ctl As Control Dim strTag As String Dim intCtr As Integer Dim strBuild As String Do For Each ctl In Me.Controls With ctl If TagCheck.ControlType = acCheckBox Then 'Is the Control a Check Box If TagCheck.Value = True Then -
Access Form Question about record verification
I have a form and data is already imported from a previous step, but at this point one can check a box and all the information that is regarding to that check box will be added to another screen. For example, Tom, Katie, and Sonya all bought a red apple. When I check all the boxes for red apples it will send it to another form that will enable me to print out all the customers who bought a red apple. But sometimes when people are clicking a box they...
No activity results to display
Leave a comment: