Search results for query: *

I have a ObjectDataSource (ods) linked to a GridView (gv) on a web page pulling data from Oracle storred procedures. The defined (corporate) solution involves statically setting properties in the ods and gv and the method is quick and reliable. But I have desktop VB6 code and some 50 SQL...

I have a word template which (when invoked) produces a document with an active X tick box which used to fire an event which ran some code. The tick box no longer fires the event. If I add a new similar tick box to the template then it also does not fire. But if I create an entirely new...

If I have two tables which must be joined, but one of those tables is missing some data then I use an outside join to link the two tables. That way I get data from the first table even when data from the second is absent but I get data from both tables when it is available. My problem comes...

How do I do the following... SELECT A, B, C, SUM(A) FROM X I found the following on an Oracle error site... ORA-00937: not a single-group group function Cause: A SELECT list cannot include both a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, and an individual column...

I recently released the latest version of one of my programs after testing it on numerous PC's. But upon release to some 80 users, 3 get an "Unexpected Error" messagebox followed by the program stopping at startup. I copied the program to a new project and systematically cut it back and cut it...

I have a form with many controls on it including two control arrays. I have recently added a user control which gives me the functionality I want in a special button. The program works fine with just two copies of the user control on the form but when I add a third user control the IDE itself...

I have many users using many PC's (and no one to one correlation of users with PC's). The IT department will distribute my installation script (which installs a Visual Basic program) across the big corporate network (using SMS). The components are stored on a server (so no file copying to...

I used to enumerate errors using something like... On Error Goto ErrorHandler ... ErrorHandler: Call DisplayError Resume ... End Sub ________ Public Sub DisplayError Dim ErrLoop As Error For Each ErrLoop In Errors msgbox ErrLoop.Description Next This still works on an old...

I'm part way through converting my asynchronous DAO's to ADO's and I cannot get the asynchronous part of the ADO to work... This line works... rstHistory.Open SQL1_, conPRS, adOpenStatic, adLockReadOnly But this one does not... rstHistory.Open SQL1_, conPRS, adOpenStatic, adLockReadOnly...

I trap the errors occuring on my user's systems and record err.number etc. in a file so that my programs can be improved. But I would also like to record the subroutine/function and/or module where the error occured. Is there is a way of programmatically discovering which subroutine (or...

I'm part way through converting my asynchronous DAO's to ADO's and I cannot get the asynchronous part of the ADO to work... This line works... rstHistory.Open SQL1_, conPRS, adOpenStatic, adLockReadOnly But this one does not... rstHistory.Open SQL1_, conPRS, adOpenStatic, adLockReadOnly...

I can quite happily deploy Visual Basic applications within our (entirely Windows 2000) company but I would like to understand more. I have started to get to know InnoSetup as it seems more flexible and comes highly recommended. Now the InnoSetup site (amongst others) recommends you do not use...

I have a form with a datagrid on it called frmDataForm. A new instance of this form is created every time I press a button to get data and the data is stored away in the new datagrid on the new form. The form of the creation command is... Dim frmDataForm As New DataGridForm The subroutine...

I'm looking for a column in a large Oracle 8i database which contains certain data so I can write queries to it. I don't know the column name or the table name but I am hoping I would be able to identify the column name if I saw it. The problem is that there are hundreds of tables in the...

I have a program which analyses a section of Excel data using automation to acquire the data from an Excel worksheet. Currently the limits of the data are the top left cell of the sheet (A1) and a cell defined in two text boxes txtNoColumns and txtNoRows. I then use a For...Next loop to...

Are there restrictions on column names in Access ?. In particular can I use a name with a space in it ?. You will have guessed that the data I want to use already has the column names with spaces. I am using automation to add and retreive data from Access and it isn't working; this is one...

In thread220-564239 I got the answer on how to put mutiple rows into one query row. Returning to my original example... Table A: Product Stage Attribute Value Alpha One Height V1 Alpha One Width V2 Alpha One Length V3 Alpha Two Height V4 Alpha Two Width V5 Alpha Two Length V6 Alpha Three...

In my mad rush to convert my Access-based database analysis tool (in Access Visual Basic) to "full" Visual Basic I made mistakes - well there's a surprise. When I prepare the converted project for packaging I see a reference to FM20.DLL which (if my understanding is right) should only...

I would like two different shortcuts on my desktop to run the same VB program but one shortcut to disable one part of the program. In my mind I am thinking of the equivalent of a command line switch but then I am a very old programer. Any ideas how to do this in VB ? Boggg1 [bigglasses]

Is there a way to display more rows when you drop down a standard combo box at run time ? I know in the Office version of the combo box (MSForms version) there is a ListRows property but there is no such thing in the true Visual Basic combo box. The default value of number of rows is 8, I want...