Search results

Hey i tried the code example out and cant seem to figure it out. i got error number 3022. Private Sub cmdfrmTopLevelDupe_Click() 'On Error GoTo Err_Handler 'Purpose: Duplicate the main form record and related records in the subform. Dim strSql As String 'SQL statement. Dim...

Thank you for the example. I will try that code and see what happens.

Hi, I have a main form with five subforms on it. I need to duplicate the main forms and subforms recordsets at the same time using one command button on the main form. Thank you.

I was able to determine what the issue was with the help of mike60samrt and all of you! thank you very much for your information. mike60samrt helped by looking at the db and figured out that the subforms i had were corrupt. I remade them and they work as intended now.

Hi, I have a problem with a database i have been working on for the past couple weeks. My main goal is to add 5 sub forms to a main form. The sub forms are continuous. i am able to add two sub forms to main form but when i add any more i get an error message."The microsoft access database...

I moved subform1 back to the details section of the form and it seemed to fix the problem. I had subfrm1 in the header section and that was causing some kind of miscommunication. Thank you all for providing ideas to fix this.

theDBguy, Yes they are properly linked by using Product_ID from the main products table and Product_ID from a junction table that saves that list of ingredients. The junction table is called product powders with the following, ProductPowders_ID Product_ID RawPowders_ID MgPerServing

I have two sub forms on a main form that i need to go to the new record when the main form is navigated to the New* Record. SubFrm1 is a continuous form and SubFrm2 is a form that pulls info from the main form controls and calculates the results. The Problem is when subform 1 pulls...

Just realized that the attachment might be locked, if so, then the password is : wordup11 Thanks, Cwats

Hey Everyone, I have used this concept in an excel program that i am replacing with MS Access. As you can see in the attachment the total weight(cellC45) is divided by the weight cap . in cell C66. if Cell C45 is zero then there would be no calculation and the cell is filled with 0. If...

"Hi. Not sure this is correct but 2400/1200 = 2, so 2 batches for blender #1. Correct? If the total batch is 3100, then 3100/1200 = 2.583, so 2 batches for blender #1. Then, 3100 - 1200 * 2 = 700, then 700/700 = 1, so 1 batch for blender #2. And so on... " theDBguy, Yes, that is...

Hey Everyone, this thread is solved thanks be to mike60smart, majp, mark, and everyone else who posted their ideas. There is no harm in posting more if you think of anything that might have been missed. Most recent activity was from mike60smart. We got together and he showed me what changes were...

Mark, Thank you for that last post. There are systems in place to prevent cross-contamination. Luckily the company has enough equipment to produce more at once. That is a great advantage because a full breakdown and clean in-between batches is not always necessary.

Hey, I am making batching instructions and need to have the ability to split a batch into smaller portions or vice versa. What I am getting at is this, I have a form to build the batches and decide what blender they will be mixed in. I want to be able to make a batch split depending on...

June7, Thank you for your advice. It works great!

Hey, Here are the field names, For the Target Dose Per Capsule: Product_ID OrderQTY MgLimitPerCapsule (this is the max mg load a capsule can be) CapsulesPerUnit CapsulesPerOrder (this is all of the information that the order needs, this would be the main form. The MgLimit would stay...

Auto populate a row in a subform based on a remaining amount Hi, I have been trying to figure out how to make a row auto populate into a continuous SubForm. What i am dealing with is this, the Continuous form is basically a list of active ingredients with the appropriate dose...

Side note, I remember mike60smart mentioning to normalize the data for the scheduling, but it slipped my mind and i never did that to the file i sent. anyways, i just want to throw that out there becasue he did a very good job explaining things i never knew about access.

Mark_ Yes we have deifferent production lines but a manufacturing hold could happen anywhere in the process for any reason. we have a few different steps in the manufacturing process, 1. Blending operation 2. Capsule filling operation 3. Drink filling op. 4. tablet press op. 5...

Hey everyone, I should have clarified what i meant by All products scheduled. The company That is interested in this Manufactures vitamins. They need a way to track when customer orders are scheduled to manufacture. Every Customer Order has one or more items that they want us to make...