Search results

It worked with Nz ... thank you !!!

The Total column is not a problem. I want a Total of the Row.

Thanks I added an example in my original post.

I have a Report based on a Crosstab Query. Rows : Date - value for A - Value for B - Value for C Totals for the columns A-B-C were created automatically. I also want to have the Total for (A+B+C). When I create a field in the detail section (ValueA+ValueB+ValueC) , this total is only shown...

Thank you.

I don't seem to get the right syntax for opening a report with only the records where the field Reference equals UD : DoComd.OpenReport "rptCosts", acViewPreview, , Reference= "UD" What's wrong with the syntax ?

Yes, I simply copied it and changed the table name. No file was transfered. In the meanwhile I have found the following code and now it works :) Dim trz As Integer Dim strCSV As String For trz = 1 To 511 Close #trz Next trz trz = FreeFile...

Yes, I looked at the reference and also used the .csv extension. But no file is transferred.

Unfortunately it doesn't seem to work : DoCmd.TransferText acExportDelim, "Standard Output", _ "External Report", "C:\Txtfiles\April.doc" There is no file created in the location that I specified. What do I have to specify for "Standard Output" ?

I need to export a table to a csv file with VBA code. How do I do that ? The name of the table is "Book". I have Access 2010.

Maybe a last question : is there a way to include the column header ?

Thank you ... it works now :-)

Thank you, the export works, but there seems to be a small bug. The csv file contains the number of rows as there are rows in the Access-table, but every row contains the same fields as the first record in the Access table.

I need to export a table (ExportTable) to a csv-file (Export) and I tried the following code : DoCmd.TransferText acExportDelim, , "ExportTable", "c:\Export.csv" When I try this, I get the message (it's a translation, the english version may vary) : : "The field separator sign of the...

Thank you for the input. It seems that I have to create a specification name to determine how to export the text file. How do I do that ?

TransferText doesn't seem to exist anymore in Access 2007.

I want to export a query to a csv-file using a macro. Is this possible ? The Output Format doesn't list csv as an option.

Okay, I already found it. Control Source must be "=1" without the brackets.

Hello, I have Access 2007. I tried this in a new report : - created a control 'Number' - Control Source : 1 - Running Sum : Over all When I run the report, I get a popup box which asks 'Enter Parameter Value' for the filed 1. When I fill in "1" (without the brackets) then the report shows...

OK ..; I found it : 'Display Navigation Pane' was not checked ... Thank you all ...