Search results for query: *

Hi, I am using VB.NET 2010 and the datagridview control. When I set the selectionmode property to fullrowselect and the rows are displayed the first row is automatically highlighted. I understand that this may be default behaviour for the datagridview control but is there a way to stop it? I...

Hi, I am using VB 2005, ASP.net 2.0, javascript, and a gridview. I have these quotes listed in a gridview and I would like to be able to double click on a row to open one. I can trap a double click on the gridview in javascript but I can't get the gridview's selected row in the javascript...

Hi, I have a form in an ActiveX DLL project and a form in a standard EXE project. Is there a difference in any way between the two in making the form visible? In a standard EXE I would use: form1.show In an ActiveX DLL I would have a class' method to show the form. The reason I ask is aside...

Hi, I am trying to retrieve the property values for a passed object. I am using the typelib example from a thread here which allows me to get the property names but I receive an error when trying to get the property's value. Thanx in advance. Dim Obj As New class1 Dim myTLI As...

Hi, I have a VB6 user control that has 3 class modules (PublicNotCreateable, notpersistable) in it. clsDropDown: has a collection in it of clsListItem objects. clsListItem: simple data holder clssupercollection: embellishment of VB collection In the user control when a command button is...

Hi, I am using VB6 and ADO to try to connect to a dbase file. I have included the ADO reference in my VB project. I am using the correct connection string (took it from here), my dbf file is where it supposed to be but I receive a driver error. I have connected to Access and SQL Server DBs...

Hi folks, I am trying to implement a 3-tier solution in VB6. I partially understand the concept of a 3-tier app but I wanted to confirm/correct my assumptions about what each tier, CODE-WISE, is supposed to do and not do. Here is how I understand a 3-tier solution: 1st tier (client)...

Hi, I am a VB6 object oriented DB programmer so I already know of all the benefits from an OOP solution BUT I wanted to know if it is still a good idea to use a VB6 OOP approach for an IIS 5 scalable web application? The reason I ask is I heard session variables work badly when trying to...

Hi, Normally, I would use an IIS 5 app with an SQL server backend. Of course, using an IIS app the webpages have to be created using HTML/XML etc. My question is can I use VB6 forms and still make a multi-user web-based app? I'm thinking not but I am curious... Have a good one! BK

Hi, I am using IIS 5 and VB6. I want a timer event to be started once in my app and continue to fire at the specified interval for as long the website is running. I tried enabling the timer in the WebClass_Start as well as Initialize events but it didn't work. The question being in which...

Hi folks, I have started to take an old app and convert it to a VB6 app. This converted VB6 app uses a DAO 2.51/3.51 data control as well as DAO code. I want to be able to connect to an Access2000 db without a whole slew of changes especially to the code. I was able to change the datacontrol to...

Hi folks, I have created a user control which has worked fine and dandy in a couple of previous projects. It was created and its compatibility was set to PROJECT. I have started a new project and remade the control with binary compatibility but it gives me an error when my project is...

Hi folks, I want to apply a filter to a form when it opens but in the help it says the filter property is ignored by SQL 7. I tried using the serverfilter property but it crashed Access. I tried using the access method of docmd.openform "frmname",,,,"WHERE fldname=crteria&quot...

Hi folks, Can a view be used in an .ADP form's recordsource, in which the form is used to add new records to the underlying tables? When I use DoCmd.GotoRrecord ,,,acNewRecord I receive an error message, "Can't go to specified record" Thanx in advance. Have a good one! BK

Hi folks, I have a yes/no field which is considered to be a bit type in MSDE (SQL Server 7.0). I have it in a select statement in a view but I get the error that the yes/no field is invalid since it is not included in the GROUP BY clause. When I include it in the GROUP BY clause it says you...

Hi folks, Can a user defined function written in a module be ysed in a SQL 7.0 statement? For example: "SELECT tblA.*, GetCity(tblA.[strZip]) FROM tblA" Thanx in advance. Have a good one! BK

Hi folks, Can I join a table or view to a view in a SQL 7 statement? ViewA would be a select query returning a recordset. For instance: TableA LEFT JOIN viewA If it is possible please provide the statement's syntax. Thanx in advance. Have a good one! Keith

Hi folks, I have an Access query (qryCOA) containing a table left joined to another Access query (qryAccountBalance). I want to convert qryCOA into SQL 7. How do I do it? Thanx in advance. The following is the SQL of the 2 Access queries: qryCOA: SELECT tblChartOfAccounts.ID...

Hi folks, I have 3 fields: strCity, strState, strZip. I want to concatenate them using a CASE in the folowing SQL 7 statement. I assumed TRUE is the return value from the isnull()function? I get an error of TRUE being an invalid column name. Thanx in advance. ======================== SELECT...

Hi folks, I am converting Access queries to SQL 7.0 statements. In an Access select query I have a reference to a control on a form. How do I convert the query to a SQL 7.0 statement? Here is the query: Thanx in advance. SELECT DISTINCTROW tblCustomerContactDepartment.strDepartmentName...