Deleted fields and now cannot export to Excel

To preface this post, I personally did not create the database in question.
It was created by someone working for our technical support provider. That
person has since left the company and is not reachable. Therefore, we should
bear in mind that I have no knowledge of how this database was initially set
up. Also, I have no programming experience whatsoever and only managed to do
what I've done because of J_Goddard's post to a thread I created on MSFT's
Discussion Groups page.
(http://www.microsoft.com/office/community/en-us/default.msp x?dg=microsoft.public.access&tid=c94afce5-b3de-4226-971e-bfa b569aedad&cat=en-us-office-access&lang=en&cr=US&sloc=en-us&m =1&p=1)


I had asked how to merge two fields and then delete one of them. I have done
that. Now, however, the macro that the man set up returns #Name? in each
field that I changed. Big problem. Especially because I can no longer
export to Excel. It gives me this error: "The INSERT INTO statement contains
the following unknown field name: 'Atty'."

Is this something that I am going to be able to fix? I have no idea where to
start, but am pretty technically savvy. Thank you in advance for your help!

Re: Deleted fields and now cannot export to Excel

On Apr 2, 12:20=A0pm, "bmcgeoch" wrote:
> To preface this post, I personally did not create the database in question=
..
> It was created by someone working for our technical support provider. =A0T=
hat
> person has since left the company and is not reachable. =A0Therefore, we s=
hould
> bear in mind that I have no knowledge of how this database was initially s=
et
> up. =A0Also, I have no programming experience whatsoever and only managed =
to do
> what I've done because of J_Goddard's post to a thread I created on MSFT's=

> Discussion Groups page.
> (http://www.microsoft.com/office/community/en-us/default.msp x?dg=3Dmicro..=
..)
>
> I had asked how to merge two fields and then delete one of them. =A0I have=
done
> that. =A0Now, however, the macro that the man set up returns #Name? in eac=
h
> field that I changed. =A0Big problem. =A0Especially because I can no longe=
r
> export to Excel. =A0It gives me this error: "The INSERT INTO statement con=
tains
> the following unknown field name: 'Atty'."
>
> Is this something that I am going to be able to fix? =A0I have no idea whe=
re to
> start, but am pretty technically savvy. =A0Thank you in advance for your h=
elp!

The error is exactly what your error message says it is. the query
that drives the export still references the deleted field name.
Modify the query that cretes the export and you SHOULD be good to go.
There may or may not be otehr issues.

Re: Deleted fields and now cannot export to Excel

This in theory sounds simple, but I do not know how to modify the query. In
fact, under the Queries tab, there are only two test queries. Under the
Forms tab, there are seven. I have the option to open them only, not to
"design" them.

Thoughts? Thank you!

frogsteaks@yahoo.com wrote:
>> To preface this post, I personally did not create the database in question.
>> It was created by someone working for our technical support provider. That
>[quoted text clipped - 13 lines]
>> Is this something that I am going to be able to fix? I have no idea where to
>> start, but am pretty technically savvy. Thank you in advance for your help!
>
>The error is exactly what your error message says it is. the query
>that drives the export still references the deleted field name.
>Modify the query that cretes the export and you SHOULD be good to go.
>There may or may not be otehr issues.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-ac cess/200804/1