Duane-
He's using 2007, and all the screen dumps he has sent me look like a
"normal" font.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Sunday, September 22, 2013 3:26 AM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] Access display of Money from SQL Server in
linked table
John,
I seem to recall a long time ago there was an issue with numeric displays
with a particular font installed. I assume this is a much later version.
Duane Hookom MVP
MS Access
________________________________
> From: JohnV@msn.com
>
> Not as far as I know. The one example my friend sent me involved
> typing a number on a row in one of the currency fields. The number
> displayed as typed, but disappeared after he saved the row. He's able
> to find the row with a query like:
>
> SELECT * FROM MyTable WHERE MoneyField = 123.45
>
> 123.45 being the value he typed in the row. The query finds the row,
> but displays the field as blank. If there were extra carriage returns
> or stray characters, the query would fail.
>
> John Viescas, Author
>
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
> jpjones23@centurylink.net
>
> Has the data been copied and pasted into Excel and/or Notepad from
> both the server and Access to see what is actually in each of the
> cells in question? I've seen this behavior in fields when an
> unexpected carriage return or some other unprintable characters are
present.
> ________________________________
>
> From: "John Viescas" <JohnV@msn.com<mailto:JohnV@msn.com>>
>
> I have a friend who has a table on SQL Server with several "money"
> fields. When displayed in a Datasheet in Access (via a linked table),
> the fields show either 0.00 or blank, even though the rows in SQL
> Server contain values. He has tried updating one of the money fields
> (mapped to Currency in Access), and the update appears to go OK on the
> server, but the field goes blank after he saves the record.
>
> Any ideas?
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (12) |
Tidak ada komentar:
Posting Komentar