I have started a new access desktop database project for tracking production in our printing department. I have a main table with general production data. I have an hour table that will keep track of all employee hours and rates. I also have a supplies table that will track supply cost.
I had originally tried putting all fields in one table but there are too many fields to track to do this.
I am have a great deal of difficulty linking both the hours and Supplies table to the main table at the same time.
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.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro: