Re: INSERT/SELECT and DataType Mismatch

Hi,

I have tried to execute the same query within MS-Access and I get the same
type conversion error.I supply all required parameters, no null! I really dont
understand! I turned the INSERT query into UPDATE query, using the same
parameters on the same table and I got no problem to update the table.

thank you for your time
serge

Del M wrote:

> Depending on where you get the source for the parameter.values from , you
> could be passing a null, which cant be converted to the proper type of the
> .value.

.

Relevant Pages

  • Re: Replace on PART of the Text in a COMMENT field ???
    ... Microsoft can't update all of the records in the update query. ... Microsoft Access didn't udpate 597 fielddue to a type conversion failure,. ...
    (microsoft.public.access.queries)
  • Re: To change negative to positive in MS Access
    ... If you want to use the UPDATE query method and you will be importing new data into the table, ... UPDATE query that will only change the numbers that haven't been changed. ... changed data or if it is new, unchanged data and then build your UPDATE ...
    (microsoft.public.access.queries)
  • Re: Update with Max date
    ... Hash: SHA1 ... But the query is still not working, the type convension error is still there. ... I still got the type conversion error, but I can't see any problem with that. ... expression with the wrong data type (comparing apples to oranges). ...
    (microsoft.public.access.queries)
  • Re: Update query after an append query?+
    ... computer so that I could tell when and if I get the update query to work. ... that if you created your query under a different ANSI SQL query mode than ... the current mode of your Microsoft Access database then your update query ...
    (microsoft.public.access.formscoding)
  • Re: Append import data to existing record
    ... I'm glad you've got the key query working. ... With the update query open in Design View: ... Split the filespec apart and reassemble it into a ... Function BuildJetTextSource(ByVal FileSpec As String, ...
    (microsoft.public.access.externaldata)