For me the template is a starting point - look at the table design and think (deeply) about whether they can hold the sorts of data you need. look for gaps you need - set your scope - eg will you need to track depreciation? service schedules? service companies/contractors/employees. When you have thought thru the data needs, map out your tables - and the relationships between the tables - post it here for review / advice. use AI to discuss the structure of your tables. Create your database and import useful elements from the sample database then modify - but only those things you understand. Then build your forms - look at the functionality in the template to see if you like the workflow. build on that - identifying and building the queries you will need for your forms and reports. This is your first database? It is a steep learning curve but there is lots of support/samples out there - ideas and snippets you can grab and use. Start simple, plan and build. Think about what happens after it is built : do you only expect yourself to use it? How would someone else take it over? Think documentation - describing its workings.
A general question
- Thread starter Able_Allan
- Start date
- Local time
- Today, 02:22
- Joined
- Oct 29, 2018
- Messages
- 22,601
I think this is possible by using third-party ODBC drivers like this one.
QuickBooks ODBC Driver | Easily Connect to Live QuickBooks Data
The QuickBooks ODBC Driver is a powerful tool that allows you to connect with live data from QuickBooks directly from any applications that support ODBC connectivity. Access QuickBooks data like you would a database - read, write, and update Customers, Transactions, Invoices, Sales Receipts...
cheekybuddha
AWF VIP
- Local time
- Today, 10:22
- Joined
- Jul 21, 2014
- Messages
- 3,051
I think this is possible by using third-party ODBC drivers like this one.
QuickBooks ODBC Driver | Easily Connect to Live QuickBooks Data
The QuickBooks ODBC Driver is a powerful tool that allows you to connect with live data from QuickBooks directly from any applications that support ODBC connectivity. Access QuickBooks data like you would a database - read, write, and update Customers, Transactions, Invoices, Sales Receipts...www.cdata.com
Ouch!
cheekybuddha
AWF VIP
- Local time
- Today, 10:22
- Joined
- Jul 21, 2014
- Messages
- 3,051
- Local time
- Today, 02:22
- Joined
- Oct 29, 2018
- Messages
- 22,601
Here's another possible option. I didn't check the pricing on this one either.At $499 a year !
How to install and set up the QuickBooks Enterprise ODBC Driver
Learn how to install and set up the QuickBooks Desktop Enterprise ODBC Driver.The QuickBooks Open Database Connectivity (ODBC) driver from FLEXQuarters allows y
- Local time
- Today, 10:22
- Joined
- Feb 19, 2013
- Messages
- 17,516
re quickbooks, a simple google found this link
no idea if it will work, you would have to try it
no idea if it will work, you would have to try it
- Local time
- Today, 05:22
- Joined
- Feb 19, 2002
- Messages
- 47,352
Absolutely, YES. If you want direct access to Quickbooks, you need to purchase the quickbooks ODBC driver and you have to be running the application on the same LAN as Quickbooks. If you are using one of the Quickbooks versions in the cloud, you are probably SOL for direct access unless QB offers an API. This will not be fun for real time interaction. As indirect access, you can export files from QB that you import into Access and you can export files from Access that can be used to update QB. Again, if your QB is cloud hosted, you have the same problem. You are limited to whatever API they offer. I am not current on any of these methods. I have only worked with local installs that could use the ODBC driver which Access can just link to as it does to any other RDBMS.
I agree with @mike60smart. You couldn't pay me to use a MS template for anything. Let it give you ideas but build your own app from scratch. You don't save yourself any work by using poor examples. The new NorthWind is different since it was developed by Access developers for developers BUT it doesn't do what you want. So, you can get good technical ideas from it but not any application design ideas for the type of system you are building.
My community is small. Only 60 units so we don't have the bandwidth to manage running the show ourselves. We outsource to a company that handles the day to day work. The HOA board comes up with an annual budget with the management company and we approve the subcontractors who do the lawn, pool, and snow removal. For small fixits, the management company either uses their own staff or hires masons or carpenters or painters for whatever jobs they can't do. Mostly the HOA is responsible for exterior maintenance. We do get involved occasionally for interior jobs that are covered by insurance so a roof leak that causes interior damage would be fixed by us but probably by a subcontractor because the maintenance company wouldn't have the type of skills necessary to do drywall for instance.
