Selasa, 29 Maret 2016

Re: [MS_AccessPros] Is expression valid Office 2007 ?

 

John,

Reports Record Source is Query:

SELECT [Sales Retail Seller].OrderID, [Sales Retail Seller].SaleDate, [Sales Retail Seller].ItemReturned, [Sales Retail Seller].ReturnQty, [Sales Retail Seller].ReturnCost
FROM [Sales Retail Seller]
WHERE ((([Sales Retail Seller].ReturnQty)>0));

On SaleDate Header
Unbound Textbox: TransactionDate by Month
Control Source: =Format$([SaleDate],"mmmm yyyy",0,0)

On Detail Section:
Textbox: SaleDate, Control Source: SaleDate
.
.
.
4 more text boxes

I have given the user backend and MDE file, as i mentioned before the report is OK on my system but on user's system still not getting month, year On SaleDate Header other report on Detail section is OK there too. 

Regards,
Khalid


---In MS_Access_Professionals@yahoogroups.com, <khalidtanweerburrah@...> wrote :

John,

I will let you inform tomorrow.

Thanks for your reply.

Regards,
Khalid


---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Then it should work just fine in 2007.  Is SaleDate a field in the Record Source?  Also, make sure you have no control named "SaleDate" on the form.

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)



On Mar 28, 2016, at 12:24 PM, khalidtanweerburrah@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



Hi John,

This is:

=Format$([SaleDate],"mmmm yyyy",0,0)

And it shows on my Laptop like:
March, 2016

Khalid



---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

That should be valid in 2007.  The #Name? indicates it doesn't know what [xxx] is.

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)



On Mar 28, 2016, at 9:21 AM, Khalid Tanweer khalidtanweerburrah@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



Hi All,

=Format$([xxx],"mmmm yyyy",0,0)
I'm using the above expression for Control Source of a Text box on a Report in access 2003 on a group header  to get
month ,year and is working.

But if the database is put on other computer having Office 2007 it does not shows
month, year and i get #Name?

My question is that is above expression valid for Office 2007? database running is 2000-2003 format.

OR the office 2007 installed there is corrupt OR that Windows 7 is not completely installed.

Khalid






__._,_.___

Posted by: khalidtanweerburrah@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar