I need Form/Report help, please

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

Guest

I am new to Microsoft Access and am not familiar with writing VB script at
all, but I was still put in charge of creating a database for our daily
schedule, lol. After months of research during down times I have created a
database and it's been in use for about 3 months now.
On the data entry form I have it arranged by the date, so I can scroll
through the dates and see what was scheduled for that date, and I can add or
delete items from each date or create a new date and schedule as needed. The
report that is printed for a day's schedule asks what date I would like and
it will print that date's schedule. I would really like to be able to have
the report automatically print from the date selected on the data entry form,
instead of asking for the date. Is this possible? Any help would be really
appreciated.

I use Access 2000 and Windows 2000
 
Greg said:
I am new to Microsoft Access and am not familiar with writing VB script at
all, but I was still put in charge of creating a database for our daily
schedule, lol. After months of research during down times I have created a
database and it's been in use for about 3 months now.
On the data entry form I have it arranged by the date, so I can scroll
through the dates and see what was scheduled for that date, and I can add or
delete items from each date or create a new date and schedule as needed. The
report that is printed for a day's schedule asks what date I would like and
it will print that date's schedule. I would really like to be able to have
the report automatically print from the date selected on the data entry form,
instead of asking for the date. Is this possible? Any help would be really
appreciated.
Click to expand...

In your Report Properties set the Input Parameters to the date you have
selected on your form.

date=forms!yourformname!yourdate
 
Hehe, it looks so simple, but I think I'm too dense for this fancy computer
stuff.
date=forms!Flight Schedule!Flight Date
Flight Schedule is the name of the Form and Flight Date is the name of the
field in the form. This appears to be the format for what I should enter,
but I'm stumped on where to enter this information
 
Greg said:
Hehe, it looks so simple, but I think I'm too dense for this fancy computer
stuff.
date=forms!Flight Schedule!Flight Date
Flight Schedule is the name of the Form and Flight Date is the name of the
field in the form. This appears to be the format for what I should enter,
but I'm stumped on where to enter this information
[quoted text clipped - 14 lines]
date=forms!yourformname!yourdate
Click to expand...
Click to expand...


Not a problem at all, I have only been at it for a couple of months now, this
is just something I was showed right from the start.

Open your report in design view.
In the top left corner of the design area you will see a small black square
inside a larger grey square,
double click on it or right click and select Properties.
Now click on the Data tab and click in the Input Parameters field.
Now type @date=forms!Flight Schedule!Flight Date in this area.
Change @date to whatever you are being prompted for when you run the report.

if you still have problems with it just let me know and I will try to help
you sort it out.
 
If you call up the report in design mode, look at the recordsource
properties for the report.
Hopefully, it is a sql statement and not just a table name. The sql
statement probably has a date field. In the criteria for that field, enter
=forms![Flight Schedule].[Flight Date]
test the sql statement and see if it asks for a value. enter a date and it
will only show records for that date.
 
Woohoo!! Thanks a lot, both of you!! I used the "=forms![Flight
Schedule].[Flight Date]", but I put it in the Criteria section of the Query
which the report was based on, and it worked like a charm. I didn't even
need to open the report at all, I just had to copy and paste that line and
get rid of the parameters query I had previously used to ask for the date
desired. My coworkers will be extremely happy now that they don't have to
type the date in, lol.

Damon Heron said:
If you call up the report in design mode, look at the recordsource
properties for the report.
Hopefully, it is a sql statement and not just a table name. The sql
statement probably has a date field. In the criteria for that field, enter
=forms![Flight Schedule].[Flight Date]
test the sql statement and see if it asks for a value. enter a date and it
will only show records for that date.

--
Damon Heron
Greg said:
Hehe, it looks so simple, but I think I'm too dense for this fancy
computer
stuff.
date=forms!Flight Schedule!Flight Date
Flight Schedule is the name of the Form and Flight Date is the name of the
field in the form. This appears to be the format for what I should enter,
but I'm stumped on where to enter this information
Click to expand...
Click to expand...
 
Back
Top