Search results

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...

I am using Access 2003. I have a question about charts please: In a report (not a form), I have a line chart with $ in the vertical axis, Date in the horizontal axis, and 3 values plotted as the data: PlannedCost, ActualCost and TotalCost. Access made my TotalCost line light yellow and I...

Thanks for writing. In my frmInitial, I have the following code for my date combo box: If Now() > AsOfDate Then DoCmd.OpenForm "frmInputForm", , , "[AsOfDate]=" & "#" & Me![cboExistingData] & "#", acFormReadOnly MsgBox "This form is read only" Else DoCmd.OpenForm "frmInputForm", , ...

I'm using Access 2003. I have a feeling I'm not on the right path.. Can someone look at my attached database and let me know what you think? My purpose is to create a database where Measures data is collected monthly. There are Data Owners assigned to different measures. Monthly, when the...

The database is attached. The change I made was: I opened the query called qrySummary in design view. I went to Query, Parameters. In the Parameter column, I typed [Forms]![frmEscalationReports]![cboEscalation]. In the Data Type column, I choose Integer. Before the change, when i clicked...

i'm at work and can't upload or download my database here. i will upload my database tonight though. but did you try what kiwiman said: "Open your crosstab in design view, then from the Query Menu select "Paramaters", then add the detail in here - the name of your combobox control, something...