Replies

Click the Properties button In the form’s design view. On the Format tab – Views Allowed: Form, AutoResize: No, BorderStyle: None. (The options for Record Selectors, Navigation Buttons, and Dividing Lines can also be set to either display or not.) Click the Other tab. Set Popup to Yes, Modal: Yes, Shortcut Menu: No.

On the Event tab, OnOpen event: write this event procedure: DoCmd.Maximize. OnClose, write event procedure: DoCmd.Restore. (This only needs to be done if your other forms are not maximized already.)

Also, as you already guessed, you will need to add a Close Form button.

HTH.

Click the Properties button In the form’s design view. On the Format tab – Views Allowed: Form, AutoResize: No, BorderStyle: None. (The options for Record Selectors, Navigation Buttons, and Dividing Lines can also be set to either display or not.) Click the Other tab. Set Popup to Yes, Modal: Yes, Shortcut Menu: No.

On the Event tab, OnOpen event: write this event procedure: DoCmd.Maximize. OnClose, write event procedure: DoCmd.Restore. (This only needs to be done if your other forms are not maximized already.)

Also, as you already guessed, you will need to add a Close Form button.

HTH.

Hey, Hans!
This is no joke – let me know the next time you’re in the Chicago area and I’ll buy you dinner!! The fixed version works beautifully. Thank you very much for helping me with this.

Hey, Hans!
This is no joke – let me know the next time you’re in the Chicago area and I’ll buy you dinner!! The fixed version works beautifully. Thank you very much for helping me with this.

Hans – I thank you for your time that you have spent on this. I do appreciate it!

Charlotte – Thank you for verifying that I have not in fact gone insane! (At least, I don’t think I have.)

Hans – I thank you for your time that you have spent on this. I do appreciate it!

Charlotte – Thank you for verifying that I have not in fact gone insane! (At least, I don’t think I have.)

Update –

Hans, I downloaded the attachment at work and it exibited the same strange behavior. I reread my initial post about this behavior and realized that I failed to mention that this oddity only occurs when you click the arrow button going to the last page before doing anything else after the report opens. When the report is closed and reopened, it works just like it is supposed to as long as you don’t go to the last page first. Very strange.

BTW, the machine at work is running NT with A2K.

Update –

Hans, I downloaded the attachment at work and it exibited the same strange behavior. I reread my initial post about this behavior and realized that I failed to mention that this oddity only occurs when you click the arrow button going to the last page before doing anything else after the report opens. When the report is closed and reopened, it works just like it is supposed to as long as you don’t go to the last page first. Very strange.

BTW, the machine at work is running NT with A2K.

Hi Hans,
To answer your question, I re-downloaded the file and tried it on my machine fresh. Similiar problem but different in that nothing happened if I tried to jump to the last page first. But then when I clicked through each page, the pages would stop on page 5 but I could continue clicking the arrow button – it did not gray out at the last page.

I then tried it on my laptop – same behavior. Laptop version Access 2000 (9.0.3821 SR-1), Desktop version Access 2000 (9.0.6926 SP-3).

This is the only report that does this so what I may do to work around this oddity is to not allow the users to preview it first – just print directly. Actually, what I need to do is figure out how to convert both reports to Word and then email the Word docs (automatically) to where they need to go (the gym).

In any case, thank you very much for your help on both of my problems!

Hi Hans,
To answer your question, I re-downloaded the file and tried it on my machine fresh. Similiar problem but different in that nothing happened if I tried to jump to the last page first. But then when I clicked through each page, the pages would stop on page 5 but I could continue clicking the arrow button – it did not gray out at the last page.

I then tried it on my laptop – same behavior. Laptop version Access 2000 (9.0.3821 SR-1), Desktop version Access 2000 (9.0.6926 SP-3).

This is the only report that does this so what I may do to work around this oddity is to not allow the users to preview it first – just print directly. Actually, what I need to do is figure out how to convert both reports to Word and then email the Word docs (automatically) to where they need to go (the gym).

In any case, thank you very much for your help on both of my problems!

Hans,
Thanks for your help. That report appears to do exactly what I wanted it to do. However, I have noticed some strange behavior that I can’t quite figure out.

After the report opens and I click on the arrow at the bottom to go to the next page – the report works just like it is supposed to: It shows all 80 records in the proper format and on the correct page – just like I wanted. But when I click on the arrow|line to jump to the last page – the report eliminates 4 records after every 14th record. In other words, the first page shows the first 14 records, then the second page skips 4 records and shows 14 records, then the third page skips 4 and shows 14 records, etc, etc. If I close the report and reopen it, it is fine unless I jump to the last page.

Did I screw something up indavertently or has my installation gotten corrupted somehow? (BTW, I checked the underlying query in both situations and it showed all 80 records.)

Hans,
Thanks for your help. That report appears to do exactly what I wanted it to do. However, I have noticed some strange behavior that I can’t quite figure out.

After the report opens and I click on the arrow at the bottom to go to the next page – the report works just like it is supposed to: It shows all 80 records in the proper format and on the correct page – just like I wanted. But when I click on the arrow|line to jump to the last page – the report eliminates 4 records after every 14th record. In other words, the first page shows the first 14 records, then the second page skips 4 records and shows 14 records, then the third page skips 4 and shows 14 records, etc, etc. If I close the report and reopen it, it is fine unless I jump to the last page.

Did I screw something up indavertently or has my installation gotten corrupted somehow? (BTW, I checked the underlying query in both situations and it showed all 80 records.)

Hi,
I created two tables (tblCustomer and tblSales) and populated them with your data. Then I created a GroupBy query with the following:

SELECT DISTINCTROW tblCustomer.GPRNT, Sum(tblSales.EXTENDEDPR) AS [Sum Of EXTENDEDPR]
FROM tblCustomer INNER JOIN tblSales ON tblCustomer.GPRNT = tblSales.GPRNT
GROUP BY tblCustomer.GPRNT;

This returns a total of zero as you expected it to. Does this help?

Hi,
I created two tables (tblCustomer and tblSales) and populated them with your data. Then I created a GroupBy query with the following:

SELECT DISTINCTROW tblCustomer.GPRNT, Sum(tblSales.EXTENDEDPR) AS [Sum Of EXTENDEDPR]
FROM tblCustomer INNER JOIN tblSales ON tblCustomer.GPRNT = tblSales.GPRNT
GROUP BY tblCustomer.GPRNT;

This returns a total of zero as you expected it to. Does this help?

I’ve been using FreePDF since May on WinXP and it has worked great. Here’s the link: http://www.geocities.com/thompso_m1/index.html%5B/url%5D .