M
Mick
To Microsoft. The following was posted to the Frontpage News Group, and
although I can see many have taken a look at the problem, as yet there have
not been any replies.
Posting as follows
I have a set up a test Database Interface Wizard in Frontpage for my Access
database, to demonstrate the problem.
http://www.prstructuralglazing.com/_database1_interface/property_table/editor/login.asp
user = “a†password=â€aâ€
There is a date field called “datebookedon†default set to “Date()â€.
There is only one record in the test database.
If I view the details, via the DIW ok.
If I go to edit, no problem.
As soon as I say ok (i.e. finished editing), all the date fields change values
, unless the number of the day is over 12 which would make the change
a nonsense.
e.g. 08/09/2006 becomes 09/08/2006. but 26/08/2006 does not change.
If you then go to edit again, and just do a save the date switches back, and
will toggle every time you edit the record. As I am using this field to
calculate time since the record was entered, it throws out the whole system.
I thank you for your interest. Mick
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...821f46c2&dg=microsoft.public.frontpage.client
although I can see many have taken a look at the problem, as yet there have
not been any replies.
Posting as follows
I have a set up a test Database Interface Wizard in Frontpage for my Access
database, to demonstrate the problem.
http://www.prstructuralglazing.com/_database1_interface/property_table/editor/login.asp
user = “a†password=â€aâ€
There is a date field called “datebookedon†default set to “Date()â€.
There is only one record in the test database.
If I view the details, via the DIW ok.
If I go to edit, no problem.
As soon as I say ok (i.e. finished editing), all the date fields change values
, unless the number of the day is over 12 which would make the change
a nonsense.
e.g. 08/09/2006 becomes 09/08/2006. but 26/08/2006 does not change.
If you then go to edit again, and just do a save the date switches back, and
will toggle every time you edit the record. As I am using this field to
calculate time since the record was entered, it throws out the whole system.
I thank you for your interest. Mick
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...821f46c2&dg=microsoft.public.frontpage.client