Recent content by rgh

Cosmark, Unfortunately if the company's approach is as you have described then Relativiy is your only hope. Overall Relativity does the job that you want it to do, just do not push it, and do not expect implementing it to be the easiest thing you have ever done. That should be enough to keep...

Cosmark, Is there any reason why you need to keep the Cobol data files? When you say "bring their system to the new century", do you mean let them still use the Cobol data capture screens and let them use Access etc. to access the data for reporting etc. or are you planning a...

I have coded the function below and I now use this to display fields with the currency symbol, however I run into another problem now. My current regional settings are "English(UK)" and when I change gstrCurrencySymbol to be $ everything displays fine, however when I do a ccur on any...

Thanks Chip - never would have got that myself.

Hi, Is it possible to change the default currency at run time. Our user's regional settings are set up to be Sterling, however they want to use our system for 2 databases, one showing Sterling and one showing Dollar. Is is possible to change the default currency for the exe that is ran to show...

To get round this problem I forced the programmers to use a specific folder on a central server as their work folder with anything that they worked on checked out into these folders. I then created a batch file that zips the contents of the folder into a zip file, which was then moved into a...

The reason for putting it into a function is so that is the routine can convert both ways. System is in Pound, user wants to display Pound and have the option to convert to Euro. Run a conversion on system to convert all values to Euro. System will be in Euro, user wants option to display in...

Thanks Sunaj, The last example is roughly how I have the coding done, however I was looking for a lazy way of changing the statement to populate the label. I was hoping that somehow I could call a function from within the format statment and pass the value to be formatted. Thanks again, Richard.

That is what I want to do. If you set up a new exe and just add the code ----- Private Sub Form_Load() Dim strValue As String strValue = Format(23.44, EuroConvert) End Sub Private Function EuroConvert() MsgBox "EuroConvert" End Function ------ The Message box in the...

Possibly I did not explain as well as I could. The system currently uses the currency as per the set up of the PC. so LblDisplayValue.Caption = Format(23.44,"Currency") will return £23.44 into the label. However what I want to be able to do is allow the user to view the currency...

I want to easily convert fields displayed within a system from one currency to another, in my case this is Pound to Euro. Currently our code has LblDisplayValue.Caption = format(curValue,”Currency”) I know that it is possible to change the Currency part to be the name of a function, e.g...

Hi Jason, E-mailed the code to you this monring. Hope it helps out. Richard.

Yes, In the VB App that we use we do all out processing in VB code and write out a temporary access database that Crystal reports then uses for the report. We use a global connection to this database which always remains open. To sort out the problem I closed the connection to this database...

OK, 2 more thoughts then, 1. The connection to one of the databases is open and therefore locked so Windows will not allow you to zip the mdb. Try closing the connection - difficult if multi-user. 2. Debug the call to pkzip by doing the following Change you pkzip.exe to pkzip.bat and...

Looks like the paths are not being picked up. Should it not read n = LocationZip o = LocationXtrain & " " & LocationsUser Richard