Search results for query: *

I am new to ADO.NET. I wish to know how to set a DataRelation object so that; If a row in the Parent DataTable be deleted, the corresponding rows in any Child DataTable objects are also automatically deleted. If the value of the primary key field in the parent row is modified, the change...

I tried the solution for "Adding ComboBox to DataGrid control" posted on 16th. November. I could not understand the DataGrid part of it. I dropped a DataGrid control & a ComboBox control on the form at design time and populated them with data at run-time. Both the controls are displaying data...

After installing Microsoft .NET Framework 2.0 on top of Microsoft .NET Framework 1.1, how can I use the later Framework version, in my already installed, VB.NET 2003 programs instead of the earlier one? Any advice will be appreciated. R. A. Abbasi

I tried the expected GetUpdateCommand method of the CommandBuilder object to retrieve the Update Query generated by the object. But, it just returns the fully qualified name of the object ("System.Data.OleDb.OleDbCommand"). I could not find any other way. If anyone can let me know, how can I get...

The following procedure does not Update the record(s). '--------------------------------------------------------- Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click Dim dadapter As OleDbDataAdapter = New OleDbDataAdapter...

The following procedure (refined from the previous one) still does not actually commence the InsertCommand property to physically insert a row into the DataSet. '--------------------------------------------------------- Private Sub btnInsert_Click(ByVal sender As System.Object, ByVal e As...

I retrieved the following function from VB.NET help and added a few statements for updating the datasource. But, it does not actually commence the InsertCommand property of the DataAdapter in order to physically insert a row into the DataSet. Please help...

I could not find any code related to the file operations, including copying, moving, deleting and/or setting the attributes etc. Any help is highly appreciated. Abbasi

One of the requirements of my project is that a report should print a Bar Chart, based on a query. The related query has the following fields: ItemCode, Quantity_received, Quantity_delivered, and the Date. The report should depict the number of transactions over a period of time, chosen by the...

I am trying to use a Modal Form inside a procedure for collecting some user-specific information (say, Username/password, for example). I expect it to function in a way that unless a user clicks 'OK' or 'Cancel' button (that is unless that form gets closed), the execution should not pass on to...

One of my forms open a report as below: DoCmd.OpenReport "rptTest", acViewPreview, "Order By '" & strIDNum & "'", strCriteria, acWindowNormal The strIDNum is read from a textbox, in the form, with no problem. The strCriteria is a string working fine. But the report does not Order the result...

I want to assign a value, from a textbox in a form, to the textbox in the PageHeader of a report. I have tried many variations of the following syntax, but all failed: Me.Section(acPageHeader)!txtSupplier= Forms!frmCriteria!cmbSuppliers Seeking help.

One of my routines calls a number of functions, each of which return True in case of 'Succes' and False in case of 'Failure', as below: Private Sub SubXmple() Obj.Begin Trans if Update_tblA = False then Goto lblRollback ....... if Update_tblB = False then...

Using the same Access database, shows different behaviors on righ-clicking the Subform on different PCs. On Some PCs, it displays the context-sensitive menu for 'Filter' and 'Sort' options but on others, it does not. I could not find any option, which can enable this feature - a very elementary...

Is it possible to restrict Deletion to One record only in a Subform (datasheet view), that is disallowing user the multiple-selection of records. The ultimate purpose of this action is recalculating the totals etc. affected by the deletion of records.

I have a Datasheet bound to a table. I want to update records in another table, each time when the user leaves a Row (a record) of the Datasheet and enters into another row.

I created a Workgroup file (Project.mdw), assigned different Permissions to different Groups, and put different Users in appropriate Groups. The above setup is working fine and just as required. But, if I remove or rename the Workgroup file, MS Access does not look for it, creates in its own...

While processing a series of database tasks - like inserting, deleting and updating a number of records at one time, MS Access presents a dialog box for each of such operations asking to confirm, every time. How to snub these dialog boxes to appear.

I can Not find any "Password Character" property, in MS Access 2003, for my TextBox, which is used for entering the password. Any help please!

How to occess another table for reading and matching the values, while working with a MS Access Form, which is already bound to a table. A tip on this issue will be highly appreciated.