Search results

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

Bingo! Just what I wanted thanks.. as it turns out I don't want to allow multiple selections, but that's an easy tweak.. :)

Rich - I need 4 fields because I wish to assign between 1 and 4 different staff members to a job. Trouble is, I may only assign one staff member, with the others being blank. The difficulty comes when trying to append a record to the 'Tasks Table' when some of the staff member fields are blank...

OK, I don't know if i'm being completely stupid here, but here goes anyway :) : I have a table containing a list of 'Tasks'. For each Tasks, you can specify between 1 and 4 'staff members' who are working on it. Therefore I have 4 fields in the Tasks Table, Staff_1, Staff_2, Staff_3 and Staff...

Many thanks for the reply - I had a feeling there'd be a bit of faffing around :) i'll give it ago just as soon as my boss isn't looking... this is just a little side project you see :p

Hi, do you know any access vb at all? :) I don't know how you'd do it without although i'm sure there's a simple way :D