I had added a new field to a form, and try insert the data to the new
created table field. But when i try to assign the a control source for that
form field, in the control source drop down list it doesn't show the new
field from that table.
Got any solution to solve this problem?
4  1543 
I had this same issue earlier tonight. The problem is that it seems access
takes a "snapshot" of your table when it opens. The only solution I found
was to exit access, and get right back in. At that point, my newly added
field(s) were there.
"-" <le******@yahoo .com.sg> wrote in message
news:43******** **@news.tm.net. my... I had added a new field to a form, and try insert the data to the new
created table field. But when i try to assign the a control source for
that form field, in the control source drop down list it doesn't show the new
field from that table.
Got any solution to solve this problem?
Save any changes you have made to the form.
Close it.
After adding the new field to your table, saving the change, and closing the
table, open the form again in design view, and you should see the new field
appear in the field list now.
If it still does not appear, make sure the Name AutoCorrect boxes are
unchecked under:
Tools | Options | General
and then compact the database.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"-" <le******@yahoo .com.sg> wrote in message
news:43******** **@news.tm.net. my... I had added a new field to a form, and try insert the data to the new
created table field. But when i try to assign the a control source for that
form field, in the control source drop down list it doesn't show the new
field from that table.
Got any solution to solve this problem?
What happens if you simply close the form and reopen it?
I usually just type in the control source for my fields if they don't
show up in the Field List or in the Control Source drop-down. You know
it exists, it's just not visible.
On Tue, 27 Dec 2005 15:59:48 +0800, "-" <le******@yahoo .com.sg> wrote: I had added a new field to a form, and try insert the data to the new
created table field. But when i try to assign the a control source for that
form field, in the control source drop down list it doesn't show the new
field from that table.
Got any solution to solve this problem?
I have found that going to SQL view of the form's recordsource, highlighting all text (Ctrl A), cutting all text (Ctrl
X) and immediately pasting the text back (Ctrl V) will force the structure to be re-evaluated and the new fields will
show up.
Wayne Gillespie
Gosford NSW Australia This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Damaji Jambhale |
last post by:
COMException: Catostrphic failure
When I added a "dll" reference in the web project.
I was able to instantiate the class OK. But when I tried
to set the properties, it failed with
"COMException: Catostrphic failure".
Any idea?
Thanks.
|
by: August1 |
last post by:
i'm having difficulties with the execution of a program, i believe due
to something i am missing in the copy constructor implementation. When
i create one object of the class and run the program with that object
alone, there are no problems. however, when subsequently using the
copy constructor for a second object and/or a third object created on
the heap memory - i run into an execution problem and assert failure
dialog box (ignore,...
|
by: Douglas Buchanan |
last post by:
I set the OnExit property of the "Cost" field in subform
"subJobDetail" to save the record (see below). Then I call a global
sub to copy the )] calculated field to a field in the
subform "subJob". The record in "subJob" displays the "writing"
(pencil) icon for the record but does not update visually until I
enter and exit a second field "Markup" that is identically coded.
How do I write code to save the record in the subform "subJob"
...
|
by: Paul H |
last post by:
Say I have a table called tblPeopleInfo, one of the fields in the table is
called FavouriteFruit. The FavouriteFruit field is a lookup field and will
contain Apples, Oranges, Grapes etc..The list can be added to by users of
the database. What is the best way to construct this lookup?
Should it lookup a Table/Query or a Value List?
If it looks up to a Table/Query should the lookup table just have a single
"text" field or should it have...
|
by: dale zhang |
last post by:
Hi,
I am writing a subscription page in C#. I first check if username is unique by
"SELECT UserName FROM Logins WHERE Username ='dadada'"
Then if unique, I create the user by
"INSERT INTO Logins
(UserName,UserType,Password,StartDate,Status,Email,Phone,Home) VALUES
| | |
by: Frav |
last post by:
The Reps team have been experiencing that Access 2002 unexpectedly
quits
while working and also lots of Corruption Failures and "Record lock
can not
update" messages since the upgrade from Windows 2000 and Access 200 to
Windows XP and Access 2002 (XP) was done.
Now, they are working and at anytime in anywhere of the application
access
unexpectedly quits with no error messages and the info that was being
entered
|
by: maxthebaz |
last post by:
Our machines have this requirement: if power failure occurs, many
important variables are to be resumed from where they were interrupted
after the machine is restarted (power on in this case). In other words,
the basic idea is to keep a snapshot of the state machine before it is
interrupted.
The board is provided with:
- a 32-bit H8S/2633 Hitachi microprocessor;
- a battery-backed memory (BBM), where these variables are stored; BBM
area...
|
by: =?Utf-8?B?SmFzb25NYQ==?= |
last post by:
All,
I've been trying to wrap my head around this for quite sometime and it
seems to be a growing issue. Below is the problem and my troubleshooting thus
far:
Outlook 2k3 Server w/ Outlook 2k3 Clients w/ Office SP2 installed
Two people, UserA and UserB, are trying to setup an appointment within
Outlook 2k3. UserA sends UserB a meeting invitation and immediately gets a
|
by: MLH |
last post by:
Anyone remember if A97 append query failure would ever report
data breaking validation rule when such was not the case. I have
an old SQL statement - several years old now. I've encountered
a case in which the append fails and the reported error is validation
rule.
The table being appended to (tblClusters) has only 1 field with a
validation rule: , with Byte Field Size property
setting. The validation rule is >0. The field's default...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
