date format problem with access and visual basic

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Windows NT / 2000 / XP / 2003 section within the Tech Talk category of DaniWeb, a massive community of 402,746 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,513 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Windows NT / 2000 / XP / 2003 advertiser: Programming Forums

Thread Tools Display Modes

Views: 5767 | Replies: 2

•

Join Date: Apr 2005

Posts: 21

Reputation: luisator is an unknown quantity at this point

Rep Power: 4

Solved Threads: 0

luisator

Offline

Newbie Poster

date format problem with access and visual basic

Sep 6th, 2005

Hi everybody...I am having a very strange problem and hope some of you can help me as soon as posible. I am workin in a small LAN with a XP PC and a W2000 PC. I have an aplication developed in Visual basic, in the XP PC, for making a query on an Access data base resident in the W2000 PC. The problem is: the query parameter of search is the date, but the results I get correspond like the query was realized in the format mm/dd/yyyy and I need to make it in the format dd/mm/yyyy.
I have checked the regional options in both computers and they seem to be the same (dd/mm/yyyy). The format in the Access table is dd/mm/yyyy and when I make a query in the data base, in the W2000 PC, it works, no problem. When I make the query in the XP PC with a local database it also works....does anybody has any idea of what I am missing in here???? I think I´ve tried all!!! Please help me.....I need to solve this today!!!!Thank yo very much!!

luisator