Search results for query: *

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

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

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

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

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

i've inherited a VB6 application that uses Word95 to generate letters (mail merge). Occasionally word will generate an error (for instance, the merge file doesn't contain the fields required by the document) which requires a response. However this application runs on an unmonitored server so...

I'm using ado controls and pressed F1 on ADODB and got the message 'cannot find msADO10.hlp'.......I can't find it on my machine or on any disk I've got, nor on microsofts sites. Does anyone know where i might get it from?

I'm migrating an old application which used an Access Db with DAO controls to a DB2 database. Firstly I found I couldn't use the original DAO controls as the recordsets were read only (why?). Having changed the controls to ADO I'm now having problems scrolling thru/updating the records...