?
Solved

VbVoice interprets the date from access incorrectly?

Posted on 2002-06-28
5
Medium Priority
?
278 Views
Last Modified: 2006-11-17
Hi all,

I am using VbVoice from Pronexus. I use the DataFind control to lookup data in an access database, one field of which is a datetime field. Then I use a PlayGreeting control to play the date. The log shows an error that it can't interpret the data and it shows the date in the format "mm-dd-yyyy". VbVoice wants the format to be "mm/dd/yyyy". So it bombs. I'm using the ODBC driver with a DSN for access.

Is there a different driver I need to use?

I can override the DataFind control and put in SQL. But it doesn't seem to accept everything. If I use a to_char function or a convert function it does not accept it. Is there something else I can do with the SQL.

Lastly, I could skip the DataFind control and go to the code level to pull the date out of the database and format it correctly, but then how can I put the data back into a control field that the Play Greeting will recognize. I would like to avoid putting the Play Greeting in the code too.

Thoughts.
0
Comment
Question by:jnhgustin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 18

Expert Comment

by:deighton
ID: 7116188
does the datafind control use a sql string?  if so you could use the format command on the date field in the sql string
0
 

Author Comment

by:jnhgustin
ID: 7116808
I have tried using an SQL String in the DataFind. I actually tested by cutting the string right out of the log. It looked like:
>SELECT [StartDate] FROM [MyTable]
The > is the key to using your own statement.
I tried adding a CONVERT function or a to_char function to this statement. But I just get an error every time. It seems as if I modify the statement at all, it doesn't like it.
0
 

Author Comment

by:jnhgustin
ID: 7124516
Well,

I guess there is no more input - I worked around the problem by setting up a "Transfer" variable and upon exiting the DataFind control, using the "exit" routine to populate the transfer variable with a correctly formatted date.

Thanks for the input.

-- This question should be closed.
0
 
LVL 49

Expert Comment

by:DanRollins
ID: 7964684
Hi jnhgustin,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Refund points and save as a 0-pt PAQ.

jnhgustin, Please DO NOT accept this comment as an answer.
EXPERTS: Post a comment if you are certain that an expert deserves credit.  Explain why.
==========
DanRollins -- EE database cleanup volunteer
0
 
LVL 5

Accepted Solution

by:
Netminder earned 0 total points
ID: 8022548
Per recommendation, points refunded and question closed.

Netminder
EE Admin
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses
Course of the Month10 days, 16 hours left to enroll

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question