Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MichaelRo1

    Reporting Services Training

    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...
  2. MichaelRo1

    Package Configurations

    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...
  3. MichaelRo1

    Turn Off Import / Export Data

    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...
  4. MichaelRo1

    Trailing Spaces

    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...
  5. MichaelRo1

    Record Count - Please Help Me!!

    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...
  6. MichaelRo1

    Record Count - Please Help Me!!

    Thanks for that You're a life saver!!
  7. MichaelRo1

    Record Count - Please Help Me!!

    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...
  8. MichaelRo1

    Send Email From VB

    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...
  9. MichaelRo1

    Opening Report Using VB in Business Objects

    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
  10. MichaelRo1

    User Defined Prompt = Ok

    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...
  11. MichaelRo1

    Opening Report Using VB in Business Objects

    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?
  12. MichaelRo1

    Opening Report Using VB in Business Objects

    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...

Part and Inventory Search

Back
Top