Deleted fields and now cannot export to Excel

[bmcgeoch]

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/comm...=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!

[frogsteaks]

On Apr 2, 12:20*pm, "bmcgeoch" <u42638@uwewrote:

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/comm....mspx?dg=micro....)

I had asked how to merge two fields and then delete one of them. *I havedone
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!

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.