Hi,

I'm fairly new at VBA programming. I have run into a snag.

I want to use code to save edited data from unbound text boxes. The
following code fragment causes an error when I try to compile the module.

Error:
"Compile Error, Method or data member not found"

Code:
With SdrInfo
'
.Edit <----------- Debugger highlights this line

What is SdrInfo? Is it a recordset?

"CityGuy" <(E-Mail Removed)> wrote in message
news:BFEA0D76-FA8E-4A66-9271-(E-Mail Removed)...
> Hi,
>
> I'm fairly new at VBA programming. I have run into a snag.
>
> I want to use code to save edited data from unbound text boxes. The
> following code fragment causes an error when I try to compile the module.
>
> Error:
> "Compile Error, Method or data member not found"
>
> Code:
> With SdrInfo
> '
> .Edit <----------- Debugger highlights this line
> .
> .
> .
> .Update
> With End
>
> I have used this code before with success, but now it won't
> compile and I am not sure why. Can anyone help me with this?
>
> Thanks in advance.

Hi,
if SdrInfo - is ADO recordset - then you don't need to call edit method,
just comment this line out

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com


"CityGuy" <(E-Mail Removed)> wrote in message
news:BFEA0D76-FA8E-4A66-9271-(E-Mail Removed)...
> Hi,
>
> I'm fairly new at VBA programming. I have run into a snag.
>
> I want to use code to save edited data from unbound text boxes. The
> following code fragment causes an error when I try to compile the module.
>
> Error:
> "Compile Error, Method or data member not found"
>
> Code:
> With SdrInfo
> '
> .Edit <----------- Debugger highlights this line
> .
> .
> .
> .Update
> With End
>
> I have used this code before with success, but now it won't
> compile and I am not sure why. Can anyone help me with this?
>
> Thanks in advance.

Hi,

Sorry, SdrInfo is a recordset. I open it with

Set db = CurrentDb()
Set SdrInfo = db.OpenRecordset("tblSdrInspectionInfo", dbOpenDynaset)


"John Spencer" wrote:

> What is SdrInfo? Is it a recordset?
>
> "CityGuy" <(E-Mail Removed)> wrote in message
> news:BFEA0D76-FA8E-4A66-9271-(E-Mail Removed)...
> > Hi,
> >
> > I'm fairly new at VBA programming. I have run into a snag.
> >
> > I want to use code to save edited data from unbound text boxes. The
> > following code fragment causes an error when I try to compile the module.
> >
> > Error:
> > "Compile Error, Method or data member not found"
> >
> > Code:
> > With SdrInfo
> > '
> > .Edit <----------- Debugger highlights this line
> > .
> > .
> > .
> > .Update
> > With End
> >
> > I have used this code before with success, but now it won't
> > compile and I am not sure why. Can anyone help me with this?
> >
> > Thanks in advance.
>
>
>

I should also add that SdrInfo references a table residing on the
back end of this database

"John Spencer" wrote:

> What is SdrInfo? Is it a recordset?
>
> "CityGuy" <(E-Mail Removed)> wrote in message
> news:BFEA0D76-FA8E-4A66-9271-(E-Mail Removed)...
> > Hi,
> >
> > I'm fairly new at VBA programming. I have run into a snag.
> >
> > I want to use code to save edited data from unbound text boxes. The
> > following code fragment causes an error when I try to compile the module.
> >
> > Error:
> > "Compile Error, Method or data member not found"
> >
> > Code:
> > With SdrInfo
> > '
> > .Edit <----------- Debugger highlights this line
> > .
> > .
> > .
> > .Update
> > With End
> >
> > I have used this code before with success, but now it won't
> > compile and I am not sure why. Can anyone help me with this?
> >
> > Thanks in advance.
>
>
>

Hi,

Thanks for the tip. How does one know if a database is an ADO or DAO.
I still find the differeneces between these 2 confusing.



"Alex Dybenko" wrote:

> Hi,
> if SdrInfo - is ADO recordset - then you don't need to call edit method,
> just comment this line out
>
> --
> Best regards,
> ___________
> Alex Dybenko (MVP)
> http://alexdyb.blogspot.com
> http://www.PointLtd.com
>
>
> "CityGuy" <(E-Mail Removed)> wrote in message
> news:BFEA0D76-FA8E-4A66-9271-(E-Mail Removed)...
> > Hi,
> >
> > I'm fairly new at VBA programming. I have run into a snag.
> >
> > I want to use code to save edited data from unbound text boxes. The
> > following code fragment causes an error when I try to compile the module.
> >
> > Error:
> > "Compile Error, Method or data member not found"
> >
> > Code:
> > With SdrInfo
> > '
> > .Edit <----------- Debugger highlights this line
> > .
> > .
> > .
> > .Update
> > With End
> >
> > I have used this code before with success, but now it won't
> > compile and I am not sure why. Can anyone help me with this?
> >
> > Thanks in advance.
>
>

