Update Records (1 Viewer)

[vvasudev]

Hello All,

i have a form which has a ComboBox for years(Integer), the user gets to select a year and the selected year gets updated on to a table. The problem is however that the year appears as small square boxes in the records. I am new to Ms Access environment and any help would be appreciated. I beleive the problem is because of datatype mismatch

regards,
Vineeth

 

[RainLover]

<< Small square Boxes>>

Could you also describe the appearance as Chinese characters.

If so you may have a corruption issue.

Try a Compact and Repair.

 

[vvasudev]

Hi,

thank you for ur reponse, i have managed to solve it, appreciate ur help

 

[RainLover]

So what was the problem?

Please share.

 

[vvasudev]

The problem was that i had a query with 3 empty fields, 1 each for year, month and distributor. Later i convert this query to a table by means of make table query. And then i update the 3 empty fields using an update query. Well the problem was that the Year field was getting a data type "Binary" after the Make Table Query operation. This was causing an data mismatch problem.

 

[RainLover]

Thanks for the information.

Glad you got it sorted.

 

[vvasudev]

Do u have any thought on the other post i have Put??