Intellisense is Driving Me Crazy Right Now - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Intellisense is Driving Me Crazy Right Now

Ryan deGuzman

9 months ago

So, i have a database where I am Using API to retrieve a URL Link to a prefilled form in MS Forms and another API to get a QR Code from tinyurl. In all the other places in my app, the code i wrote works. But somehow, in this form, it doesn't work. I've changed 1 field name, but now intellesense doesn't recognize the name change. I've decompiled, compacted, and repaired the database as well as rebooted my computer. The table shows the correct new name. The form shows the correct new name of the field. But in the VBA Editor, when i thype "me.w..." the field name is still showing the old name. Can someone help me get to the bottom of this?

	Ryan deGuzman OP @Reply 9 months ago

	Ryan deGuzman OP @Reply 9 months ago

	Ryan deGuzman OP @Reply 9 months ago

	Ryan deGuzman OP @Reply 9 months ago
its the field [WastePrefillURL] vs [WasteURLPrefill]...

Donald Blackwell @Reply

9 months ago

Quick Checklist:

You've changed the name everywhere, but, just to be safe, verify in the form that you changed the control name to match the new field name in the table. Even if you updated the Control Source to the new name, if it still has the old name on the "Other"/"All" tab for control name, it won't update the Intellisense.

Having gone through the Troubleshooter as you pretty much seemed to have, then the next thing I might try is doing a Ctrl-F in the VBA Editor window and search for the old name and make sure it is set to "All Modules". That way you'll make sure it didn't slip in somewhere else you've forgotten about.

If that doesn't do it, then I would back up the form (copy/paste it to something "Copy_of_Form") then create a new form and copy all the fields from the old form to the new form. Delete the old form (again making sure you have your backup copy) and save the new form as the old form's name.

If this doesn't fix it, let us know, and we can try to help you track it down further.

Don

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

Next Unseen

New Feature: Comment Live View