Is it possible to change the caption name on a report on opening it?
Mine is currently called "Transaction summary", but I would like to change it to something like the following:
The DCX#### is the name of the unique autonumbered field. I'd also like a date stamp on it and then another unique number. Ideally, I'd also be able to automatically log this number on another new table.
Is this possible? Or are only parts of it possible?
I've modified it slightly to make it look nicer on the eye. The only other minor problem is that the case_number is, as standard a number between 1 and 9999. On all forms etc it's formatted as 0001 or 0025, etc. What sort of code is recommended to put this formatting in?
To log this unique "DCX number date time" in a field in another database.
Would I create a database with autonumbers, etc and then add this as a sort of a hidden field in the report it self. Then instead of the top code with "DCX" & Case_number, etc I would direct it to this hidden field.
The above code is put into an Event Procedure in the Active section of a Report (in the case of this example, the report's called "Inclusion Letter". What the above does is create a title for the report using the Case_number and also a date/time stamp to uniquely identify the correspondence.
When I preview the report, I print to the MS document image writer.
It asks where I want to save the file (The file name is the same as the report name noe and I save it as an MDI file) and I save it into the customer's directory. Once I click save, it immediately opens up the file for me to print. PERFECT.
The only modification I want to do now, it to try and create a unique ID (using the DCX case_number as a prefix) and log this report on to another database. I can't get my head around how to do this though.
Do I code this unique number which is to be generated and logged into a database, by coding the print/preview button on the form?