Visit our new web pages

We have launched a new extended set of web pages at www.alvechurchdata.co.uk. These old pages will stay on the server because people still have links to them but they will not be updated.

The new version of this page is at www.alvechurchdata.co.uk/hints-and-tips/foxprotips.html.

Visual FoxPro Tips

Database development in Visual FoxPro requires a range of skills. FoxPro is a relational database so an effective solution must be based on a sound database design and must make the best use of the features of the FoxPro language. We hope that these tips help you make the most of FoxPro and VFP.

Most of these tips apply to Visual FoxPro (VFP 3 to VFP 9) although some can be applied to FoxPro 2.6 or earlier versions. This is not a FoxPro tutorial, you will need to know something about the language to get benefit from these tips. All are provided for your guidance rather than as solutions to particular problems. Refer to the FoxPro Help system for more detailed information about the commands used:

• Add a checkbox to a grid.
• Add buttons to the Fox desktop.
• Addresses in a consistent format.
• Advanced features of Find.
• ASCII codes.
• Autocomplete in VFP 9.
• Autocomplete table structure.
• Base classes.
• Bit manipulation functions in FoxPro.
• Calculate, an alternative to SQL.
• Calculator tool in FoxPro.
• Calendar and Diary.
• Cannot Quit Visual FoxPro.
• Checksum to improve security.
• Clipboard transfer in FoxPro.
• Converting from FPW26 to VFP.
• Command line switches.
• Configuration file.
• Copy data to delimited text files.
• Creating an array with SQL
• Custom controls on the Form Design toolbar.
• Date functions in FoxPro.
• Design a form to make data entry easier.
• Displaying messages in FoxPro.
• Fast way to lookup Fox data.
• Files required to distribute a VFP application.
• Fonts for data entry
• Forms in an executable flash on the screen and vanish.
• Functions for file names in FoxPro.
• Gotcha!
• Hide the main FoxPro window.
• HTML from FoxPro
• Intellisense
• Links to other FoxPro sites.
• Lotus Approach data in Visual FoxPro.
• Low level file handling.
• Merge data into text files
• Multiselect list boxes
• Numeric functions in FoxPro.
• Object parameters
• Save files to the Windows Desktop
• Service Pack 1 for VFP 8.
• Starting FoxPro
• Switching between Development and Runtime
• Table functions in FoxPro.
• Text functions in FoxPro.
• Top ten tips
• Trivia quiz.
• Tutorial for new users of FoxPro.
• Useful commands.
• VFP 8
• Wrap the calls to MessageBox.

If you need to know more about FoxPro and Visual FoxPro we run a series of workshops, tutorials and training courses to help you.