Transfer Money From Account 1 to Account 2 - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Transfer Money From Account 1 to Account 2

Werner Mildt

9 months ago

I have 6 fields to consider for this process.
If I use the 3, Id, ChkDate and Amount fields there is no problem.
When using the additional 3 fields I am getting the ERROR message (Missing Operator).
PayComboFrom, DescFrom and TagFrom.
The data displays correctly from Debit and Credit in Code.
What am I Missing?????
Werner
Thanks

	Werner Mildt OP @Reply 9 months ago

	Kevin Robertson @Reply 9 months ago
NZ Function

	Werner Mildt OP @Reply 9 months ago
Thanks Kevin, but how do i implement the NZ Function in the above Code? Is it possible to help me with it? I am trying to learn as much as I can to get this working. I appreciate any help you can give me. Thanks Werner

	Werner Mildt OP @Reply 9 months ago
I have not been able to figure this out. is there any chance to get help, please?

	Werner Mildt OP @Reply 9 months ago

	Sami Shamma @Reply 9 months ago
Werner Do the following: dim SQL as string, put the sql statement in this variable. Them Msgbox it before you execute it with: "currentdb.execute SQL" If at this point you still can't figure out what you are doing wrong, please show us the message you get when you do the messagebox.

	Donald Blackwell @Reply 9 months ago
I believe you need Double Double Quotes around DescFrom, TagFrom, DescTo, and TagTo in your statements.

	Werner Mildt OP @Reply 9 months ago
Hi Donald, I tried it with this on to line, getting a compile error. Maybe the double quotes are incorrect. "(" & CreditCombo & ", #" & Date & "#, " & Amount & ", " & PayComboFrom & ", " & "PFrom"" & ", " & "DescFrom"" & ", " & "TagFrom"" & ", " & ")"

	Kevin Robertson @Reply 9 months ago
I am assuming PayComboFrom (or PayFromCombo) has an ID in the first column (hidden) and the text that goes into PayeeName is in the second column. `"(" & CreditCombo & ", #" & Date & "#, " & Amount & ", """ & PayComboFrom.Column(1) & """, """ & PFrom & """, """ & DescFrom & """, """ & TagFrom & """)"`

	Werner Mildt OP @Reply 9 months ago
Thanks' Kevin, I really appreciate your input. I see I have made some big mistakes. I Just did not know how to do the double double Quotes. The code worked perfect for creditcombo and debitCombo. Also, thanks to Donald for your input. I got it finally working, what a relief. Thank You again, Werner Mildt

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View