Search results

:confused: I have been playing around with this thing for hours and I still can't get it to work properly. Right now, when I click on the classifications buttons (REW,WRAP1,WRAP2)with your code the Sheet ID (for SheetMaster) always resets to '0'. Once this does this I am unable to enter...

lol.. Sorry Tim! Funny thing - I had my browser open for the entire day and did not see all the other posts you left for me! When I had posted that I have found out where the REW_WRAP_INDICATOR was, I did not see or read the post you made explaining it. And the exclamation mark wasn't at all...

Hm..I took a snippet of your code, but I can't get the text box which is located in the subform to display the value I selected from the Option Group box. I think this is due to the fact that I have a blank subform called 'BlankSub' which loads the actual rewinder, wrapper1 or wrapper2 subforms...

Okay nevermind! I found out what the REW_WRAP_INDICATOR is. :p

I've removed the duplicates. I have made a lot of changes and didn't bother removing them. The key difference I see in your program compared to mine is the following code: Private Sub frmClassificationChoice_AfterUpdate() Select Case Me.frmClassificationChoice Case Is = 1 ' REW...

Sure thing. I will even give you the actual names of the forms/subforms :) Manual_Entry_Master | Rec.Source: SheetMaster | Mainform Manual_Entry_Master_Machine_Rew | Rec.Source: SheetMachine | Subform Manual_Entry_Master_Machine_Wrap1| Rec.Source: SheetMachine | Subform...

Hi Tim, Sorry for the late reply. My boss had my working on another project that took a considerable amount of time. I have fixed up the forms and tables in the same way you have indicated. However, now I am getting a problem I originally had. All 3 subforms are writing to a single table...

UPDATE: I have created separate tables and have created ref integrity links. However, currently I see a problem. When I click on each of the 3 buttons (category buttons) a new record is generated. How can I limit the amount of new records for Rew, Wrap1 and Wrap2 to simply a single record...

Hi Tim, Once again, thank you for your insightful reply. In your QueryStart.jpg I see that Rew, Wrap1 and Wrap2 are all in one table. You meant to create a table for each right? Therefore, 3 tables in total linked in the same way in your pic. Similar to the last picture I had posted...

But, if I have separate tables for each of the categories then the relationships will be even more complex! I do not know if we are on the same page, but please see the attached picture. Is this what you mean? The arrows should obviously point to the PK's. I didn't bother pointing them to the...

Thanks for your long and detailed response Tim! I really appreciate it. I think the confusion is the subforms part. I forgot to say that I have a subform inside a subform. I'll try to give you a picture of it: Mainfrm subfrm1/subsubfrm1 subfrm2/subsubfrm2 subfrm3/subsubfrm3 The subfrm's is...

Hi, I have a bit of a problem. I have 3 buttons that will launch 3 different subforms. These subforms are all children of the form. In my database, it is possible for all 3 subforms to be filled and created, but the problem is giving each subform an unique ID so I can link it (uniquely) to the...

Can anyone help? Essentially, the problem is passing values from one combo box on to all fields in the subform...

Here is the table for the Machine Category and its subform (Machine Name)

Doing this: Private Sub MACHINE_NAME_COMBO_AfterUpdate() Me.MACHINE_CATEGORY_COMBO.Requery Me.MACHINE_NAME_COMBO = Me.MACHINE_NAME_INVIS End Sub Will only allow me to pass the value from the combo box on to whatever Problem I am focused on. The value should be passed to all entries of the subform.

Hi Bilbo, I forgot to attach it the first time I posted. I guess it takes a while to load the changes. Here's the pic: http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=18172&d=1185287683

Passing values and extracting secondary values Hi, Is it possible to have a single combo box who's value will be passed into every subsequent entry of a record? If you take a look at the attached picture, you can see a combo box for Machine. I want to push this value I select from the...

Oh. I see. Thank you for clearifying that up. I actually had the settings you speak of, so I looked around and found that the Bound Column is the column that will be entered into the database and changed that to 2, where the names were. Thank you for your help. ;)

I have an idea, how about for each problem (subform->Detail) I add a hidden field that points to the value selected in the MACHINE_NAME combo box and the corresponding MACHINE_CATEGORY? How does addressing work in Access?

OH! I'm sorry. Yes, I only made one subform because I wanted to solve the problems of that subform first then I could go copy and paste the subform and make small changes to it to make it the other 2 subforms. :p