Re: [MS_AccessPros] Is expression valid Office 2007 ?

 

John,

I opened the .mdb (FE) on my users system and got message like:

"You have broken reference to the file 'AcroPDF.dll' version 1.0."

The i checked it in Tools--> References

MISSING was checked (Adobe Acrobat Browser Control Type Library 1.0

I unchecked it.

Now still on my FE and MDE the report is OK and showing "Month, Year", but not on the user's system.

Further on my user's system on a control for 'CustomerID'  if he enters CustomerID the message displays "The text you entered is not in list" even for its properties in Data tab its Limit to list property is set to Yes.

Same is the case here on my own system it does works.

Khalid

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

I suspect the libraries aren't being updated correctly when your user tries to open using 2007.  You should send him the .mdb file and ask him to open any module to see if it compiles.  Is anything else broken in the database?  If so, that would be a clue.

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)

On Mar 29, 2016, at 2:23 PM, khalidtanweerburrah@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,

He is using Windows 7 with office 2007, then obviously his Access would be 2007. But i have put backend and MDE of in Access 2000-2003 format.

Khalid

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

Then that should work.  Is your user running the same version of Access as you?

 

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)

On Mar 29, 2016, at 1:44 PM, khalidtanweerburrah@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,

 As i mentioned in my previous reply on Detail Section i have first bound control "SaleDate" with control source: SaleDate and these dates are displaying on detail section. Does it not suffice?

Regards,

Khalid

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

Khalid-

Sometimes the Report engine can't find a field in the Record Source because it reformats the SQL to optimize it based on grouping, etc.  If you don't have SaleDate in a bound control on the Report, it's not guaranteed to be available at run time.  Try adding  a hidden text box containing that field.

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)

On Mar 29, 2016, at 1:01 PM, khalidtanweerburrah@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

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 

http://www.viescas.com/ 

(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 

http://www.viescas.com/ 

(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 (12)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? The Yahoo Mail app is fast, beautiful and intuitive. Try it today!

---

Visit Your Group

• New Members 3
• New Links 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___