Search results

The code is actually from a different form, and it's on click. First, the report is loaded, then the subreports are filtered. As far as when it works and when it doesn't, I don't know. I think the FilterOn usually works the first time then after that, it doesn't. The subreport does not have...

Hello all, When filtering subreports in VBA, I sometimes get errors with FilterOn. For example, my code looks like this: strWhere = "[Billing Effective Date] <= #" & Me.txtAsOfDate & "#" 'Filter Buyside CPU Appendix With .srptBuysideCPU.Report .Filter = strWhere...

I could, but what my manager is looking for is more like links.

Hello all, Is it possible to have a directory with hyperlinks in a report header? For example, there are 5 reasons a customer is not billed: University, Trial, Non-Billed, Consulting and Barter. The report header has each of those 5 listed. From that list, I want to click "University" and it...

Hello all, I have a report with multiple sub-reports. In print preview, I want it to show with two columns. However, when I add page breaks between sub-reports, I only get one column. Is there a way to fix this?

Hello everyone. I have a report with several subreports. In print preview, I have it set to landscape and 2 columns. However, I can't figure out how to make my subreports have two columns. I have set the width of the subreports to less than half the width of the main report. Also, the...

Before I try to decipher all that code, are there any other suggestions for how to change the WHERE clause of a query using VBA?

You are correct; he is one of the authors. I will try to find that function in the code. Do you happen to have a link to his site? I couldn't find it by a Google search. Thanks for your help! Jeff

Hello All, I would like to replace the WHERE clause of a query using VBA, based on the value in another form. In the book I have, it said to do it something like this: 'Change qryNewBusinessYTD Dim strSQL As String Dim qdf As QueryDef Dim db As Database Set db = CurrentDb Set qdf =...

I just realized you meant use the RepeatSection. That worked. Thanks!

Even using the natural group (region), I cannot get it to show at the top of each column, just the very beginning of that group. When a group carries over onto the next column or next page, I want that next column/page to also show that header. Is there a way to do that?

Thanks! I see how it works, but it doesn't seem to work for what I'm doing. It keeps the header at the top of each column, but it doesn't display a new header when a new group begins.

Hello all, In a report, I have the print preview set to 2 columns. For the different groups, sometimes the detail flows into the next column. I want the top of the new column to have the group header (and possibly say 'continued'). For example, now it looks like this: Customer...

In a report, is there a way to set alternate back row colors that are not every other row, but instead when the field value changes? For example, my rows may show as following: Alliance Co. Capital One Capital One Morgan Stanley I want Alliance to have a white background, both Capital One...

I had that feeling, but I figured I'd try. Thanks! :cool:

My form is a continuous form, that is a list of employees. They are all in one long column, like this: Employee 1 Employee 2 ... Employee 200 However, I would like it to look this: Employee1 Employee 101 Employee2 Employee 102 ...

No, but I would like to reduce the length of the form, so even 2 columns would be very helpful.

Hello everyone, I am trying to create a form with multiple columns. The form is directory with a couple hundred names, each one linking to the employee information form. Is it possible to do this? Thanks! Jeff

I'm still in the building phase of the database. Other people aren't using the database yet. I am aware that in most cases, tables aren't the way to go, however in this case, I am using tables. If anyone knows how to set up tables to automatically maximize, that would be helpful.

Okay, this is probably an easy one. I'm using Access 2007. I know how to do this with forms, but I can't figure out how to automatically maximize tables when they open. My other databases haven't had this problem, but the one on which I'm currently working does. It just opens up in a...