Search results

Ok i got that to work. To auto fill my form but now i have to figure out how to go to the next item on the subform. Here is the code that i have.... Private Sub cbopro_AfterUpdate() Me.subform1!Procedure = Me.[cbopro].Column(1) Me.subform1!REV = Me.[cbopro].Column(2) Me.subform1!TA =...

Ok i really new to this. Here is the problem im having I have a main form RCB it has RCB#,Order,Heat,Grade,Size,Shape,Tolerance. This has a list of procedures that go alone with up up to ten depending on the order. Ok i no i have to make a subform to add the orders that i want to the...

Sorry worded that wrong, the combo box uses a table to get its info from and it will auto fill on a Continuous subform, then evertime the user selects a new procedure it will requeary and add another procedure to the subform. Is this do able?

Well the issue im having is that i dont want to use a text box but a combo box to enter the data on the form. For example i have another form that the user will use to enter the procedure then use Procedure&","& REV&","& TA&","&REV1 so that it all shows up in a combo box. Can this be done with...

Hope this helps.

Ok attached is what im working with. Again i have most of the items i need and there forms. The only thing im stuck on is the Notch section and the Dia section. I have a key code for Im not sure how to add them all togther like the spreedsheet? Bc of the muiltiple rows that i will need. Plus how...

But figured someone out there has done this b4, but yes still a noob with access!!

No made one b4 but trying to make it more simple then the way i made my other one. plus this time i trying to add everything that i do into one. For instance Employees, Calibrations, RCB's, Linearity checks. I will open this database and select one of 5 catagories to chose from. Everything i do...

No i have not. I do have another question. With the DiaGo, NoGo section you told me to use a lookup table. Like i said b4 there could be up to ten entries per column & all different. How would i use a llokup table to make the user be able to easily enter that data? I looked online to see if...

Yes when its all done that will all be added. Ill attached the semi final drawing for the report i plan on printing out for my customers. The middle is where i figured i have the most trouble bc i could have so my values with the DiaGo, nogo and the Notches Section.

Ok that makes a little more sense. So that we are on the same page what i mean is this is just part of a tbl. I have a total of 5 tbl to merge into one. Im adding customers, Employees, instruments, and a few other things to make one record. Ill send along my Access database so you might see what...

Had to send as PDF but its normally in Excel. But that pic is how i need it to be. And most of the time i dont have to fill all of the spaces. Just an FYI. I'm just not sure if access had a button to use on this or not. If i have to make a table for each thats ok. But is there a buttom to add...

I work at a steel mill and we make steel bars with drill holes in them. There are push pins with sizes on them which if the pin fits in the hole " say the hole is .25 thats the DiaGo, and the DiaNoGo is .26". The TMD is the test metal distance from the top of the bar to the top of the drill...

The form that im trying to make has three spots to fill, DiaGo,DiaNOGo,TDM & they could have up to 10 entries per field. What I'm asking is how? If i just want to populate the three with whatever numbers i have or do i need to make a new table for each?:banghead: Because on my report it will...

So i just removed all the spaces in the table and code but as soon as i open Access i still get the Security Warning message " Some active content has been disabled . Clicick for more details." As soon as i hit that, no "matter what number i stick in the text box its a duplicate.

Yea this was the first one i did and the more i do and see i should redo alot over.As for the user to enter the numbers, that will be me and and me co-worker. But as soon as i set this up this is all its going to do. This just saves me and my parther like 5 to ten mins because the guys before me...

Ok here it is. Well at least it says it attached.

Ok put the code in that way but still give me the same error.Let me explain, when i enable the content i get the message box error of "RCB Number already exists please enter a new number" And when i enter i brand new number will say 1 never been entered before still give me the error "RCB Number...

Yes its a number. So the Dlookup is only used for string/text? Let me put the code in and see is i still get the error message when i enable the activeX.

Hello all, i have been fighting with this for a bit and just thought that id reach out. Anyway my code is as follows; Private Sub RCB_Number_BeforeUpdate(cancel As Integer) Dim Answer As Variant Answer = DLookup("[RCB_Number]", "tblRCB", "[RCB_Number] = '" & Me.RCB_Number & "'") If Not...