Search results for query: *

Thanks for your reply! I found the way around my issue, and as usual it was rediculously simple. Yet another case of trying to to pound a nail with an anvil. If the combobox is already bound to a query, programmatically setting it's value to one of the currently bound values causes the box...

A report is not so very different from a form. It's simply read only. I would create a subform and drop the elements of your "report" into it. Set the background to white. The user can't tell the difference..

Explicitly define the columns you would like for the listbox. This is exactly the same as any other query, simply build the datasource to include only the fields you would like.

Howdy folks, I'm in a bit of a quandry trying to figure this one out. Basically I have a comma deliminated string that I need to use to populate a multi-column combobox. I'm confused because passing a comma deliminated string works properly for populating a listbox, and combo boxes are...

Howdy folks, I have an issue that's been raking me over the coals for a few hours now. Basically I'm trying to export an access report to an excel spreadsheet. The issue I'm having is excel is very picky about the format of the data. In the report, I have one group header and a detail band...

=([UnitsSold]-[PrevTotSold])/iif([PrevTotSold] = 0 , 1, [PrevTotSold])

Will you ever have more then two entries for the same studio? If not I can see quick fix. Something to the effect of: SELECT [id], [name], MIN(end date), MAX(beg date), DATEDIFF(day, edate, sdate) FROM tblA INNER JOIN tblB ON tblA.id = tblB.id If you need it dynamic, then I'd have to put...

The sort order of the underlying query does have an effect on the output of the data, provided you have not set an overriding condition in the report itself. For instance, take a report with grouping levels consisting of: Parent Company ____Company ________Employees Sorting by Parent Company...

YOu may be able to do this with an OR operator in your where clause. SELECT [2003].Manger FROM 2003 WHERE (([2003].Investor=fncGetInvestor) AND ([2003].["One on One" Manager Meetings])>0) OR ([2003].[Capital Introductions Event "Manager Sessions" Attended])>0) OR...

Make sure the report isn't carrying over into the waste area of the report. This is much the same as excel printing additional horizontal cells on the following page. I believe the cut off for a default portrait report is "6.5" according to the in-line ruler during design time.

If it only appears at the top of the first page, then you would be better off using the report header.

Are you absolutely sure the command is being triggered in the first place? Perhaps you could post the sub that you're stepping through. You may want to consider throwing a debug messagebox before and after the DoCmd.Quit, just to make sure it is indeed failing.

I think you're on the right track with setting the "filter" in the Report_Open event. Why not flat out set the record source though? Essentially you could do something along the lines of: Dim frm As Form Dim Src As String Dim WhrClause As String Set frm = Forms!yourForm Src =...

Actually, you won't return anything for an agent, not even null. SQL constructs the dataset from the join statement first. If a value does not appear in one table, it is assigned null at that time. The problem you may run into is that if the broker has any sales at all, then they do in fact...