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.

Site Map

• About Us
• Access
• FoxPro and Visual FoxPro
• General Topics
• Training

About Us

• British Computer Society (BCS)
• Description of Alvechurch village
• Features of Alvechurch
• General information about Alvechurch Data
• Geoff Franklin
• History of Alvechurch
• Home Page
• Legal notes
• Site map
• Slant Design - collaborative projects
• Where is Alvechurch?
• Where can we buy this picture?

Access

Tips for developers and users of Microsoft Access. Covers versions 2.00 to 2003.

• Access XP.
• Backup an Access database.
• Centre controls on Access forms.
• Choose the right tool - Access or Excel.
• Common Dialog control to choose a file name.
• Compacting a database.
• Custom toolbars in Access.
• Cut, Copy, and Paste.
• DAO in Access 97.
• Database Support.
• Date functions in Access.
• Datestamp as a filename.
• Editing method code.
• Error log to improve debugging.
• Faster queries.
• Form design.
• Generating primary keys instead of using AutoNumber
• Lines on Access forms.
• Linking tables from another database.
• Linking two listboxes.
• Links to other Access pages.
• Logical functions in Access.
• Migrating to Access XP.
• Numeric functions in Access.
• Pictures.
• Queries with "In" and "Between".
• Random numbers from Visual Basic
• Simple backup techniques.
• Search options.
• Shortcuts for entering data into an Access form.
• Splitting a database into code and data components.
• SQL date formats.
• Startup options in Access.
• Subqueries.
• Switchboards in Access - Part 1
• Switchboards in Access - Part 2
• Switchboards in Access - Part 3
• Switchboards in Access - Part 4
• Text handling functions in Access.
• Top ten tips.
• Turn off the Office Assistant.
• Types of Query - Modify and Delete.
• Wild cards in searches.
• Wrap the calls to MsgBox.

FoxPro and Visual FoxPro

• 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.
• Cannot Quit Visual FoxPro.
• Calendar and Diary.
• Checksum to improve security.
• Clipboard transfer in FoxPro.
• Converting from FPW26 to VFP.
• Converting from FPW26 to VFP - Data.
• Converting from FPW26 to VFP - Program Code.
• Converting from FPW26 to VFP - Menus.
• Converting from FPW26 to VFP - Reports.
• Converting from FPW26 to VFP - Screens.
• Converting from FPW26 to VFP - Strategy.
• 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.
• 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.
• Lotus Approach data in Visual FoxPro.
• Low level file handling.
• Low level file handling - FCREATE()
• Low level file handling - FOPEN()
• Low level file handling - FREAD()
• Low level file handling - FWRITE()
• Low level file handling - FCLOSE()
• Links to other FoxPro sites.
• 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.
• Tutorial - Advanced features.
• Tutorial - Building an executable.
• Tutorial - Databases.
• Tutorial - Development environment.
• Tutorial - Do Case selection.
• Tutorial - Do ... While loop.
• Tutorial - For ... Next loop.
• Tutorial - Form designer.
• Tutorial - Goto statement.
• Tutorial - If ... Else ... EndIf structure.
• Tutorial - Navigation buttons.
• Tutorial - Program code.
• Tutorial - Program structure.
• Tutorial - Project manager.
• Tutorial - Scan loop.
• Tutorial - Tables.
• Tutorial - Variables.
• Useful commands.
• VFP 8
• Wrap the calls to MessageBox.

General Topics

• Address formats
• ASCII codes.
• Automatic backups
• "Data", singular or plural?
• Database Support
• Design a form to make data entry easier.
• Duplicate records
• Error handling
• Fonts for data entry
• Golden ratio in form design
• Normalising a database
• Searching the site
• Software Development
• Delivering a database
• Specifying software
• Top ten tips
• Tower of Hanoi pattern of backup

Training

• Access
• Crystal Reports
• Database Design
• FoxPro
• General Conditions for training courses
• Training