Search results for query: *

Hsitz, thanks for the reply!! Sorry my fault very bad example, I tried to simplify the problem and I screwed up the reason my query is struggling!! Here is the way my data is set up: TableA: MYID RandFld 1 A 2 B 3 A 4 B 5 D TableB: MYID Amount 2...

Sorry my fault very bad example!! Here is my the way my data is set up: TableA: MYID RandFld 1 A 2 B 3 A 4 C 5 D TableB: MYID Amount 2 10 2 20 3 10 TableC: MYID Amount 1 50 2 20 3 60 So, this is...

Hi there, What I want is to obtain summary information only on data in Table A, regardless of any joins with other tables. Normally if you say for example SELECT Sum(TableA.Amount), Sum(TableB.Amount) FROM TableA LEFT JOIN TableB ON TableA.ID = TableB.LinkID, you will get NOT the sum the...

I actually tried your solution, however I need to sum the whole Amount column, so Group By TableA.ID doesn't work for me!! Any other thoughts?!!!

Hi there, What I want is to obtain summary information only on data in Table A, regardless of any joins with other tables. Normally if you say for example SELECT Sum(TableA.Amount), Sum(TableB.Amount) FROM TableA LEFT JOIN TableB ON TableA.ID = TableB.LinkID, you will get NOT the sum the...

Instead of a command button calling an input box you can have a command button call the Find Dialog box (the one with the Binoculars as an icon). Your code would look something like this: Private Sub cmdSearchPart#_Click() Me.Controls("Part#").SetFocus SendKeys...

Does anyone know if Visual SourceSafe is included in VB 6.0 Professional? I have a book published by Microsoft that states that it does, but I can't find it anywhere in the setup for the program and microsoft's site doesn't help much with installations. If anyone can tell me if I'm missing...

Does anyone know how to set focus to the last character of a textbox in vbscript.  For example when a page loads a value will be set in a textbox. Take the word "sample", for instance.  I want to set focus to the textbox and the cursor should appear after the...

Does anyone know how to set focus to the last character of a textbox in javascript.  For example when a page loads a value will be set in a textbox. Take the word "sample", for instance.  I want to set focus to the textbox and the cursor should appear after the...

Does anyone know how to set focus to the last character of a textbox in javscript or vbscript.  For example when a page loads a value will be set in a textbox. Take the word "sample", for instance.  I want to set focus to the textbox and the cursor should appear...

Sorry to get your hopes up if you still haven't solved this problem, but I am having the exact same problem. Could you e-mail if you came across a solution for this!! I noticed it's been a couple of months since you submitted your problem!! My direct e-mail address is...

Hi everybody. I'm looking for some code if anybody knows of any that would run an Active X function when the Print button on the Internet Explorer Navigation Toolbar has been pressed. Sort of like an OnPrint function. I'm able to run the Active X control from a button on the page using...