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 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: *

  1. jwestmore

    How to summarize data from 3 tables on one report

    Your problem here is a cartesian product If you join all 3 tables on job id and you have multiple records in the two source tables, every record gets joined with every other record. For example: Let's say you have a job that required two people and two materiel types all linked by job id. You...
  2. jwestmore

    Embedded Selects

    I have a group of accounts and each account has a number of charges associated with it. Each charge has a post date. I want a report that groups charge details by account. The caveat is I only want accounts that have had a charge posted within the last 90 days. However, each account group...
  3. jwestmore

    Function that returns a two dimensional array

    Never mind, I've got it, forgot the parentheses on the function return data type: Dim Board() As Integer Private Sub Form_Load() Board() = LoadB(4, 4) End Sub Function LoadB(x As Integer, y As Integer) As Integer() Dim b() As Integer Dim i As Integer, j As Integer, size As Integer...
  4. jwestmore

    Function that returns a two dimensional array

    I'm trying to build a function that creates and returns a populated two-dimensional array based on function parameters. I'm receiving a "Can't assign to array" error with the following code. Any suggestions on how to make this work correctly? Thanks in Advance, Jon. Dim Board() As Integer...
  5. jwestmore

    Getting Date Received/Date Sent from the Outlook Object Library

    Hi Everyone, I'm trying to pull the date sent and date received values from e-mails in my Inbox using Vb's Outlook object library. Anybody have any idea what the syntax is for something like that? inbox.items(i).??? Thanks! Jon
  6. jwestmore

    Customizing the Deployment Wizard

    Hi there, I'd like to set up the deployment wizrad so that when the user installs it, he is prompted with a couple of textboxes that allow paths to be entered that point to dependent databases. The textbox entries would then be saved at into the registry. Any thoughts on how to do this...
  7. jwestmore

    Creating Registry Keys during package and deployment

    Greetings, I would like to customize the VB's Package and Deployment Wizard so that the user is prompted to specify paths that point a couple of dependent databases. I would then like to create registry keys that store those paths. Any tips on how to do this? Thanks, Jon
  8. jwestmore

    Registering Two different versions of a .dll

    I have two applications that interact with the Text Object library (tx32.dll, tx4ole.ocx). However, the apps use different versions of the files. One set of files is stored in its own program directory, the other set is stored in winnt/system32. Is it possible to have two different versions...
  9. jwestmore

    Conditional Header Suppression on Drill Down

    Thanks! I read that was possible but couldn't find a resource for how to do it. I'm using CR8.5 Jon
  10. jwestmore

    Conditional Header Suppression on Drill Down

    I have a report that is grouped by: Department, Day of the week, Numeric Sub Group I want the user to open the report, double-click on the department, double-click on the day of the week and then have the detail display with the Numeric Sub-Group above it. In other words, I'd like the Numeric...
  11. jwestmore

    View Question

    Thank you! That worked. Jon
  12. jwestmore

    View Question

    I have a SQL Server View that does a UNION on some other Views in the database. The records in the views I'm referencing are unkeyed and many of the records are identical. When my View does a SELECT from those Views it seems to want to combine the identical records into a single record. Is...
  13. jwestmore

    Using getdate() in a proc

    I'm inserting records into a table on a daily basis from 3 source tables that are updated in real-time. I want to capture records entered between midnight to 11:59pm of the previous day. Somthing like INSERT INTO destination_table SELECT * FROM source_tables WHERE entry_date =...
  14. jwestmore

    Using CASE and IN together

    Hi everyone, I'm writing a short proc and am trying to make my code easier to read by using CASE and IN together: CASE test WHEN IN('a','b','c') THEN '123' WHEN IN('d','e','f') THEN '456' WHEN IN('g','h','i') THEN '789' END Anyone see anything wrong syntactically here? This code generates an...

Part and Inventory Search

Back
Top