Creating a field

[Guest]

Very new to Access. Forgive me for incorrect terminology. Working as a
volunteer in a clinic setting and a software package is provided that uses
Access to track and compile bloodwork results for patients.

On the screen where you enter their "numbers" (Cholesterol, HDL, etc.) there
is a text box and the field for the numberic entry. I need to add 2 new
fields. I used copy and paste.

Inside the field, in design view I see that my numeric entry has a field
name(Weight is "Wt1"). When I created the new fields, I simply typed what I
wanted as a field name (Insulin is "Ins1"). But that must not be the correct
way to do it because when I save it and get out of design view #NAME? appears
on the data entry form and it will not let me make a numeric entry.

Do I need to create a usuable field name elsewhere?

Any help would be most appreciated. I'm working with a tight deadline.

D. Reinwald

 

[Guest]

Did you create the field in the table before adding it to the form?

 

[Guest]

Thanks Dave. No. I'm doing a little reading through other posts. Must I
add both? (Insulin from the text box and Ins1 in the data entry box).

It appears that there is a button which allows you to see the list of the
many tables. As I look at them, how do I decipher which table I need to make
the addition to? I should be able to recognize it since I will see all of
the other "controls" (right word?) that were originally set-up and viewable

 

[Guest]

Are you still there Dave? "qryresults" is the name of the query that seems
to associated with this sub-form and the field I'm trying to create but I
want to make an insertion into a table - correct?

Thanks!

 

[Guest]

"tblresults" is the name of the table that I need to modify to add my fields.
I opened it in design view and inserted the rows, modified the tabs
underneath but the changes will not save. What am I doing wrong?

Thanks!

 

[gls858]

Are you still there Dave? "qryresults" is the name of the query that seems
to associated with this sub-form and the field I'm trying to create but I
want to make an insertion into a table - correct?

Thanks!

I'm not Dave, but this may help.
Yes you need a field in a table to store the data.
Open the query in design view. You should be able to find the source
of the information there.

gls858

 

[Guest]

Sorry, I was away at work. What did the error say when you tried to save
the table?

 

[Guest]

I think it won't let me save the changes to the table beacuse it is "linked".
Does that sound right. Thanks for your time!

 

[gls858]

I think it won't let me save the changes to the table beacuse it is "linked".
Does that sound right. Thanks for your time!

If it's a linked table will have a small arrow just to the left of the
table name. If you click on tools > Database Utilities > Linked table
Manager you should see the location of the linked table. Add your field
to the table in that database.

gls858

 

[Guest]

Correct. You can not change the design of a linked table. You will have to
open the database the linked table is in and change the design there.

 

[Guest]

I followed gls858's instructions. Thanks to both of you for your help by the
way. Tools/Database Manager/Linked Tables brings up a list of tables. If I
choose the one I want to edit it just gives me a message about "refreshing"
the table. How can I access the foundational database that I need to edit to
create this new field?

Thanks!

 

[Guest]

Okay today's my day to learn Access. I think I know what you mean now about
using the utility to locate the database even though I can't accomplish my
task through that window. I know the location. There is only one database
for all of the tables. The software is such that if you open the database
via File/Open, etc. it runs all of the forms and the buttons etc. If you use
the icon at the top a window opens for the database with all the many tables
in the window but it doesn't seem that you can "use" or edit the database
from there. I'm sorry I'm such a rookie. This thing is suppose to be user
friendly unless of course you want to customize it. Any ideas on how I can
edit the root database to add my 2 fields?

Thanks!!

 

[John Spencer]

You are going to have to find the database that your application is linked
to. Try this.

When you are in the design mode, note the name of one of the linked tables
-- Type Control+G
-- In the window that appears, there should be one labelled "Immediate"
-- Type the following
?CurrentDb().TableDef("TheNameofYourTable").Connect
-- Press return
At this point you should see a pathname to the database containing the
linked tables.

CLOSE the application and don't return to this VBA window until you get some
training. If asked DO NOT save any changes.

Now that you know where the tables are you can open that database and change
that table.
RULE ONE: Make a backup of the database first.
RULE TWO: See Rule one.

 

[gls858]

I followed gls858's instructions. Thanks to both of you for your help by the
way. Tools/Database Manager/Linked Tables brings up a list of tables. If I
choose the one I want to edit it just gives me a message about "refreshing"
the table. How can I access the foundational database that I need to edit to
create this new field?

Thanks!

The linked table manager will only give you the path to the file. You won't
be able to access it from the manager. The path should look like this:
\\servername\directoryname\databasename.mdb You will need to go to Access
select File > open and navigate to that location and open the database.

gls858