473,739 Members | 6,186 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Chicago Access Users Group meets May 25: Quickbooks integration, Total Access Analyzer from FMS

What: CAUG Meeting - QuickBooks IIF Files; Total Access Analyzer; CAUG
Social
When: Thursday, May 25, 2006, 6PM
Who: Chris Monaghan and Kevin Anderson
Where: The Information Management Group
200 W. Monroe St. Suite 900
Chicago, IL 60606
(312) 222-9400
Location: www.imginc.com/IMG/About+IMG/chicago.htm

[RSVP REQUIRED: email in**@caug.com and add "ATTENDING" to the subject
line. Must RSVP by 10 AM the day of the meeting to be recognized.]

All,

It's time to wrap up another CAUG season. The 2005-2006 campaign has
been a good one as we've welcomed some new speakers, topics, and
members. I want to thank everyone for their participation and special
thanks to IMG, for continuing to be gracious and generous hosts. For
those of you that are new, CAUG will resume again in September.

For this year's final meeting we welcome Chris Monaghan and Kevin
Anderson back to the speakers stand. Chris recently worked on a
project the required integration with QuickBooks, the most popular
accounting program for small businesses. Kevin takes a look at a new
version of a longtime Access product, Total Access Analyzer.

QuickBooks Integration Example
by Christopher Monaghan

Intuit's QuickBooks Accounting package is wildly popular in small
businesses (including my small business). This presentation will
demonstrate how to load your external accounting data into QuickBooks,
using Intuit's IIF Format (Intuit Interchange Format). In Chris'
project, he creates an IIF file from within his Microsoft Access
application.
About Chris
Chris is president of Business Data Designs and a former CAUG VP. He
does independent consulting that includes training and programming. He
has been a regular on the CAUG speaking circuit.

Total Access Analyzer
by Kevin Anderson

FMS Software is a long time provider of Microsoft Access tools and
utilities. Their flagship product, "Total Access Analyzer" has been
around since 1994 has been the winner of every "Best Access Add-In
Award", since that time.

Kevin will give us a quick tour of Total Access Analyzer and will
discuss how it can help the Access professional.

About Kevin
Kevin is president of Anderson Information Technology Inc. He develops
and maintains database system solutions for small and mid-sized
organizations and specializes in Microsoft Access. Kevin is an MCP in
Access and Visual Basic and has an MS in EECS from University of
Illinois - Chicago.

CAUG Social

Help us to celebrate the end of another successful CAUG season by
attending the CAUG Social, right after the meeting. We'll raid the
CAUG coffers, buy a couple of rounds, and toast to another great
season. If you're particularly thirsty, bring some cash as CAUG
generosity doesn't exceed two rounds. The location is yet to be
determined but will be a short walk from the meeting. Please join us!

May 19 '06 #1
14 2585
"Kevin G. Anderson" <kg*****@pobox. com> wrote in message
news:11******** ************@j5 5g2000cwa.googl egroups.com...
What: CAUG Meeting - QuickBooks IIF Files; Total Access Analyzer; CAUG
Social
When: Thursday, May 25, 2006, 6PM
Who: Chris Monaghan and Kevin Anderson


As strongly as I believe in User Groups, and as good a reputation as CAUG
has, I have to point out the FAQ for this newsgroup,
http://www.mvps.org/access/netiquette.htm which contains the charter, which
does not specifically permit advertising, and the request that you not
advertise anything, even free stuff. Thanks for your consideration in the
future.
May 22 '06 #2
"Larry Linson" <bo*****@localh ost.not> wrote in
news:oQccg.4168 $oa3.157@trnddc 08:
"Kevin G. Anderson" <kg*****@pobox. com> wrote in message
news:11******** ************@j5 5g2000cwa.googl egroups.com...
What: CAUG Meeting - QuickBooks IIF Files; Total Access
Analyzer; CAUG Social
When: Thursday, May 25, 2006, 6PM
Who: Chris Monaghan and Kevin Anderson


