Editing Records In a Form

[Julie]

Greetings,

I have a database built, imported records from Excel, have a form to view
Records. I will need to be able to edit or add information to each record. I
can add information, but each time I add a document # to one record it adds
it to all reocrds that this area is blank. It will not overright the record
that has the information already there, but will populate all the ones that
are blank. I know a tad bit about Access, but not a bunch. Any information
would be great, and assume I don't know where to find the things you are
about to tell me.

Thank you

 

[Beetle]

You have provided almost no information about about the structure of
your application, such as what tables you have, their relationships and
how you set up your form, so it will be rather difficult for anyone to
offer you much in the way of advice.

 

[Julie]

I did provide information that I knew almost nothing about this whole process
so will try to fill in the gaps now, SORRY!

I imported the Excel spreadsheet and created queries and forms. I have a
control source of the query. As for Relationships, when I go to
Tools/Relationships it is showing two tables but no lines, ( I am going to go
out on a limb and assume that it means I have no relationships.) I will also
assume that this means I have a problem and that is why I can get the form to
work.

Structure? Do you want me to list all the tables and queries? Do I need to
go into detail as to what I want it to do? AND how much detail?

I feel so stupid. Like I stepped off into it and now am drowning.

 

[Julie]

Also, when i imported from Excel into Access, I allowed it to do it all
throught the wizards, so all the relationships are there, I just was not
seeing them. But that still did not fix it. so back to the questions of my
reply prior to this one

 

[Beetle]

OK. Didn't mean to get you worked up, just trying to point out that
we need more information. You will find a lot of help in this newsgroup,
but often times responses will be direct and to the point. This is not
meant to offend, it's just the nature of the newsgroup. "We" are just
a random collection of people from around the globe who volunteer their
time to answer questions. Now, on to your issues.

First, Access is quite different from Excel and does have a bit of a
steep learning curve. Since you are new to all of this, I would suggest taking
a look at a very good tutorial on the basics of Access by Crystal. You
can find it at this link;

http://allenbrowne.com/casu-22.html

It may very well help you determine where the problem lies. If not, then
by all means post back here. You don't necessarily need to post every
detail of every object in you db, but, for starters at least, we would need
to at least know something about the objects that are involved with your
current problem. For example, you said you are entering data in a form.

Is it a single form, or a main form with a subform?

If it is the latter, does the problem happen when you are entering data
in the main form or the subform?

Which tables hold the data in question?

If there is more than one table involved with this form/data, what is the
nature of the relationship between the two tables?

Even if no actual relationship has been established, how is the data
supposed to be related in the real world?

Is it a table of Clients and a table of their associated documents
(or something like that)?

This is the type of information "we" would need to know in order to
provide you more help.

 

[Julie]

Thank you, I will try the link, and then if that does not help, then I will
post back here, was not meaning to 'get worked up' just a bit frustrated. As
for the learning curve, you are correct. holy cow.

Thank you for everything.