Microsoft Access Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community Forums > Databases > Microsoft Access Development
Reload this Page

How to display value as Jan, Feb... on report?

Discuss How to display value as Jan, Feb... on report? in the Microsoft Access Development forum on Dev Articles.
How to display value as Jan, Feb... on report? Microsoft Access Development forum to discuss problems and solutions with this popular DBMS. Use Access to build and modify database tables, or full-featured applications.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old June 6th, 2006, 10:25 PM
awiezzz awiezzz is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Jun 2006
Posts: 2 awiezzz User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 m 49 sec
Reputation Power: 0
How to display value as Jan, Feb... on report?
Hi..
I have tblWorkHistory with value (01,02,...12).
I want to display this value as Jan, Feb... in report. As for example, if the value in the table is "01", then it will display as "Jan" in the report. Is it possible?
this is the code..
Code:
Private Sub Report_Activate()
If Me.MonthFrom.Value = "01" Then
        Me.MonthFrom = "Jan"
ElseIf Me.MonthFrom.Value = "02" Then
        Me.MonthFrom = "Feb"
......
......
    End If    
End Sub

but the problem is, when i run the report..this is the error,
"You can't assign a value to this object".

I just want to display as "Jan" in the report if the value is "01" not change the value in the table.
Any idea? thanx in advance..
Reply With Quote
  #2  
Old June 7th, 2006, 02:51 AM
MStef MStef is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Mar 2006
Location: Zagreb - Croatia
Posts: 98 MStef User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 Day 18 h 21 m 55 sec
Reputation Power: 3
Hello awiezzz!
Look at "DemoMonthA2000.mdb"
Attached Files
File Type: zip DemoMonthA2000.zip (12.5 KB, 238 views)
Reply With Quote
  #3  
Old June 7th, 2006, 03:03 PM
Thunder Thunder is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Jun 2006
Posts: 5 Thunder User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 22 m
Reputation Power: 0
change control name to another name and try other functions like choose and mid
Attached Files
File Type: zip DemoMonthA2000.zip (17.1 KB, 229 views)
Reply With Quote
  #4  
Old June 8th, 2006, 03:27 AM
awiezzz awiezzz is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Jun 2006
Posts: 2 awiezzz User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 m 49 sec
Reputation Power: 0
Hi all..
thanx for the reply..it works....
thanx again..
Reply With Quote
Reply

Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > How to display value as Jan, Feb... on report?

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway. 
Stay green...Green IT