Search results

Figured it out. I needed to add single quotes around my key values: SELECT '" & lngID & "' As NewID, Pattern, Ppod, Date, Qinj_m3d, Cppm, Bags_Week " & _ "FROM [RE_Forecast_Inj] WHERE Key = '" & Me.Key & "';" However now I can't get my date to insert any idea on that one? The column is set...

I just get the #error however if I substitute a value ie: 750 it works fine. =Sum([Cppm]/1000000*[Qinj_m3d]*1000/750*7) Please let me know if I can supply any additional information that would help. I'm new to access programming and also new to the forum. Thanks!

Hi There, Thanks so much for responding this is driving me crazy and putting me behind schedule. However you copied the code I had exactly I think you meant to modify it? Thanks, S.

Hi There, I have a field in my subform that I'm calculating using a value from the main form [RE_Forecast_PPod]: =[Cppm]/1000000*[Qinj_m3d]*1000/Forms!RE_Forecast_PPod!Bag_size_kg*7 This is working correctly. What I then tried to do was create a Sum of this field in the footer of the...

Hi There, I have some experience with sql, but limited experience with access. I am trying to create duplicate parent and child records using a form. I have added the following VB code and I keep getting a syntax erro in insert into statement. I'm hoping (praying) it's something simple that I...