Search results

It is taking three months away from todays date. therefore if you passed it 26/09/2002 it would return 26/06/2002. Lookup DateAdd in Access help for a complete breakdown.

Microsoft states that this behaviour is by design, which means it's pants! See this:http://support.microsoft.com/default.aspx?scid=kb;en-us;Q168219

In the Totals line of the designed query set it to Group By, that is presuming you do not want to do any calculations on any of your other fields.

Start here: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q119655 There are links from this page to help you achieve your goal using various methods.

You can do what you want if you have no grouping in the report and you are doing all sorting in the report code. It may not be working because you need to put this line of code in: [Report_MyReport].OrderByOn = True Then again it may not be working because you have grouping in the report.

I would do it in the query. Do you have 2 seperate queries for each report? In the first report query you need to Group your data, this will remove the duplicates. Only put the fields in the query that you wish to output to the report.

To save a query/table as an Excel file: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "Your Query Or Table Name", "Path to be saved and filename", True To send as an email lookup: Docmd.SendObject This code is in this forum hundreds of times, people ask the same question...

I could be barking up the wrong tree but just copy the left hand report headers to the right hand side of the page. Therefore they'll be there twice.

I think you have posted this before and I didn't fully understand the first time. To produce 2 columns on a report. -Design the report -Click File>Page Setup>Columns Tab. -Type in 2 for two columns and adjust the column width to the width required I don't understand what you mean by the first...

The 'Illegal Error Message' is what? Does it not give you any more information? If you are talking about an IPF or a GPF it is probably worth looking up the error message on Microsofts' website as this is extremely unlikely to be a problem with your macro but a problem with your MS Office.

It's on the Microsoft Office CD in the Value Pack.

You can export them as a snapshot. You will need the Snapshot Viewer from Microsoft to view them and you won;t be able to edit them....but they will appear as the do in Access. For Access97 goto: http://office.microsoft.com/Downloads/9798/snpvw80.aspx For Access2000 goto...

When the database is distributed they will be included. If you click Tools>Options and check System objects. Then go to Tables and open MSysIMEXSpecs. You will see all of your specs...

If you minimise the database window and close Access it should remember this setting.

I've never found an answer to this. Best I can offer is to press Z to zoom out then page up and down to scroll the pages. Then press Z to move zoom back in.

Try this: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=33155 It is the inbulit security in Outlook causing your problem...

Docmd.SetWarnings False To turn them back on: Docmd.SetWarnings True

To remove the parameter, design the query and take out the criteria for that field. EG: Remove [Please enter the input value:] And put LG in it's place. This may also be in the report, so you may need to remove it from there or it will still ask you for a parameter when run. If you need to...

If I understand what you are saying......As far as I am aware it is not possible to remove the grey border. You are print previewing your report.

If I export a report to a snapshot the back colour of text boxes is kept. Try looking on Microsofts website as there are many rules as to why Access will or won't export colours of lines, text boxes etc etc, usually dependant on the colour of the sky. Sorry I can't be more help.