Need Some Help With Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok, so I am using Access 2000 at work and am setting up a database for our
sales reps to use for their orders that are backlogged. This is a database
that will track which orders still need to be entered into our main system
and so we are using forms for each of the reps to use to enter this info
everyday. I have the forms set up and I also have the tables set up. I have
one field that is already populated and that is the date since we have to
have each day show up for everyone even if they don't enter their data for
that day. (we have charts attached to these and need everyone to be
consistant). What I would like to see happen is that when the CSR opens their
specific form it automatically goes to that days date. So that there won't be
confusion in entering data for a previous day. HELP! If this makes sense and
you have the solution I would greatly appreciate it! I am not a developer so
the plainer the english and the more specific the steps the better... Thank
you so much for your help! :)
 
Ok, so I am using Access 2000 at work and am setting up a database for our
sales reps to use for their orders that are backlogged. This is a database
that will track which orders still need to be entered into our main system
and so we are using forms for each of the reps to use to enter this info
everyday. I have the forms set up and I also have the tables set up. I have
one field that is already populated and that is the date since we have to
have each day show up for everyone even if they don't enter their data for
that day. (we have charts attached to these and need everyone to be
consistant). What I would like to see happen is that when the CSR opens their
specific form it automatically goes to that days date. So that there won't be
confusion in entering data for a previous day. HELP! If this makes sense and
you have the solution I would greatly appreciate it! I am not a developer so
the plainer the english and the more specific the steps the better... Thank
you so much for your help! :)
Click to expand...

It sounds like you have a different form - and perhaps even a
different table - for each sales representative. Is that the case?

If so - you're a long ways down the WRONG TRACK, and you're painting
yourself into a corner!

Please describe the tables you have set up. It should NOT be necessary
to prefill a table with one record for each date; the charts can very
easily be generated without storing empty "placeholder" records.

John W. Vinson[MVP]
 
Yes, each sales person has their very own table and form to fill out. The
tables are pretty simple. There are 15 columns total for their data entry. I
need to have each day show up even if they don't enter anything for the
purpose of tracking those who are entering their daily totals and those who
aren't. Thank you so much for your help!
 
Yes, each sales person has their very own table and form to fill out.
Click to expand...

So for each new salesperson, you create a new table?

Sorry, this is simply *incorrect*. Store sales all in a single table,
with a SalespersonID field to indicate who is storing it.
The tables are pretty simple. There are 15 columns total for their data entry. I
need to have each day show up even if they don't enter anything for the
purpose of tracking those who are entering their daily totals and those who
aren't. Thank you so much for your help!
Click to expand...

No. You do not need to enter "phony" records to accomplish this end. A
properly designed Query will get totals, including zero totals for
days with no sales.

John W. Vinson[MVP]
 
Back
Top