Your code should be something like:
Dim db as DAO.Database
Dim SdrInfo As DAO.Recordset
Set db = CurrentDb()
Set SdrInfo = db.OpenRecordset("tblSdrInspectionInfo", dbOpenDynaset)

This code explicitly uses the DAO library which has been around in Access
for more years than ADO. DAO IMHO works best for Access tables.


--
Duane Hookom
MS Access MVP

"CityGuy" <(E-Mail Removed)> wrote in message
news:9DA19ACB-AC75-4939-A5CE-(E-Mail Removed)...
> Hi,
>
> Thanks for the tip. How does one know if a database is an ADO or DAO.
> I still find the differeneces between these 2 confusing.
>
>
>
> "Alex Dybenko" wrote:
>
>> Hi,
>> if SdrInfo - is ADO recordset - then you don't need to call edit method,
>> just comment this line out
>>
>> --
>> Best regards,
>> ___________
>> Alex Dybenko (MVP)
>> http://alexdyb.blogspot.com
>> http://www.PointLtd.com
>>
>>
>> "CityGuy" <(E-Mail Removed)> wrote in message
>> news:BFEA0D76-FA8E-4A66-9271-(E-Mail Removed)...
>> > Hi,
>> >
>> > I'm fairly new at VBA programming. I have run into a snag.
>> >
>> > I want to use code to save edited data from unbound text boxes. The
>> > following code fragment causes an error when I try to compile the
>> > module.
>> >
>> > Error:
>> > "Compile Error, Method or data member not found"
>> >
>> > Code:
>> > With SdrInfo
>> > '
>> > .Edit <----------- Debugger highlights this line
>> > .
>> > .
>> > .
>> > .Update
>> > With End
>> >
>> > I have used this code before with success, but now it won't
>> > compile and I am not sure why. Can anyone help me with this?
>> >
>> > Thanks in advance.
>>
>>

The OpenRecordset method of the DAO Database object will always return a DAO
Recordset, so if SdrInfo was anything other than a DAO Recordset, I'd expect
a Type Mismatch error on the line that calls OpenRecordset. I think you may
need to post more of the code before we can see what the problem is.

--
Brendan Reynolds
Access MVP


"CityGuy" <(E-Mail Removed)> wrote in message
news:9DA19ACB-AC75-4939-A5CE-(E-Mail Removed)...
> Hi,
>
> Thanks for the tip. How does one know if a database is an ADO or DAO.
> I still find the differeneces between these 2 confusing.
>
>
>
> "Alex Dybenko" wrote:
>
>> Hi,
>> if SdrInfo - is ADO recordset - then you don't need to call edit method,
>> just comment this line out
>>
>> --
>> Best regards,
>> ___________
>> Alex Dybenko (MVP)
>> http://alexdyb.blogspot.com
>> http://www.PointLtd.com
>>
>>
>> "CityGuy" <(E-Mail Removed)> wrote in message
>> news:BFEA0D76-FA8E-4A66-9271-(E-Mail Removed)...
>> > Hi,
>> >
>> > I'm fairly new at VBA programming. I have run into a snag.
>> >
>> > I want to use code to save edited data from unbound text boxes. The
>> > following code fragment causes an error when I try to compile the
>> > module.
>> >
>> > Error:
>> > "Compile Error, Method or data member not found"
>> >
>> > Code:
>> > With SdrInfo
>> > '
>> > .Edit <----------- Debugger highlights this line
>> > .
>> > .
>> > .
>> > .Update
>> > With End
>> >
>> > I have used this code before with success, but now it won't
>> > compile and I am not sure why. Can anyone help me with this?
>> >
>> > Thanks in advance.
>>
>>

"Brendan Reynolds" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)
> The OpenRecordset method of the DAO Database object will always
> return a DAO Recordset, so if SdrInfo was anything other than a DAO
> Recordset, I'd expect a Type Mismatch error on the line that calls
> OpenRecordset. I think you may need to post more of the code before
> we can see what the problem is.

I don't think the "type mismatch" error will be raised until run time.
The "method or data member not found" error will be raised at compile
time, which is what CityGuy is reporting.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Yes, you're right Dirk, thanks.

--
Brendan Reynolds
Access MVP

"Dirk Goldgar" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> "Brendan Reynolds" <(E-Mail Removed)> wrote in
> message news:(E-Mail Removed)
>> The OpenRecordset method of the DAO Database object will always
>> return a DAO Recordset, so if SdrInfo was anything other than a DAO
>> Recordset, I'd expect a Type Mismatch error on the line that calls
>> OpenRecordset. I think you may need to post more of the code before
>> we can see what the problem is.
>
> I don't think the "type mismatch" error will be raised until run time.
> The "method or data member not found" error will be raised at compile
> time, which is what CityGuy is reporting.
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
>