472,345 Members | 1,523 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,345 software developers and data experts.

Form update on Table property change ?

I am working with MS Office Access 2003 11.5614 on a computer running
XP. If I change a property such as the input mask in a table, to have
the change reflected in an existing form I have to go to the form
design, delete the field and re-insert it into the form to exhibit the
change in the property. Is there a command I can use to cause the
forms to refresh their conditions from the table ?

Thank you for your reply,

Stan Hanna

Dec 12 '06 #1
4 3007
On 11 Dec 2006 17:31:06 -0800, "Stan" <st*******@hotmail.comwrote:

That's by design. Therefore spend enough time on your table design
BEFORE you create your forms.

-Tom.
>I am working with MS Office Access 2003 11.5614 on a computer running
XP. If I change a property such as the input mask in a table, to have
the change reflected in an existing form I have to go to the form
design, delete the field and re-insert it into the form to exhibit the
change in the property. Is there a command I can use to cause the
forms to refresh their conditions from the table ?

Thank you for your reply,

Stan Hanna
Dec 12 '06 #2
"Stan" <st*******@hotmail.comwrote in message
<11*********************@79g2000cws.googlegroups.c om>:
I am working with MS Office Access 2003 11.5614 on a computer
running XP. If I change a property such as the input mask in a
table, to have the change reflected in an existing form I have to go
to the form design, delete the field and re-insert it into the form
to exhibit the change in the property. Is there a command I can use
to cause the forms to refresh their conditions from the table ?

Thank you for your reply,

Stan Hanna
When you change properties in the 2003 version, you should get a
smart flag you can click (some thingie with a "lightening" on it),
where you are asked whether you want to propagate the changes
everywhere the field is used. Whether it works or not, I wouldn't
know.

--
Roy-Vidar
Dec 12 '06 #3
RoyVidar <ro*************@yahoo.nowrote in
news:mn***********************@yahoo.no:
"Stan" <st*******@hotmail.comwrote in message
<11*********************@79g2000cws.googlegroups.c om>:
>I am working with MS Office Access 2003 11.5614 on a
computer running XP. If I change a property such as the
input mask in a table, to have the change reflected in an
existing form I have to go to the form design, delete the
field and re-insert it into the form to exhibit the change in
the property. Is there a command I can use to cause the
forms to refresh their conditions from the table ?

Thank you for your reply,

Stan Hanna

When you change properties in the 2003 version, you should get
a smart flag you can click (some thingie with a "lightening"
on it), where you are asked whether you want to propagate the
changes everywhere the field is used. Whether it works or not,
I wouldn't know.
It's not called AutoCorrupt(tm) for nothing.
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Dec 12 '06 #4
Thanks Roy. I tried your thingie and it worked great.
Stan Hanna

RoyVidar wrote:
"Stan" <st*******@hotmail.comwrote in message
<11*********************@79g2000cws.googlegroups.c om>:
I am working with MS Office Access 2003 11.5614 on a computer
running XP. If I change a property such as the input mask in a
table, to have the change reflected in an existing form I have to go
to the form design, delete the field and re-insert it into the form
to exhibit the change in the property. Is there a command I can use
to cause the forms to refresh their conditions from the table ?

Thank you for your reply,

Stan Hanna

When you change properties in the 2003 version, you should get a
smart flag you can click (some thingie with a "lightening" on it),
where you are asked whether you want to propagate the changes
everywhere the field is used. Whether it works or not, I wouldn't
know.

--
Roy-Vidar
Dec 13 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Keith | last post by:
Hi I'm having a great deal of difficulty doing a very simple thing. This is what I want to do. On a Windows Form - NO DATAGRID.... I have various...
25
by: Lyn | last post by:
Hi, I am working on a genealogy form. The only table (so far) lists everybody in the family, one record per person. Each record has an autonum...
14
by: Abhi | last post by:
FYI: This message is for the benefit of MS Access Community. I found that this prblem has been encounterd by many but there is hardly any place...
3
by: Frankie | last post by:
Hi, I am working on a form in which in a certain field a number of an employee can be entered. After entering this number I would like to show in...
4
by: Dave Boyd | last post by:
Hi, I have two very similar forms each with a subform. The main form gets a few fields from the user and passes this back to a query that the...
2
by: genojoe | last post by:
Using ADOX to update a Property does not work. I want to change the Access database for a linked table. My abridged code is: Dim oCAT As...
8
by: fonzie | last post by:
Is it possible to have a data entry form where the information is stored in several different tables (5 or 6)? I have an inventory database where...
2
by: ssmith147 | last post by:
Hi, I'm somewhat familiar with access and vb programming (I can read someone else's code, for the most part), but I'm still very green when it...
6
by: Volker Neurath | last post by:
Hi all, I have a Problem with combobox-property "NotInList" and an unbound Form. The situation: On my main form i have three comboboxes for...
0
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
0
better678
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
0
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
0
Oralloy
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.