Search results

That did it,thanks ever so much. I thought I tried every Combination there was

I got the equation from a excel spreed sheet that was sent. I hope that kinda explains it. If you need to see the spread sheet I should have that around here as well?

Steve, thanks for chiming in. I will do even better. I will upload the db so you can see the report and give me suggestion on what I did wrong

Paul, thanks for the quick reply.......... I am using the formula that the client has given to me from a excel file. It should come out as 6.50. I mean 8.50 divided by $53.53, shoud read 6.50

Field Name A =Sum([Piece]+[Summary detail]+[PartialSum]+[Summary Partial]+[WVSum]+[Summary wv]) = $53.53 Field Name B =([ClockHrs]) = 8.50 I want to divide field B into field b It shoud come out to read 6.50 I have tried everything but cannot make it read 6.50:banghead: What in the heck is...

Bob, I am sure that not storing it twice. On the Main form where sits the subform. I have a text field called ED Rate. In the following I have this as event procedure: Private Sub EDRate_AfterUpdate() Me.FrmWorkProduction_subform!DRate = Me.EDRate End Sub All I am...

Good morning all, this is what I have: Main Frm Sub form Form= FrmEmployee Hire 1 Text key called Text1 Need to update the Sub form from FrmEmployee Hire I used the “After update” Event in the main Frm and it work great. What Event would I use from the FrmEmployee Hire to update the sub form...

Isskint, I hope you can understand this. I think I covered about everything. If you think you need additional information, please let me know. Once again thanks for taking the time to view this. Main Form: Name FRM ADD/Edit Payroll S3 2 Tables are involved with the Main Form 1. TblEEFullName...

Isskint, thats a bummer. I can give you all the relationships that are involved and the links.

I just updated the db. I was able to address my problem so what and it works on a Main form and a subform, but nothing is link. So it has to do with many link fields. I will attach the revised db. Any help would be most appreciated

Isskint, that would be great. I think it would be alot better if you can review the db for yourself and you will get a better idea where the issue is hanging up.

Isskint, thanks for the quick reply. I have uploaded the db, to make it more clear. By any chance were you able to view the db?

Isskint, thanks for chiming in. I pasted in the code as suggested. I am still getting the error " the recordset is not updateable" Private Sub EDRate_AfterUpdate() Forms![Frm ADD/Edit Payroll S3]!FrmWorkProduction.Form!DRate = Me.EDRate End Sub

There are 3 words that are dangerous a staff meeting: Can you do? Is this possible Why can’t we Then why do I say, “It most likely can be done”. This is what I am trying to accomplish. I have a form with a subform. I would like to populate a field in the subform, from the Main Form. The...

Bob thanks for chiming in. If I understand you response "what constitutes "correct data using the sub form?" I have the sub form using link Master ID on main form with Child wrkdescrp_ID on sub form I used the following: Me.Employee.Locked = (Me.NewRecord = 0) On Current event on the main...

I have a combo box located in the form called “Frm Add/Edit Payroll”. The combo box is “EE” What my problem is I do not want to have the user be able to change the name in the combo box once the records have been created with the correct data using the subform. I tried changing the...

Duh, you are right, been working on this to long today. Again thanks pbaldy

Anyone like to take a stab at this one. It must be so simple, because I cannot find out where the problem sets. I think I need a fresh set of eyes.

Ok, just figure it out, duh me had to use a Goto command with add New Action. I was thinking backwards again. I need a drink

Duh me...... I guess that would help, you guys are not mind readers. Sorry Combox ........ EE Form ......... Add/Edit Payroll S2