Search results for query: *

I got it!!!. . . I had the options set to stop on all errors. I changed it to Stop on unhandled errors and it WORKS!!! Grreat job GVF. Thanks for your help. Tony

The On Error Resume Next is what I thought would prevent the error, but it doesn't. I get a runtime error, and it says "cannot rename a sheet as another sheet. . . " instead of the dialog box. It's like the "resume next is not working (???) I'm confused. . . I like the way your re-code works...

Thanks GVF for your response. When I copied your code into the template sheet and run it. It errors with duplicate name, if I try to create the sheet twice. Sheets(NewRRSht).Name = Format(Date + 1, "MMM") & Right(Year(Now()), 2) Should I just put in an "exists" if statement and follow it...

I'm a novice (at best) in writing VBA code and I'm trying to "automate" a workbook for the "boss". What happens is I have a workbook with a sheet for every month of the year that contains columns for ID, Name, Amnt, Prev Balance, Fees, Amnt Paid, Current Balnce. The ID, Name and Amnt come from...

EXCELLENT!!!!! Works Great. Thanks for the help. tony

Thanks for the reply chirpyform. Sorry I wasn't clear enough. You gave me an idea to change a few things around then this will work. I was using a single combobox for all the choices, but if I use two comboboxes (one for Active and another for Inactive) I can use your suggestion. Am I right...

I posted this in the Microsoft Access Other forum, which was the wrong place. Sorry. I'm not a "seasoned" VBA coder but I'm learning through this forum. Now I need to ask a question. I have a form with a combobox and an option group. I have the following code in the After_Update of...

I'm not a "seasoned" VBA coder but I'm learning through this forum. Now I need to ask a question. I have a form with a combobox and an option group. I have the following code in the After_Update of Frame81: ******************************** Private Sub Frame81_AfterUpdate() 'This...

Thanks for pointing in the right direction. The main report needed to be unbound. Thanks again for your help tempclerk. tony9bb

I've read previous posts with this problem, but I'm not sure how to fix it. I have a linked transaction table. From that I have 2 Make Table queries to extract detail data of charges and receipts separately. Then I have 2 crosstab queries to sum the charges and receipts by insurance companies. I...

Thanks Nickjar2. It is a popup form and your solution works. It looked too easy once you know what you're doing. I've tried numerous Control Source options to get the calculation on my main report, but have not found the right solution. Your help is greatly appreciated. tony9bb

I'm a newbie with Access 97. This forum has helped me tremendously, just by reading previous posts, but now I'm stuck. I have two questions/problems: 1.)I have a report that has five subreports created by a form for date range input. The report data is fine. But when it displays in Print...