How do I update input mask across tables

[Guest]

I am in dire need of some help. I am taking a class on database management,
and the book is for 2003, but I am using 2000. My question is this, I did
an input mask for a phone number for a table that had already had information
in it. Now I want to make sure the phone number in the table and any other
subsequent tables change to that phone number form. The book keeps telling
me there is a Property Update options button to the left of the Input Mask
property. Am I blind? I cannot find it. Can anyone help me figure out
how to do this?

 

[fredg]

I am in dire need of some help. I am taking a class on database management,
and the book is for 2003, but I am using 2000. My question is this, I did
an input mask for a phone number for a table that had already had information
in it. Now I want to make sure the phone number in the table and any other
subsequent tables change to that phone number form. The book keeps telling
me there is a Property Update options button to the left of the Input Mask
property. Am I blind? I cannot find it. Can anyone help me figure out
how to do this?

Did you set the new mask to be saved with the data?

If you have existing data in your field, and have a new input mask,
you will need to run an UPDATE QUERY to change existing data to match
the new data. You haven't stated what your new mask is, nor what your
existing data looks like.

Is it in US format?
Assuming you wish to change your data to a (xxx) xxx-xxxx format, you
can use:
"Update YourTable Set YourTable.[PhoneField] =
Format([PhoneField],"(@@@) @@@-@@@@");"

 

[Shirley]

My assignment was to take table in an existing database and put in input mask
in the phone field. I did that and saved the table. Then it said we were
to update everywhere that Phone was used. It said to Click the Property
Update Options button, and than click update input mask. It said that the
Property Updates button appears on the left of the Input Mask property.
This is a 2003 book, but many of us are using 2000. I can not find the said
button.

I am in dire need of some help. I am taking a class on database management,
and the book is for 2003, but I am using 2000. My question is this, I did

[quoted text clipped - 4 lines]

property. Am I blind? I cannot find it. Can anyone help me figure out
how to do this?

Did you set the new mask to be saved with the data?

If you have existing data in your field, and have a new input mask,
you will need to run an UPDATE QUERY to change existing data to match
the new data. You haven't stated what your new mask is, nor what your
existing data looks like.

Is it in US format?
Assuming you wish to change your data to a (xxx) xxx-xxxx format, you
can use:
"Update YourTable Set YourTable.[PhoneField] =
Format([PhoneField],"(@@@) @@@-@@@@");"

 

[fredg]

My assignment was to take table in an existing database and put in input mask
in the phone field. I did that and saved the table. Then it said we were
to update everywhere that Phone was used. It said to Click the Property
Update Options button, and than click update input mask. It said that the
Property Updates button appears on the left of the Input Mask property.
This is a 2003 book, but many of us are using 2000. I can not find the said
button.

I am in dire need of some help. I am taking a class on database management,
and the book is for 2003, but I am using 2000. My question is this, I did

[quoted text clipped - 4 lines]

property. Am I blind? I cannot find it. Can anyone help me figure out
how to do this?

Did you set the new mask to be saved with the data?

If you have existing data in your field, and have a new input mask,
you will need to run an UPDATE QUERY to change existing data to match
the new data. You haven't stated what your new mask is, nor what your
existing data looks like.

Is it in US format?
Assuming you wish to change your data to a (xxx) xxx-xxxx format, you
can use:
"Update YourTable Set YourTable.[PhoneField] =
Format([PhoneField],"(@@@) @@@-@@@@");"

1) I think your book is mistaken, or else you have miss-interpreted
what the book says.
In Access 2003, as well as earlier versions, after you click on the
Input Mask property line, there is a little button with 3 dots that
appears on that line .... on the *** RIGHT ***.
If you click on that button it will take you to the Mask wizard
dialog, which will help you change the Mask, but it does nothing to
any existing data already stored in your table.

2) If you have already changed the table field mask, all you need do
is copy and paste it onto your form control.

3) Since this is a homework assignment, perhaps the proper place to
get clarification and help is from your instructor.

 

[Guest]

That feature is not in Access 2000. You really should get a copy of Access
2003 if you are taking a class in it. I teach A03 at the local community
college and have students like you who try to do the work in the wrong
version of Access. They can do about 80% of the work, but then run into
problems like you did.

Since you are a student, you may be able to buy Office 2003 Professional for
as low as $180. Here's just one place to do so:

http://www.academicsuperstore.com/