Search results

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

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 ?

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.

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

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.

Hello, I have an Access 2000 database with a Main Page that loads automatically. I have now installed Access 2007. The database loads and works fine, but ... I have no clue how to see the list of tables, queries, forms, ... in that database ... there doesn't seems to be a tab on the menu. Am...

Hello, Is there a way to create a field in a form which functions like a cell in Excel ? I have a numeric field where I would like the result of an addition, so I would like to type e.g. =10+15+4 and the result (29) would be the value of the field, but in the form I would like to be able to...

Hello, I have a table with a list of emails and would like to export them as a text-file with a comma as a separator. Any thoughts on how I should proceed ? :confused: Thanks.