Showing posts with label vba. Show all posts
Showing posts with label vba. Show all posts

Sunday, March 25, 2012

Can we call a RS report from within another VB or VBA application?

Will I be able to launch a reporting services report from within a VB/VBA
application? How would I do this?
Thanks
Ranjit CharlesThree options:
1. URL integration. Embed a IE control into any app and set the url
appropriately. Works with VB6, VB.Net, etc.
2. Web services integration. Works with VB.Net, VB6 with soap toolkit (but
can be problematic and I suggest staying away from it).
3. VB.Net 2005 use the new report control that ships with VS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ranjit Charles" <RanjitCharles@.discussions.microsoft.com> wrote in message
news:0391CF5D-44EE-4710-BCC1-3F8CDC1CD5DD@.microsoft.com...
> Will I be able to launch a reporting services report from within a VB/VBA
> application? How would I do this?
> Thanks
> Ranjit Charlessql

Monday, March 19, 2012

Can the .mdb file (include VBA code) be indexed?

Hi GURU, I wonder if the code inside the .mdb or .adp file can be indexed? if
yes, what iFilter can do that? Thanks.
Raymond,
If memory servers me correctly, both of those file extensions are Microsoft
Access related. Assuming so, I do not believe that there are any known /
public IFilters for this files types. However, the IFilter API is well
known, and if you know the internal structure of these MS propriety file
formats, then by all means write your own! <g>
-- John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Raymond" <Raymond@.discussions.microsoft.com> wrote in message
news:015B1CD4-7874-464E-B154-CAA1201583B4@.microsoft.com...
> Hi GURU, I wonder if the code inside the .mdb or .adp file can be indexed?
> if
> yes, what iFilter can do that? Thanks.