'Method 'Value' of object '_AccessField' failed
From: Daniel (anonymous_at_discussions.microsoft.com)
Date: 02/26/04
- Next message: Len: "Access vs VB ado"
- Previous message: Jerry: "Custom Data Provider for .NET"
- Next in thread: Val Mazur: "Re: 'Method 'Value' of object '_AccessField' failed"
- Reply: Val Mazur: "Re: 'Method 'Value' of object '_AccessField' failed"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Feb 2004 11:01:09 -0800
What's this error and how do I get rid of it ?
This error occurs at random times and mostly under Access Runtime (XP Running on Win2K SP4)
Here's the SUB:
Sub RecalcStr(frm As Form)
If frm.Dirty Then frm.Dirty = False
Dim tbl As New ADODB.Recordset
tbl.Open "Select * From dbo.ItemDimWgt(" & frm!ID & ")", CurrentProject.Connection, adOpenStatic, adLockReadOnly
frm!UnitWeight = Nz(tbl!NewWgt) <------ Here
frm!Dimensions = Nz(tbl!NewDim) <------- And Here
tbl.Close
End Sub
The desperate :-(
- Next message: Len: "Access vs VB ado"
- Previous message: Jerry: "Custom Data Provider for .NET"
- Next in thread: Val Mazur: "Re: 'Method 'Value' of object '_AccessField' failed"
- Reply: Val Mazur: "Re: 'Method 'Value' of object '_AccessField' failed"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
