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

  • Users: jwestmore
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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
  4. 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...
  5. 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
  6. 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...
  7. 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...
  8. 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...
  9. 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 =...
  10. 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