Changing information

[Reen]

How do I make changes in access?

 

[Wayne-I-M]

You need to give more information about what you trying to do and what
version of access you have

 

[Klatuu]

Or wait for the next version to come out, Microsoft will have made the chages?

(sorry, one of those days)

 

[Klatuu]

And the other 99% will complain about the changes <]%^{}

 

[Reen]

I am trying to fix errors in spelling and changing certain headings that were
put in place by someone prior to myself.

And the other 99% will complain about the changes <]%^{}

--
Dave Hargis, Microsoft Access MVP

But the changes they'll have made will only be helpful to 1% of all develpers!
;0)>

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

 

[Klatuu]

Now we have something to go on. Here is a link to a utility that will allow
you to make global changes throghout your application.

http://www.rickworld.com/download.html

If that still doesn't answer your question, then you have not asked it yet.
The more specific the question, the more specific the answer.

--
Dave Hargis, Microsoft Access MVP

I am trying to fix errors in spelling and changing certain headings that were
put in place by someone prior to myself.

And the other 99% will complain about the changes <]%^{}

--
Dave Hargis, Microsoft Access MVP

But the changes they'll have made will only be helpful to 1% of all develpers!
;0)>

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

 

[Reen]

I don't mean to seem dense, but isn't there simply a way to edit data that is
already in a table for example: misspelled words, one address when I need a
field for an additional address?

Now we have something to go on. Here is a link to a utility that will allow
you to make global changes throghout your application.

http://www.rickworld.com/download.html

If that still doesn't answer your question, then you have not asked it yet.
The more specific the question, the more specific the answer.

--
Dave Hargis, Microsoft Access MVP

I am trying to fix errors in spelling and changing certain headings that were
put in place by someone prior to myself.

And the other 99% will complain about the changes <]%^{}

--
Dave Hargis, Microsoft Access MVP


:

But the changes they'll have made will only be helpful to 1% of all develpers!
;0)>

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

 

[Klatuu]

Well, Reen, you haven't yet asked a full question.

How do I make changes in access?

Is very vague. It could be, modify VBA code, make changes to a query, add or
remove controls on a form, change the caption in a list box, modify
relationships between tables, change the actions in a macro, add or remove a
field from a table, make a change to a table's indexes, modify the data type
of a table, etc, etc,

The point is, we need to know what you are trying to accomplish.

If what you are asking is how to change the data in a table, that also
depends on your application. Do you have forms to use for entering, editing,
and deletitng data or do you need to just open a table, find a record, and
modify the data in a field, or do you need to make some bulk changes?

Please try again and be specific about What you want to do. Once we
understand the What, we can help with the How.

--
Dave Hargis, Microsoft Access MVP

I don't mean to seem dense, but isn't there simply a way to edit data that is
already in a table for example: misspelled words, one address when I need a
field for an additional address?

Now we have something to go on. Here is a link to a utility that will allow
you to make global changes throghout your application.

http://www.rickworld.com/download.html

If that still doesn't answer your question, then you have not asked it yet.
The more specific the question, the more specific the answer.

--
Dave Hargis, Microsoft Access MVP

I am trying to fix errors in spelling and changing certain headings that were
put in place by someone prior to myself.

:

And the other 99% will complain about the changes <]%^{}

--
Dave Hargis, Microsoft Access MVP


:

But the changes they'll have made will only be helpful to 1% of all develpers!
;0)>

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

 

[Reen]

Okay, here goes: I am entering all the homeowners in a town, the access
table I downloaded has headings such as Name, street address, owner's
address, etc and some of the properties have more than one owner and to make
it clearer I would like two more "owner address" fields, how do I accomplish
that? Also there are typos in some headings, how do I correct that? Thanks
for your patience.

Well, Reen, you haven't yet asked a full question.

How do I make changes in access?

Is very vague. It could be, modify VBA code, make changes to a query, add or
remove controls on a form, change the caption in a list box, modify
relationships between tables, change the actions in a macro, add or remove a
field from a table, make a change to a table's indexes, modify the data type
of a table, etc, etc,

The point is, we need to know what you are trying to accomplish.

If what you are asking is how to change the data in a table, that also
depends on your application. Do you have forms to use for entering, editing,
and deletitng data or do you need to just open a table, find a record, and
modify the data in a field, or do you need to make some bulk changes?

Please try again and be specific about What you want to do. Once we
understand the What, we can help with the How.

