A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Convert Coding into VB?



 
 
Thread Tools Display Modes
  #1  
Old December 6th, 2006, 04:20 PM posted to microsoft.public.access.forms
Curtis Stevens
external usenet poster
 
Posts: 231
Default Convert Coding into VB?

Can anyone help convert this coding into vb?

Command Button - Control Name: Speak

On Click CODE:

FORM METHOD="post" NAME="demoForm" ACCEPT-CHARSET="iso-8859-1"
ACTION="http://hegel.research.att.com/tts/cgi-bin/nph-talk"
input type="text" NAME="txt" size="30"
input type="hidden" NAME="voice" VALUE="crystal"
INPUT TYPE="submit" NAME="speakButton" VALUE="Speak"
/FORM

I wouldn't even know where to start!

Thanks!
Curtis


  #2  
Old December 6th, 2006, 04:29 PM posted to microsoft.public.access.forms
Douglas J. Steele
external usenet poster
 
Posts: 9,313
Default Convert Coding into VB?

I wouldn't assume it's possible to convert that to VB (or, since this is an
Access newsgroup,VBA): it appears to be passing data to a web page using the
POST method.

If your intent is to get your application to read text, take a look at my
January, 2006 "Access Answers" column in Pinnacle Publication's "Smart
Access". You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Curtis Stevens" wrote in message
news
Can anyone help convert this coding into vb?

Command Button - Control Name: Speak

On Click CODE:

FORM METHOD="post" NAME="demoForm" ACCEPT-CHARSET="iso-8859-1"
ACTION="http://hegel.research.att.com/tts/cgi-bin/nph-talk"
input type="text" NAME="txt" size="30"
input type="hidden" NAME="voice" VALUE="crystal"
INPUT TYPE="submit" NAME="speakButton" VALUE="Speak"
/FORM

I wouldn't even know where to start!

Thanks!
Curtis




  #3  
Old December 7th, 2006, 12:15 PM posted to microsoft.public.access.forms
Brendan Reynolds
external usenet poster
 
Posts: 1,241
Default Convert Coding into VB?

I can't remember if I ever actually used this or not, but I had the link
stored in my IE favourites, and it looks as though it may possibly be of
interest to you ...

http://abstractvb.com/code.asp?A=948

--
Brendan Reynolds
Access MVP

"Curtis Stevens" wrote in message
news
Can anyone help convert this coding into vb?

Command Button - Control Name: Speak

On Click CODE:

FORM METHOD="post" NAME="demoForm" ACCEPT-CHARSET="iso-8859-1"
ACTION="http://hegel.research.att.com/tts/cgi-bin/nph-talk"
input type="text" NAME="txt" size="30"
input type="hidden" NAME="voice" VALUE="crystal"
INPUT TYPE="submit" NAME="speakButton" VALUE="Speak"
/FORM

I wouldn't even know where to start!

Thanks!
Curtis




  #4  
Old December 14th, 2006, 12:23 AM posted to microsoft.public.access.forms
Curtis Stevens
external usenet poster
 
Posts: 231
Default Convert Coding into VB?

I have tried to take your file, make necessary changes to fit mine and
getting errors. Mind helping, should be easy. I want it to use Sam by
default, no option or pull down for any other voice. Volume will always be
50 & rate - 1, so wont need those pull downs.

My Speak or command button is named cmdSpeak. The box that wholes my text,
its name is Contact, so Me.Contact.

Everything else don't want or use.

Can you help, if it is easy to do?

Thanks
Curtis


I wouldn't assume it's possible to convert that to VB (or, since this is an
Access newsgroup,VBA): it appears to be passing data to a web page using the
POST method.

If your intent is to get your application to read text, take a look at my
January, 2006 "Access Answers" column in Pinnacle Publication's "Smart
Access". You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Curtis Stevens" wrote in message
news
Can anyone help convert this coding into vb?

Command Button - Control Name: Speak

On Click CODE:

FORM METHOD="post" NAME="demoForm" ACCEPT-CHARSET="iso-8859-1"
ACTION="http://hegel.research.att.com/tts/cgi-bin/nph-talk"
input type="text" NAME="txt" size="30"
input type="hidden" NAME="voice" VALUE="crystal"
INPUT TYPE="submit" NAME="speakButton" VALUE="Speak"
/FORM

I wouldn't even know where to start!

Thanks!
Curtis





  #5  
Old December 14th, 2006, 01:29 AM posted to microsoft.public.access.forms
Douglas J. Steele
external usenet poster
 
Posts: 9,313
Default Convert Coding into VB?

