This topic has been archived. It cannot be replied.
-
工作学习 / 专业技术讨论 / MS Access 高手挑战：电话号码一览现在是十位数字的text。想加入format把它变成(416) 999-9999这样的。但是履试不成功。失败原因都是同一个：“0 record updated due to TYPE CONVERSION FAILURE"。怎么回事？update to format([Telephone],'(aaa) aaa-aaaa')不成
update to "(" & Left([Telephone],3) & ") " & Mid([Telephone],4,3) & "-" & Right([Telephone],3)不成。
split into 3 separate fields and concatinate them不成
谁能解释TYPE CONVERSION FAILURE是什么原因？
-23456789(大白呼);
2007-4-10
{266}
(#3605965@0)
-
这也太简单了，我都不好意思解释了。
-mine888(老想上进);
2007-4-10
(#3605980@0)
-
lol
-canadiantire(轮胎-ten.prahsc);
2007-4-10
(#3605994@0)
-
看看，好几个高手都没整明白。你先在这卖一会关子吧哈。不过一会你要是也答不上来你就是那啥。
-23456789(大白呼);
2007-4-10
(#3606031@0)
-
http://support.microsoft.com/kb/125259
-canadiantire(轮胎-ten.prahsc);
2007-4-10
(#3605992@0)
-
我在那转悠回来没解决问题才贴的。text with format怎么回是'type conversion"?设想可能是NULL value在作怪，另复制了一个table, 把null都切掉了还是没成。
-23456789(大白呼);
2007-4-10
(#3606010@0)
-
because the field type is number and cannot store text?
-jeffrey815(Smartiecat);
2007-4-10
(#3606000@0)
-
field type is text, 15 characters long.
-23456789(大白呼);
2007-4-10
(#3606019@0)
-
把电话号码定义为数字，默认为0，定义显示的格式为电话号码格式
-andy2060(胖胖猴 ：(|);
2007-4-10
(#3606041@0)
-
写个挑战.嘿嘿,帮你就说谢谢.好要真心的,7
-iwantcar(恶疾,时日无多,戒网);
2007-4-10
(#3606978@0)
-
把input mask 改成 !\(999") "000\-0000;0;_ 不是改format
-zxcvb(朝天椒);
2007-4-13
(#3612649@0)
-
试过了.不成. Input mask只管以后输入的.现在电话号码已经全在里面了.不好使.
-23456789(大白呼);
2007-4-15
(#3616845@0)
-
从table design里面改， 我用2000做的test, work得很好呀
-zxcvb(朝天椒);
2007-4-16
(#3617787@0)
-
hope this helps.1.back up your database first.
2. open query window, new query with design view, choose the table, use SQL window
3. type in the query
update tableXXXX set telephone ="(" & Left([telephone],3) & ") " & Mid([telephone],4,3) & "-" & Right(telephone,4)
and run it. But make sure the field size for the telephone is more than 14.
should work.
-sunday8(sunday8);
2007-4-15
{350}
(#3616930@0)