Graham-
I have suggested he try different things in the Format property, but to no avail.
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
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Graham Mandeno
Sent: Sunday, September 22, 2013 1:37 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Access display of Money from SQL Server in linked table
Hi John
It's not a problem with a peculiar Format property is it?
Cheers,
Graham
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of jpjones23@centurylink.net
Sent: Sunday, 22 September 2013 05:14
To: MS Access Professionals
Subject: Re: [MS_AccessPros] Access display of Money from SQL Server in linked table
What happens if a text file is added to an Access form with its data source being a link to a money field in the server? Do the bucks show up?
From: "John Viescas" <JohnV@msn.com>
To: "MS Access Professionals" <MS_Access_Professionals@yahoogroups.com>
Sent: Saturday, September 21, 2013 12:31:15 PM
Subject: RE: [MS_AccessPros] Access display of Money from SQL Server in linked table
Yes, there are other numeric values, including a foreign key to another table, that all display correctly.
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
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of jpjones23@centurylink.net
Sent: Saturday, September 21, 2013 5:28 PM
To: MS Access Professionals
Subject: Re: [MS_AccessPros] Access display of Money from SQL Server in linked table
And, are there other numeric, but not currency, fields in the table that do display correctly? If not, might temporarily add one as a test if this can be done in the server table.
From: "John Viescas" <JohnV@msn.com>
To: "MS Access Professionals" <MS_Access_Professionals@yahoogroups.com>
Sent: Saturday, September 21, 2013 9:39:03 AM
Subject: RE: [MS_AccessPros] Access display of Money from SQL Server in linked table
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
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of jpjones23@centurylink.net
Sent: Saturday, September 21, 2013 2:57 PM
To: MS Access Professionals
Subject: Re: [MS_AccessPros] Access display of Money from SQL Server in linked table
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>
To: "MS Access Professionals" <MS_Access_Professionals@yahoogroups.com>
Sent: Saturday, September 21, 2013 7:16:03 AM
Subject: [MS_AccessPros] Access display of Money from SQL Server in linked table
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?
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (13) |
Tidak ada komentar:
Posting Komentar