Microsoft Access Database Conversions

We provide solutions for Access databases that have become unstable and slow from large amounts of data. Our experts will migrate your data to a SQL Server backend database, keeping the existing screens, and use SQL Server’s robust scalable backend solution for storage and reporting.

By Admin

Properties Window

The Properties Window is found directly below the Project Explorer window. It displays the properties for the object currently highlighted in the Project Explorer. If the Project Explorer is not visible when you open the Microsoft Visual Basic window, you can make it visible by selecting Properties Window under the View menu.

By Admin

Access Report Field Not Exporting to Excel Consistently

Recently, I experienced an issue with an Access report that was exported to Excel - sometimes one particular column was not being exported. This was confusing because there was no error messages but for certain sets of ...

By Admin

Adding Objects to a Form

Once the Record Source has been identified, Access provides the ability to easily drop objects onto the form. In the toolbar near the top of the page, click on the button called Field List. (In the example below, it is located directly under Adobe PDF. It looks like a piece of paper with writing on it.)

By Admin

Viewing a Report

Up until now, you have been editing and viewing your report in the Design View. Once the design has been completed, you will want to view your report as a user would view it.

By Admin