Skip site navigation (1) Skip section navigation (2)

Re: time columns: ms-access bound controls

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: lists <lists01(at)dds(dot)uconn(dot)edu>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: time columns: ms-access bound controls
Date: 2004-07-15 13:34:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
--- lists <lists01(at)dds(dot)uconn(dot)edu> wrote:
> hello -
> i have an ms-access form with a textbox bound to a
> "time" column in an 
> underlying postgresql table.
> initially, the field displays correctly:
>     16:00
> ...but when i click in the field to begin editing,
> the text in the 
> textbox changes by adding a date component set to
> the current date:
>     7/15/2004 4:00:00 PM
> this is would be quite confusing to our users.

This is a display problem, not a data problem.  You
need to set the display format, either in the control
properties, or in the table properties.  Probably
easiest to set the format at the table level (open in
design view, highlight that field, set the "format"
value to your preference.

> is there a work-around for this?  i'm in the process
> of moving a number 
> of ms-sql server / ms-access apps to web-based ui's
> hitting our 
> postgresql database, but i need to get the access
> apps working with the 
> postgresql first...
> btw, i'm using  postgresql 7.3.3 on red hat 7.2
> thanks
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?

Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages! 

In response to


pgsql-odbc by date

Next:From: Dario V. FassiDate: 2004-07-15 19:16:19
Subject: pgODBC and Unicode
Previous:From: listsDate: 2004-07-15 06:36:29
Subject: time columns: ms-access bound controls

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group