What errors are you getting?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Curtis Stevens" wrote in message
...
I have tried to take your file, make necessary changes to fit mine and
getting errors. Mind helping, should be easy. I want it to use Sam by
default, no option or pull down for any other voice. Volume will always
be
50 & rate - 1, so wont need those pull downs.

My Speak or command button is named cmdSpeak. The box that wholes my
text,
its name is Contact, so Me.Contact.

Everything else don't want or use.

Can you help, if it is easy to do?

Thanks
Curtis


I wouldn't assume it's possible to convert that to VB (or, since this is
an
Access newsgroup,VBA): it appears to be passing data to a web page using
the
POST method.

If your intent is to get your application to read text, take a look at my
January, 2006 "Access Answers" column in Pinnacle Publication's "Smart
Access". You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Curtis Stevens" wrote in
message
news
Can anyone help convert this coding into vb?

Command Button - Control Name: Speak

On Click CODE:

FORM METHOD="post" NAME="demoForm" ACCEPT-CHARSET="iso-8859-1"
ACTION="http://hegel.research.att.com/tts/cgi-bin/nph-talk"
input type="text" NAME="txt" size="30"
input type="hidden" NAME="voice" VALUE="crystal"
INPUT TYPE="submit" NAME="speakButton" VALUE="Speak"
/FORM

I wouldn't even know where to start!

Thanks!
Curtis







  #6  
Old December 14th, 2006, 01:36 AM posted to microsoft.public.access.forms
Curtis Stevens
external usenet poster
 
Posts: 231
Default Convert Coding into VB?

I don't remember, onload, got focus, etc. I basically important the
frmSAPIDemo form only, nothing else. It did it, but when I take your
database file & delete EVERYTHING but that one form, it works great no probs,
but when I import that form into my database, gives me errors....


What errors are you getting?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Curtis Stevens" wrote in message
...
I have tried to take your file, make necessary changes to fit mine and
getting errors. Mind helping, should be easy. I want it to use Sam by
default, no option or pull down for any other voice. Volume will always
be
50 & rate - 1, so wont need those pull downs.

My Speak or command button is named cmdSpeak. The box that wholes my
text,
its name is Contact, so Me.Contact.

Everything else don't want or use.

Can you help, if it is easy to do?

Thanks
Curtis


I wouldn't assume it's possible to convert that to VB (or, since this is
an
Access newsgroup,VBA): it appears to be passing data to a web page using
the
POST method.

If your intent is to get your application to read text, take a look at my
January, 2006 "Access Answers" column in Pinnacle Publication's "Smart
Access". You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Curtis Stevens" wrote in
message
news Can anyone help convert this coding into vb?

Command Button - Control Name: Speak

On Click CODE:

FORM METHOD="post" NAME="demoForm" ACCEPT-CHARSET="iso-8859-1"
ACTION="http://hegel.research.att.com/tts/cgi-bin/nph-talk"
input type="text" NAME="txt" size="30"
input type="hidden" NAME="voice" VALUE="crystal"
INPUT TYPE="submit" NAME="speakButton" VALUE="Speak"
/FORM

I wouldn't even know where to start!

Thanks!
Curtis








  #7  
Old December 14th, 2006, 10:45 AM posted to microsoft.public.access.forms
Brendan Reynolds
external usenet poster
 
Posts: 1,241
Default Convert Coding into VB?

PMFJI, but I believe Doug's demo needs a reference (in the VBA editor, from
the Tools menu, choose References) to the Microsoft Speech Object Library
(C:\Program Files\Common Files\Microsoft Shared\Speech\sapi.dll). Have you
added that reference to your new MDB?

--
Brendan Reynolds
Access MVP

"Curtis Stevens" wrote in message
...
I don't remember, onload, got focus, etc. I basically important the
frmSAPIDemo form only, nothing else. It did it, but when I take your
database file & delete EVERYTHING but that one form, it works great no
probs,
but when I import that form into my database, gives me errors....


What errors are you getting?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Curtis Stevens" wrote in
message
...
I have tried to take your file, make necessary changes to fit mine and
getting errors. Mind helping, should be easy. I want it to use Sam by
default, no option or pull down for any other voice. Volume will
always
be
50 & rate - 1, so wont need those pull downs.

My Speak or command button is named cmdSpeak. The box that wholes my
text,
its name is Contact, so Me.Contact.

Everything else don't want or use.

Can you help, if it is easy to do?

Thanks
Curtis


I wouldn't assume it's possible to convert that to VB (or, since this
is
an
Access newsgroup,VBA): it appears to be passing data to a web page
using
the
POST method.

If your intent is to get your application to read text, take a look at
my
January, 2006 "Access Answers" column in Pinnacle Publication's "Smart
Access". You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Curtis Stevens" wrote in
message
news Can anyone help convert this coding into vb?

Command Button - Control Name: Speak

