Where is the declaration exactly? And a few more q's.
1) I assume the declaration is in a bas module (not Form module), yes?
2) Is the same rst object used to hold different recordsets across multiple forms?
3) Could you post the Form_Load and Form_Activate code?
4) If you write an error handler in the form_load that looks something like this, what is written to your c:\\myerrors.log file?
Form_Load()
On error goto Load_Err
...
Load_Exit:
Exit Sub
Load_Err:
' I don't remember if DAO has an errors collection or not, but I think it does.
' If it doesn't, strike out the errX stuff below
Dim hFile as long
Dim errX as Error
hFile = Freefile()
Open "C:\\MyErrors.log" for Append as #hFile
Print #hFile, Err.Description
For Each errX in DAO.Errors
Print #hFile, errX.Description
Next errX
close #hFile
Resume Load_Exit
bcnu,
Mikem
Eine Leute. Eine Welt. Ein F\ufffdhrer.
(Just trying to be accepted in the New America)
Edited by
mmoffitt
Dec. 30, 2004, 12:40:15 PM EST
Where is the declaration exactly? And a few more q's.
1) I assume the declaration is in a bas module (not Form module), yes?
2) Is the same rst object used to hold different recordsets across multiple forms?
3) Could you post the Form_Load and Form_Activate code?
4) If you write an error handler in the form_load that looks something like this, what is written to your c:\myerrors.log file?
Form_Load()
On error goto Load_Err
...
Load_Exit:
Exit Sub
Load_Err:
' I don't remember if DAO has an errors collection or not, but I think it does.
' If it doesn't, strike out the errX stuff below
Dim hFile as long
Dim errX as Error
hFile = Freefile()
Open "C:\MyErrors.log" for Append as #hFile
Print #hFile, Err.Description
For Each errX in DAO.Errors
Print #hFile, errX.Description
Next errX
close #hFile
Resume Load_Err
bcnu,
Mikem
Eine Leute. Eine Welt. Ein Führer.
(Just trying to be accepted in the New America)
