Very Rusty Former Beginner/Intermediate Access Guy Needs a Little Help

[Jack B]

I'm using Access 2002 to create a database for a small opera company that my
wife is involved in, and I'm more than a bit rusty because I haven't created
a new Access database since about 1999. So, I will probably have quite a
few questions as I go through this, and hopefully this group will help me
out.

I will be creating this database for someone else to enter the data. I have
a patron table with name, address, email, etc., and I want to add a form to
enter donations from patrons into a donation table. All I need in this form
is last name, first name, date, and amount. I know I can use a combo box so
the data entry person can select last name, but I need to include the first
name somehow also as there are several people with the same last names.

How do I go about this?

Thanks,

Jack

 

[Dirk Goldgar]

In

I'm using Access 2002 to create a database for a small opera company
that my wife is involved in, and I'm more than a bit rusty because I
haven't created a new Access database since about 1999. So, I will
probably have quite a few questions as I go through this, and
hopefully this group will help me out.

I will be creating this database for someone else to enter the data. I
have a patron table with name, address, email, etc., and I want to
add a form to enter donations from patrons into a donation table. All
I need in this form is last name, first name, date, and amount. I know
I can use a combo box so the data entry person can select last
name, but I need to include the first name somehow also as there are
several people with the same last names.
How do I go about this?

I'd suggest you base your combo box on a query that combines the last
name and first name in a calculated field (e.g.,

FullName: [LastName] & ", " & [FirstName]

), and let that calculated field be the column that you display in the
combo for the data entry person. You'll need to store the unique patron
ID, assuming there is one, but you don't need to show it -- you can
include it in the combo's rowsource, and have it be the bound column,
but set the width of that column to 0.

 

[Jack B]

Thanks, I'll give it a shot.

In

I'm using Access 2002 to create a database for a small opera company
that my wife is involved in, and I'm more than a bit rusty because I
haven't created a new Access database since about 1999. So, I will
probably have quite a few questions as I go through this, and
hopefully this group will help me out.

I will be creating this database for someone else to enter the data. I
have a patron table with name, address, email, etc., and I want to
add a form to enter donations from patrons into a donation table. All I
need in this form is last name, first name, date, and amount. I know I
can use a combo box so the data entry person can select last
name, but I need to include the first name somehow also as there are
several people with the same last names.
How do I go about this?

I'd suggest you base your combo box on a query that combines the last name
and first name in a calculated field (e.g.,

FullName: [LastName] & ", " & [FirstName]

), and let that calculated field be the column that you display in the
combo for the data entry person. You'll need to store the unique patron
ID, assuming there is one, but you don't need to show it -- you can
include it in the combo's rowsource, and have it be the bound column, but
set the width of that column to 0.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[aaron.kempf]

if you haven't used Access since 1999; then the first thing that you
need to do is this:

a) installed MSDE
b) use Access Data Projects
c) use SQL Server Management Studio Express for additional development
of sprocs, views, etc

it's a great combination

MDB hasn't had a single modification this decade

-Aaron