Search results

Hello, I am not good at coding as I am learning...can you please help with the coding? Learning as I go

Hello, I have Field "BC1Chng" which requires user input. I want to be able to write a code to reference to "BC1Chng" if there is an input in that field for any record...I want to copy the Remarks into each record in the Remarks Field. I was able to get the remarks1 field to loop through...

Wow that worked...now I will post another question. Please look for it

Call TrackUser ...Track anybody in the unit that is making a change to the record. Accountability

Sorry If I was not clear enough...What you described is exactly what it is doing right now. I am just taking the Comments from one record and copying that into another record..same field. But currently for me to move through the records..I have to keep clicking a button. I need for it to move...

I have a code that I am currenly using with a button to move to the next record. I just want it to loop by itself. I am currently having to press the Update button for it to move to the next record. Thank You Private Sub UpdateAllComments_Click() Dim memoContent As String memoContent =...

Hello, I have one module that I have it set on a button for each of the four forms. I works fine for the first form and the second form..it doesn't. My forms have subform where the button is and that's where I copied the code on all four subforms. Any ideas?

Hello, I only have four separate mainforms...all the same and each of those mainform has a subform ...the subform is based off a query. I am new to Access so for me I am still in the learning stage and if it works I don't question how it worked ..it just did. Even my calculation field in...

Hello CJ, I did try it with the parent.[fsub_Final_Table Query2].form.[TotalBC2].. it keeps putting brackets around the parent name and the .form. I have been trying everything

Hello Spikepl, I tried the expression builder, but the field I need is on the other form?

I still get an error with =[Forms].[fsub_Final_Table Query2]![TotalBC2] this form is a subform. Both forms are subforms. Even if I put in a formula..I just hae tried all the combo for that field in that form to show up on my third form. All I am doing is taking the last field which has a...

I tried =[Forms]![fsub_Final_Table Query2]![TotalBC2]. I get the same value in all my records. It's the first record in Form2..that is the Value in that field..in form3..it shows in all the records for that field

Hello, Both my fields are on Subforms ...it's like getting your bank statement. You have a beginning balance and you have a ending balance. I want the sending balance to carry over to the next form..I have four forms total.

I have two fields..on two different forms..the output needs to be the same. FormA.field b = FormB.field a FormA.field b is a calculation on form A....the end result. On FormB that needs to be my beginning number. I have tried everything that I could think of..also the fields are a part of...

I am having problems with my INSERT statement: INSERT INTO [FINAL_TABLE_CROSSTAB](OrgName, CostCenter, Fund, PEC) Select [Final_Table_AllotQ].OrgName , [Final_Table_AllotQ].CostCenter, [Final_Table_AllotQ].Fund, [Final_Table_AllotQ].PEC, from Final_Table_AllotQ WHERE...

My field on Form A is a calculation if that helps. I have a calcualation in the control source.

Here is what I tried in the Control Source =Nz([Forms]![Final_frm].[TotalBC1],0)

Do I think the " in between?

How do I populate fieldA in formB with FieldB from FormA.. So Field is the last numeric field in Form A..so I need to the take the calculation value of that field and be the starting value in formB.

Also..unfortunately I have 10 comment boxes on each of my four forms....