>Anyway to get a default FileName already typed in for this user so he doesn't have to pick one if he would just like to select the default one I gave? (like LOCFILE does)? I can't use LOCFILE as that will pick the file if in fact it does exist.
>
>Thanks in advance.....
>
>Mel
Hi,
when our users generate their own reports (based on our default versions) they can define any name they want. period.
However....
any unwanted character found in the filename will be replaced by blank within textbox valid event.
This.Value = ALLTRIM( CHRTRAN( This.Value , [!"§$%&/()=?\*+'#-.:,;|] , [ ] ) )
Additionally, that name isn't used as identifier as it will only be a part of the real filename.
In case the users reportname input is "my 1. reporttest & so on" it will be converted to "my 1 reporttest so on".
After that, a unique ID is created by a stored procedure (GetNextReportID) within the DB and stored in a ID table.
This ID is used in the filename -> i.e. "001234_my 1 reporttest so on.frx|frt"
The generated reportname is stored in a table thats used for report selections. This way users don't get access to the file directly.
To be honest, the users filename definition doesn't even have to be part of the real filename at all. It simply helps our supporters to identify reports.
Best Regards
-Tom
Debugging is twice as hard as writing the code in the first place.
Therefore, if you write the code as cleverly as possible, you are,
by definition, not smart enough to debug it.
Oh, and BTW: 010101100100011001010000011110000101001001101111011000110110101101110011