Basic stamps and microsoft access
Archiver
Posts: 46,084
I need a microsoft access database to talk to a stamp, probably via the
serial port.
I've seen some discussions here about using visual basic to do that and
access appears to have a VB subset as its programming language. This
subset does not seem to contain the necessary commands.
Does anyone know if this is true?
It seems that if I purchase the stand alone visual basic, then I will
get those commands and can somehow integrate them into my access
program. Does anyone know if this is true?
Or of any other way to communicate between access and the stamp.
Thanks
bob
serial port.
I've seen some discussions here about using visual basic to do that and
access appears to have a VB subset as its programming language. This
subset does not seem to contain the necessary commands.
Does anyone know if this is true?
It seems that if I purchase the stand alone visual basic, then I will
get those commands and can somehow integrate them into my access
program. Does anyone know if this is true?
Or of any other way to communicate between access and the stamp.
Thanks
bob
Comments
a .txt file, which qbasic would then read, and send to the stamp.
qbasic would then get input from the stamp and put this into
another .txt file which access could then read.
--- In basicstamps@yahoogroups.com, "Bob Roan" <bob@t...> wrote:
> I need a microsoft access database to talk to a stamp, probably via
the
> serial port.
>
> I've seen some discussions here about using visual basic to do that
and
> access appears to have a VB subset as its programming language.
This
> subset does not seem to contain the necessary commands.
>
> Does anyone know if this is true?
>
> It seems that if I purchase the stand alone visual basic, then I
will
> get those commands and can somehow integrate them into my access
> program. Does anyone know if this is true?
>
> Or of any other way to communicate between access and the stamp.
>
> Thanks
>
> bob
application so cheapness isn't as important as user friendliness.
Original Message
From: Sam [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=bXFZ6g7P9Foa-LHhG1iWKPRr8xIXgAa-473-3OoMxeUQNiTo76j87HW03g30IlOOYmDJuQ_wMK6p0eI]hard-on@t...[/url
Sent: Friday, August 01, 2003 7:36 AM
To: basicstamps@yahoogroups.com
Subject: [noparse][[/noparse]basicstamps] Re: Basic stamps and microsoft access
a dirt cheap way to do it would be to tell access to save stuff into
a .txt file, which qbasic would then read, and send to the stamp.
qbasic would then get input from the stamp and put this into
another .txt file which access could then read.
--- In basicstamps@yahoogroups.com, "Bob Roan" <bob@t...> wrote:
> I need a microsoft access database to talk to a stamp, probably via
the
> serial port.
>
> I've seen some discussions here about using visual basic to do that
and
> access appears to have a VB subset as its programming language.
This
> subset does not seem to contain the necessary commands.
>
> Does anyone know if this is true?
>
> It seems that if I purchase the stand alone visual basic, then I
will
> get those commands and can somehow integrate them into my access
> program. Does anyone know if this is true?
>
> Or of any other way to communicate between access and the stamp.
>
> Thanks
>
> bob
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject
and Body of the message will be ignored.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
the SaxComm object on http://www.sax.net/activex/comm/default.aspx
various Communications Tools on http://lvr.com/serport.htm (about 1/2 way down
the page)
HTH,
Daniel
Original Message
From: Bob Roan [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=Gx7heSMcjmOXsngDHvIM3xQFUB6iYKSR85Ev3_2hOlNGodmFkBSwpDCB4JctFWkgR40_VT3A]bob@t...[/url
Sent: Friday, August 01, 2003 1:53 PM
To: basicstamps@yahoogroups.com
Subject: RE: [noparse][[/noparse]basicstamps] Re: Basic stamps and microsoft access
Thanks for the suggestion. However, this is for a commercial
application so cheapness isn't as important as user friendliness.
Original Message
From: Sam [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=ev5iquEbjBKB_autbx0k28Yl7jzXKfOoS9lYeAFIvHsgESdPsKnBqam5GK6nbKFmTWHLmVQv6QQbV8c]hard-on@t...[/url
Sent: Friday, August 01, 2003 7:36 AM
To: basicstamps@yahoogroups.com
Subject: [noparse][[/noparse]basicstamps] Re: Basic stamps and microsoft access
a dirt cheap way to do it would be to tell access to save stuff into
a .txt file, which qbasic would then read, and send to the stamp.
qbasic would then get input from the stamp and put this into
another .txt file which access could then read.
--- In basicstamps@yahoogroups.com, "Bob Roan" <bob@t...> wrote:
> I need a microsoft access database to talk to a stamp, probably via
the
> serial port.
>
> I've seen some discussions here about using visual basic to do that
and
> access appears to have a VB subset as its programming language.
This
> subset does not seem to contain the necessary commands.
>
> Does anyone know if this is true?
>
> It seems that if I purchase the stand alone visual basic, then I
will
> get those commands and can somehow integrate them into my access
> program. Does anyone know if this is true?
>
> Or of any other way to communicate between access and the stamp.
>
> Thanks
>
> bob
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject
and Body of the message will be ignored.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject and Body
of the
message will be ignored.
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Due to the 'funny' Forms model used by Access,
you may have to create a 'hidden' form to put
the VB6 Pro 'MSCOMM' control on, so you can
keep the control open and active during your
Access application program.
Create a Form, then put an ActiveX control
'MSCOMM' on it. Proceed from there. If you
don't own VB6 Pro, you may not have a development
version of the MSCOMM control on your machine,
so the after-market link given earlier will
be needed.
You'll still have to deliver the MSCOMMxx.OCX
control with your application, so your apps
can use it...
--- In basicstamps@yahoogroups.com, "Bob Roan" <bob@t...> wrote:
> I need a microsoft access database to talk to a stamp, probably via
the
> serial port.
>
> I've seen some discussions here about using visual basic to do that
and
> access appears to have a VB subset as its programming language.
This
> subset does not seem to contain the necessary commands.
>
> Does anyone know if this is true?
>
> It seems that if I purchase the stand alone visual basic, then I
will
> get those commands and can somehow integrate them into my access
> program. Does anyone know if this is true?
>
> Or of any other way to communicate between access and the stamp.
>
> Thanks
>
> bob
database. I remember I used two computers both with access DB,
sending serial to the BS2, then send out by debug to the second PC.
Of course I did not have two serial ports on my computer, so I used
my laptop.
I used the example from nuts and volts "VB to stamp" or somthing.
I remember I was diseponted that I could not send out more then 2400
boud from access, cause the stamp (Using serin wait....) did not
managed higher speed. Don't know why. It did'nt just work.
As allan points out, you need a developer access to be able to get
the MScomm control. It's a nasty task to import one. Made it after
saveral atemts.
Hope this was to any help.
Stein_frostad at mailcity dot com
--- In basicstamps@yahoogroups.com, "Allan Lane" <allan.lane@h...>
wrote:
> Yes, this should be doable.
> Due to the 'funny' Forms model used by Access,
> you may have to create a 'hidden' form to put
> the VB6 Pro 'MSCOMM' control on, so you can
> keep the control open and active during your
> Access application program.
>
> Create a Form, then put an ActiveX control
> 'MSCOMM' on it. Proceed from there. If you
> don't own VB6 Pro, you may not have a development
> version of the MSCOMM control on your machine,
> so the after-market link given earlier will
> be needed.
>
> You'll still have to deliver the MSCOMMxx.OCX
> control with your application, so your apps
> can use it...
>
> --- In basicstamps@yahoogroups.com, "Bob Roan" <bob@t...> wrote:
> > I need a microsoft access database to talk to a stamp, probably
via
> the
> > serial port.
> >
> > I've seen some discussions here about using visual basic to do
that
> and
> > access appears to have a VB subset as its programming language.
> This
> > subset does not seem to contain the necessary commands.
> >
> > Does anyone know if this is true?
> >
> > It seems that if I purchase the stand alone visual basic, then I
> will
> > get those commands and can somehow integrate them into my access
> > program. Does anyone know if this is true?
> >
> > Or of any other way to communicate between access and the stamp.
> >
> > Thanks
> >
> > bob
I used a RS232 between the PC and stamp, then the debug out on p16
to the second pc.
--- In basicstamps@yahoogroups.com, "stein_frostad"
<Stein_Frostad@m...> wrote:
> I have done this ones, sending serial info from BS2 to access
> database. I remember I used two computers both with access DB,
> sending serial to the BS2, then send out by debug to the second PC.
> Of course I did not have two serial ports on my computer, so I
used
> my laptop.
>
> I used the example from nuts and volts "VB to stamp" or somthing.
>
> I remember I was diseponted that I could not send out more then
2400
> boud from access, cause the stamp (Using serin wait....) did not
> managed higher speed. Don't know why. It did'nt just work.
>
> As allan points out, you need a developer access to be able to get
> the MScomm control. It's a nasty task to import one. Made it after
> saveral atemts.
>
> Hope this was to any help.
> Stein_frostad at mailcity dot com
>
>
>
>
> --- In basicstamps@yahoogroups.com, "Allan Lane" <allan.lane@h...>
> wrote:
> > Yes, this should be doable.
> > Due to the 'funny' Forms model used by Access,
> > you may have to create a 'hidden' form to put
> > the VB6 Pro 'MSCOMM' control on, so you can
> > keep the control open and active during your
> > Access application program.
> >
> > Create a Form, then put an ActiveX control
> > 'MSCOMM' on it. Proceed from there. If you
> > don't own VB6 Pro, you may not have a development
> > version of the MSCOMM control on your machine,
> > so the after-market link given earlier will
> > be needed.
> >
> > You'll still have to deliver the MSCOMMxx.OCX
> > control with your application, so your apps
> > can use it...
> >
> > --- In basicstamps@yahoogroups.com, "Bob Roan" <bob@t...> wrote:
> > > I need a microsoft access database to talk to a stamp,
probably
> via
> > the
> > > serial port.
> > >
> > > I've seen some discussions here about using visual basic to do
> that
> > and
> > > access appears to have a VB subset as its programming
language.
> > This
> > > subset does not seem to contain the necessary commands.
> > >
> > > Does anyone know if this is true?
> > >
> > > It seems that if I purchase the stand alone visual basic, then
I
> > will
> > > get those commands and can somehow integrate them into my
access
> > > program. Does anyone know if this is true?
> > >
> > > Or of any other way to communicate between access and the
stamp.
> > >
> > > Thanks
> > >
> > > bob
Thanks for the information. I had hoped this would all be
straightforward!
VB6 Pro doesn't seem to be readily available anymore. I think its being
replaced by VB net. Do you know which version of vb net I should try to
get? Or if any of them have the capability?
I am also getting the feeling that once I get the right version of
visual basic to do this, I will need help figuring out how to get access
to integrate the mscomm control. Any suggestions there?
Thanks again
bob
Original Message
From: Allan Lane [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=X-8g112iwufqg-3j6sEQYpLu9B-LjuH0Sp2osEX5A8TX290PXIm3VKVnsN6QTkl8c_f8moaCIzVLoR1x3_8nsH_p6KhC9Q]allan.lane@h...[/url
Sent: Friday, August 01, 2003 10:54 AM
To: basicstamps@yahoogroups.com
Subject: [noparse][[/noparse]basicstamps] Re: Basic stamps and microsoft access
Yes, this should be doable.
Due to the 'funny' Forms model used by Access,
you may have to create a 'hidden' form to put
the VB6 Pro 'MSCOMM' control on, so you can
keep the control open and active during your
Access application program.
Create a Form, then put an ActiveX control
'MSCOMM' on it. Proceed from there. If you
don't own VB6 Pro, you may not have a development
version of the MSCOMM control on your machine,
so the after-market link given earlier will
be needed.
You'll still have to deliver the MSCOMMxx.OCX
control with your application, so your apps
can use it...
--- In basicstamps@yahoogroups.com, "Bob Roan" <bob@t...> wrote:
> I need a microsoft access database to talk to a stamp, probably via
the
> serial port.
>
> I've seen some discussions here about using visual basic to do that
and
> access appears to have a VB subset as its programming language.
This
> subset does not seem to contain the necessary commands.
>
> Does anyone know if this is true?
>
> It seems that if I purchase the stand alone visual basic, then I
will
> get those commands and can somehow integrate them into my access
> program. Does anyone know if this is true?
>
> Or of any other way to communicate between access and the stamp.
>
> Thanks
>
> bob
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject
and Body of the message will be ignored.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Thanks. That does help. The choices are a little overwhelming. Any
suggestions on how I can figure out which route to take?
bob
Original Message
From: D. Daniel McGlothin [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=djsYQBqxDmC9wxVVDLBEpaikjyfA0E_na28guM67ZRA1mBm4VU_c-974Z0KdIgvBHV-A9c7IXrIi6HaJ]ddm@m...[/url
Sent: Friday, August 01, 2003 10:14 AM
To: basicstamps@yahoogroups.com
Subject: RE: [noparse][[/noparse]basicstamps] Re: Basic stamps and microsoft access
Maybe you want to look at:
the SaxComm object on http://www.sax.net/activex/comm/default.aspx
various Communications Tools on http://lvr.com/serport.htm (about 1/2
way down the page)
HTH,
Daniel
Original Message
From: Bob Roan [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=MS4sP07Kw5EhlUtwbFqjGl5IdMrv0DvHIn-b26duO3VVs2KfFf_wnm-mbp-Gm5xCqhqa2Bz_C3M7THU]bob@t...[/url
Sent: Friday, August 01, 2003 1:53 PM
To: basicstamps@yahoogroups.com
Subject: RE: [noparse][[/noparse]basicstamps] Re: Basic stamps and microsoft access
Thanks for the suggestion. However, this is for a commercial
application so cheapness isn't as important as user friendliness.
Original Message
From: Sam [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=e5f11omnGS3lVc0JLNjELgJAu4sytd4flPgK4ctNoM5dTINppFeUbL4j0Bg0f4zfcbhKImJfjRoE3ILO]hard-on@t...[/url
Sent: Friday, August 01, 2003 7:36 AM
To: basicstamps@yahoogroups.com
Subject: [noparse][[/noparse]basicstamps] Re: Basic stamps and microsoft access
a dirt cheap way to do it would be to tell access to save stuff into a
.txt file, which qbasic would then read, and send to the stamp. qbasic
would then get input from the stamp and put this into another .txt file
which access could then read.
--- In basicstamps@yahoogroups.com, "Bob Roan" <bob@t...> wrote:
> I need a microsoft access database to talk to a stamp, probably via
the
> serial port.
>
> I've seen some discussions here about using visual basic to do that
and
> access appears to have a VB subset as its programming language.
This
> subset does not seem to contain the necessary commands.
>
> Does anyone know if this is true?
>
> It seems that if I purchase the stand alone visual basic, then I
will
> get those commands and can somehow integrate them into my access
> program. Does anyone know if this is true?
>
> Or of any other way to communicate between access and the stamp.
>
> Thanks
>
> bob
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject
and Body of the message will be ignored.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject
and Body of the message will be ignored.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject
and Body of the message will be ignored.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
I'd start with trying the XMComm ActiveX control
(http://ourworld.compuserve.com/homepages/richard_grier/xmcomm.htm) and do as
Allan Lane
suggested.
If you buy something, take note of what Allen says about Access' funny forms
model (the
funniness seems to vary with Access version); the XMComm page makes brief
mention of the
same issue when it states it works with "...appropriate versions of Access".
The point is
to confirm with the object vendor that their control will work with your version
of
Access.
The Grier book and/or the Microsoft documents (mentioned on the XMComm page)
would be a
good place to start--both to get a general sense of how to use the
communications object,
as well as specifics of that objects details.
Jan Axelson's book (http://lvr.com/serport.htm) is another good starting
place--she
discusses and provide examples of usage for the MSComm control.
I've used MScomm in both VB and Access. I have a copy of the SaxComm control as
well, but
but have not used it much.
HTH,
Daniel
Access can be a bit of a problem, Note that
Original Message
From: Bob Roan [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=9RZ1RhuWJOGxJdhY_fcTtfZkM_4zhdURy_e3wBvr3xzstmeVN14cVtTn_AjX18bWAl98Y3Bjgp7yV9M]bob@t...[/url
Sent: Monday, August 04, 2003 10:59 AM
To: basicstamps@yahoogroups.com
Subject: RE: [noparse][[/noparse]basicstamps] Re: Basic stamps and microsoft access
Daniel,
Thanks. That does help. The choices are a little overwhelming. Any
suggestions on how I can figure out which route to take?
bob
Original Message
From: D. Daniel McGlothin [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=ilpYQ-daidUSZg5FeCqfLQOpIvuIpGoKQcjK6fkJRUJ_Pi3sl1VoJuxrdDGlONKcuA8iNJsDG0cxhOo]ddm@m...[/url
Sent: Friday, August 01, 2003 10:14 AM
To: basicstamps@yahoogroups.com
Subject: RE: [noparse][[/noparse]basicstamps] Re: Basic stamps and microsoft access
Maybe you want to look at:
the SaxComm object on http://www.sax.net/activex/comm/default.aspx
various Communications Tools on http://lvr.com/serport.htm (about 1/2
way down the page)
HTH,
Daniel
Original Message
From: Bob Roan [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=9RZ1RhuWJOGxJdhY_fcTtfZkM_4zhdURy_e3wBvr3xzstmeVN14cVtTn_AjX18bWAl98Y3Bjgp7yV9M]bob@t...[/url
Sent: Friday, August 01, 2003 1:53 PM
To: basicstamps@yahoogroups.com
Subject: RE: [noparse][[/noparse]basicstamps] Re: Basic stamps and microsoft access
Thanks for the suggestion. However, this is for a commercial
application so cheapness isn't as important as user friendliness.
Original Message
From: Sam [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=sLO_wQhi53IbTcY2peWQeWFKzodKi9bR9xFQh08zaAT-QO71ps1yb0vfUQzqYVKIgRmeAwDHF1fQ6SqG]hard-on@t...[/url
Sent: Friday, August 01, 2003 7:36 AM
To: basicstamps@yahoogroups.com
Subject: [noparse][[/noparse]basicstamps] Re: Basic stamps and microsoft access
a dirt cheap way to do it would be to tell access to save stuff into a
.txt file, which qbasic would then read, and send to the stamp. qbasic
would then get input from the stamp and put this into another .txt file
which access could then read.
--- In basicstamps@yahoogroups.com, "Bob Roan" <bob@t...> wrote:
> I need a microsoft access database to talk to a stamp, probably via
the
> serial port.
>
> I've seen some discussions here about using visual basic to do that
and
> access appears to have a VB subset as its programming language.
This
> subset does not seem to contain the necessary commands.
>
> Does anyone know if this is true?
>
> It seems that if I purchase the stand alone visual basic, then I
will
> get those commands and can somehow integrate them into my access
> program. Does anyone know if this is true?
>
> Or of any other way to communicate between access and the stamp.
>
> Thanks
>
> bob
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject
and Body of the message will be ignored.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject
and Body of the message will be ignored.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject
and Body of the message will be ignored.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject and Body
of the
message will be ignored.
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Thanks for the advice. I downloaded the XMComm ActiveX control and
ordered his book.
I'm still confused about how to get the MSComm control. It seems like
microsoft is moving away from VB 6 to Visual Basic.Net, so if the MSComm
control is available in Visual Basic.Net that would be a better route.
And it also seems there are various versions of both VB 6 and VB.Net.
Eg. Visual Basic 6 Developer and Visual Studio.Net. Do you know which
one or ones have the MSComm control?
Thanks for all your help
bob
Original Message
From: D. Daniel McGlothin [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=yfr9DJ8JVAUmcZifHti6-A81AFMHDpZVopEGzO8yYsF8UxMdJvIikT8SeCAdt41625LoKvA-R8E]ddm@m...[/url
Sent: Monday, August 04, 2003 7:39 AM
To: basicstamps@yahoogroups.com
Subject: RE: [noparse][[/noparse]basicstamps] Re: Basic stamps and microsoft access
bob,
I'd start with trying the XMComm ActiveX control
(http://ourworld.compuserve.com/homepages/richard_grier/xmcomm.htm) and
do as Allan Lane suggested.
If you buy something, take note of what Allen says about Access' funny
forms model (the funniness seems to vary with Access version); the
XMComm page makes brief mention of the same issue when it states it
works with "...appropriate versions of Access". The point is to confirm
with the object vendor that their control will work with your version of
Access.
The Grier book and/or the Microsoft documents (mentioned on the XMComm
page) would be a good place to start--both to get a general sense of how
to use the communications object, as well as specifics of that objects
details.
Jan Axelson's book (http://lvr.com/serport.htm) is another good starting
place--she discusses and provide examples of usage for the MSComm
control.
I've used MScomm in both VB and Access. I have a copy of the SaxComm
control as well, but but have not used it much.
HTH,
Daniel
Access can be a bit of a problem, Note that
Original Message
From: Bob Roan [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=KEesa7XYJh3M0Nr5-w0MAeuZatvX8S1kJ1erwBx670ADEFJ-34Q0k833uDnm8no8UFfnZ2aO]bob@t...[/url
Sent: Monday, August 04, 2003 10:59 AM
To: basicstamps@yahoogroups.com
Subject: RE: [noparse][[/noparse]basicstamps] Re: Basic stamps and microsoft access
Daniel,
Thanks. That does help. The choices are a little overwhelming. Any
suggestions on how I can figure out which route to take?
bob
Original Message
From: D. Daniel McGlothin [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=yfr9DJ8JVAUmcZifHti6-A81AFMHDpZVopEGzO8yYsF8UxMdJvIikT8SeCAdt41625LoKvA-R8E]ddm@m...[/url
Sent: Friday, August 01, 2003 10:14 AM
To: basicstamps@yahoogroups.com
Subject: RE: [noparse][[/noparse]basicstamps] Re: Basic stamps and microsoft access
Maybe you want to look at:
the SaxComm object on http://www.sax.net/activex/comm/default.aspx
various Communications Tools on http://lvr.com/serport.htm (about 1/2
way down the page)
HTH,
Daniel
Original Message
From: Bob Roan [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=KEesa7XYJh3M0Nr5-w0MAeuZatvX8S1kJ1erwBx670ADEFJ-34Q0k833uDnm8no8UFfnZ2aO]bob@t...[/url
Sent: Friday, August 01, 2003 1:53 PM
To: basicstamps@yahoogroups.com
Subject: RE: [noparse][[/noparse]basicstamps] Re: Basic stamps and microsoft access
Thanks for the suggestion. However, this is for a commercial
application so cheapness isn't as important as user friendliness.
Original Message
From: Sam [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=e8qtFx1E8YBKF72E8WRQAACi0xgXi7spCUDGA0nAHflQc28Fw8zSlGEq6WLLcHBcwW9gJYdLwxaIhwOTrw]hard-on@t...[/url
Sent: Friday, August 01, 2003 7:36 AM
To: basicstamps@yahoogroups.com
Subject: [noparse][[/noparse]basicstamps] Re: Basic stamps and microsoft access
a dirt cheap way to do it would be to tell access to save stuff into a
.txt file, which qbasic would then read, and send to the stamp. qbasic
would then get input from the stamp and put this into another .txt file
which access could then read.
--- In basicstamps@yahoogroups.com, "Bob Roan" <bob@t...> wrote:
> I need a microsoft access database to talk to a stamp, probably via
the
> serial port.
>
> I've seen some discussions here about using visual basic to do that
and
> access appears to have a VB subset as its programming language.
This
> subset does not seem to contain the necessary commands.
>
> Does anyone know if this is true?
>
> It seems that if I purchase the stand alone visual basic, then I
will
> get those commands and can somehow integrate them into my access
> program. Does anyone know if this is true?
>
> Or of any other way to communicate between access and the stamp.
>
> Thanks
>
> bob
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject
and Body of the message will be ignored.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject
and Body of the message will be ignored.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject
and Body of the message will be ignored.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject
and Body of the message will be ignored.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject
and Body of the message will be ignored.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
The XMComm control is a packaging of the Microsoft MSComm control. This means
that you
can use the XMComm control as its documentation guides you; it, in turn, uses
the embedded
MCComm control to do its work.
You are not the only confused about which VB has MSComm. I can not speak to
VB.net, but I
have VB 6 Pro (part of Visual Studio 6 Pro), and it has the MSComm control.
I found that this page http://support.microsoft.com/?kbid=194784&sd=msdn answers
the
question for VB6. I found that page when searching for the answer by starting
at this
page http://msdn.microsoft.com/vbasic/previous/default.aspx; perhaps you can
answer your
question about other versions of VB by exploration from there.
However, if you are using a third party control, such as XMComm, having MSComm
may be
moot.
Daniel
Original Message
From: Bob Roan [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=3jswCB_-RqNhH0QW65qsLna6IefAjR056DWfN7YWht6nuo2jvMKH5v6DIaCs7XYGJzxh2CgGEtI2qQ]bob@t...[/url
Sent: Tuesday, August 05, 2003 8:41 PM
To: basicstamps@yahoogroups.com
Subject: RE: [noparse][[/noparse]basicstamps] Re: Basic stamps and microsoft access
Daniel,
Thanks for the advice. I downloaded the XMComm ActiveX control and
ordered his book.
I'm still confused about how to get the MSComm control. It seems like
microsoft is moving away from VB 6 to Visual Basic.Net, so if the MSComm
control is available in Visual Basic.Net that would be a better route.
And it also seems there are various versions of both VB 6 and VB.Net.
Eg. Visual Basic 6 Developer and Visual Studio.Net. Do you know which
one or ones have the MSComm control?
Thanks for all your help
bob
Original Message
From: D. Daniel McGlothin [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=XPq0yl5nW2nK5zY74_naq7YA5FxxNaXcklVhd21mKxVvr_EICh5831c9BMjLi51Gvfz_HrFqXob3UQ]ddm@m...[/url
Sent: Monday, August 04, 2003 7:39 AM
To: basicstamps@yahoogroups.com
Subject: RE: [noparse][[/noparse]basicstamps] Re: Basic stamps and microsoft access
bob,
I'd start with trying the XMComm ActiveX control
(http://ourworld.compuserve.com/homepages/richard_grier/xmcomm.htm) and
do as Allan Lane suggested.
If you buy something, take note of what Allen says about Access' funny
forms model (the funniness seems to vary with Access version); the
XMComm page makes brief mention of the same issue when it states it
works with "...appropriate versions of Access". The point is to confirm
with the object vendor that their control will work with your version of
Access.
The Grier book and/or the Microsoft documents (mentioned on the XMComm
page) would be a good place to start--both to get a general sense of how
to use the communications object, as well as specifics of that objects
details.
Jan Axelson's book (http://lvr.com/serport.htm) is another good starting
place--she discusses and provide examples of usage for the MSComm
control.
I've used MScomm in both VB and Access. I have a copy of the SaxComm
control as well, but but have not used it much.
HTH,
Daniel
Access can be a bit of a problem, Note that
Original Message
From: Bob Roan [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=3jswCB_-RqNhH0QW65qsLna6IefAjR056DWfN7YWht6nuo2jvMKH5v6DIaCs7XYGJzxh2CgGEtI2qQ]bob@t...[/url
Sent: Monday, August 04, 2003 10:59 AM
To: basicstamps@yahoogroups.com
Subject: RE: [noparse][[/noparse]basicstamps] Re: Basic stamps and microsoft access
Daniel,
Thanks. That does help. The choices are a little overwhelming. Any
suggestions on how I can figure out which route to take?
bob
Original Message
From: D. Daniel McGlothin [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=XPq0yl5nW2nK5zY74_naq7YA5FxxNaXcklVhd21mKxVvr_EICh5831c9BMjLi51Gvfz_HrFqXob3UQ]ddm@m...[/url
Sent: Friday, August 01, 2003 10:14 AM
To: basicstamps@yahoogroups.com
Subject: RE: [noparse][[/noparse]basicstamps] Re: Basic stamps and microsoft access
Maybe you want to look at:
the SaxComm object on http://www.sax.net/activex/comm/default.aspx
various Communications Tools on http://lvr.com/serport.htm (about 1/2
way down the page)
HTH,
Daniel
Original Message
From: Bob Roan [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=3jswCB_-RqNhH0QW65qsLna6IefAjR056DWfN7YWht6nuo2jvMKH5v6DIaCs7XYGJzxh2CgGEtI2qQ]bob@t...[/url
Sent: Friday, August 01, 2003 1:53 PM
To: basicstamps@yahoogroups.com
Subject: RE: [noparse][[/noparse]basicstamps] Re: Basic stamps and microsoft access
Thanks for the suggestion. However, this is for a commercial
application so cheapness isn't as important as user friendliness.
Original Message
From: Sam [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=C2_pqWIq-a0SYobb_87gIcRma2dwg68dYeQTR3EngC3A0w9cr4KKJMqpnPUH-hSaHNlLDQgtLkjA]hard-on@t...[/url
Sent: Friday, August 01, 2003 7:36 AM
To: basicstamps@yahoogroups.com
Subject: [noparse][[/noparse]basicstamps] Re: Basic stamps and microsoft access
a dirt cheap way to do it would be to tell access to save stuff into a
.txt file, which qbasic would then read, and send to the stamp. qbasic
would then get input from the stamp and put this into another .txt file
which access could then read.
--- In basicstamps@yahoogroups.com, "Bob Roan" <bob@t...> wrote:
> I need a microsoft access database to talk to a stamp, probably via
the
> serial port.
>
> I've seen some discussions here about using visual basic to do that
and
> access appears to have a VB subset as its programming language.
This
> subset does not seem to contain the necessary commands.
>
> Does anyone know if this is true?
>
> It seems that if I purchase the stand alone visual basic, then I
will
> get those commands and can somehow integrate them into my access
> program. Does anyone know if this is true?
>
> Or of any other way to communicate between access and the stamp.
>
> Thanks
>
> bob
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject
and Body of the message will be ignored.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject
and Body of the message will be ignored.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject
and Body of the message will be ignored.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject
and Body of the message will be ignored.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject
and Body of the message will be ignored.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject and Body
of the
message will be ignored.
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/