Query based form errors

25 Feb 2005 3:37 PM

Michelle

I've created a form based on a query which has 4 tables that are all related.
The form works great and does what it is supposed to. BUT...When I tried to
add a fifth table which stores changes to my employees table, but I get an
error message about ambiguous outer joins. I then created a query to try to
pull the data into the table from the form, but when I use the expression
builder in the text control of the form, I get the "#Name?" error. I'm new to
access and am very confused about what I am doing wrong. Any help will be
greatly appreciated.

Thanks!

25 Feb 2005 4:29 PM

Paul Doree

Michelle,

It's difficult to see what's really going on here, but a couple of thoughts...

The "#Name?" error occurs when an Access form can't find the field in the
underlying recordset

It's rather unusual to have a form being fed from so many tables. There may
be a design issue here. Whe multiple tables are in use, it's more usual to
have subforms on the main form to show the data from the other tables.

Paul

Show quote

"Michelle" wrote:

> I've created a form based on a query which has 4 tables that are all related.
> The form works great and does what it is supposed to. BUT...When I tried to
> add a fifth table which stores changes to my employees table, but I get an
> error message about ambiguous outer joins. I then created a query to try to
> pull the data into the table from the form, but when I use the expression
> builder in the text control of the form, I get the "#Name?" error. I'm new to
> access and am very confused about what I am doing wrong. Any help will be
> greatly appreciated.
>
> Thanks!

25 Feb 2005 6:43 PM

Michelle

Let me see if I can clarify :-)
Table #1 is to store employee information, name, employee number,dept,
manager ID, etc . Table #2 contains employee's phone #'s, mail code, fax,
etc. and the data is retrieved from the company phone roster. table #3
contains team leader, team name, team code. Table #3 contains the job codes,
and employee #. Table #5, the one I want to add to the query and subsequently
use on the form is the transaction history table which contains data on
employees joining a team, leaving a team, date of change, explanation for
change, etc. All this information needs to be displayed in the "employee
form" so when new employee joins the group, we can enter the relevant data
and track changes as they occur. Also on my form is the assets (pc equipment)
assigned to each employee. This information is already stored in a subform.

If it is simpler to do what I need with a subform, is there a way to get the
subform to display like a regular form with individual boxes for each field
instead of table form?

Show quote

"Paul Doree" wrote:

> Michelle,
>
> It's difficult to see what's really going on here, but a couple of thoughts...
>
> The "#Name?" error occurs when an Access form can't find the field in the
> underlying recordset
>
> It's rather unusual to have a form being fed from so many tables. There may
> be a design issue here. Whe multiple tables are in use, it's more usual to
> have subforms on the main form to show the data from the other tables.
>
> Paul
>
> "Michelle" wrote:
>
> > I've created a form based on a query which has 4 tables that are all related.
> > The form works great and does what it is supposed to. BUT...When I tried to
> > add a fifth table which stores changes to my employees table, but I get an
> > error message about ambiguous outer joins. I then created a query to try to
> > pull the data into the table from the form, but when I use the expression
> > builder in the text control of the form, I get the "#Name?" error. I'm new to
> > access and am very confused about what I am doing wrong. Any help will be
> > greatly appreciated.
> >
> > Thanks!