Search results

Sorry, not sure I understand what you mean. If you're using the second query as the record source for your report, the fiels should be there. Might be quickest to email me a sample of your database (i.e. don't include all the records, just enough for me to test with.) My email address is in my...

Well, you're really not. You're basing it off a table created by an action query instead. But the table is recreated each time the report is run. Glad to hear it works though.

Here's one way to handle it with a minimal amount of code. It's probably not the most elegantly conceived approach, but it works. -Use the Find Duplicates query wizard to build a query. -In design view, change this query into a Make Table query. Add a new column to the query and type in the...

Yes, the query on which the report is based (I called it Query A above) uses an aggregate function (Max). Is that the problem?

Rich, Sorry, use DLookup how? Not really sure what you mean. Thanks!

Set the Width and Left properties for both the label and the text box to the same value.

Hi all, I'm having a problem with memo fields on reports truncating after the first 255 characters. The full content of the fields displays perfectly on the form but not on the report. Here's the other weird item: the entire field contents display in the results of a "base" query but not in...

Thanks for your replies, guys. But I'd already played around with the CanGrow/CanShrink properties quite a bit. I ended up working around the problem by borrowing some code I found in another thread to draw lines around each field, rather than using solid borders. Thanks again.

I have a spreadsheet-like report containing a row of text and combo boxes in the detail section. In design mode, all the elements in the detail section are the same height. However at runtime, one of them shrinks to a slightly smaller height while the rest remain at the correct height. Needless...

Unfortunately, exporting Access reports to Word typically causes all the formatting to be lost, as you said. Your best bet, assuming the recipient does not need to edit the document, only view and/or print it, is to export it to a Snapshot file and have the recipient install Snapshot viewer. The...

I don't know if this is the best way, but it should work: Create an unbound control in the report detail with a control source of: =[NameOfCalculateControlCreatedAbove]. Set the Visible property to No and the Running Sum property to Over All. In the report footer, create another unbound control...

You might want to take a look at the Solutions.mdb file. It's a sample database that comes with Access. You'll probably find it under Program Files\Office\Samples or somesuch. There is an example in the this database that explains how to do exactly what you want to do. If for some reason, you...

Here's the only way I got it to work. Include your actual field somewhere on the report but set its Visible property to No. Then put an unbound control where you would have placed your actual field on the report. In the report Detail event: Private Sub Detail_Format(Cancel As Integer...

You could try entering [Event_date] in the "Order by" property of the form itself. I believe that overrides any other sort orders. [This message has been edited by RedSkies (edited 05-16-2001).]

This same sort of thing drove me nuts on a report I was working on for some time. Here's how I eventually did it: =(IIf([YourSubreportName].[Report].[HasData],[YourSubreportName].[Report]![YourSubReportField1],0))+(IIf([YourSubreportName].[Report].[HasData],[YourSubreportName].[Report]![YourSu...

You question got me curious so I was checking out a couple other bulletin boards. This code was posted on Tek-Tips by RHicks whom I've seen post on this forum numerous times as well (and he's obviously damn good! ) All you'd need to do on your report is add a textbox control with the...

Not sure if I remember this correctly but I believe I handled a similar situation by setting the height of the subreport to 0 or some other very small value like .0313 That is, from your main report click on rectangle containing the subreport and set the height property to 0 and the Can Grow...

In the fields properties, set Format to Long Date.

This solution is EXTREMELY simplistic so I'm not sure you'll want to use it. But it might give you some ideas. In the General Declarations section of your form (i.e. between Option Declare Database and Option Explicit) declare a constant string variable for your password. Specifically: Const...

On the Form_Load event of your form, make sure that the combobox is initialized to 0 or "" or Null (Is it a number or text data type?) so it appears blank - nothing is selected. Then the criteria for that field in the underlying query for the report should be; Like "*" &...