Solved

VbVoice interprets the date from access incorrectly?

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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
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 process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

746 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

12 Experts available now in Live!

Get 1:1 Help Now