Solved

VbVoice interprets the date from access incorrectly?

Posted on 2002-06-28
5
273 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
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…

912 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now