Insert into Error Message

T

TESA0_4

Hi,
I have added a field to a table called EmailDteTime to store the date/time
when a Command Button on a form is clicked to send an email with an
attachment. I modified the relevant form to include a new bound control to
display EmailDteTime. The control is locked so that users cannot amend the
entry. The Email Command Button includes the following line of code for the
click event:

Me.txtEmailDteTime.Value = Now()

Everything tests OK (almost). The Date/Time defaults to the control and is
written to the table. However, whenever the form is closed after creating a
new record or editing any data on an existing record, the following message
is displayed "The INSERT INTO statement contains the following unknown field
name: "EmailDteTime'. Make sure you typed the name correctly, and try the
operation again."

I have gone through deleting/creating fields on the table and controls on
the form with various names but still get the same error. I have added fields
and controls before but not seen this problem. Can anyone offer me any
suggestions on what is causing the error mesaage how to get rid of it?
(PS: I only have a modest level of self taught VB knowledge).
 
T

TESA0_4

A work colleague has solved my problem. I have an audit file linked to the
table/form and had forgotten to modify the audit file to capture the new
field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top