Re: How to convert records in expression fields in Forms to a tabl

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

The users are still able to add or modify records. If I open the form, it
does show the current record that was being modified and I can add new
record. But if I open the design (by exporting out this database to a
working one), there is no "Customers" table as it referred to! I am really
puzzled!

"bcap" wrote:

It certainly sounds like your Customers table is missing. You said earlier
that "the data is there". What exactly did you mean by that? What data
were you referring to, and how do you know it is "there"?

"tan" <encisc@xxxxxxxxxxx> wrote in message
news:A7367823-407C-4B45-AFFF-17916F716582@xxxxxxxxxxxxxxxx
1. I did make sure the hidden objects are shown. A query called
"Customer
Query": in Design View, there is a "Customers" table without field names
inside the table box; whereas 2 field names are displayed under the table
view: Expr1: customers.customers.ID and customers.customers.company.

When I double click the Query, the Access gave an error: "The MS Jet DB
engine can't find input table or query "Customers". Make sure it exists
and
name spelled correctly!"

I've noticed, when user used "Find" to find a customer name, the system
responded "can't find such name" but it is in the list! This problem
happened to another form and query.

2. I'd probably separate this question to another discussion! I was
trying
to add fields to an existing table, not the above table.

Your questions and suggestions are extremely helpful because I'd have
opportunity to review the database again and again to understand more
about
this database. Thank you very much for all of your insights.



"bcap" wrote:

1. It's probably a query. Click on "Queries" in the database window, and
see if there's one named "Customers". If so, open it in design view to
see
what table(s) the data is coming from. It *might* be a hidden table - on
the menu bar, click Tools-Options-View and tick the "Hidden Objects"
check
box.

2. You will certainly have problems adding fields to a table if you can't
find the table! Or, if you are talking about another table, in what
sense
can you not add fields to it? What happens when you try?


"tan" <encisc@xxxxxxxxxxx> wrote in message
news:0E2605B1-9ED2-4888-B198-0E4E5C413801@xxxxxxxxxxxxxxxx
Thanks for the quick responses.
1. A non existing table name specified (called Customers") to the
recordsource of the Form. I can't seem to find it anywhere in the
database
but the data is there! It couldn't be hidden, could it?

2. Adding more fields in the existing table is another problem. I
can't
seem to be able to do so to the current database even though with an
identical copy to avoid interruption of user's operations. Could you
assist
me in the process? Could I use split table method?

"bcap" wrote:

1. For a bound control, the ControlSource property *always* refers to
the
field. To discover which table the form is bound to, you need to look
at
the RecordSource property of the form (with the form open in design
view,
note that there is a square within a square at the extreme top left of
the
window; double-click this to see the form's properties).

2. In the database window, click "Tables". Find the table to which
you
want
to add fields, right-click it, and choose "Design View".

"tan" <encisc@xxxxxxxxxxx> wrote in message
news:82CDA34F-F241-4183-9D0D-E8B12D7FE6A8@xxxxxxxxxxxxxxxx
I inherit an old simple database written in Access 2000 with many
forms
and
queries that contain either "expression fields" or refer to a non
existing
table names. I have few questions:
1. There is a form "ADD/EDIT customer list" where users enter
customer
inmformation such as company name, address, phone. In the Design
view,
the
properties of these fields showed the ControlSource to itself!
Where
are
these records saved to because there was no table referred to?
2. How can I add more fields into an existing tables?

Thank you,
TAN









.

Relevant Pages

  • RE: Store Added Value List Items
    ... You could even union that query with the actual list from the form ... Each user in this database needs to have access to all the same customers. ... is praticle to create a seperate one field table to store values for a lookup ...
    (microsoft.public.access.formscoding)
  • RE: Design suggestions
    ... database design and the more discussion and debate on such issues the better. ... As regards changes in the Customers table then it really depends on what the ... I'd advise against storing the 'historic' invoices externally; ...
    (microsoft.public.access.gettingstarted)
  • RE: Creating a query with dynamic fields
    ... As for the table design, you're probably right, but I'm working on this ... database for a colleague, and I believe that the table needs to be in this ... filter records such that only those records with a value greater than a ... query can vary depending on the value of a control on a form? ...
    (microsoft.public.access.queries)
  • Re: Key Violations in Append Queries
    ... I even added a test field and that does not append. ... returns with the other 3 records and cant be removed from the query results. ... the design of the database requires uniqueness for the key involved. ... Whoever designed the database supposedly felt this was necessary. ...
    (microsoft.public.access.queries)
  • Re: Query Design View is Slow to Open
    ... My benchmark query takes about 20 minutes to open in design view. ... Each subsequent time, the query opens ... In the same database, there are many queries that open normally in ...
    (comp.databases.ms-access)