Hello everybody!
I made an access database which works very nicely. There is one problem though. When I started running the database on other computers visual basic started reporting errors when I tried to filter a form with criteria the user can enter in the form. I later found out that the problem was with the user's regional settings. Some use "." as a separator others "/". Is there a way to find out what the settings of the user are?
Thanks for your help!
P.S.: to give an example of my problem:
People using "." as a separator wont have problems, but people with "/" as a separator will because "/" can't be used in a file name.
I'm using the date so the people know what the search criteria for the file was.
I made an access database which works very nicely. There is one problem though. When I started running the database on other computers visual basic started reporting errors when I tried to filter a form with criteria the user can enter in the form. I later found out that the problem was with the user's regional settings. Some use "." as a separator others "/". Is there a way to find out what the settings of the user are?
Thanks for your help!
P.S.: to give an example of my problem:
Code:
DoCmd.OutputTo acOutputForm, "frmProducts", acFormatXLS, "s:/filename" & date, True
I'm using the date so the people know what the search criteria for the file was.