I have a problem of different date formats in an international study,
where the data entry module and error checking module are delivered to
the data collecting centres.
Error checking module displays queries for edit specifications, many of
them with dates. For exmple in Sweden, date format is YYYY-MM-DD, this
are how dates are displayed; However, the input mask had been specified
for tables as dd/mm/YYYY. This makes problematic using the error
checking module in Sweden. Solution could be if at start of the
application, the Windows regional settings could be changed for a time
of running the application.
I have not found the way to do this, is it possible at all.
Any suggestions.
--
Vlad 7 7709
Hi Vlad
You need to use the DateSerial function.
Can't see how it can help when dealing with a query based on tables
with specified input masks, which differs from local date format.
summerwind wrote: Hi Vlad
You need to use the DateSerial function.
--
Vlad
See:
International Date Formats in Access'
at: http://allenbrowne.com/ser-36.html
The article explains how values entered into the interface will be
interpreted according to the user's settings, how you need to format literal
date values in SQL strings and VBA code, and how to avoid the 3 situations
where Access will misunderstand your dates.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Vlad" <vl************ ******@ktl.fi> wrote in message
news:dr******** **@oxygen.ktl.f i... Can't see how it can help when dealing with a query based on tables with specified input masks, which differs from local date format.
A Google search finds numerous examples of code which will do this. One
is: http://a1vbcode.com/snippet.asp?ID=2722
I have largely given up using such code, preferring to write directly
to the Registry (with code), but that is irrelevant.
I think many developers would do what you propose to do, only as a last
resort, feeling that changing basic User Info should not be done by an
application, worrying that the change might work, with the change-back
failing for whatever reason, and that resulting in something bad
happening with other programs that rely on this setting, and worrying
about any application that might be running concurrently with the
Access application.
TTBOMK, Access/JET/MS-SQL SQLs are all perfectly happy with
#YYYY-MM-DD#, regardless of the ShortDate setting.
Perhaps there is some other safer way to meet your needs which we could
suggest if we knew more.
Thanks,
I will check this way.
I fact, I need to do this as temporal means to support the process.
1. There is a library of textual modules modeling the sections - part
of the study forms, an library of forms - ordered lists of sections.
2. Program tools in SAS(open VMS) and VBA generate MS Access modules
containing forms, modules and tables for data entering and HTML versions
of the forms being set on the website of the project.
3. The error checking modules are being produced as well, At the moment
manually but it goes also to be automated.
4. All the modules, but error checking, are centre-specific, in terms of
password and user names, fonts used in the text boxes and date input masks.
5. The data entered in the centres are regularly sent to me as MS access
files with tables for pooling and analysis, (SAS database is used).
before sending they automatically are stripped of the confidentional
information. Special interface has been developed to transfer MS access
tables to SAS (Open VMS) data sets. Industry-made means for this are not
available by now.
6. The entry database modules are upgraded and corrected run-time. The
new version are sent to the centres along with the interface module
pumping "old" data in the new tables.
7. Error checking module has dozen of queries grouped by forms which
mimic the original ones, checking the corresponding set of data.
By now, there were no problem with "other" date format, since this was
managed at the level of forms controls linked with fields of tables by
specifying a centre-specific input masks. Though, in tables the input
masks remained the same for all centres.
Queries use input mask of the corresponding fields of tables.
Possible "other" solutions:
1. I can also change input masks for tables, while generating the
database. This, however, will require to change SAS program reading the
CSV files where to the access tables are exported while transferring to
SAS datasets. - I know how to do this, but this requires quite a work
2. Specify input mask in queries, this looks too complex, and don't see
at the moment whether this is possible at all.
--
Vlad
!!!!!!!!!!
Perhaps, changing the setting is the only easy way, then.
Lyle Fairfield wrote: !!!!!!!!!! Perhaps, changing the setting is the only easy way, then.
Thanks for reference, it works.
--
Vladislav Moltchanov Ph.D.
National Public Health Institute
Dept. of Epidemiology and Health Promotion
Mannerheimintie 166, 00300 Helsinki, Finland
Tel: +358 9 4744 8644
Fax: +358 9 4744 8661 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Cesar Ronchese |
last post by:
Hello All!
I have a .Net project that, in my machine, the dates are showed in this
format: dd/mm/yyyy. But, when I install the project in some customer
machines, the date is showed in this format: dd/mm/yyyy hh:mm:ss.
My doubt is, I can resolve this problem on which form?
a) changing the Windows Regional Options
b) setting the Internationalization classes of my AppDomain
|
by: Laurence Neville |
last post by:
This is regarding a change in the Short Date format under Hebrew Regional
Settings, that has caused huge problems in our ASP web application. The
change appears to have been introduced sometime before Windows 2000 Service
Pack 4 and has remained through to Windows XP. I am looking for a solution
that doesn't involve rewriting our application (much) and that allows all
our users to keep using Hebrew Regional Settings.
To summarize our...
|
by: Javier Gomez |
last post by:
1-Is it possible to change Window's Regional Options from Access ??
2-Is it possible to know which Regional Options by defaul is active in
Windows (from Access)??
3-If something is possible.... please explain how ??
Thank in advance.
Javier
|
by: magister |
last post by:
Hello,
I know I can set the Culture to what I want, but shouldn't the current
culture be taken from the regional settings on the web server's
control panel!!!
Mine is set to "united kingdom"
but in my asp.net page I do
|
by: Colmag |
last post by:
I've written an application with vb.net 2003 (framework 1.1) which automates
a 3rd party viewing/printing application (via an activex control). I've
released several versions over the last year without problem, but since
getting a new laptop, people can't run the program since I built it with the
new machine. Even if I take the modified code and build it with my old
machine, it still crashes.
I thought maybe it was the code, but it...
| |
by: Harold Crump |
last post by:
Greetings,
This is not strictly a ASP.NET question, but I am hoping someone can
help.
I have an ASP.NET web app that used the DateTime.Parse and Compare
methods a lot.
As expected, the Regional Settings/Culture on the server (Windows
Server 2003), affects the behaviour of those DateTime functions (date
|
by: Janette |
last post by:
Hi,
I have done a lot of reading before doing this posting, but I just can't
find a solution that makes sense.
eg http://support.microsoft.com/default.aspx/kb/306044 - Behavior of
Date/Time format differs when accessed from Active Server Pages
and http://support.microsoft.com/kb/264063/ - VBScript Date and Time
Functions May not be Formatted Properly in Non-English (US) Locales
|
by: Luis Lanuza |
last post by:
Hi all,
I can't get Visual Studio 2003 to recognize my WindowsXP SP2 regional
settings.
For ex: On Control Panel / Regional Settings / Regional Options Tab, my
standadrs and formats corresponds to English (United States), where for
example, if you see on the Customize secction, the default decimal symbol is
a dot the digit group symbol is a comma.
The problem I have is that VS2003 wont recognize those settings, and is
|
by: pax |
last post by:
Hello there!
Here is my problem, in the simplest scenario:
- an Access 2000 format database (created with Access 2003)
- a simple table that contains one single field defined as Number, Decimal,
18,2
- VS2005 standard, C#
- a data source / dataset that cotains that simple Access table
- a DataGridView, created by drag and drop, with all the helper objects
(adapter, navigator etc) that edits that simple table
|
by: bvdb |
last post by:
Hi Everyone,
One of my customers lives in Taiwan and can only make my program work if he changes his Regional and Language Options to English from the Simplifies Chinese that his computer is normally set to use. Switching back and forth is very inconvenient for him.
Is there a way that I can compile my program so that it works with the Regional Options set to Simplified Chinese?
I set my PC Regional Options to Simplified Chinese,...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |