Search results for query: *

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

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

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

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

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

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

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

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

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

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

Thank you! That worked. Jon

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

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

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