Oh My! Almost There!!!! It only took me 8 HOURS!!

[Andy]

Hi, I am not sure what I did but whatever it is I like it because I am almost
there, meaning my form input to a report task is almost done.

Background: Access 2003, Win XP Professional
See other posts for further info such as macros, VB code, etc. etc.
Post titled "Ok, so close, just need a little push to get form inputs
into repo" dated 6/14/05
Post titled "Symbol" dated 6/10/05

Here is where I am at now:

I run the query directly (double click on the query) and get three parameter
boxes. I input the parameters and the query runs just fine.

I run the form directly (double click on the form) and the form opens. I
select from a drop down list (combo box) the OPR. I then go to the start
calendar and select Apr 1, 2003. I go to the end calendar and select May 31,
2005. I click the "OK" command button and nothing happens. The form just
stares at me. I click the "Print Preview" command button and the form goes
away and the report appears but without any data. The only thing on the
report is the header and footer info, no data.

I run the report and the form opens up. I select the OPR form the combo box
drop down list. I then go to the start calendar and select Apr 1, 2003. I go
to the end calendar and select May 31, 2005. I click the "OK" command button
and nothing happens. The form just stares at me. I click the "Print
Preview" command button and the report window appears behind the form but
without the report. I can move the form all around the screen and there is
nothing behind it. I click the "Cancel" command button and the form goes
away and a parameter box appears. I input the requested data and the next
parameter box appears. I input that data and the final parameter box
appears. I input that data and the report appears with the same number of
records I got when I ran the query directly.

This is the closest I have been. I need to get the form to work and I need
to get the report to work better. As always, I truly appreciate all the help
I have been given.

Andy

 

[Ian Davies]

Andy

Have you checked to see if there is any code behind the command button. The
code can become disassociated from the button if it has been renamed.

In form design view click on the command button open its properties, open
its 'on click' event and see if there is any code there

Ian

 

[Allan Murphy]

In short you want to run a report from a form by selecting OPR from the
drop down box and seelcting a start and finish date from calendars

Dates
Using unbound textboxes do you store the start and finish dates when you
click on the dates in the respective calendar?
Do you reference the dates in your query.

Assume OPR is the field used in the combo box
Assume DATEX is the field for the date range that you want
Assume START_Date and FINISH_Date are your dates used for the calendars
When you click on your print preview the relevant query should have the
following in the criteria.
In the criteria for OPR enter [forms]![formname]![opr]
In the criteria for DATEX enter between[forms]![formname]![start_date] and
[form]![formname]![end_date]

I use only one calendar to set my start and finish dates

I can send you an example if require more.

Allan Murphy
Email: (e-mail address removed)

 

[Andy]

Ok, I am completely stumped. I have looked at your DB example and it works
great but I had some questions about it. I emailed you the questions, plus I
emailed you a very stripped down version of my DB. I am hoping you can see
something in it I am missing, such as why I cannot get it to work.

Andy.

In short you want to run a report from a form by selecting OPR from the
drop down box and seelcting a start and finish date from calendars

Dates
Using unbound textboxes do you store the start and finish dates when you
click on the dates in the respective calendar?
Do you reference the dates in your query.

Assume OPR is the field used in the combo box
Assume DATEX is the field for the date range that you want
Assume START_Date and FINISH_Date are your dates used for the calendars
When you click on your print preview the relevant query should have the
following in the criteria.
In the criteria for OPR enter [forms]![formname]![opr]
In the criteria for DATEX enter between[forms]![formname]![start_date] and
[form]![formname]![end_date]

I use only one calendar to set my start and finish dates

I can send you an example if require more.

Allan Murphy
Email: (e-mail address removed)

Hi, I am not sure what I did but whatever it is I like it because I am almost
there, meaning my form input to a report task is almost done.

Background: Access 2003, Win XP Professional
See other posts for further info such as macros, VB code, etc. etc.
Post titled "Ok, so close, just need a little push to get form inputs
into repo" dated 6/14/05
Post titled "Symbol" dated 6/10/05

Here is where I am at now:

I run the query directly (double click on the query) and get three parameter
boxes. I input the parameters and the query runs just fine.

