Recent content by rutica

I am using Access 2003. I have the following code to create a spreadsheet in Excel. Private Sub cmdExportToExcel_Click() On Error GoTo ProcError Dim strFilePath As String strFilePath = CurrentProject.Path & "\Template_rawdata.xls" If Dir(strFilePath) <> vbNullString Then Kill...

Bob, Is it possible to save the Excel sheet to a Sharepoint site? So I would replace CurrentProject.Path with.....? Thanks

Bob! You're the best. it works great. Thanks!!!

Hi, I'm using Access 2003. I have the following code to create an Excel spreadsheet: Private Sub cmdExportToExcel_Click() On Error GoTo ProcError Dim strFilePath As String strFilePath = CurrentProject.Path & "\Template_rawdata.xls" DoCmd.TransferSpreadsheet TransferType:=acExport...

i just solved my problem by removing "FormatCurrency" from a query that was behind my chart in my subreport. Check out my thread. (see link in post above) Maybe it will work for you too.

this is really weird, but i think i found the problem. In the query behind my chart, i used FormatCurrency in a field: ActualCosts: FormatCurrency(IIf([release]="Dev",[ActualCostDev],IIf([release]="Maint",[ActualCostMaint])),0) I found when I removed the FormatCurrency from the field in the...

thanks again for writing. i just tried compacting and repairing, but still no luck. My database is 78 MB. You had written: "There are also settings on your printer preferences that may assist." What settings? Thanks again.

That is a coincidence. I have a very similar problem. See my thread: http://www.access-programmers.co.uk/forums/showthread.php?p=962896#post962896 I don't have an answer yet, but a workaround for you might be to go into the Design view of your report, and go into the query that is the Record...

thanks for writing. I tried your suggestions, but no luck. I am using Adobe Acrobat 8 Professional. I have Acrobat Distiller 8. --I rebooted, then tried printing my file, but still couldn't see my charts. I ran a windows cleaner to remove temp files, but still no luck. --I tried printing...

this is really weird. i started modifying my database to post it here, but now i see my chart looks correct in Design view! so somehow the problem is fixed. your code is great, but now i can simply right click on the line and select my own color. but... I commented out your code and my...

I'm using Access 2003. I have a report that contains a subreport. The subreport contains a line chart. I open the report in View mode, then go to File, Print and choose Adobe PDF to make a pdf file. i have Adobe Acrobat 8 Professional. All works well if the report is about 165 pages (there...

thanks. i tried what you said: "copying the chart into a new blank Form, run it and then copy it back to a new Report. When the chart is formatted in the Form it should hold its formatting when copied back to the Report." but when i copied the chart from the report to the form, the form also...

it works! thanks!! you're the best. :-) I'll take a look at the demo later. i'm at work and can't download. thanks for sharing the demo. Do you know why the graph lines aren't showing up in Design view? That would be the easiest: simply right click on the line. i have another chart...

Sorry, I see that Detail Format event is what you originally had in your first email. I changed it and now it works!! wow. i have spent over 1.5 hours on this! thanks!!!!! Is there a way to change the color of the markers as well? I went to excel and ran a macro in order to get the code...

thanks for writing. I'm getting 'object doesn't support this property or method' and it highlights this line: .SeriesCollection(1).Border.Color = vbRed here is my code. my graph is named Graph3: Private Sub Report_Open(Cancel As Integer) With Graph3...