66 minutes
ago: Doing some maintenance on the server today. If you've placed an order and it hasn't processed yet, hang in there. Should be ready soon. I've got the car up on the jack and the tires are off...
Dismiss
In D3 Richard showed that nowadays the form values can be used directly instead of using contagion which had to be used in the past. When I tried to use contagion to see how it worked I ran into problem with my date field and my notes fireld. I tried to get he correct syntax by using " #SaleDate# " but that didn't work either. I used: DoCmd.RunSQL "INSERT INTO CommissionT (EmployeeID, CommissionRate, SaleDate, SaleAmount, Commission, Notes) " & _ "Values (" & SalesRepCombo & "," & CommissionRate & " ," #SaleDate# "," & SaleAmount & "," & Commission & "," & Notes & ")"
This worked for all fields except for SaleDate and Notes. Suggestions are much appreciated.
Thanks Adam.
Now it works, won't forget that one easily which is exactly the idea of learning something
I mixed up & with " when looking at your last answer.
Also, I thought that with a date an & was not needed.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Forum.
