Is there a Sales Database that prints invoices for Access?

[mapotter]

I'm looking for a Database that will allow me to store contact information
and manage them, like the customer order database but also allows me to print
invoices and receipts. Does anyone know of such a database?

 

[John W. Vinson]

If you don't find a sales database that does what you want, I can build one
for you for a nominal fee.

http://www.microsoft.com/library/gallery/components/wn/3/locales/help/help_en-US.htm#RulesofConduct

Rules of conduct
Appropriate Language: The purpose of our communities is to exchange technical
information and expertise about Microsoft products. Please avoid personal
attacks, slurs, and profanity in your interactions.

Relevance to Topics: Please make sure that your postings in discussion groups
and chats are relevant to the subject at hand. It is normal for some topics to
drift from the stated subject. However, to ensure maximum benefit for
everyone, we encourage you to keep your postings as close to the subject as
possible.

Advertising/Solicitation: These communities were created as a forum for
providing peer-to-peer assistance on Microsoft products and services.
**********************************************************
We ask that you refrain from posting advertisements or solicitations that do
not pertain directly to the intended use and purpose of the newsgroup or chat.
**********************************************************

Confidentiality: Please keep in mind that our communities are public spaces,
so don't post anything that you don't want the world to see. Credit card
numbers, product keys, and other confidential information, including anything
covered under a non-disclosure agreement (NDA), should not be posted to a
discussion group, chat, or other community.

 

[John W. Vinson]

I'm looking for a Database that will allow me to store contact information
and manage them, like the customer order database but also allows me to print
invoices and receipts. Does anyone know of such a database?

The Northwind sample database does... but they may not be (well, WILL not be)
customized for *your* business. A receipt or invoice for a hardware store will
look different than one for a music shop or for a business selling airliners.

You should consider Access as a toolkit, not as a set of finished
applications. There might be a sample database out there, but it will
probably still need tweaking. Check out some of the resources at these sites:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

 

[David W. Fenton]

http://www.microsoft.com/library/gallery/components/wn/3/locales/he
lp/help_en-US.htm#RulesofConduct

Rules of conduct

[]

He's not posting from Microsoft's server so is not bound my MS's
rules of conduct.

He *should* be bound by the rules of conduct for Usenet groups in
general, and the Access groups in particular, where solicitation is
prohibited, but he doesn't seem to have any integrity at all.

 

[Larry Linson]

Mr. Potter,

Aside from the customer comments I provided in
my response, you can further verify my qualifications
to help you by looking at the large number of
responses I make in these newsgroups.

Further, if you want to avoid the frustration and time
consuming effort in doing-it-yourself, I can help you
for a very reasonable fee.

Mr. Potter, If you should decide to follow Steve's advice, you should also
compare the number of times he provides useful answers to non-trivial
questions versus the times he just spams for his services. If he were to
tell the whole truth, he'd admit that he asks for help more times in the
newsgroup than the times that he gives help.

Many experienced Access developers here, as you see, tend to think that
Steve's answers do not justify anyone venturing even what would be "a very
reasonable fee" for useful work.

Larry Linson

 

[Arvin Meyer [MVP]]

He's not posting from Microsoft's server so is not bound my MS's
rules of conduct.

But he is posting to Microsoft newsgroups which requires that he adhere to
the rules. Additionally, all Microsoft newsgroups run through Microsoft
servers, regardless of point of origin.

 

[George]

WHoooot!

Mr. Potter,

Aside from the customer comments I provided in my response, you can
further verify my qualifications to help you by looking at the large
number of responses I make in these newsgroups.

Further, if you want to avoid the frustration and time consuming effort in
doing-it-yourself, I can help you for a very reasonable fee.

Steve
(e-mail address removed)

 

[John... Visio MVP]

Hello!

If you don't find a sales database that does what you want, I can build
one for you for a nominal fee. I provide help with Access, Excel and Word
applications for a nominal fee. Contact me if you would like my help.

Steve
(e-mail address removed)

Here are a couple of customer comments after I helped them .....

--- More proof that P.T. Barnum was right.

Stevie, if you were any good, you would not need to grovel for work in these
newsgroups.


These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

A few gems gleaned from the Word New User newsgroup over the Christmas
holidays to show Stevie's "expertise" in Word.


Dec 17, 2008 7:47 pm

Word 2007 ..........
In older versions of Word you could highlght some text then go to Format -
Change Case and change the case of the hoghloghted text. Is this still
available in Word 2007? Where?
Thanks! Steve


Dec 22, 2008 8:22 pm

I am designing a series of paystubs for a client. I start in landscape and
draw a table then add columns and rows to setup labels and their
corresponding value. This all works fine. After a landscape version is
completed, I next need to design a portrait version. Rather than strating
from scratch, I'd like to be able to cut and paste from the landscape
version and design the portrait version.
Steve


Dec 24, 2008, 1:12 PM

