Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

VbVoice interprets the date from access incorrectly?

Posted on 2002-06-28
5
Medium Priority
?
280 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
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…
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…
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

618 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