VERY Strange Append Query problem...

  • Thread starter Thread starter Bill Mitchell
  • Start date Start date
B

Bill Mitchell

Ok, I have two unbound fields on my form. One is based
upon a field on a subform like this:

[MyContactIDField]=forms![Main]![Contact].form![ContactID]

The other is based upon a column in a combo box like this:

[MyContactIDCombo]=forms![Main]![MyCombo].column(10)

Both return a Long Integer. Both are the same number.

Ok, here's the WEIRD PART. If I try to append
[MyContactIDField] to another table using an append query
I get an error. It sees the value of [MyContactIDField]
as a weird group of BOXES AND CHINESE LETTERS!
Seriously, thats what it sees.

However, If I try to append [MyContactIDCombo], it works
JUST FINE!

Both are based upon unbound fields. Both have the same
number in them, yet one works and one sees it as chinese
letters????

Can anyone explain this to me?

This one is truly bizarre.

Thanks,

Bill
 
Bill Mitchell said:
Ok, I have two unbound fields on my form. One is based
upon a field on a subform like this:

[MyContactIDField]=forms![Main]![Contact].form![ContactID]

The other is based upon a column in a combo box like this:

[MyContactIDCombo]=forms![Main]![MyCombo].column(10)

Both return a Long Integer. Both are the same number.

Ok, here's the WEIRD PART. If I try to append
[MyContactIDField] to another table using an append query
I get an error. It sees the value of [MyContactIDField]
as a weird group of BOXES AND CHINESE LETTERS!
Seriously, thats what it sees.

However, If I try to append [MyContactIDCombo], it works
JUST FINE!

Both are based upon unbound fields. Both have the same
number in them, yet one works and one sees it as chinese
letters????

Can anyone explain this to me?

This one is truly bizarre.
Click to expand...

I don't see offhand why it shouldn't work, and it works for me in a
quick, simple test. Garbage characters in a field most commonly
indicates some sort of corruption in the data, so maybe that's what's
going on. Do you assign those unbound controls in VBA code, or do you
just have them set up as calculated controls? Just in case there's
something wrong in your setup or your code, how about posting the
properties from the data tab of the controls and the code that builds
and executes the apend query?
 
The controls are calculated. I have not tried running
the query in sql, just in the query grid. I don't seem
to find any corruption in the data as the same thing
happens no matter what table the calculated controls seem
to be pointing to.

Is there some way to check for corruption in my data
other than a compact and repair?

Bill
-----Original Message-----
Ok, I have two unbound fields on my form. One is based
upon a field on a subform like this:

[MyContactIDField]=forms![Main]![Contact].form! [ContactID]

The other is based upon a column in a combo box like this:

[MyContactIDCombo]=forms![Main]![MyCombo].column(10)

Both return a Long Integer. Both are the same number.

Ok, here's the WEIRD PART. If I try to append
[MyContactIDField] to another table using an append query
I get an error. It sees the value of [MyContactIDField]
as a weird group of BOXES AND CHINESE LETTERS!
Seriously, thats what it sees.

However, If I try to append [MyContactIDCombo], it works
JUST FINE!

Both are based upon unbound fields. Both have the same
number in them, yet one works and one sees it as chinese
letters????

Can anyone explain this to me?

This one is truly bizarre.
Click to expand...

I don't see offhand why it shouldn't work, and it works for me in a
quick, simple test. Garbage characters in a field most commonly
indicates some sort of corruption in the data, so maybe that's what's
going on. Do you assign those unbound controls in VBA code, or do you
just have them set up as calculated controls? Just in case there's
something wrong in your setup or your code, how about posting the
properties from the data tab of the controls and the code that builds
and executes the apend query?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.
Click to expand...
 
The controls are calculated. I have not tried running
the query in sql, just in the query grid. I don't seem
to find any corruption in the data as the same thing
happens no matter what table the calculated controls seem
to be pointing to.

Is there some way to check for corruption in my data
other than a compact and repair?
Click to expand...

It's possible, but before going that route let's see if we can find
something wrong with the query. Please post the SQL of the query.
 
Back
Top