Search results

I meant for selecting the printer, as well as other options like color, quality, feed tray, etc. Probably can do without, though. I did manage to use OpenRecordSet once, and then just feed that recordset into my main report and 5 subreports, but it didn't seem to speed anything up at all :(.

I wonder if maybe I am concentrating on the wrong thing here. Since I already have something that works, my main concern is the time it takes to generate all the statements. Currently it seems to take a little over 1 second per statement. Trying to think of where the slowdown actually is, the...

Where does the actual printing happen? Won't that just open the individual statements in Print Preview? Assuming that's what I have set as the "Default View". Edit: Nevermind, I see that acViewNormal should send the report to the printer. Is there a way to retain an initial printer dialog box?

Thanks for your help on this! I am still a bit confused, though. I assume within each of my separate report templates, I would need to set the record source to be a single record that matches the progress of the loop? I think I could manage to do this. Or would I be able to use the rsClients...

I don't want separate reports, though. I want to end up with one alphabetized stack of statements (with varying formats), not 3 separate alphabetized stacks. When you say to open up the relevant template at print time, that seems simple enough, but then how do I open up a different template for...

I am printing statements for clients. Depending on certain criteria about the client, the format of the statement changes completely. This is just how the boss wants it, I have no control. I still want to generate all statements at one time (not separate reports). I currently have this working...

Wow, thanks! Didn't expect someone to go through that much effort. I'm not sure if it's doing exactly what I want or not, and it will take me awhile to go through and figure out what all that is actually doing, but I think I will be able to take it from here.

tbl_Recurring Deliveries: ID, ClientID, Deliver, StartDate, EndDate, DayOfWeek, Frequency, ReferenceDate, DeliverA, DeliverB 1, 1, True, 9/23/14, null, 3, 1, 9/23/14, True, False 2, 2, True, 9/23/14, null, 3, 1, 9/23/14, True, False 2, 3, True, 9/23/14, null, 3, 1, 9/23/14, True, True This says...

Thanks for the response. I don't have tables with the same data structure, I simply queried my underlying tables into the form of two tables with the same data structure since I assumed it would then be easy to combine them in the way I needed to. Bad assumption I guess! Assuming I simply had...

I feel like this is probably going to turn out to be an extremely simple question, but I can't seem to figure it out. I have two tables, structured the same, with three fields: ID, CriteriaA, CriteriaB. CriteriaA and CriteriaB are both booleans. There are some IDs that are only in table1, some...

I currently have a button with a checkbox on top (z-axis wise). This works exactly like I want, except that whenever the button is clicked or focused, it gets brought to the top and hides the checkbox. Is there a simple way to prevent this? The only idea I've been able to come up with is maybe...