Need some assistance in importing data from an Excel spreadsheet into a table in Access. I need to be able import students into a class. When I click in 'create a new class' a dialogue box opens up when a new class record started as seen by the last screenshot below. I need to import students to 'that' particular class. I am familiar with the VBA code docmd.TransferSpreadsheet command and can 'import' students but need to know how to do this for a 'specific' class.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc.
In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
How can you see what you are working on when you want to see it while you to save a copy?
Add a "Save As" icon to the Quick Access Toolbar, or QAT.
That way, when you save a copy of a query, form, report, or other object you are modifying, you…