Skip to main content

Posts

Featured

QODBC: How to Disable Non-Updateable Fields

If you use QODBC to create your own QuickBooks add-ons with Microsoft Access, this article might interest you:

https://www.experts-exchange.com/articles/30860/QODBC-How-to-use-VBA-to-Disable-Non-Updateable-QuickBooks-Fields-on-a-Microsoft-Access-Form-Part-2.html

It's part 2 of my 2 part article recently published on Experts-Exchange.

You don't want users trying to change data that's not updateable but instead of manually disabling those fields, a bit of code lets VBA do it for you when the form opens. Any form. 
This means when QuickBooks changes a field's updateable value, the form automatically changes too.
There's a bonus as well. If there are fields you don't want users to update, like social security number or others, this method lets you add those fields to a table so VBA disables them on the form in spite of their updateable value.
Here's the link to Part 1, which you need to complete Part 2:
https://www.experts-exchange.com/articles/30664/QODBC-How-to…

Latest Posts

Image

Don’t make these two file naming mistakes

Image

Fuel Reporting with QODBC

Image

Update QuickBooks from Microsoft Access

Image

QuickBooks to PDF Payroll Tax Forms

Image

Linking Spreadsheets in Microsoft Access

Image

How to View QuickBooks Transactions with QuickBooks Closed

Microsoft Access Database Error -2147352567: The data has been changed.

QuickBooks ODBC Database Rules 1

Image

How to Migrate Transactions from Microsoft Access to QuickBooks Part 3

Image

How to Migrate Transactions from Microsoft Access to QuickBooks Part 2