Search results

error in Customer = aa.itemdata(I). 'Get next item in list'

Yes, I have query for that purpose. The program is showing error

I wrote this code, is this ok? For i = 0 To aa.ListCount - 1 Customer = aa.itemdata(I). 'Get next item in list' aa = Customer 'Set list box. DoCmd.OpenReport "cust" Next My buyers table name is Customer Combo box name is aa report name is cust

I have a drop down menu from where the user selects a particular buyer and then click on the show report button and the report for that specific buyers opens in front of him. This works fine. No issue with that. When printing reports, the users have to click on each buyer one by one and the...

I compact and repair the database as well. Im using the print command by right click on t he report n click print. I dont have any print command button on the report. and yes, the users open the report from the command button on the form.

every single time this table gets printed and it can't be queued on its own every time and if it is, what could be the reason. I do not have any code module :(

bcoz is because

But it is repetitive n it wastes too many print pages. The manger noticed it and asked me to fix it asap but Im clueless why is it happening. is it bcoz of the print option I am choosing or some other reason.

No, the table isn't open when I give print command but it is the first table in my db, the topmost in the list. I just right click, select print preview and from there right click n click on print.

Wait Lemme try to elaborate it a bit more. I have few reports based on queries and working pretty well. Sometimes when I want to print the report, report will get printed along with few copies of one of the tables in my db. that particular table is not even part of the report. Its a table...

No, its not the same

I have quite a few tables in the same db. One table with get printed with the report and sometimes instead of the report.

A query: Whenever I give print command on my reports, some tables automatically gets printed with it and too many pages gets wasted. How to overcome this issue?

Wow See thats what is called the expert advice. Since Im new to access thus never n=knew we have OnNoData event procedure. Thanks alot, my issue is solved within 5 minutes.

Greetings my friends I have a report. which based on the conditions, might show zero records sometimes. Now I want that if the record has zero entries, a message box appears prior to to opening the report that says that 'there are no records for the said condition'. I guess this will be...

perfect, works very well

Sure, lemme try this one thanks

Yes, I have year condition as well but for now this is easy.

Thanks. I got it worked. Used WHERE Month(MillenniumDeliveryDate) = Month(Date());

Im sorry, I didnt get it. I want three different button that is: Current Month, Previous Month and Next Month and they should open the respective reports. I have an extensive data ranging more than these three months. How to filter the specified records only. I guess something need to be given...