On Click CODE:

FORM METHOD="post" NAME="demoForm" ACCEPT-CHARSET="iso-8859-1"
ACTION="http://hegel.research.att.com/tts/cgi-bin/nph-talk"
input type="text" NAME="txt" size="30"
input type="hidden" NAME="voice" VALUE="crystal"
INPUT TYPE="submit" NAME="speakButton" VALUE="Speak"
/FORM

I wouldn't even know where to start!

Thanks!
Curtis










  #8  
Old December 14th, 2006, 11:47 AM posted to microsoft.public.access.forms
Douglas J. Steele
external usenet poster
 
Posts: 9,313
Default Convert Coding into VB?

While the sample database does have a reference to sapi.dll, it shouldn't be
required for text-to-speech. I just loaded up the database, removed the
reference, and the samples worked for me..

As I explain in the article, it was only speech-to-text that wouldn't work
with Late Binding.

Curtis: if you expect help, you're going to have to be a little more
explicit in what's not working. The exact error message, the exact code,
etc. You've already confirmed that the sample code works, so it's got to be
something in your code.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Brendan Reynolds" wrote in message
...
PMFJI, but I believe Doug's demo needs a reference (in the VBA editor,
from the Tools menu, choose References) to the Microsoft Speech Object
Library (C:\Program Files\Common Files\Microsoft Shared\Speech\sapi.dll).
Have you added that reference to your new MDB?

--
Brendan Reynolds
Access MVP

"Curtis Stevens" wrote in
message ...
I don't remember, onload, got focus, etc. I basically important the
frmSAPIDemo form only, nothing else. It did it, but when I take your
database file & delete EVERYTHING but that one form, it works great no
probs,
but when I import that form into my database, gives me errors....


What errors are you getting?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Curtis Stevens" wrote in
message
...
I have tried to take your file, make necessary changes to fit mine and
getting errors. Mind helping, should be easy. I want it to use Sam
by
default, no option or pull down for any other voice. Volume will
always
be
50 & rate - 1, so wont need those pull downs.

My Speak or command button is named cmdSpeak. The box that wholes my
text,
its name is Contact, so Me.Contact.

Everything else don't want or use.

Can you help, if it is easy to do?

Thanks
Curtis


I wouldn't assume it's possible to convert that to VB (or, since this
is
an
Access newsgroup,VBA): it appears to be passing data to a web page
using
the
POST method.

If your intent is to get your application to read text, take a look
at my
January, 2006 "Access Answers" column in Pinnacle Publication's
"Smart
Access". You can download the column (and sample database) for free
at
http://www.accessmvp.com/DJSteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Curtis Stevens" wrote in
message
news Can anyone help convert this coding into vb?

Command Button - Control Name: Speak

On Click CODE:

FORM METHOD="post" NAME="demoForm" ACCEPT-CHARSET="iso-8859-1"
ACTION="http://hegel.research.att.com/tts/cgi-bin/nph-talk"
input type="text" NAME="txt" size="30"
input type="hidden" NAME="voice" VALUE="crystal"
INPUT TYPE="submit" NAME="speakButton" VALUE="Speak"
/FORM

I wouldn't even know where to start!

Thanks!
Curtis












  #9  
Old December 14th, 2006, 01:36 PM posted to microsoft.public.access.forms
Curtis Stevens
external usenet poster
 
Posts: 231
Default Convert Coding into VB?

I'm doing the text to speech, type something in & it talks to me.

Ok, I created a new sample clean db, imported the frmSAPIDemo form only.
Opened form it says:

The expression on load you entered as the even prop setting produced the
following error: user-defined type not defined. HIT ok

Another error saying: ListVoices may not be a valid setting for the
RowSourceType property or there was a compile error in the function.

Curtis


  #10  
Old December 14th, 2006, 05:57 PM posted to microsoft.public.access.forms
Douglas J. Steele
external usenet poster
 
Posts: 9,313
Default Convert Coding into VB?

I see nothing in the form's Load event that should raise that error. What
specific code is it complaining about? (You may have to do a Compile, under
the Debug menu).

The ListVoices function is in that form's code, and it definitely compiles
properly even if there's no reference set to sapi.dll.

I'd expect that once you fix the error(s) uncovered by the Compile, both
errors should be fixed.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Curtis Stevens" wrote in message
...
I'm doing the text to speech, type something in & it talks to me.

Ok, I created a new sample clean db, imported the frmSAPIDemo form only.
Opened form it says:

The expression on load you entered as the even prop setting produced the
following error: user-defined type not defined. HIT ok

Another error saying: ListVoices may not be a valid setting for the
RowSourceType property or there was a compile error in the function.

Curtis




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:21 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.