I have an outside office that has access to our servers here at that main office. I tried to put an Access app I made that works great in the main office. All the tables are in a BE Access. When I put the FE on the satellite office it takes forever to open a form with a linked BE table. I am sure it is connectivity between the offices. That said I can do nothing about this at this time. So I thought maybe I would go to MS SQL Server. When I put the tables in the BE will that be any faster? Do I need to link to the BE on SQL Server? What is the best approach in a case like this?
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
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: