Reports not working in germany

[Wile_E]

Hi, this may take a bit of explaining so please bear with me

i have been tasked with creating a sales forecast database for use by our sales reps and production coordinator and i seem to have run into a snag.

firstly our company does not use the traditional calendar (dont ask) so i have to define each month in a table, then for the reports users can select the month from a listbox and it looks up the dates for the report.

this system works fine for everyone except our german rep who gets errors when trying to open it. the only difference i can see is that his date format is DD.MM.YYYY and the rest of us use DD/MM/YYYY is there anyway round this (or is it nothing to do with this difference)

cheers
Wile_E

 

[spikepl]

or is it nothing to do with this difference

Not enough info to say anything about this.

If your application has no SQL created in VBA, nor any hardcoded dates, then the source of your problem is not the formatting.

If you have SQL in VBA, AND also decimal numbers, then that is the error source - SLQ demand "." as decimal separator.

'You have to actually tells us what errors , and what generates them.

Next time you ask, supply the error messages and all other information that you have -we do not read minds

 

[Frothingslosh]

spikepl - bad day? You're starting to sound as ornery as me!

 

[Wile_E]

sorry

the error report is in german, i will get our rep to translate it for me

basically what im doing is

i have a table (tblMonths) which has the monthname (ie Jan-2014) a start date and an end date.

i have a form that lists these month names in a list box. on click for the list box looks up the 2 dates for this month and sets global variables GetDateLower and GetDateUpper to these dates.

when the open report button on the form is clicked it opens a report using a query that has the criteria Due Between GetDateLower and GetDateUpper.

this works for all reps using English UK settings but failes for our German Rep

does this better explain the problem ?

 

[Frothingslosh]

The easiest option would be to tell your German Rep to use the MM-DD-YYYY format like the rest of your reps.

Is your German rep only selecting dates, or is he entering them as well? If he's just selecting them, you can change the format of the displayed date to one that avoids confusion, such as "Jan 31, 2015".

If he's entering them, you're going to need to find a way to either restrict how he enters them or validate them after the fact. The former would be safer in the long run - if nothing else, I have around here someplace a bit of code written by Allen Brown that brings up a calendar, has the user select a day, and then places the selected date in a selected control on a specified form.

 

[Wile_E]

Thank you for the reply

he is only using the dates not entering them (that is done on another form as an admin function at the start of the year) so i guess i could change to a different format for the date...will changing the format of the table field mean i need to re-enter all the data ?

thanks again

Wile_E

 

[Frothingslosh]

Thank you for the reply

he is only using the dates not entering them (that is done on another form as an admin function at the start of the year) so i guess i could change to a different format for the date...will changing the format of the table field mean i need to re-enter all the data ?

thanks again

Wile_E

I would do it in the form, not the table. Either way, however, it only changes how the data is displayed, not how it is stored, so you should be good.