Recent content by Ctrler

1.) Make a query for only those companies that match the criteria "*attorney*". Include a field for the person's name. 2.) Link this query 1.) to the table containing all your companies using a 'join property' that includes all records from your table but only only those companies...

One of my applications is using a macro to send reports in Rich Text format from Access 97 by the click of a button. All worked fine until sone users switched to Windows XP. Under XP, they now get a blank (!) error message and the report fails to output into a mail attachment. At least within...

When running a macro including a list of queries and commands, is there a way to show which step is currently being executed? By default, Access 97 only shows 'Run Query' and a progress meter in the status bar, but it does not show the name of the query being currently executed. Running some...

Hey Joe, that's exactly the kind of easy solution I was looking for. Works great - thanks a thousand! Gion

How can I create a report with alternating background colours for each record line (price list-style)? I would assume something including an OnFormat event based on odd and even row numbers would do the trick, but perhaps someone has an easier solution at hand. Thanks, Gion

Although crosstab queries sort column headers in ascending order by default, you can change the order of columns by using some drag and drop in the result table, simply select your monday-column and drag it to the left, etc. Remember to save before your query you switch back to design view. the...

Have you checked for cross-links between the two databases? Could it be that CAS_Tables.mdb in PRODUCTION contains links to CAS_Tables in DEVELOPMENT? regards, Gion

Thanks benwah, i still did it in a macro with SendObject, not in code, and included field values from the report (not from the form) in the message header: =[Reports]![reportname]![RecordID]&" "&[Reports]![reportname]![Name] Thanks for showing the direction. Gion

Have a look at thread181-7646 - it got 5 stars and should do the trick. Regards, Gion

When sending a report for one record via e-mail, is there a way to automatically include a certain field value (eg. RecordID) in the e-mail header? Thanks, Gion see also thread181-159806

On your data entry form, create a button committed to the following macro: RunCommand, SaveRecord OpenReport, PrintPreview WHERE [RecordNr]=[Forms]![DataEntry]![RecordNr] SendObject Close The condition in OpenReport limits the output to the record showing currently on your...

Thanks Craig, that solved it. Gion

I've come across this too at one point but found no good solution. One idea would be to make the border of your 'can grow' field visible, which would give you sort of a box-design instead of separating lines. I didn't like it, but perhaps it fits into your report's design. Gion

Thanks Lightning, I didn't know there was such a feature. Problem solved. Gion

Is it possible to display data in a report in columns, avoiding having to use the whole page width for one recordset? I'm using Access 97, I imagine you could do it with web publishing in Access 2000, but that's not an option for me. Can anyone help? Thanks, Gion