How do you protect the document for filling in forms?
Steve


One of my favourites:
Dec 30, 2008 8:07 PM - a reply to stevie
(The original poster asked how to sort a list and stevie offered to create
the OP an Access database)

Yes, you are right but a database is the correct tool to use not a
spreadsheet.

Not at all. If it's just a simple list then a spreadsheet is perfectly
adequate...




John... Visio MVP

 

[John... Visio MVP]

Mr. Potter,

Aside from the customer comments I provided in my response, you can
further verify my qualifications to help you by looking at the large
number of responses I make in these newsgroups.

There is a big difference between quantity and quality.

Further, if you want to avoid the frustration and time consuming effort in
doing-it-yourself, I can help you for a very reasonable fee.

Steve
(e-mail address removed)

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

A few gems gleaned from the Word New User newsgroup over the Christmas
holidays to show Stevie's "expertise" in Word.


Dec 17, 2008 7:47 pm

Word 2007 ..........
In older versions of Word you could highlght some text then go to Format -
Change Case and change the case of the hoghloghted text. Is this still
available in Word 2007? Where?
Thanks! Steve


Dec 22, 2008 8:22 pm

I am designing a series of paystubs for a client. I start in landscape and
draw a table then add columns and rows to setup labels and their
corresponding value. This all works fine. After a landscape version is
completed, I next need to design a portrait version. Rather than strating
from scratch, I'd like to be able to cut and paste from the landscape
version and design the portrait version.
Steve


Dec 24, 2008, 1:12 PM

How do you protect the document for filling in forms?
Steve


One of my favourites:
Dec 30, 2008 8:07 PM - a reply to stevie
(The original poster asked how to sort a list and stevie offered to create
the OP an Access database)

Yes, you are right but a database is the correct tool to use not a
spreadsheet.

Not at all. If it's just a simple list then a spreadsheet is perfectly
adequate...




John... Visio MVP

 

[John W. Vinson]

you can further
verify my qualifications to help you by looking at the large number of
responses I make in these newsgroups.

Excellent advice, Steve. I think they give a pretty good picture of your skill
level.

 

[BruceM]

The customer comments are unsubstantiated. I doubt they know you are
quoting them. Volume of posting means nothing. Others post far more often
than you do without ever seeking payment.

You have been asked over and over why you do not post links to your work,
but you refuse to respond, or even to acknowledge the question. I believe
now that the answer is you have produced nothing of merit. You have a web
site, and with it an opportunity to demonstrate what you claim you can do,
but you have posted absolutely *NO* samples.

 

[Mark Andrews]

I have a CRM template that does Invoices.

Read more and download the eval at:
http://www.rptsoftware.com/products/crmtemplate/

I also have a very nice Access2007 CRM template that is similar to this one.
The Access2007 template is a "Contact based" CRM model vs an "Account based"
CRM model.
Currently I give that one away to any customers that are using Access2007
(most like it a little better than the original one which was geared more
for Access 2003 and earlier). Both templates do basic Invoices (which I
designed to be similar to Quicken). I have a friend that sells a
sophisticated Invoice program but it's written in Filemaker (if that
interests you shoot me a note, see contact info on my website).

HTH,
Thanks,
Mark Andrews
RPT Software
http://www.rptsoftware.com

 

[David W. Fenton]

But he is posting to Microsoft newsgroups which requires that he
adhere to the rules.

I don't know if that's true or not. Certainly one should be bound by
the rules of the charter of the newsgroup you're posting to, but
where are the charters for the MS newsgroups?

Additionally, all Microsoft newsgroups run through Microsoft
servers, regardless of point of origin.

That is not true at all. Because the newsgroups are propagated to
other news servers, posts do not have to go through MS's servers at
all. I could post to Newsguy and you could reply on Newsguy, and
none of the posts would have travelled "through" MS's servers. Now,
naturally, the posts would be *propagated* to MS's servers, but
that's not what you said.

Indeed, your very reply to my post didn't go through MS's servers,
as you can see from the PATH line in the header (reformatted for
readability):

news5.newsguy.com!extra.newsguy.com
num01.iad!npeer02.iad.highwinds-media.com
news.highwinds-media.com
feed-me.highwinds-media.com
nx01.iad01.newshosting.com
newshosting.com
novia!border2.nntp.dca.giganews.com
border1.nntp.dca.giganews.com
nntp.giganews.com
news.alt.net!msrtrans
TK2MSFTFEEDS02.phx.gbl!TK2MSFTNGP01.phx.gbl
TK2MSFTNGP05.phx.gbl

You injected the post into Usenet at phx.gbl and it was retrieved by
new from newsguy.com, with nary a Microsoft host in between.

This is the way Usenet works.

That's how it's always worked (well, at least since the move to
NNTP).

