With the dreaded roll out to chrome books, our business is now using Citrix to rum the application I wrote in Ms Access 2003 but published in 2007. Since the roll out, users are unable to analyse reports in Excel or PDF it or snapshot it. i am sure I am not the first person to have this issue. Did someone have the issue and how was this resolved? When I try to run the option to analyse report, i get attached error.
Reports analyse with Excel in citrix
- Thread starter khwaja
- Start date
- Local time
- Today, 23:32
- Joined
- Feb 19, 2013
- Messages
- 17,509
Have you tried stepping through the code?
Re Excel - are you using early binding? If you are, update the references to use the current excel version used on citrix (I presume excel is installed) or better change to late binding
Re pdf print not sure the method used in 2003 will work in 2007, even if it does, you will need to update access to the current drivers. In 2007 you can now use acFormatPDF
Re Excel - are you using early binding? If you are, update the references to use the current excel version used on citrix (I presume excel is installed) or better change to late binding
Re pdf print not sure the method used in 2003 will work in 2007, even if it does, you will need to update access to the current drivers. In 2007 you can now use acFormatPDF
Thank you very much. I don't have a great deal of understanding on early binding. I tried once but did not quite see how I use it. But now that you have indicated that this could be used in Citrix (Yes we have Excel 2007) then help me a little to how to use it. Does it go into the reports module or does it have a global impact?
- Local time
- Today, 23:32
- Joined
- Feb 19, 2013
- Messages
- 17,509
Apologies, forgot to paste the link - you can just google 'early binding v late binding'
http://support.microsoft.com/kb/245115
and a bonus one
http://www.dicks-clicks.com/excel/olBinding.htm
http://support.microsoft.com/kb/245115
and a bonus one
http://www.dicks-clicks.com/excel/olBinding.htm
- Local time
- Today, 23:32
- Joined
- Feb 19, 2013
- Messages
- 17,509
you don't have to use late binding, it is just considered the better option to cater for a changing environment - as discussed in the links. Google some more to get more opinions. If you have the right references at the moment, then it is not a problem at the moment.
With regards adding code to handle all issues, that depends on the code you already have. You have mention pdf, that is handled differently from 2007 so you need to make changes there - google 'access 2003 v 2007' or similar to find out what other changes are required
here is a link to get you started
https://technet.microsoft.com/en-gb/library/ee523661(v=office.14).aspx
You may find you are not using any of these features so it won't matter or that there is backward compatibility so again, no changes required.
Your issues are:
I don't understand what you mean by 'analyse reports in Excel', a report is basically a 'paper format' style of presentation whereas I suspect you mean you are either exporting a query to excel or using excel to interrogate access - perhaps you are using a feature there which has been changed for 2007 or the problem is with Excel rather than Access.
Perhaps you are using shortcut menus to print to pdf or whatever - these also have changed from 2003 to 2007.
Without knowing your code I could keep guessing.
Other basics - I presume each user has their own front end on citrix and excel is located there as well and they are not using excel on their own pc to access something in citrix?
With regards adding code to handle all issues, that depends on the code you already have. You have mention pdf, that is handled differently from 2007 so you need to make changes there - google 'access 2003 v 2007' or similar to find out what other changes are required
here is a link to get you started
https://technet.microsoft.com/en-gb/library/ee523661(v=office.14).aspx
You may find you are not using any of these features so it won't matter or that there is backward compatibility so again, no changes required.
Your issues are:
we have eliminated references as an issue for excel, explained about pdf and I believe snapshot disappeared in 2007 in favour of the new pdf output feature as well.
I don't understand what you mean by 'analyse reports in Excel', a report is basically a 'paper format' style of presentation whereas I suspect you mean you are either exporting a query to excel or using excel to interrogate access - perhaps you are using a feature there which has been changed for 2007 or the problem is with Excel rather than Access.
Perhaps you are using shortcut menus to print to pdf or whatever - these also have changed from 2003 to 2007.
Without knowing your code I could keep guessing.
Other basics - I presume each user has their own front end on citrix and excel is located there as well and they are not using excel on their own pc to access something in citrix?
Thank you so much. So as I understand the refs I have got are sufficient for early binding. However, when I publish the mde in Windows 7, these refs also change. Again that should still handle. So may be the issue I have described is resulting from something else. And you are right I have a custom short cut provided to user within the application which offers a similar functionality as you normally see in a report. This feature is still part of 2007. I have attached a screen shot for your info. I have also attached a file to show how I am providing a custom menu.
