Hi
I have a web page I need to modify that uses the BulkEditGridView from realworld.grids.dll. Up to now this has done the job.
I need to amend the page slightly and the result is that a drop down list on each row needs a parameter from that row.
Ie, one of the fields is a list of people, but...
Hi
I have a need to take some data and produce a smoothed set of data containing the inbetween values. Rather like a smoothed graph, except I need the values to do some calculations on rather than just display them.
Any common routines I can use to pass a small subset of data and the call to...
Hi
Anyone any experience of using parameter markers in SQL?
Trying to get an ASP app to use these to access a DB2 database (it should be far more efficient than using normal dynamic SQL).
Basically got it working for character fields but I cannot get it to work for numeric fields. For...
Hi
I am getting an "Invalid control array index" error on some code. I am currently unable to recreate the error to check exactly where it is occuring. However I do now know which function it is being produced from.
According to the MSDN the error is caused by using a negative...
Hi
Is it possible to select and copy data from an Excel spreadsheet and then paste it into a grid control of some kind within VB.
I want to transfer some data from Excel to VB, and due to formating and validation it may be easier to paste it into VB first (although I will probably read it from...
Hi
We have a fair size project with about 20 dlls related to it.
A guy wrote a small program to go through the entire project and compile it all up, passing it to the package and deployment wizard.
Generally this works fine
However quite often when we pass it through a routine to get the...
Hi
I m trying to modify a program which has a large 2 dimensional array. This dimensions are the records and then the fields on the records (a CSV file is read into this array).
I can refer to the complete array as vArray() and a single element as vArray(5,5) (for example).
Is there any way I...
Hi
Just had to flatten machine and reinstall, and I am now having a couple of problems.
Firstly when I run any VB code I get a window popping up asking for my source safe userid and password (the code is booked out from sourcesafe). Not sure how to turn this feature on and off
Secondly I have...
Hi
I want to sort out an application for viewing old mainframe 3270 screens in VB, specifically for checking the various BMS map controls.
What I need is a very basic grid. No title lines, no selection of columns (although multiple cell selection would be good), not bound to any data control...
Hi
I want to check and set the Caps Lock and Num Lock keys from within a program. In theory SendKeys will do this, but it doesnt seem to have any effect.
A thread last year dealt with this and the answer is below, but I cannot get this to work either
Dim iRetVal As Integer
' Check the...
Hi
Has anyone any experience in controlling applications which are not set up to be accessable.
We have a 3rd party application which we have no internal documentation for (it is, for all real purposes, a black box). We also have a large amount of data that needs to be typed into this...
Hi
I have a pair of forms that are having problems with the mouse pointer. The first form loads and triggers a logon form. When the user enters the logon details they can either press return or click on the Logon button. One of the first things done is to set the mouse pointer to the...
Hi
I am trying to write a Perl script and I am getting the "Premature end of script headers: " error. Normally this is due to an error in the code, but I cannot get rid of it. I have another script that works, and have copied this and uploaded it with another name. The copy fails with...
Hi
Reading through a mySQL book I have found and want to use the enum data type. However is there a way to retrieve a list of possible values from the database (for example, to generate a drop down list box to select a value on an HTML form).
All the best
Keith
Hi
I have a form in Access which I use to set off a report. If I do this first then it works fine (ie, dont use any other buttons on forms). If I use any of the other buttons then I get the following error message:-
Run-time error '3075':
Function isn't available in expression in query...
Hi
I am working on a Access database. One of the forms allows adding or updating a record, with validation done in VBA. A field on here is a combo box to allow the user to select a member of staff as the contact for this record.
When adding a record this works fine, with the drop down box...
Hi
I am having problems with Access 97. It was working fine before lunch, but coming back up went back into the database I was playing with and it will not load. I get a Dr Watson log generated with the message "Exception: access violation (0xc0000005), Address: 0x65102169".
I have...
Hi
I am new to Perl and CGI programming (OK, week off work and I have been playing). I have a minor problem using Mysql. I am having no problems pulling records from a database, but I cannot see how to pull the results of an SQL function. For example I want to know the latest date that certain...
Hi
I am writing an Access application to read various Excel spreadsheets into a database. These Excel spread sheets are only slightly different (half a dozen ways of reading a spec!), and I have used different subroutines to read them and insert to the table.
This was working fine, but on one...
Hi
I am currently working on an Access app which will take data in from an Excel spreadsheet. It will be stored and processed in Access and later output to Excel again.
I have got Access to read from and create Excel spreadsheets, but it is a bit untidy to close Excel as it asks whether you...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.