Go Back   Access World Forums > Microsoft Access Discussion > Queries

Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 07-12-2019, 11:56 AM   #1
Newly Registered User
Join Date: Jul 2019
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Robert2019 is on a distinguished road
Type conversion error in append query that worked minutes ago

I have a query that appends data to an existing table. This query is run from a form. It sets query criteria from one field in the form. It's been working great for weeks. It worked yesterday.

I created another append query to append data that's calculated differently and to be appended to the same table as the first. Again it uses some criteria submitted from the form and subform. After much searching of the web I finally figured out how to properly call for a criteria value from my subform. The append query worked.

Then I thought I would get smart and after running the query, I added anew instruction to refresh the form. (I have a refresh button, but I thought if refresh could just happen after running the append query, it would be much nicer.)

Now the append query gets this error: ms access set 0 fields to null due to a type conversion failure

I removed the refresh action. But it's broken. Both append queries are broken. The whole point of the database is to run these queries which split costs for resources across multiple campuses at varying cost shares.

It makes no sense that the queries appended fine one moment and get conversion type errors now. Nothing in the original table was changed, (that I'm aware I changed). Even running the queries outside of the form and without the calls to form data, the conversion error comes up.

Robert2019 is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Data Type Conversion Error 3421: Parameter Query Sonnydl Modules & VBA 13 07-03-2018 09:59 PM
Append Query: Type Conversion Failure jehanim009 Queries 8 09-09-2016 01:43 AM
Append query: data conversion error not triggered by commas rsf Queries 2 06-27-2016 05:53 AM
Type conversion error on select/update/make table query PISI Guy Queries 7 12-13-2011 01:12 PM
"Type conversion failure" error when running update query ktmchugh Queries 2 04-07-2009 07:38 PM

All times are GMT -8. The time now is 03:11 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World