Search results for query: *

Hi, I have an MS Access 2000 .adp that makes use of SQL Server 2000 backend. Historically the application has worked fine. Recently I added a new continuous form that is bound to a stored procedure. The form has a combo box at the top that enables users to specify which fields in the form...

Hi, I developed an .adp that is being used by 270 people. Each time somebody connects to the database via the application I see 2 or 3 connections for each person. The .adp has a number of forms that are bound to SQL Server stored procedures. The application also uses ADO to execute stored...

Hi, I have a form that is bound to a row in a SQL Server table. The form contains text boxes that are used to store values for each column in my row. The form also has an "Add New" button which, when pressed clears all the text boxes so that users can populate the text boxes with values for a...

Thanks for your advice. I neded up manually binding the event handler to the event just before the load event had completed and after the data binding had taken place. i.e I did the following: this.cmbAreaOfSystem.SelectedIndexChanged += new...

Hi all, How can I set the color property of a button column in a dataviewgrid control? I have dynamically added my column as follows: DataGridViewButtonColumn b = new DataGridViewButtonColumn(); grid.Columns.Insert(0, b); I can set text properties by doing: b.Text = "Edit"; etc.... but...

Hi all, I am new to C# windows forms and have a basic question. I have a form which contains a datagrid. The datagrid is bound to a stored proc that takes 4 parameters. In the Load event I do a one time initialization of the 4 parameters. Each of the 4 parameters comes from the selected...

The problem with your solution is that in the future my recordset might increase significantly in size (to say 200,000 records) in which case I would need 4 recordsets. I would much rather use one SQL stored proc to return all the data I need and then tackle 60,000 records at a time. Cheers, Kabir

I am trying to export data from SQL server to Excel via my VB interface. I execute my stored procedure and it returns 100,000 records. Since Excel only allows 65535 records per worksheet I export the first 60,000 records from my recordset and then want to export the remaining 40,000 in the...

Hi all, I have an ADO recordset that contains about 100,000 records. Is it possible to delete the first 60,000 records from this recordset using one command? At the moment I am using the following: For intX = 1 To 60000 rs.Delete adAffectCurrent rs.MoveNext Next The above is very...

I have recently upsized an Access database to SQL Server. The .adp is for the most part working fine. However, when an end user tries to create a duplicate record in one of the Primary key columns of a Form he gets a SQL Server error message as follows: "Violation of Primary Key constraint...

"Field 'F1' doesn't exist in destination table 'tablename.'" I hate this error message. I am using the following command to load data from an excel spreadsheet into a backend SQL Server database via an .adp: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel7, sTempTable, strFileName...

I recently upsized an Access database to SQL Server 2000. All of the Access tables, macros and queries have been migrated and the application works fine. I have now been asked to implement security so that different people have different access permissions in the adp. Specifically, I would...