Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: FoxAl
  • Order by date
  1. FoxAl

    MS Mail Merge Questions

    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...
  2. FoxAl

    bnormal program termination - Memory protection fault

    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...
  3. FoxAl

    bnormal program termination - Memory protection fault

    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...
  4. FoxAl

    Scanning Documents Electronically

    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
  5. FoxAl

    Improve Speed across Kilostream Link?

    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...
  6. FoxAl

    Improve Speed across Kilostream Link?

    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...
  7. FoxAl

    Improve Speed across Kilostream Link?

    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...
  8. FoxAl

    Improve Speed across Kilostream Link?

    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...
  9. FoxAl

    Unexplained Events

    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...
  10. FoxAl

    how to send an automatic email from foxpro for dos 2.6 application

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

    Multi User Record Locking / Unlocking

    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...
  12. FoxAl

    Multi User Record Locking / Unlocking

    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...
  13. FoxAl

    Multi User Record Locking / 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...
  14. FoxAl

    Can Users Modify Reports

    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...
  15. FoxAl

    Scanning Documents Electronically

    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...
  16. FoxAl

    Scanning Documents Electronically

    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...
  17. FoxAl

    Can Users Modify Reports

    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...
  18. FoxAl

    Printing in Landscape - problems

    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...
  19. FoxAl

    Help needed with Report Design

    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...
  20. FoxAl

    FoxPro 2.6 doesn't support SQL in stand-alone exe.

    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 =...

Part and Inventory Search

Back
Top