Hi,
Iam using Access2000 and VB as frontend ..Iam getting lot of problems with date Vb application while Inserting date into database/retrieving date.
User wants in DD/MM/YYYY, format..
So,
1.I set the Date/Time field in Access as short date
2.FrontEnd(VB) DatePicker format as short date..
3. Regional Setting to DD/MM/YYYY..
Still problems..
Is there any global way to just define dataforma in Vb application so that it can be used through out life time of application..with our changing regional settings.IF so, where can i set the dateformat in VB application.
thanks
Iam using Access2000 and VB as frontend ..Iam getting lot of problems with date Vb application while Inserting date into database/retrieving date.
User wants in DD/MM/YYYY, format..
So,
1.I set the Date/Time field in Access as short date
2.FrontEnd(VB) DatePicker format as short date..
3. Regional Setting to DD/MM/YYYY..
Still problems..
Is there any global way to just define dataforma in Vb application so that it can be used through out life time of application..with our changing regional settings.IF so, where can i set the dateformat in VB application.
thanks