Charters of newsgroups are supposed to apply and Usenet providers
are supposed to honor complaints of infractions against those
charters (though whether they do or do not is a matter for each
Usenet provider to determine). But Microsoft has no special say over
its public newsgroups. If they wanted that, the only way to get it
woul be to not propagate them to other servers.

 

[BruceM]

If it is so successful, why do you need to troll here? How come you don't
have a decent web site, so people can see some actual examples of what you
claim?

Just for your information, I built a very successful business providing
basic help to Access users many of whom contacted me from newsgroups. My
fees have always been very reasonable.

Steve

 

[John... Visio MVP]

If you were so successful, why do you need to grovel for work. Is the amount
of repeat business so low, that you need to hunt out a fresh supply of
unsuspecting customers? That would definitely reflect on the quality of your
work.

John... Visio MVP

Just for your information, I built a very successful business providing
basic help to Access users many of whom contacted me from newsgroups. My
fees have always been very reasonable.

Steve

 

[Larry Linson]

Just for your information, I built a very successful
business providing basic help to Access users many
of whom contacted me from newsgroups. My
fees have always been very reasonable.

Saying so, even over and over, doesn't make it so, Steve.

By continually trolling for business here in the newsgroups, you have
destroyed any credibility you might have had, and by repeatedly providing
incomplete and wrong answers, you haven't inspired any confidence in your
ability to provide even basic help. If it doesn't work, it doesn't matter
how low the price is, even if it was free.

Larry

 

[Arvin Meyer [MVP]]

I don't know if that's true or not. Certainly one should be bound by
the rules of the charter of the newsgroup you're posting to, but
where are the charters for the MS newsgroups?
http://support.microsoft.com/gp/newswhelp

Indeed, your very reply to my post didn't go through MS's servers,
as you can see from the PATH line in the header (reformatted for
readability):

I can't speak to that, I did not use your server. But since I read and
replied to:

microsoft.public.access

there is no chance that it didn't touch that news server before being
slurped by another.

 

[David W. Fenton]

http://support.microsoft.com/gp/newswhelp

Given that there was likely no RFC and no vote and that MS just
creates the groups and propagates them as they see fit, I guess
that's as close to a charter as you're going to get.

I don't know how that fits into the traditions and rules of Usenet.

I can't speak to that, I did not use your server.

No, but your post was propagated to my server, and that's where I
read it from.

But since I read and
replied to:

microsoft.public.access

there is no chance that it didn't touch that news server before
being slurped by another.

You're wrong, Arvin. You obviously have never taken the time to
learn how Usenet works. The PATH header lists the servers a post has
been through and your posts are not going through any microsoft
servers.

"microsoft.public.access" is not a server -- it's just a newsgroup.
The actual NNTP servers by which a post by me gets to you will
differ according to the path between the NNTP servers, which can
differ from day to day for any pair of NNTP servers. And you can see
what that path is by looking at the PATH header.

The only way MS's servers are involved is if you post or read
through news.microsoft.com, or if the NNTP server you use gets its
posts from news.microsoft.com, or from another NNTP server somewhere
in the path that has gotten its posts from news.microsoft.com.

All that said, violations of the charter of a newsgroup can still be
used as the basis for complaints to the ISP (or news provider) of a
poster. In the old days, ISPs were very responsive to these kinds of
complaints.

In this case, you'd registrer a complaint about Steve's actions to
Giganews, his news provider. I don't know if Giganews is responsive
or not, but if they are, Steve could have his Giganews account
terminated.

 

[David W. Fenton]

there is no chance that it didn't touch that news server before
being slurped by another.

I meant to post this URL that explains (rather badly) how Usenet
actually works:

http://en.wikipedia.org/wiki/Usenet

Have a look at the diagram of Usenet from 1981 -- what that diagram
showed was the path that a post to Usenet would take from any one
server to any other. From zehntel in the lower right to tekmdp in
the upper right one path would be:

zehntel
sytek
menlo70
uwvax
chico
teklabs
tekmdp

Now, that would dependent on all the servers in that path carrying
the newsgroup that you posted to. If you posted into tekmdp in
microsoft.public.access, but uwvax did not carry the
microsoft.public.* hierarchy, another possible path would be:

zehntel
sytek
menlo70
cbosg
harpo
chico
teklabs
tekmdp

....assuming the servers in this other path carried the newsgroups.

The name of the newsgroup has zilch to do with what servers a post
goes through, except insofar as the servers involved in passing the
message have to carry that particular newsgroup. The only exception,
of course, is when the news server is private, i.e., not propagating
its posts to Usenet in general. In that case, the only place to post
and read is on that particular news server.

Microsoft has wisely chosen to propagate their newsgroups to Usenet,
rather than maintaining a walled garden private news server. If they
had chosen the latter, they could kick people off for violation of
their terms of use. But, of course, we all know how well that works
-- the offender will just get another account name.

In any event, your posts are not going *through* Microsoft's servers
except for those reading from a Usenet server that gets its newsfeed
from a source that has Microsoft in between your server and it.