Recent content by MichaelRo1

Hi My company has agreed to send me on a SSRS course and I've identified 'Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services - 6236a' as the course to meet my requirements. However, I am unsure who to go with in regards to the training. I'm located in the South West but...

Quite new to SSIS and obviously Package Configurations. I have inherited a system where an external application alters the XML package configuration to define an XML Source File Path. This application no longer works and I want to recreate something within SSIS. I hoped that by moving the...

Hi, I have a SQL Server 2005 database that I have created several users with db_datareader access. Most of these users access the data via ODBC, but some use SQL Server. Those that can use SQL Server are my issue. I assumed that with db_datareader users could only connect and view the data...

I always assumed that in Access when you join a field only exact matches return (Unless you change the Join Type obviously!!) However when I joined two tables I got unexpected results. So after running a quick test, I'm even more confused. Access matches even if there are trailing spaces...

Nothing Great I'm afraid - I can post the code for the basic functions. The Automation is run through a Userform and has 34 buttons so I won't post all of that!! Option Explicit Option Base 1 'Start Value for Array 1 or 0 Public RunReport(34) As Boolean 'Array Variable - Has Report been...

Thanks for that You're a life saver!!

Hi, I've created an Automated System, mainly through luck rather than judgement, that opens several reports, refreshes them, saves as pdf's and either prints or e-mails them to my clients. What I'm looking to do now is on refreshing have a record count for each report. I've got a form...

I also used Shellexecute When I try and send several emails at once - Outlook can't keep up - I get the message Microsoft Word Mail Could not be started. Close any Open Dialog Boxes in word and try again. I use Application.Wait (Now + TimeValue("0:00:04")) Application.SendKeys "%s" at the...

Ta for that Also Managed to find an alternative I found that BO retains the last prompted value As the prompts won't really change - I turned them off Application.interactive = false/true

Any Help Will be great. Am using VB to Open,Refresh,Print,Save and Close several reports. However the reports all have user defined prompts - 2 with date ranges and 4 with user names from a list. When the macro gets to: activedocuments.refresh I get the user prompt form appear - How can I...

Cheers Mate, Managed to Open, Refresh Print and Save. My only problem now a User Defined Prompt The Report asks the user to define a date range - I don't want to remove this from the report but I don't want have to click ok everytime - Is there a way I can say ok in the macro?

Hi, I have been trying unsuccessfully to open a document/report using VB. Have tried several methods: 1)Open "Report1" For Random As #1 'Can't see the report anywhere 2)Documents.Open ("C:\Report1.rep") 'Object variable or With block variable not set (Error 91) Not sure what I'm doing wrong...