This really has me pulling out my hair!!!

[jransom1974]

Ok,
I have a db that I have been working on for a while. I made a few small upgrades and now I am getting an error that I cannot (for the life of me) explain.

Let me set the scene....

I have a database that I collect FirstName, LastName, Phone, etc.

Well... when I enter a "new" contact ans save, I get an error that says, "There is no field named 'First Name' in the current record."

Heres the kicker. All my names for my "first name field" are FirstName. No spaces. I have checked all the tables and forms.

I know I am missing something small, but after working on various projects all day, I just need another set of eyes to look at the issue...

any help is greatly appreciated!

Thanks!!!

 

[PNGBill]

Check the Forms text box control property. Other, Name.

This should be txtFirstName or in your case FirstName

If you prefix txt to the name you ensure no conflict with the Control Source which could be also be FirstName.

If all is ok with the forms controls then check the table fields.

Maybe create a new Append Query / sql and test this with manual input data and if this works then the error may be your automated append method or back to the form.

 

[jransom1974]

I have check all the areas and I am using the txtFirstName, because I am using these as a combo box lookup to populate fields.

I am not sure I understand when yo usay run a query. This is very disappointing for me. iI have everything working like a champ on my database, except this little glitch...

could you elaborate on your possible solution.

Thanks a million!

 

[PNGBill]

You have a Table and wish to Append a New record to same.

You have a form to enter data on and then on a "Click" have the data appended to the above table as a new record.

trust this is correct.

Problem is that when you "click" an error message advising There is no field named First Name.

This could mean mean an descrepency in your Form, the Append method and or the Table.

In order to check the table can accept a new record I suggested you create an Append Query and try and Append a new record to your table.

If you supply the table name and field names I will create an sql to do this.
Copy the database or be prepared to delete the record and have your autonumber sequence miss a number if you use auto number primary key.

Also, what method do you use to append the form data to the table ?

 

[jransom1974]

tell ya what...

If you tell me how to post the database, i will just show you what I have and you could see it first firsthand.

 

[PNGBill]

What version access are you using ?
What size is your database ?

To attach the file to a Post you first should ensure it is clear of any sensitive data and as small as possible. say 200 or 300KB, not MB

Create a new database and import just the "bits" you need to replicate the error.

To include any code in your Post, see symbols above "#" if cliked will allow code to be "Pasted" between them.

I will post a simple Append SQL for you to see what I am talking about re Append Query.

 

[jransom1974]

I have creadted this using Access 2010. I am not sure how to put just the file you are talking about. The database is 25 MB in total. Could i use dropbox to put the database up where you could download it?

 

[PNGBill]

here is a Simple Select Query, in SQL View - can be viewed in Query Design by clicking on that view option.

SELECT tblCommunication.CommID, tblCommunication.CommDate, tblCommunication.CommTime, tblCommunication.OperatorID, tblCommunication.RecordRef, tblCommunication.RecordType, tblCommunication.CommNotes
FROM tblCommunication;

In this example, Table Name is tblCommunication and Field Names are CommID (primary key), CommDate, CommTime, OperatorID, RecordRef, RecordType and CommNotes.

Here is the same SQL but now edited to be an Append Query (INSERT INTO)

INSERT INTO tblCommunication ( CommDate, CommTime, OperatorID, RecordRef, RecordType, CommNotes )
SELECT [Enter Date] AS AddCommDate, [Enter Time] AS AddCommTime, [Enter Operator ID] AS AddOperatorID, [Enter record ref] AS AddRecordRef, [Enter Record Type] AS AddRecordType, [Enter comm Story] AS AddCommNotes;

Note the INSERT INTO line is the Table details of where the record will be added to.
The SELECT part now requests you to manually type each field.
My example has 6 fields. You don't include the primary key as the table will handle same.
Edit this to be the your table name and field names and it should work.

 

[PNGBill]

I have creadted this using Access 2010. I am not sure how to put just the file you are talking about. The database is 25 MB in total. Could i use dropbox to put the database up where you could download it?

sorry, 25mb is a bit big for my internet connection. Wife will have to cease downloading recipes for a week

How about a screen shot of your Data Entry Form?

 

[jransom1974]

I have created a PDF with screenshot of the database. Could I email it to you?

 

[PNGBill]

I have created a PDF with screenshot of the database. Could I email it to you?

You should be able to attach the .pdf to your post. Scroll down and you should see a place to Manage Attachments.

Then 560,000 can see your form.

Best to keep communication with the Forum as others can learn and more to thepoint, any advice I give you can be critiqued

 

[jransom1974]

see my main problem here Bill is that I am still kinda new to access 2010. and I have not had to use the append query feature.

 

[PNGBill]

see my main problem here Bill is that I am still kinda new to access 2010. and I have not had to use the append query feature.

Don't worry, everyone was in the same boat at one time.

Is your Database Split ??
If not, make a copy and use that to "play" with.

If split, then copy the back end as well as the front end and link the two copies so again, you can "play" with such things as Append Queries.

Select Queries are safe as they just Collect Data for you to view.
Action Queries - Update, Apend and delete - All effect your tables in one or the other and can cause all your hair to disapear in a split second
or, they can save you a lot of time if handled properly.

 

[jransom1974]

Thanks Bilkl... I will give it a few more tries. Yes, I have my database slipt.

I appreciate all your help. Thanks !

See ya in the forum world....

 

[jransom1974]

I figured out what the issue was.

For some reason i was getting an error from a macro that was running and looking for a callout for the First Name.

I changed it to txtFirstName, and fixed it all.....

Now we know.... ahhh.. ya gotta love databases!