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

Don’t make these two file naming mistakes

Fuel Reporting with QODBC

Update QuickBooks from Microsoft Access

QuickBooks to PDF Payroll Tax Forms

Linking Spreadsheets in Microsoft Access

How to View QuickBooks Transactions with QuickBooks Closed

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

QuickBooks ODBC Database Rules 1

How to Migrate Transactions from Microsoft Access to QuickBooks Part 3

How to Migrate Transactions from Microsoft Access to QuickBooks Part 2