As strongly as I believe in User Groups, and as good a reputation
as CAUG has, I have to point out the FAQ for this newsgroup,
http://www.mvps.org/access/netiquette.htm which contains the
charter, which does not specifically permit advertising, and the
request that you not advertise anything, even free stuff. Thanks
for your consideration in the future.


Oh, puh-leaze, Larry. This is a public service.

Was the announcement of the Access 12 blog an advertisement?

If the charter prohibits announcements of Access user group
meetings, then the charter definitely needs to be revised.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
May 22 '06 #3
Larry is right! If there is going to be complaining about my responses
trying to help posters, then what the OP posted here is pure advertising. It
provides no technical Access help to anyone.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting help
re******@pcdata sheet.com


"David W. Fenton" <XX*******@dfen ton.com.invalid > wrote in message
news:Xn******** *************** **********@127. 0.0.1...
"Larry Linson" <bo*****@localh ost.not> wrote in
news:oQccg.4168 $oa3.157@trnddc 08:
"Kevin G. Anderson" <kg*****@pobox. com> wrote in message
news:11******** ************@j5 5g2000cwa.googl egroups.com...
What: CAUG Meeting - QuickBooks IIF Files; Total Access
Analyzer; CAUG Social
When: Thursday, May 25, 2006, 6PM
Who: Chris Monaghan and Kevin Anderson


As strongly as I believe in User Groups, and as good a reputation
as CAUG has, I have to point out the FAQ for this newsgroup,
http://www.mvps.org/access/netiquette.htm which contains the
charter, which does not specifically permit advertising, and the
request that you not advertise anything, even free stuff. Thanks
for your consideration in the future.


Oh, puh-leaze, Larry. This is a public service.

Was the announcement of the Access 12 blog an advertisement?

If the charter prohibits announcements of Access user group
meetings, then the charter definitely needs to be revised.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

May 22 '06 #4
but of course, you are not going to stop abusing the newsgroups or the
participants.

John... Visio MVP
"PC Datasheet" <No****@Spam.Co m> wrote in message
news:nr******** ********@newsre ad3.news.pas.ea rthlink.net...
Larry is right! If there is going to be complaining about my responses
trying to help posters, then what the OP posted here is pure advertising.
It provides no technical Access help to anyone.


May 22 '06 #5
Go play with Arno R and his young boys, you STUPID A$$!!!!!!

"John Marshall, MVP" <la******@stone henge.ca> wrote in message
news:48******** ************@ma gma.ca...
but of course, you are not going to stop abusing the newsgroups or the
participants.

John... Visio MVP
"PC Datasheet" <No****@Spam.Co m> wrote in message
news:nr******** ********@newsre ad3.news.pas.ea rthlink.net...
Larry is right! If there is going to be complaining about my responses
trying to help posters, then what the OP posted here is pure advertising.
It provides no technical Access help to anyone.


May 23 '06 #6
A$$ = ASteveSantos?
May 24 '06 #7
Larry Linson wrote:
"Kevin G. Anderson" <kg*****@pobox. com> wrote in message
news:11******** ************@j5 5g2000cwa.googl egroups.com...
What: CAUG Meeting - QuickBooks IIF Files; Total Access Analyzer; CAUG
Social
When: Thursday, May 25, 2006, 6PM
Who: Chris Monaghan and Kevin Anderson


As strongly as I believe in User Groups, and as good a reputation as CAUG
has, I have to point out the FAQ for this newsgroup,
http://www.mvps.org/access/netiquette.htm which contains the charter, which
does not specifically permit advertising, and the request that you not
advertise anything, even free stuff. Thanks for your consideration in the
future.


Larry,

