Re: Accounting with Ms Access



I have successfully integrated Access databases with People's Choice
Accounting which is written in Access:

http://www.peoples-choice.com/
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Thomas" <JustAsk@xxxxxxxx> wrote in message
news:rQldj.32851$JD.13560@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello all I have been working on a database for are small retail Tile
company (we do everything by pen and paper now). I have been able to setup
a working Orders/Invoice table and forms, CreditMemo table and forms, and
PurchaseOrder table and forms all based on the Northwind Sample Database.
"Thanks to all the help here". I have been searching for a sample database
with accounting. With A/R, A/P, Billing Statements and so on. I am not a
programmer or accountant so the chance of me doing something wrong is
pretty good. I am hoping that someone has a add-in MsAccess database for
sale that would link to my tables and do the accounting process. I have
looked at Ms Accounting 2008 and QuickBooks 2008 no way to link the tables
to the programs I can see. Any help or suggestions welcome.

Thank in Advance
Thomas
wills.t.NOSPAM@xxxxxxxxxxxxx <Remove .NOSPAM>

PS.
Happy New Year
And Best of Wishes for You and Yours in the New Year



.



Relevant Pages

  • Re: Database Design
    ... In practice I know of working, real-life Access databases with 20,000,000 rows ... Oracle or DB2 database containing terabytes of data. ... Many to Many if it is for accounting software? ... containing money, and Creditors who get money, there will be a many to many ...
    (microsoft.public.access.modulesdaovba)
  • RE: database with yearly split data
    ... i am designing a database for a firm that has annual period of the accounting. ... balances of the suppliers and customers accountings ... as the first records in the new database accounting tables and stock tables. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Looking for inventory management and invoicing programs
    ... > Good point Rick, but I think most of the problematic issue with Y2K related ... Accounting program used 4 digits for data in the year ... Database program generated "automatic dates" using Julian ... It simply went nuts trying to report dates after 12/31/1999. ...
    (comp.sys.tandy)
  • Re: Database Design
    ... Thanks John for your extensive explanation. ... Oracle or DB2 database containing terabytes of data. ... Many to Many if it is for accounting software? ... containing money, and Creditors who get money, there will be a many to many ...
    (microsoft.public.access.modulesdaovba)
  • Re: Simply Accounting
    ... It actually turns out that simply accounting uses ms-access files (and the ... counting uses the same database format as ms-access. ... also, and if you don't join that workgroup file, then you'll not be all to ... Dim strTables As String ...
    (microsoft.public.access.modulesdaovba)