How To Update Access After Adding A New Field?

C

Chipcom

Hi

1. I need to know how to update the field list of the query after
adding a new field into the table and the query?
2. I need to know how to update the records table after adding
calculated filed?
 
L

Larry Daugherty

Hi Chipcom,

Chipcom, Inc. in Massachusetts was bought by 3Com many years ago...

Your questions don't really make sense as given.

HTH
 
C

Chipcom

Assuming you added a new filed to the table and then added the same
field to the query, what filed list are you talking about?


It is not generally considered a good idea to save a calculated field in
a table, rather you just let the query, report or form recompute it any time
it is needed. This will be faster and in the event the data on which the
computation is based changes the new result will be automatically changed.
Of course if you want the result of a calculation from a given point in
time, then you would want to save the result in the table. You would
usually use an update query to do that.
Click to expand...

Hi

1. When I want to add the field to the subform query I don't see the
new field in the field list?
2. Is there any simle way to update the table without update query?
 
T

Todos Menos [MSFT]

I strongly disagree.

of course it's a good idea to store calculated columns

SQL Server allows this-- you can even PERSIST the value and it's a lot
easier to do it this way than anything in the MDB world

I highly reccomend, if you like computed columns-- to look at Access
Data Projects



in design view of a table, add a column and set the formula for that
column
 
T

Todos Menos [MSFT]

a) good old fashioned copy and paste in a datasheet-- I'm disgusted
how often I do this in and out of databases
b) typing the new values by hand in a datasheet

I've done a LOT more data entry in my life then I'd like to admit


I used to have this nickname 'elbow grease aaron' because I washed
people's cars and I did a really good job.. I was like 8 years old I
think Lol

I apply the same principal to my keyboard-- just type if out the old
fashioned way LoL


btw; what don't you like about update queries?
you've jsut always got to be careful to have an appropiate where
clause

I use SQL Server.. and I usually start with a SQL Statement like this

select *
from employees
where managerid = 62

and then I change the sql statements to say this

update employees
set managerid = 64
where managerid = 62


and then if I _LIKE_ that sql statement? and I know i'm gonig to run
it again?

I just add two lines at the top of the statement

create procedure LarrysReportsToSusan
as
update employees
set managerid = 64
where managerid = 62


I just use Query Analyzer.. or SQL Server Management Studio.. these
are enterprise level tools for writing SQL Statements.

MS Access doesn't have the same capability, that is why I only use
Access Data Projects-- so that I can leverage enterprise-level tools


in Access, it would take about 100 steps to follow that same
methodology
 
L

Larry Linson

Once you add the field to the Table, you must open the Query in Design View,
and add that new Field to the Query. One of the reasons for Queries is to
allow you to choose which Fields you wish to retrieve, and simply adding a
Field to one of the Tables that is a data source does not necessarily imply
that it should be added to Queries for which the Table is a data source.

If you are asking whether there is some option that adding a Field to a
Table will also add it to each Query using that Table as a data source, the
answer is "No." Clairvoyance is not one of Access' features, even in the
latest version.

Larry Linson
Microsoft Access MVP
 
T

Tony Toews [MVP]

I strongly disagree.

of course it's a good idea to store calculated columns

SQL Server allows this-- you can even PERSIST the value and it's a lot
easier to do it this way than anything in the MDB world

I highly reccomend, if you like computed columns-- to look at Access
Data Projects



in design view of a table, add a column and set the formula for that
column
Click to expand...

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
L

Larry Linson

Tony Toews said:
Note that this person is really A a r o n K e m p f and that he is not
an employee
of Microsoft.
Click to expand...

Nor, apparently, has he ever learned the principles of relational database
design.

Larry
 
Top