CONTACT US: 778-373-4422 | info@mackenziemackenzie.com


Photo by Kelly Lacy from Pexels

How to Use BOF and EOF in MS Access

10-August-2021
When you’re using recordsets in MS Access, it is useful to know when you’re at the very beginning or end of the recordset. This is where BOF (Beginning of File) and EOF (End of File) are very useful, and can help you to stop when you are traversing records. Checking for BOF and EOF can save you from running into errors (as we see in this video), and can make your code run more smoothly. Definitely a good tool in your toolbox!



MS Access? Contact me today!

3 Reasons Why You Should Learn Data Techniques

Find 3 big reasons why you should learn data techniques if you are a professional or business person.

Read article

About our workshop

The Professional Problem, 3 Things They Need, and 1 They Don't Have

Why do people constantly run into problems with their data, even when they are highly trained in their area?

Read article

About our workshop

Why Finding Uniqueness is the Key: 6 Methods to Help

Find out why keys and uniqueness are so important for data transformation and data analysis.

Read article

About our workshop

When to Excel and When Not To: Why Specialists Don't Use Excel for Data Transformations

Start your journey in data transformation, and learn why specialists don't use Excel to transform raw data for analysis.

Read article

About our workshop