Search results

Thanks Ghudson. :)

Thanks Mile-O-Phile.

Hi All, Is it possible to change the Font Size of the text displayed in a message box? Thanks Ant

I have a command button on a form which deletes records. Not sure if it possible, but was wondering if when the command button is clicked if there are related records to have a custom message box saying it cannot delete the records and telling them to delete the related records first and...

One more thing, what is the Err_ for, is it error trapping?

I See. Thanks

Thanks Again Mile-O-Phile. Whats the difference between Me! and Me. ?

Hi Mile-O-Phile, It now works great.:D I added a bit to the code you gave, not sure if its the way i should have but it works anyway. It now Looks like this:- Private Sub DeleteActivity_Click() On Error GoTo Err_DeleteActivity_Click If Me.List3.Column(11) = vbNullString Then Dim...

Thanks Mile-O-Phile it works fine.:D However if i add before that code:- If isnull ([List3].column(11)) then if wont work even though Column(11) is empty. Any Ideas? Thanks Again Ant

Hi All, Attached is a copy of my database. If anyone can give me help its greatly appreciated. Thanks Anthony

Am a bit unsure where to post my database. Where would you recommend? Thanks Anthony

Selecting Cascading Deletes has unfortunately again not worked. Stumped! Ant.:confused:

Okay got ya. I have one Primary Key made up of the Above four fields. However it is a foreign key in this table.

Copied and Pasted the code but no luck unfortunately. What did you mean by composite key?

Hi All, I now get the message:- Error Cannot Delete this Record ? Ant

Hi jon, Thanks for replying. Tried that and it asks me to confirm that i would like to delete the Row, but when i click yes it does nothing. Any Ideas. Maybe it would need to be added into the SQL somewhere? Regards Ant

Yes 4. Learn_id Provi_id Lprog_id Lacti_id

Command Button Code Help I am working in Access 2000 and currently I am trying to delete a row from a table by using a command button. The row to be deleted depends on an item selected in my list box. Command button is named:- cmdDeleteActivity ListBox is named:- List3 This is the code I...