Recent content by purextc
-
P
Creating duplicate records with Form command - sql error
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... -
P
Sum of calulation in subform not working?
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! -
P
Creating duplicate records with Form command - sql error
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. -
P
Sum of calulation in subform not working?
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... -
P
Creating duplicate records with Form command - sql error
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...