--
Dave Hargis, Microsoft Access MVP

I don't mean to seem dense, but isn't there simply a way to edit data that is
already in a table for example: misspelled words, one address when I need a
field for an additional address?

Now we have something to go on. Here is a link to a utility that will allow
you to make global changes throghout your application.

http://www.rickworld.com/download.html

If that still doesn't answer your question, then you have not asked it yet.
The more specific the question, the more specific the answer.

--
Dave Hargis, Microsoft Access MVP


:

I am trying to fix errors in spelling and changing certain headings that were
put in place by someone prior to myself.

:

And the other 99% will complain about the changes <]%^{}

--
Dave Hargis, Microsoft Access MVP


:

But the changes they'll have made will only be helpful to 1% of all develpers!
;0)>

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

 

[Klatuu]

Okay, so what you want to do is modify the table itself.
First, be sure you make a backup copy of your mdb.
Open the table in Design View and you will see a list of all the fields and
the names of the fields. I think this is what you are calling headings.

Now you can make changes to the names of the fields in design view. If you
need to add additional fields, you can do that by just typing in a new field
name in the list and identifying the data type of the field.

There are a couple of things I should warn you about. If this database has
forms and queries and other objects in it, then when you change the name of a
field, you will break the application. That is, the objects that were
referencing the old name will not be able to find it. You will have to
change the name there as well.

Now, the link to the Add In I posted earlier is great at doing that. I use
it all the time. You can identify the value you want to change and it will
find all occurances of the value in all your database objects, and allow you
to change them.

When it comes to naming in Access. Be careful about the names you use.
They should never be any Access reserved words like Date, Name, Month, Year,
etc. It can cause problems if you do. I also stay away from using anything
other than letters, numbers, and the underscore character. If you have
spaces or use any other special characters like #, $, etc. you will always
have to enclose the name in brackets so Access understands that it is an
name. ! & * + # and others for example all have meaning in Access.

One other point. You say you want to allow form multiple owners for a
property. To add another owner name field to the table would be incorrect.
It violate the repeating data rule for database normalizatin. Today you may
have two owners, but someday, you may have six. The curret design is to
remove all the fields from the property table that related to the owner, and
build a new Owner table with all the information about owners. You also will
need a Property/Owner junction table that will identify the owners of a
property and it will also tell you which properties each owner has an interes
it. That junction table only needs the primary key field on the property
table as a foreign key value and the primary key field of the onwer table as
a foreigh key value for the property.
Assume your property table has a primary key field called PropID and the
Owner table has a primary key field called OwnerID.

tblPropOwner
PropID - foreign key to Property table
OwnID - foreigh key to Owner table


--
Dave Hargis, Microsoft Access MVP

Okay, here goes: I am entering all the homeowners in a town, the access
table I downloaded has headings such as Name, street address, owner's
address, etc and some of the properties have more than one owner and to make
it clearer I would like two more "owner address" fields, how do I accomplish
that? Also there are typos in some headings, how do I correct that? Thanks
for your patience.

Well, Reen, you haven't yet asked a full question.

How do I make changes in access?

Is very vague. It could be, modify VBA code, make changes to a query, add or
remove controls on a form, change the caption in a list box, modify
relationships between tables, change the actions in a macro, add or remove a
field from a table, make a change to a table's indexes, modify the data type
of a table, etc, etc,

The point is, we need to know what you are trying to accomplish.

If what you are asking is how to change the data in a table, that also
depends on your application. Do you have forms to use for entering, editing,
and deletitng data or do you need to just open a table, find a record, and
modify the data in a field, or do you need to make some bulk changes?

Please try again and be specific about What you want to do. Once we
understand the What, we can help with the How.

--
Dave Hargis, Microsoft Access MVP

I don't mean to seem dense, but isn't there simply a way to edit data that is
already in a table for example: misspelled words, one address when I need a
field for an additional address?

:

Now we have something to go on. Here is a link to a utility that will allow
you to make global changes throghout your application.

http://www.rickworld.com/download.html

If that still doesn't answer your question, then you have not asked it yet.
The more specific the question, the more specific the answer.

--
Dave Hargis, Microsoft Access MVP


:

I am trying to fix errors in spelling and changing certain headings that were
put in place by someone prior to myself.

:

And the other 99% will complain about the changes <]%^{}

--
Dave Hargis, Microsoft Access MVP


:

But the changes they'll have made will only be helpful to 1% of all develpers!
;0)>

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com