Recent content by anandsbr

First parameter is optional. That's why i did not use. Syntax is InStr([start, ]string1, string2[, compare])

Sorry.. Code written in Visual Basic 6.5

Just a note that rowsource is 'Select a,b,c,d,e from table a Where a = 3. so need to find SQL data not typed data in the listbox.

Hi, I have a bound listbox which displays data from query based on user's selection. I would like to add a provision to search any type of data within the listbox and highlight/select if present. For that I have provided a textbox and command button. User can type in any value in the textbox...

Here it is qptQCSelect SQL is ------- SELECT * FROM AlertSelect_UI_V WHERE 1=2 AlertSelect_V SQL CODE is -------- /****** Object: View [dbo].[AlertSelect_UI_V] Script Date: 01/29/2010 08:27:16 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO Create view [dbo].[AlertSelect_UI_V] AS...

Bob, I am using ADO connection and here is the code for connectivity. 1) Form frmstartup is being called first which in turn calls form frmDBSelect to get db information. 2) code in Form frmDBselect is... Code ----- Option Compare Database Option Explicit Private Sub cmdOK_Click()...

Please help..

No, It does not work. It was a typo but in the code it starts with ODBC. I tried removing and still it prompts me to give .dsn name.

Oops, It is ODBC;DRIVER=SQL Server;SERVER=<<server>>,<<port>>\database;DATABAS E=<<database>>;Trusted_Connection=Yes" Also I tried removing ODBC part from the connectionstring but it would not work meaning it still prompts me to choose dsn name.

Hi Now, I have added and bound the column to checkbox control. but am unable to check/uncheck the column as it says record is not editable. Reason could be datasource of the form is query called "qptQCselect". The description of "qptQCSelect" is select * from AlertSelect_V. Here...

Hi, I am unable to change the DRIVER to SQL Native Client 10 as when I try to connect, it prompts for dsn name which I do not have. I use ADO.NET for connectivity. I also checked connectionstring.com website where they have given all sorts of connectionstrings for each connectivity. Nothing...

Please see my reply below. Windows XP Professional. This is connectionstring is being used to connect. DBC;DRIVER=SQL Server;SERVER=<<server>>,<<port>>\database;DATABASE=<<database>>;Trusted_Connection=Yes"

Hello, I have an Access Database 2007 that is linked to our SQL Server 2008. In my MSA I have a Form that has recordsource which is view. User can update his userid so far without any issues. Now I have selected a new column in the view which already exists in one of the main table. since...

Thanks for the quick reply. The data source of the form is view, so i had added a dummy column with space as value. (' ' as qcselect). I bound the checkbox with the dummy column. Now the issue when I preview still all checkbox is selected and when I try to uncheck it says it is not editable. I...

Guys, I am new to MSAccess programming so need some help here. I have a form where data is being displayed and currently user choose any row and assign to a investigator. This is very time consuming so they want mass select or random select and assign it a investigator. I tried to provide...