Search results for query: *

thanks CClint...it worked with cancelupdate.

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...

thanks guys. i used a datacombo and i set its rowsource, rowmember, listfield and boundcolumn properties and it worked perfect. cheers sergio.

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 ZOR, thanks for the reply. Yes my field is an autonumber and I did use a recordset to populate the combobox and it worked. so far i knew how to do it. My problem is that I am adding the combobox to a bindingcollection and where I have the code .add cmbVacTypes, "ItemData&quot...

Yes but I am not using the datacontrol and I don't want to coz i prefer doing things myself in code. any other suggestions please ?

Ok CClint, it worked for filling up the combo box. thanks. However, I need to add the combo box to a bindingcollection. when i try adding the Itemdata property it gives me an error "Need property array index". should I bind the listindex instead, but I think it won't be right...

yeah, good thinking. thanks but how can i set the index to the ID from the table ? because i need to use that index while saving. thanks

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...

i thought so ok thanks. i'll check that out.

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

thanks. your help solved it. I did read that article but I just couldn't understand what was wrong. maybe coz it was so early in the morning (or late at night) that i wasn't seeing well. thanks again. by the way, have you ever had the error "field not updatable" ? I have a...

yes i do. the textboxes change and show the changed info of that particular record so that's ok. the problem is that when i click on movenext just after loading the form it's ok. when i do it after i edit something they do not 'move' with the recordset. i tried resetting the datasource of the...

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 Regarding the field type, does it make any difference ? because the error was returned on the first line and even when I removed rstVacTypes.Fields("Ref") = txtRef.text it still gave me the error. Anyway, the field type is 3 (autonumber in the access database) The problem is that...

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...

i have it because i thought that a user might pass any value seeing that it's a public property. but now i removed it and it's working. cheers. sergio. by the way, do you have any idea how to check that a user actually passed what was intended as paramter. for example, I have a sub...

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...

strongm, do have an idea of how to stop that. i was thinking of checking that the return was one of the constants of the enum type. But that would defy the purpose coz i would still have to know the constants and write them down. thanks sergio.