Recent content by NiallWestland1974

I've had a similar problem. After reading a few discussion forums, where installing service pack 2 was mentioned, among other things, I finally got to the bottom of the problem, in my case at least. The scheduled DTS was executing at 8pm - the same time as the Veritas back-up for the server...

Thats it! The Dim rst As DAO.Recordset Did the trick - thanks Ken - it never even occurred to me that there would be some confusion with the declaration of the recordset without declaring which library it used. Many Thanks Niall

D'oh! Rookie error :-) Mind you, still getting the "error 13 - Type MisMatch" error, with rst=Nothing in the debug window..

Hi All, I'm trying to populate a recordset from a simple query, but I keep getting Type MisMatch (error 13) errors.. Anyone have any idea what the problem is, and how to solve it? Dim dbs2 As Database Set dbs2 = CurrentDb Dim rst As Recordset Dim qry As QueryDef Set qdf...

Hi, I'm doing something along the same lines I guess. One form, that feeds into two separate tables. The problem is that the autonumber of the new record from one of the tables is needed as a foreign key in the second table. But when you create a new record in the first table, the autonumber...

D'oh - I have the caption problem sorted out - by looking for labels rather than textboxes, the code above basically works: For i = 0 To Me.Count - 1 If TypeOf Me(i) Is Label Then If i = 1 Then AlterTextBox = "Date altered: " & Now() & " - " & Me(i).Caption Else AlterTextBox...

Hi, I'm trying to dynamically capture the captions of the forms contained in a form and, in addition, set the onchange property of these controls dynamically through VBA. Does anyone have any ideas on how to solve either (or even one!) of these problems?? The (faulty!) code is: For i = 0 To...