This is the first complaint I've gotten. I've been posting our meeting
announcements since March, so I suspect the problem is that this time
I'm one of the presenters. If so, then I'd be happy to leave my
name/bio off next time. Since I don't link to a website or give a
business email address, I have a hard time seeing how this is
advertising. Nevertheless, diligent policing of these things by you
and many others has preserved the usability of CDMA over the years, so
I can respect that.

And while I certainly don't want to damage CAUG's reputation, we've had
people attend based on seeing the announcements here, so I think it's
important to keep posting them in some form or another. Heck, I'd like
to see other Access UG's posting their announcements - it would be
reassuring to know who's still meeting, and what they're doing. As
another recent post discussed, Access is facing stiff competition
nowadays for user/developer attention, and the volume of CDMA postings
has fallen. My position is that monthly posts like this cannot hurt.

I'd be happy to take this discussion off-line. You'll find my email
address in the header (yours - contrary to RFC 1036 rules for Usenet -
is nowhere to be found;)

Cheers,
Kevin

May 24 '06 #8


Kevin, for what it's worth, I think we are all a bit sensitive in CDMA
because of the flagrant abuse by one individual. I suspect that Larry's
post was in hope that particular miscreant would not be encouraged by
your posting. In my opinion there is no similarity between your post
and the persistent advertising by that person and there is no reason
that you shouldn't continue to post such announcements.

Just my 2 cents worth,

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.
May 24 '06 #9
Kevin G. Anderson wrote:
Larry Linson wrote:
"Kevin G. Anderson" <kg*****@pobox. com> wrote in message
news:11******** ************@j5 5g2000cwa.googl egroups.com...
What: CAUG Meeting - QuickBooks IIF Files; Total Access Analyzer; CAUG
Social
When: Thursday, May 25, 2006, 6PM
Who: Chris Monaghan and Kevin Anderson


As strongly as I believe in User Groups, and as good a reputation as CAUG
has, I have to point out the FAQ for this newsgroup,
http://www.mvps.org/access/netiquette.htm which contains the charter, which
does not specifically permit advertising, and the request that you not
advertise anything, even free stuff. Thanks for your consideration in the
future.


Larry,

This is the first complaint I've gotten. I've been posting our meeting
announcements since March, so I suspect the problem is that this time
I'm one of the presenters. If so, then I'd be happy to leave my
name/bio off next time. Since I don't link to a website or give a
business email address, I have a hard time seeing how this is
advertising. Nevertheless, diligent policing of these things by you
and many others has preserved the usability of CDMA over the years, so
I can respect that.

And while I certainly don't want to damage CAUG's reputation, we've had
people attend based on seeing the announcements here, so I think it's
important to keep posting them in some form or another. Heck, I'd like
to see other Access UG's posting their announcements - it would be
reassuring to know who's still meeting, and what they're doing. As
another recent post discussed, Access is facing stiff competition
nowadays for user/developer attention, and the volume of CDMA postings
has fallen. My position is that monthly posts like this cannot hurt.

I'd be happy to take this discussion off-line. You'll find my email
address in the header (yours - contrary to RFC 1036 rules for Usenet -
is nowhere to be found;)

Cheers,
Kevin


I propose a solution. Not only does CAUG have a website, they have a
webpage with info on upcoming meetings.

Although I appreciated the extra detail in the CDMA posting, the
webpage seems to convey most of what is to be covered at the next
meeting. When the time of a meeting nears, a post can be made here
such as:

Upcoming Chicago Access Users Group meeting:
http://www.caug.com/meetings.asp

AFAICS, this should satisfy the valid objections posted without
conveying the false impression that Access User Group info is not
desirable in CDMA. In addition, ironically, the Partners and
Consultants links on the CAUG site get free advertising by doing this.

James A. Fortune
CD********@Fort uneJames.com

Access has supported "Lookup Fields" for several versions and has added
power to the feature for Access 12 by allowing for multi-valued
lookups. ... This is simply good database practice (normalized data,
joined on unique identifiers), but made easy enough for non-developers.
.... Access 12 extends the lookup concept by enabling multi-valued
lookups. Where a lookup is really just a join made easy, a
multi-valued lookup is simply a many-to-many join made easy. -- Erik
Rucker's Access Blog

