M
Moose
I am trying to create a template to automatically make a quote and enter in
the discription of item and the price.
the discription of item and the price.
R
Rick B
Are you using Microsoft Access? If so, we would need to know much more
about the structure of your database. The forms wizard will normally help
you build basic forms for data entry.
about the structure of your database. The forms wizard will normally help
you build basic forms for data entry.
L
Larry Daugherty
You are more than a little vague about what you want to do and your
use of the term "template" kind of suggest that you are thinking of
Excel rather than Access, the database product.
HTH
use of the term "template" kind of suggest that you are thinking of
Excel rather than Access, the database product.
HTH
M
Moose
Ok. I am creating a quote sheet . In it I want to have the part number, the
quanity and the description and price.
1. I want to be able to have a drop down list from the part number, have
it coded where if I just place a letter in the field, I can scroll down in
that area only and not have to search through thousands of part numbers.
2. I then want to have the part number corrilate to a discription where
when I choose a part number, the description field will pop up the
discription of that part.
3. Finally, I want to have the price tomautomaticall corralate to the part
number and quanity, so it will automatically pop up with the price.
Do you have any ideas? If so please make the directions very simple.
Thanks!!
quanity and the description and price.
1. I want to be able to have a drop down list from the part number, have
it coded where if I just place a letter in the field, I can scroll down in
that area only and not have to search through thousands of part numbers.
2. I then want to have the part number corrilate to a discription where
when I choose a part number, the description field will pop up the
discription of that part.
3. Finally, I want to have the price tomautomaticall corralate to the part
number and quanity, so it will automatically pop up with the price.
Do you have any ideas? If so please make the directions very simple.
Thanks!!
L
Larry Daugherty
What research have you done toward creating your application?
What research have you done about the product (NS Access) that you're
trying to use?
There isn't much work in designing a Quote application for someone who
knows the application and the tools s/he will use to build it. The
work is in getting educated to that point in applications and in the
use of the tool.
Access is the ideal tool for building the application you want. But
.... You won't get a single answer in these newsgroups that will take
you from ground zero to a finished application.
If you want to learn to do it yourself then I suggest that you read a
few basic books on Access and do all of their suggested exercises. As
you are doing that, relax from time to time by lurking these
newsgroups with an eye to understanding the questions that people ask
and the answers they give. Most of the Access newsgroups have
descriptive names - this is one of the omnibus groups which doesn't.
Try microsoft.public.access.gettingstarted and
microsoft.public.access.tablesdesign and microsoft.public.access.forms
Access has a steep learning curve to get from ground zero to
journeyman level competence. If you want to learn Access, stay with
it and don't get discouraged. Most of the Access MVPs are self
taught.
On the other hand, if you're in a furry to have your application
completed, you may be better off to engage a consultant.
Lots of organizations have quoting applications already. They were
designed to get done what they needed done and built on their data.
There are lots of Access consultants who might be happy to work with
you.
That's about as simple as I can make it.
HTH
-
-Larry-
What research have you done about the product (NS Access) that you're
trying to use?
There isn't much work in designing a Quote application for someone who
knows the application and the tools s/he will use to build it. The
work is in getting educated to that point in applications and in the
use of the tool.
Access is the ideal tool for building the application you want. But
.... You won't get a single answer in these newsgroups that will take
you from ground zero to a finished application.
If you want to learn to do it yourself then I suggest that you read a
few basic books on Access and do all of their suggested exercises. As
you are doing that, relax from time to time by lurking these
newsgroups with an eye to understanding the questions that people ask
and the answers they give. Most of the Access newsgroups have
descriptive names - this is one of the omnibus groups which doesn't.
Try microsoft.public.access.gettingstarted and
microsoft.public.access.tablesdesign and microsoft.public.access.forms
Access has a steep learning curve to get from ground zero to
journeyman level competence. If you want to learn Access, stay with
it and don't get discouraged. Most of the Access MVPs are self
taught.
On the other hand, if you're in a furry to have your application
completed, you may be better off to engage a consultant.
Lots of organizations have quoting applications already. They were
designed to get done what they needed done and built on their data.
There are lots of Access consultants who might be happy to work with
you.
That's about as simple as I can make it.
HTH
-
-Larry-