Search results

Awsome ..... thanks again. I have learned a great deal with your help!!

No good effort and assistance goes without followup thoughts and questions. Is there a way in the syntax below to restrict the reports to only those that begin with "C"? SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Type)=-32764)); Thanks once again

Found it ..... Thanks again for all the help!!!

That appears to work fine .... many thanks to all. This is a great place to find answers and get assistance!! How would I change the syntax to get print preview?

I placed this command in the Onclick event field and received the following: MSAccess cant find the macro 'Docmd.' the macro(or its macro group) doesn't exist or the macro is new and hasn't been saved. Note that when you enter the macrogroupname.macro syntax in an argument, you must specify the...

Okay that works !! On the command button I want it to print the selected report. So what would I put in the OnClick property?

Bob, The form I tried to add the list box to is Date Range Form2 Dan

Bob I will strip down the data base and send it shortly Thanks

Bob, I did that and did not get the error message, but there is nothing in the list when I open the form??

I placed the exact formula as you indicated and got the following message when I opened the form: SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Type)=-32764)); may not be a valid setting for the row source type property, or there was a compile error in the functiion. ?????

Okay this is a bit beyond my understanding?? Would this go in the control source fieldof a combo box? Is MSysObects.Name a reference to where the reports are located in the Access database? What does MSysObjects.Type refer to? and what is -32764?

This process works using the form you suggested .... great. Is there a way to have a drop down list that shows the all reports in the data base so that an individual could be generated in the same way? What would be the command structure look like if ths can be done?

You are right in that the formula works, but what needs to happen is the report period needs be shown whether there is data or not. Suggestions??

Okay ... I think this will come to you? It is the only Report included.

Neither appear to work still showing #ERROR. I have tried it with referencing the text box and tried including the formula??

No this is a report. When you request the report it asks for a start date, end date, and the report period. The text box for the report period is in the Report header. In the report period box you enter say "October 2010". When there is data the report header shows what you enter. However when...

Great news the IIF(HasDat .... works, so here is another question?? I have a Text box where the date (month and year) are entered as text. Control Source has the formula =[Enter Report Period]. When there is data, and you enter the month and year, it appears as expected. When there is no data...

As I said the text box works fine and I can display the necessary message. I could not get the error to go away. I used IIf function but unfortunately there is still an issue which I cant figure out but will keep working at it. Thanks, I am sure I will be back for more help.

Okay the text box worked however all the calculated fields in the Date Footer still show #ERROR. Is there a way to not display the date footer when there is no data??

Let me backup a minute ... the first report works fine when there is qualifing data. If there is no data all the calculated fields show #Error. (Assum this is due to division by 0.) Data is based on "Yes/No" or -1,0. The second report is has the same headers but has a lable box which states...