Please Please Help - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Please Please Help

Rajashree Natarajan

4 months ago

My DB was working perfectly to what I wanted. Medicare deleted 6 CPT and add 12 of them this year. So I updated the CPT table. Added a new field Inactive (Yes/No) and now the form where i write the code which automatically generated the charge and unit does not work. Does it have to do with me adding a new field? My VBA keeps coming back as bad. Can someone look at it and lmk. I am beginner/intermediate at best

	Rajashree Natarajan OP @Reply 4 months ago

	Rajashree Natarajan OP @Reply 4 months ago

	Alex Hedley @Reply 4 months ago
Can you write the exact message in the popup? (It should help you identify the problem)

	John Davy @Reply 4 months ago
Hi Rajashree, Alex is correct. If you show us or tell us what the error message is, we might be more helpful. John

	Kevin Robertson @Reply 4 months ago
It's a Missing operator error. Most likely due to a Null value or an empty string. We need to see which line is highlighted when the Debug button is clicked.

	Alex Hedley @Reply 4 months ago
It's in the first picture, I'm just trying to run through the problem solving steps > Run-time error "3075: > Syntax error (missing operator) in query expression CPTCodeID=

	Sam Domino @Reply 4 months ago
"CPTCodeID" vs "CPTcodeID"? Is "Option Explicit" used in the code module?

	Kevin Robertson @Reply 4 months ago
Sam Visual Basic is not case sensitive.

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

Next Unseen

New Feature: Comment Live View