Search results for query: *

if I have many numerical fields in format #,##0.00 how can I ensure that they are all aligned under each other such that all decimal points are 1 under the other. I guess it is to do with tab stops but cant find the winning solution. Also, more difficult, if I have a system default setting...

it calls a procedure library which through various sys and function calls checks that the printer is on-line, is networked or local etc. Having done that, it then checks the user input as to whether it is a detailed or summary report, whether or not to page eject before and/or after report...

Upon printing any report within the system, the Foxpro application will return a message to user saying 'Busy... Please Wait whilst printing'. This is one of my programmed messages and is fine.This flashes and continues to flash until:- However after a few seconds the whole application 'moves...

MorgyDogy, Thanks for the offer but this post was made Dec 2002 - 18 months ago!! It has long since been closed and advice offered to user was that it was not feasible. I'll keep your alias in mind though should anyone else ask. FoxAl

DSumm222, The anti-virus software is running on these PC's. It is outwith our control to check or disable this or prove that it could be a possible cause and the politics are such that we support software for the app but not other apps, hardware, links or networks. This is not so much passing...

DSumm222, Thanks. I already have the exe set up with a set path command as you suggest, not in exactly the way you suggest but similar. I create a system.dbf in the root dir of where the exe lives on the server with a field called app_path. The users can edit this field to point to where their...

Cricket, I need all users who are sharing files within the application to be able to see other users changes as soon as they are made. If I set up an executable on each users PC at the remote site then we would have multiple copies of the data with everyone only seeing their own changes. It is...

I have standalone Foxpro 2.6a for DOS executable running on 2 sites connected by Kilostream link. All PC's (W2000) are mapped to server where executable resides. On the site where the application resides, accessing and logging on to the application is virtually instantaneous, however, on the...

Have 1 site where a number of unexplained events are hsppening:- 1). Users make payment (BACS) one day, this payment is recorded , yet some days later, it is deleted, both the person and payment. In looking at deleted records on table I can see it there as deleted. The system does not allow...

I, too would be interested to try this code. Where can I locate a copy of procedure library file :- FOXTOOLS.FLL ? Thanks

Rick, Thanks, you are right re the unlocking and disk caching. Have now been able to replicate error re ownership of data by 1 user. It seems to work differently though on different Operating Systems. I have issued unlock command in various code snippets of the form unload events (Deactivate...

Rick, It is not a true server application, it is used for Word, Excel and another Foxpro Application. The server is NT4.0. On the optimisation thing - why would you ever want a file/record locking mechanism that takes minutes to unlock? What do you have to do to make the unlocking...

Have a problem with Multi User Site whereby if 2 users try to access the same record one gets in but the other receives the error message:- 'Cannot Lock the Current Record in MyFile, Try Again' with options for 'Yes' & 'No'. This is normal behaviour but once 1 user exits the record and the...

Rick, jrbbldr, Thanks for confirming what I suspected was true about not being able to modify reports self contained within the APP/EXE. I will need to evaluate the 3rd party products mentioned and mark the reports as external to the application. I further take the point re the dangerous...

Thanks! Rick, I take the point about adding new functionality to old software but VFP is not an option currently. If the customer wants it and it is available, then we are merely the messengers in providing the goods. Dave S, I appreciate the lengthy reply and info and welcome the warning re...

I am investigating how to Scan Documents Electronically into a Foxpro (DOS) Application rather than have the users input the data manually. If possible, a few queries arise:- 1. How do I set up procedure for such. 2. How do I access an update table from results scanned 3. Error Routines...

I have a number of pre-defined reports which are included within an APP which in turn are shipped in an Executable to the end users. They would like ability to modify and save changes to these reports. Is this possible by still keeping the report self contained within the APP? If not, what are...

There is an alternative way to the above. Create a new Printer Driver through Printer Driver Setup. Choose New and give it a name - say LandRep. At the top of the screen you will see a number of option buttons. Under orientation there is either Landscape or Portrait. Choose Landscape. Select...

I am using Crystal Reports, but the principle is independent of this. I have three tables: A, B and C. (there are at least 5 tables in fact - but the essence is 3) B and C relate to A but not to each other. A is related to B and C by left outer joins. There is a select on A so that only one...

Use Macro Substitution to run your SQL statement. Build up the SQL select string into a Memory Variable and then put the &(Macro Substitution character) in front of the Memory Variable such that you interpret the changes at Run Time. i.e SelectStr = "Select " FieldList =...