|
| |
|
|
accessman
Posts: 74
Joined: 9/13/2005
Status: offline
 |
Property Not Found of DecimalPlaces - 6/20/2006 14:14:47
Hi
I want to change the property setting of DecimalPlaces
Firstly,
I made the crosstab query,
then, I used SQL to create the new table as following code
CurrentDb.Execute "SELECT [qry2_crosstab].* INTO [New Table] FROM [qry2_Crosstab];"
Afterwards, I used the following codes to change the property setting, the Format is OK, but the decimalplaces is NOT working, it shows "Property Not Found"
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim qd As TableDef
Dim str As String
Set db = CurrentDb
Set qd = db.TableDefs("New Table")
qd.fields("Total").Properties("Format") = "Percent"
qd.fields("Total").Properties("DecimalPlaces") = 5
What's wrong with it?
Please let me know, thanks.
|
|
|
|
yb2
Posts: 653
Joined: 1/30/2006
Status: offline
|
RE: Property Not Found of DecimalPlaces - 6/22/2006 6:23:18
Where are you running this code?
_____________________________
it is natural for people not to see one's own faults, and to exaggerate other people's faults and failings.
Currently listening to: L'Enfer Des Formes by Stereolab
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
