Recent content by dom_donald

This is what i get trying to delete that record with your code pasted in (see attached)

thanks for looking at this - I've just pasted that code in (in fact, i'd tried exactly that before posting here, expecting that to be the solution) but it didn't work for me. I don't get the programmer-specified msgbox, just the system one. Does this work on, say, deleting translator 35...

that would certainly be a workaround I'll consider, so thanks ;) BUt I can't help being slightly surprised there's not an obvious way of trapping these expected errors :( So i'll just go away and cry for a bit :D

i'd love to :( But I don't want to permit the deletes under those circumstances i.e. I don't want to cascade deletes. Sorry for being a PITA ;)

hi, open the FT_Summaries form and go to the 'Translators' tab. Try selecting a row using the record selector then clicking the trashcan button. The system displays an error (which is correct) but i want to catch this error myself to display something sensible. Admittedly my code's a bit...

Could do.. it's only a string, not a field. Don't think this affects the original problem :D

yeah, I understand what you're saying, but I've put this code (or similar) in the OnError event for both the form and the subform. However, it's the VB code that's deleting a record from a recordset derived from the appropriate table. Set rst = dbs.OpenRecordset("SELECT * FROM Translators WHERE...

thanks.. not sure entirely how to use this in my case. I have a sub-form in datasheet view. The main form has a button which deletes the selected record from the subform when pressed. I've tried putting the onError event for both the form and the subform, but this makes no difference...

Hi, I've searched the forums but can't find the specific answer I'm looking for - so i apologise if someone else can find it! I've got a db with various relationships that enforce referential integrity. It works fine.. until the point where I try to delete a record from a table using VB code...

OK, I've searched the forums again and found the answer I was looking for i.e. i've done it all wrong :) :D

ok, now i think i am accessing my arrays with the wrong syntax :( Hmm I'll faff around for a bit more! :D

hi.. i'm having a problem with some VB code.. i'm trying to add some controls to an array of controls so that I can later manipulate them more easily. But when i've initialised the arrays with the controls, i have problems setting some of the properties of those controls. When i try to view the...

More detail please :)

Hi, the code is the following (at least one method!), using the "Surname, Forename" format: Dim Name_Str As String Dim Comma_Pos As Integer Dim Surname As String Dim Forename As String Comma_Pos = InStr(1, Name_Str, ",", vbTextCompare) Surname = Mid(Name_Str, 1, Comma_Pos - 1) Forename =...

erm.. ok, I think i got what you're saying although it's not very clear to me. Are you saying that I should introduce another table to hold the information about the staff who are assigned to Tasks, indexed by the Task Id? (see attached). But this way, I don't have any fields in the Tasks...