Acqrprts.mdb P_Order-P date format not editable in Access 2010
- Article Type: General
- Product: Voyager
- Product Version: 7.2.1
Description:
Bug Report Form for Issue 16384-15969
Module(s): acqrprts.mdb
Server platform(s) affected: Solaris/all
Access version: 2010
Loss of functionality from (previous version, if applicable): Access 2003
Expected results:
You should be able to edit the date format in the acqrprts.mdb
Open P_Order-P in the .mdb, and try to reformat the [P O Date] field on landscape-format printed purchase order, and you’ll get an error prompting you for a value for the parameter "Format".
This does not happen in Access 2003.
Workflow implications: Operators can’t reformat the date.
Replication steps:
Go to C:\Voyager7\Reporter\Acqrprts.mdb on any workstation.
Open P_Order-P in the .mdb in design view.
Look at the [P O Date] field on landscape-format printed purchase order -- it's this format: =Format([P O Date],"dd mmm yyyy")
If you edit the format, even with valid syntax, you'll always get an error prompting you for a value for the parameter "Format".
Other information:
If you go to Visual Basic>Tools>References>Libraries, you'll see that for the acqrprts.mdb in 2010, MS ActiveX Data Objects 2.x is not checked. Once checked, changing the date format is successful.
Resolution:
- Article last edited: 3/19/2015