Groan.

May 24 '06 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1436
by: Ian Bicking | last post by:
The Chicago Python User Group, ChiPy, will have its next meeting on Thursday, December 9th, starting at 7pm. For more information on ChiPy see http://chipy.org Topic ----- This month's topic is testing and profiling strategies in Python. Chris McAvoy will talk about doctest. Brian Ray will talk about the hotspot profiler. Ian Bicking will be talking about py.test, a unittest
0
1414
by: Betty Harvey | last post by:
The next meeting of the XML Users Group will be held on Wednesday, May 19, 2004 at the American Geophysical Union (AGU) at 2000 Florida Avenue, N.W., Washington, DC 20009-1277. The meeting starts at 7:00 p.m. and usually last approximately 2 hours. If attending the meeting by Metro, get off the Dupont Circle stop and walk north to Florida Avenue...turn right. There is no cost associated with attending but if you are planning on...
14
2813
by: Mark | last post by:
Yes, my family business wants to create an accounting database to keep track of invoices, production, inventory, man hours, etc.... There will be two kinds of users to access the database, on two different computers at max. (Admin and User) The table sizes won't get too big. I am thinking 10 thousand records at max for the biggest table. (they will be replaced each year, ie: all the records in the tables will be removely and backed up...
41
3089
by: Matt Alanzo | last post by:
Our SOHO 2 person compay sells furniture (not programmers). In '98 we paid $,$$$ for a VBA -Access '97 accounting application, including VBA source code .... an huge investment for us then (and now!). The application publisher went belly up years ago. Over time we've made a number of VBA code changes (< 500 lines total). Now our CPA is urging us to switch to Quickbooks Premier for Contractors at a cost of $,$$$ plus data entry. Argh, no...
3
1572
by: dixie | last post by:
My company has recently purchased Total Access Analyzer and I am exploring its use right now. Overall, it is an excellent piece of software that is very helpful and can find problems so easily. I do not have access to the special newsgroup for users of this software, so was wondering if anyone here can tell me the easiest way to find if a report is actually still in use by the database. I have a lot of reports, some of which are most...
92
7665
by: Jeffrey P via AccessMonster.com | last post by:
Our IT guys are on a vendetta against MS Access (and Lotus Notes but they've won that fight). What I can't understand is, what's the problem? Why does IT hate MS Access so much. I have tried to find out who it is that actually wants to get rid of it, but I can't find anyone who will admit to trying to get rid of it. Nevertheless, I'm always hearing about how their "phasing it out" or "getting rid of it". Because no-one owns up I can't...
0
1141
by: bray | last post by:
Learn, share, and have fun at ChiPy's Monthly meeting this Thurs, April 13 at 7pm. This is sure to be our best meeting yet. Confirm your attendance: mtobis aat gmail doot com with "ChiPy April" in your subject line. Headliners ---------- * httpy -- (Chad Whitacre) a sane and robust HTTP library.
0
1744
by: Kevin G. Anderson | last post by:
What: CAUG Meeting - Visual Studio 2005 Tools for Office When: Thursday, April 27, 2006, 6PM Who: Jacob Cynamon, Microsoft Where: The Information Management Group 200 W. Monroe St. Suite 900 Chicago, IL 60606 (312) 222-9400 Location: www.imginc.com/IMG/About+IMG/chicago.htm info@caug.com and add "ATTENDING" to the subject
1
1322
by: Brian Ray | last post by:
This will be our best meeting yet! ChiPy's Monthly meeting this Thurs. May 11, 2006. 7pm. (except for folks who want to help setup at 6:30 and get first dibs on pizza) Location -------- ThoughtWorks' Chicago office
0
8969
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8794
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
9269
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8216
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6756
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6056
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
3282
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2748
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2195
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.