Recent content by Access11

Yes the textbox is bound to the original Master table. This is the same scenario I have on my other project. I will look into the search

It's an Access Autonumber. I have this code on another project and it works, only difference is this project has the subform added to the main form. The code should assign a new number using Dmax function to add +1 before it is added to the table.

Morning all, I was wondering if someone could help with this code. I have a form and a subform. I want to pass the value of both form and subform to my Master2 table, however I get an error. Revsion No is an automuber field. The section in blue seeems to be the issue. Any help would be...

Okay, I will look through the posts again and see what I can pick up, thank you.

Is there a way to save the main form and subform data to a table without using SQL? An easier method I can try?

I changed all the names to show as followd BOMNo, VersionCode, strSql = "INSERT INTO tblMaster2 (*) '" & _ "SELECT " & lngID & " As NewID, Type, No, VariantCode, Description, Quantity, Scrap% " & _ "FROM tblMaster2 WHERE BOMNo= '" & Me.BOM_No & "' AND VersionCode= '" & Me.Version_Code & "';"...

Thank you, Yes I have reworked it a little to be more conventional.

That's how Thanksgiving should be. Hope you enjoyed it. Unfortunately no I have not been able to sort this out. I tried all weekend to make any change that would work. I wish there was an easier way , where I wouldn't need SQL to run this code. Hopefully you can look at the DB and make...

Enjoy your dinner and thank you for the time and effort you have put into this. I appreciate it.

I cut down the DB to show just what can be seen. Basically the DB works this way. You select a BOM No (Build of Material) it populates on another form that has a subform. One BOM can have multiple No (Items) attached to it. when it opens user should be able to make revision and save to a...

Okay I ran the SQL and obviously I did it wrong cause notiing came back. I did notice that when I got the error thought the very beginning of my Code was hightlighted in yellow. the Private Sub cmdSaveRevision_Click() part. Again sorry, I'm sure I'm testing your nerves now If...

Sorry, I missed the post about the Single Quotes. I thought I had to use them as some fields such as Type, Varaint Code are text fields. Let me try and run the SQL Debug and see if I can do it. Sorry foir my lack of knowledge on these matters.

Maybe I'm missing something. I just caught the Scrap % and made the change , anything else you see? MY VBA and SQL are subpar at best. I appreciate your help on this. My SQL is strSql = "INSERT INTO tblMaster2 (*) '" & _ "SELECT " & lngID & " As NewID, Type, No, [Variant Code]...

Thank you for the tip I checked and all fields with spaces have []. Still not sure why the code is not working, any thoughts?

Hello all, Happy Holidays I used a code from Allen Browne website to pass value from Form and Subform to a new table, but it does not work for me. Can someone take a look at the code and see what is wrong? I get a Compile error: Method or data member not found on my WHERE clause, at least...