Search results for query: *

Hi I am trying to delete a record with rst.delete but Access is not allowing me because of referential integrity. I trap this and I exit the sub. So far so good. bu when I try to do rst.absoluteposition = 5 to move the recordset pointer I get an error saying Row handle referred to a deleted...

Hi What property of a combobox should i use when adding the combobox to a bindingcollection ? i am filling in the combobox with values from a table. The text is getting the "Desc" field and the Itemdata is getting the "ID" field. any ideas pls ? thanks

Hi i have a recordset returning a recordset, in which i have 4 boolean fields. i also have a bindingcollection in which i am adding 4 checkboxes like so colbind.add chkView,"Value","View" no, this line gives me error "invalid property value" All i want is the...

hi I have to following code to fill in a combobox with the items from a recordset. I want to show the Description and use the iD as an idex for each item. The folloeing code gives me an error "Invalid Procedure Call or Argument" on the bold line. If Not rst.EOF And Not rst.BOF Then...

Hi is it possible to pass parameters to the Class_Initialise event of a class ? thanks

Hi I have a class acting as a datasource. In it i have an ADO recordset which i populate with the records from an Access table. I have a bindingcollection on a form and the datasource is set to the class and the recordset is returned as the datasource. Textboxes are then added to this...

Hi I have the following code for adding a new record to a table: (the recordset is an ADO recordset) rstVacTypes.AddNew rstVacTypes.Fields("Ref") = txtRef.text rstVacTypes.Fields("Description") = txtDesc.text rstVacTypes.update on the first line, it's giving me an error...

Hi I have the following code in a Control I made: Public Property Let ShowRecNo(Show As Boolean) If Show Or Not Show Then txtRec.Visible = Show End If PropertyChanged ShowRecNo End Property Before it goes through the line saying "txtrec.visible = show&quot...

Hi Can you get the current procedure name and line number in VB to insert in an error handler ? cheers sergio

Hi am setting up an ADO connection string at runtime and i have a procedure accepting parameters for the commandtype and the commandtext. I have set the commandtype as adCommandTypeEnum so that the intellisense comes up when calling the procedure. how can i check that the passed parameter is...