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!

  • Congratulations Chriss Miller 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: *

  • Users: ablackwe
  • Content: Threads
  • Order by date
  1. ablackwe

    table align

    I'm hoping that someone can help and this is not just a "feature" of RS. I have a report that is rendered as follows: table matrix matrix All looks ok when developing and the top of each is lined up. However, when the report is uploaded, the middle matrix is lower than the other 2 and...
  2. ablackwe

    Chart Labels

    I wonder if someone could help. I have a query which returns the following: Vendor Revenue ------ ------- Vendor1 100 Vendor2 25 Vendor3 75 I then have a pie chart for this data and currently, the label for each is set to: =format(Fields!Revenue.Value,"#0") & " - " &...
  3. ablackwe

    Custom Rendering Formats

    I wonder if anyone can help with a little problem I am having. I have to deliver a report in Pipe-delimited format but this is not one of the rendering options. I therefore need to create a custom format but I am unsure how to do this. Any help would be much appreciated. Thanks Adam...
  4. ablackwe

    SubReport problem - Help!!

    I hope someone can help with this 'cause I'm getting increasingly frustrated with it! I have a report that groups by a field called Zone. Int he group footer, I have a sub report where it passes 2 date parameters and the ZoneID. However, when running the report, I am only getting output from...
  5. ablackwe

    Error with Trusted Connection

    I have received the following error after deploying my report. An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'ADEPT'. (rsErrorOpeningConnection) Get Online Help Login failed for user '(null)'. Reason: Not...
  6. ablackwe

    Margin Default Settings

    I am trying to set the margins on my reports to 1cm rather than the 2.5cm that seems to be standard. Does anyone know how I can set this as my default for all future reports so I don't have to change each one individually? Thanks Adam
  7. ablackwe

    Check if table exists

    I have a little problem that hopefully someone can help with. I currently have a DTS package that is scheduled and creates a number of tables. What I need to be able to do is schedule a seperate DTS package that checks if a specific table exists. If not, it keeps checking until the table has...
  8. ablackwe

    Open & Close Apps

    Can someone please help with a problem I have. I have a number of command buttons on a Word document that each opens a seperate document or spreadsheet (similar to hyperlinks). The problem I have is when one button is clicked, it needs to check if any of the other docs are open, if so, close...
  9. ablackwe

    Outlook - Creating Forms

    I wonder if anyone can help. I am trying to create a form that is used to capture information. The form is sent to another user for them to complete and then return to a specific mailbox. I have managed to create a form already but when details are entered into the text boxes, the data is not...
  10. ablackwe

    Notes email

    Does anyone have any suggestions how I can create some sort of program to export mail from Lotus Notes to Microsoft Outlook. My employers have decided to move across to Outlook and have asked us to send each email to our new email address. As you can imagine, this could be a bit time...
  11. ablackwe

    Master/detail form

    I wonder if someone could help. I have created a VB6 Master/detail form that contains data from 2 sources (tblTable1 & tblTable2), however, there is no field that relates the two tables. The actual link is provided from a 3rd table, tblTable3. So the relationship should be as follows...
  12. ablackwe

    Column name variable

    Does any one know how you can set a variable with a column name then call it in a select statement? select * from ksa_running_totals DECLARE @week1 as datetime SET @week1 = 'col' & GETDATE() This code works OK to get the column name. What I need to do now is do a select which selects this...
  13. ablackwe

    Reading Lotus notes email from Excel VBA

    I wonder if anyone can help. There seems to be lots of posts on how to send emails from Lotus Notes using VB/VBA, but does anyone know how to open an email and extract the contents to Excel using VBA? Any help would be very much appreciated.
  14. ablackwe

    Reading from Lotus Notes via Excel VBA

    I wonder if anyone can help. There seems to be lots of posts on how to send emails from Lotus Notes using VB/VBA, but does anyone know how to open an email and extract the contents to Excel using VBA? Any help would be very much appreciated.

Part and Inventory Search

Back
Top