Search results

Can you help me achieve this please. Thankyou

Issue is I have no idea what I'm seeing let alone know how to type the formula after seeing what I saw.

Yes this looks like what I am wanting to achieve.

I have no idea what a running sum is, let alone know how to do it. I just need one little field from the previous record to be calculated in the current row and field. I'm totally lost. Without a multitude of code I guess I'm at a stand still. thank you anyways

Yes, however, I need to add the sum from the last record without having to type it. A query reads and can sum from the same row but I need it to sum from the previous record.

I'm looking to do a simple inventory where what comes in (form 1) and what goes out (form 2) are taken away to leave a total. This total needs to be added to the next 'what comes in' form when new inventory is recorded. Is it possible to have a vba or something that can take the last field...

How do I do that?

@ Isaac. It's a fieldname. Anyways upon further data inputs it only shares data from same record over and over again. sigh, not what I want. I'm trying to save myself from double entering the data when it's available on another form. Oh well.

Private Sub LSDate_AfterUpdate() Me.Child143.Form.Sold_Date.Value = [LSDate] Me.Child143.Form.SBWK.Value = DatePart("ww", [LSDate]) End Sub Private Sub PlayDate_Pcs_AfterUpdate() Me.Child143.Form.Amount_Sold.Value = [Total Pcs] End Sub So, LSDate works fine and the said values go where they...

Hello, I am trying to send data from one form to another to a certain field an afterupdate VBA, and it send it just fine. However the trouble is when field 2 has the same formula (though it's going to a new field in the said form) it goes to a new record, which is not what I need it to do. I...

The date field in form 1 need to also be the value of form 2 so, form one (date) sends the data over to form 2 (creating a new record)

It says: Run-time error '2465: Application-defined or object-defined error

I was using this code: Private Sub Delivery_Date_AfterUpdate() Me.InventrySub.Form.InV_Date.Value = [Delivery_Date] End Sub and it was working. now it isn't. Can't figure out why. This happened after I did a compact and repair.

I'm sorry I have no idea on what you said. I don't really know vba code at all, just fudging along. What I need is this. Fields 1 thru 4 say hold a value, this is then is multiplied by 5, field 5 multiplied by 25, and field 6 as is. These values are added then need to be put into field 7...

Hello, I currently creating a DB to sum fields and place them in a db field. Which is working kinda fine until.. Private Sub VIP_Pcs_AfterUpdate() Me.Total_Pcs.Value = Me.PcsTot Me.Tax_Amt.Value = Me.TaxSum Me.Bling_Total.Value = Me.BlgTot Me.Refresh End Sub I have 3 other afterupdate fields...

(Len), I always had the ability to show fees after choosing the product. I just need cbo2 to display a selected list depending on cbo 1 choice. Each cbo needs to do these two things, for example: Product Combo Box choices; letterheads; business cards; flyer... The cbo displays two columns...

Can access do this or shall i seek another db program?

that suggestion didn't work Each selection already displays column 2 the following textbox. I need the combo box to do two things. One: display selection in the cbo & display the fees in the following texbox and TWO: query the 2nd combo box

Thanks, I will give this a shot.

OrderID OrderID CustomerID CustomerID ProductName ProductID (Cbo) LayoutFee LayoutFee (priced determined by ProdID choice) PaperGrade PaperID (Cbo) $PerSheet $PerSheet (priced determined by PaperID choice) PaperColor Paper Color...