I run the form directly (double click on the form) and the form opens. I
select from a drop down list (combo box) the OPR. I then go to the start
calendar and select Apr 1, 2003. I go to the end calendar and select May 31,
2005. I click the "OK" command button and nothing happens. The form just
stares at me. I click the "Print Preview" command button and the form goes
away and the report appears but without any data. The only thing on the
report is the header and footer info, no data.

I run the report and the form opens up. I select the OPR form the combo box
drop down list. I then go to the start calendar and select Apr 1, 2003. I go
to the end calendar and select May 31, 2005. I click the "OK" command button
and nothing happens. The form just stares at me. I click the "Print
Preview" command button and the report window appears behind the form but
without the report. I can move the form all around the screen and there is
nothing behind it. I click the "Cancel" command button and the form goes
away and a parameter box appears. I input the requested data and the next
parameter box appears. I input that data and the final parameter box
appears. I input that data and the report appears with the same number of
records I got when I ran the query directly.

This is the closest I have been. I need to get the form to work and I need
to get the report to work better. As always, I truly appreciate all the help
I have been given.

Andy

 

[Allan Murphy]

Andy

Looked at your database.

Sent you an explanation .

Briefly

The combo box had two fields one that held the reference number for the
provider and the provider's name. When the query was called via the report
it was looking for the reference number in the provider's name column. I
removed the reference number from the combo box.

In the table tblworkRequest changed PROJ_ECD to short date format.

Allan Murphy

Email: (e-mail address removed)

Ok, I am completely stumped. I have looked at your DB example and it works
great but I had some questions about it. I emailed you the questions, plus I
emailed you a very stripped down version of my DB. I am hoping you can see
something in it I am missing, such as why I cannot get it to work.

Andy.

In short you want to run a report from a form by selecting OPR from the
drop down box and seelcting a start and finish date from calendars

Dates
Using unbound textboxes do you store the start and finish dates when you
click on the dates in the respective calendar?
Do you reference the dates in your query.

Assume OPR is the field used in the combo box
Assume DATEX is the field for the date range that you want
Assume START_Date and FINISH_Date are your dates used for the calendars
When you click on your print preview the relevant query should have the
following in the criteria.
In the criteria for OPR enter [forms]![formname]![opr]
In the criteria for DATEX enter between[forms]![formname]![start_date] and
[form]![formname]![end_date]

I use only one calendar to set my start and finish dates

I can send you an example if require more.

Allan Murphy
Email: (e-mail address removed)

Hi, I am not sure what I did but whatever it is I like it because I am almost
there, meaning my form input to a report task is almost done.

Background: Access 2003, Win XP Professional
See other posts for further info such as macros, VB code, etc. etc.
Post titled "Ok, so close, just need a little push to get form inputs
into repo" dated 6/14/05
Post titled "Symbol" dated 6/10/05

Here is where I am at now:

I run the query directly (double click on the query) and get three parameter
boxes. I input the parameters and the query runs just fine.

I run the form directly (double click on the form) and the form opens. I
select from a drop down list (combo box) the OPR. I then go to the start
calendar and select Apr 1, 2003. I go to the end calendar and select

May
31,

2005. I click the "OK" command button and nothing happens. The form just
stares at me. I click the "Print Preview" command button and the form goes
away and the report appears but without any data. The only thing on the
report is the header and footer info, no data.

I run the report and the form opens up. I select the OPR form the

combo
box

drop down list. I then go to the start calendar and select Apr 1,

2003. I
go

to the end calendar and select May 31, 2005. I click the "OK" command button
and nothing happens. The form just stares at me. I click the "Print
Preview" command button and the report window appears behind the form but
without the report. I can move the form all around the screen and

there
is

nothing behind it. I click the "Cancel" command button and the form goes
away and a parameter box appears. I input the requested data and the next
parameter box appears. I input that data and the final parameter box
appears. I input that data and the report appears with the same number of
records I got when I ran the query directly.

This is the closest I have been. I need to get the form to work and I need
to get the report to work better. As always, I truly appreciate all

the
help

I have been given.

Andy