Comm port in Access

[mstefansen]

New member here hoping to get some expert help.

I have an access db using access 07. I am using a serial port to collect ASCII data from a PLC project. In the db I have a label I click to turn the comm port on and off and a drop list to select the comm port.

This db worked perfect a couple months ago but now that I am getting ready to release this project, the db has an issue with the comm port. If I click the label or select a port I get the following error.

438 "Object doesn't support this property or method"

This is on my laptop and desktop running Access 07.

I took the laptop and restored back to June and the db works fine.
It looks like this is related to a recent update but how do I resolve it?

Any thoughts?

Thanks for your time,

Mike

 

[Uncle Gizmo]

Hi Mike,
There seems to be a bit of confusion here, when I suggested in your other thread to look at VB forums I meant a dedicated forum elsewhere on the Internet. Like I said you may be lucky here, however it’s much more likely a question like this has been posed and answered in a VB6 forum.

I realise that MS access uses VBA and not VB but much of the VB code can be pasted in used in access.

 

[mstefansen]

Hi Mike,
There seems to be a bit of confusion here, when I suggested in your other thread to look at VB forums I meant a dedicated forum elsewhere on the Internet. Like I said you may be lucky here, however it’s much more likely a question like this has been posed and answered in a VB6 forum.

I realise that MS access uses VBA and not VB but much of the VB code can be pasted in used in access.

I have been hunting around.
An Access forum was worth a try.
There has to be someone out there that is using access similar to the way I am. If not, the hunt continues.

This issue is access related since my stand alone VB routines work fine.

M