Search results for query: *

George, I copied the code, paste it in Query Analyser and ran it. it worked absolutely perfectly. My figures are correct and I did not have to change any syntex. I can't thank you enough. I had about a dozen people looking at this and no one gave me the correct answer. Thanks lots.

Thanks George. I have tried that but unsuccesfully. Here's what I tried to do. When I run this it says Invalid object name blahtable. I tried without (), etc... and can't get the syntex right. Any ideas? Please look in the code inclosed with *'s SELECT LBTRMATR.PROJECT_NO, max(LBBALCDE.Name) As...

I would be grateful if someone could help me out with this. I have a sql statement (see below) which is dynamically built from vb. The sql works perfectly exept one line marked with *** SELECT LBTRMATR.PROJECT_NO, max(LBBALCDE.Name) As BalName, '' As LedgerId , max(LBTRMATR.USER_ID) as...

Thanks strongm...I've used the SelStart before but didn't realise it would apply in this case....doh![sleeping2]

Found what I was looking for....api SendMessageByNum does the trick. If anyone else is interested I found it here... http://www.developerfusion.co.uk/show/1161/

Thanks Swi for your response....I'm editing some old code thats not that flash using an array of text boxes. So I don't want to change the control type in case it causes more problems than it solves!....any other ideas? I was hoping there might be an api?

Hi all, I have various textbox's where users can input a number. Using one as an example of my problem... I want to limit the input of a percentage to upto 99.99. I know I can add validation after the users entered a value but I'm trying to be a bit smarter and not allow an invalid value to...

Thanks for your suggestions guys I've found @@Identity does work. I've tested with other users creating records after I do and before I run the @@Identity statement and it still returns the correct ID.. Thanks again and a star for you

I wish to retrieve the identity of a record I've just previously written (using ADO to MS SQL 2000 DB). Like this.... (table TEST_TABLE has an identity column) sSQL = "INSERT INTO TEST_TABLE (TESTFIELD1 ) " sSQL = sSQL & "VALUES(?)" Set oCommand = New ADODB.Command Set...

Thanks TipGiver....I've given you a star

Hi all, I've converted an application from VB6 to .net and I'm slowly resolving the issues raised. The VB6 code stores the current TopIndex of a combobox so that later the combobox can be redisplayed with the same item positioned at the top. However there doesn't seem to be an equivalent in...

Has anyone had experince with using DLL redirection as a way of solving the DLL Hell. I've only recently become aware of it and was wondering whether it works (on W2000 +/or W2003) and what the problems are (if any).

A template usually has a suffix of .xlt. I sugest you open you workbook and save as xxxx.xlt (making sure the type is 'template'), and change your code to open this file. You should find Excel will then open a workbook named Book1.xls based on your template. Even if auto save is on it won't...

Hi Brian, thanks for your response. Unfortunately what you suggest is'nt any good for this app as some of the workbooks the user's have open need to have the ability to be closed. If only one of these is open then it wouldn't allow the workbook to close. Is there no way of stoppping the...

Using a VB app I launch Excel + populate/display a workbook. All works fine if the user closes the workbook then displays another workbook (from witin the VB app)..BUT if the the user closes the Excel application, subsequent workbooks are not visible (although the frame of excel is visible and...

I suggest you try using the MSFlexgrid control which as the name suggests is more flexible than the DBGrid. Take a look at this faq222-3262 Towards the end it specifically deals with overlaying cells with controls such as a combo box Good luck

Here's another site to try http://www.mentalis.org/apilist/apilist.php

I have an app (VB6) which instantiates Excell and creates/displays a workbook to the user via a button. The problem I have is if the user closes Excell the app still works (i.e. the user can recreate a workbook using the button) but any subsequent workbooks created are not visible. The...

I'm embeding a template (.dot) into a document (.doc) by opening the document, selecting Insert/Object/Create from File, selecting the template, and selecting the 'Display as icon' option. This inserts the template OK, displaying as an icon. However when the user opens the document and views the...

Hi John, The problem is Vb hasn't generated an error. VB has instantiated a version of word and word has generated the error...meanwhile the Vb app is still waiting for word to complete...here's a copy of the code: (fields such as txtLTPMNL have been retrieved earlier in the code)...