Categories:
Administration (161)
Adware Spyware (43)
Apache (20)
Bluetooth (127)
DOS Commands (2)
Edge (28)
General (5)
Internet Connection (21)
Internet Explorer (224)
Media Center (14)
Media Player (135)
Mozilla Firefox (22)
MS Access (9)
Performance (204)
PHP (25)
Programming (36)
Security (109)
Silverlight (22)
Tips (144)
Tools (312)
Tutorials (40)
Windows 10 (193)
Windows 7 (1411)
Windows 8 (1712)
Windows Phone (33)
Windows Server 2008 (165)
Windows Server 2012 (84)
Windows Server 2016 (23)
Windows Vista (71)
Windows XP (23)
Collections:
Other Resources:
Getting #Name? In a Form Field
Why am I getting “#Name?” in a form field?
✍: FYIcenter.com
If you open a form and see “#Name?” in a form field, it means that the Control Source of this field is linked to a non-existing column on the underlying table. The main reason is that you probably modified the underlying table structure by renaming or deleting columns. This tutorial shows what happens to the form if a column is renamed in the underlying table.
0. Continue from the previous tutorial to create the tabular form.
1. Click "Tables" in the Objects list. Then double click the “Account” table to open it. Click the design icon in the icon bar. The design window shows up.
2. Right click the “remark” column and select “Cut” command to delete the column. Save the change and close the design window.
3. Click “Forms” in the Objects list. Double click the “Account List” form. The form window shows up with “#Name?” displayed in the “remark” field.
4. Right click on the “remark” field and select the “Properties” command. The properties dialog box shows up. Click the “Data” tab. You will see the value of the “Control Source” setting is “remark” as shown in the picture:
To fix the “#Name?” issue, you need to add the column “remark” back to the “Account” table.
2010-04-10, 7627👍, 0💬
Popular Posts:
How to remove DVDLauncher.exe from the startup application list to gain performance and reduce secur...
Can I remove startup application "shstat.exe - VirusScan On-access scanner statistics" to speedup my...
How do I move the licenses for the tracks that I ripped from CDs to my new computer? Typically, lice...
How to uninstall Yahoo! Install Manager? If you want to remove Yahoo! Install Manager from your syst...
Can I remove startup application "shstat.exe - VirusScan On-access scanner statistics" to speedup my...