Search results

Hi Ian, Hope it's not too big, but here it comes: Original table: Customer Period ReportGroup Sales 507 200508 A 24244 507 200508 B 1920 507 200509 A 24244 507 200509 B 1920 507 200510 A 19318 507 200510 B 360 507 200511 A 19318 507 200511 B 360 507 200512 A 24244 507 200512 B 1920 507 200601...

Hi, I'm using Access 2003 and have a question about "topvalues". I've created table T_Sales with following fields: Customernr Period Productgroup Sales Suppose we've only sold in Productgroup A, B and C. Following example records could be in the table: 1000 - 200701 - A - 850 1000 - 200701 -...

Hello, I'm using Access 2000 on Windows 2000 and got the following question. In my database I'm using the following VBA: DoCmd.SendObject acSendReport, "Sales Report", acFormatRTF, [mailadres] This script is creating a mail with the report "Sales Report" attached to it. That's working fine...

Hi, This works, thanks a lot for your advice! Robert

Hi, I'm using Access 2000 on Windows 2000 and got the following question: We've set up a database where you have data per factory. So suppose in the table "T_factory" are the fields "factory" (text-field), "machinenumber", "purchasedate". Now I've tried to build a module which takes care of...

Mike, I got a hint from a colleague of mine which solved the problem. I replaced: DoCmd.TransferSpreadsheet acExport, , "Q_report", "C:\Data\export" with: DoCmd.OutputTo acOutputQuery, "Q_report", acFormatXLS, "C:\Data\export" This works, the single quotes are gone! But thanks for your...

Hi, I defined the 3 parameters that I'm using, but I still get the error message "Too few parameters, expected 3". I'm using a UNION-query. Could that be the problem? I also tried "opensnapshot" but that doesn't work either, same error -message... Any other suggestions? Appreciate your help...

Hi, We're getting closer now! I've got one problem left. So I'm trying to export this query. In the query are 2 variables that are entered in a form. So part of the SQL looks like: " WHERE (((tblmain.wm_week)>=[Forms]![F_menu]![start_week_r1] And...

Hi, I'm using Access 2000 on Windows 2000 and got the following question: In a database I'm using the following VBA to export the data from query "Q_report" to an Excel file: DoCmd.TransferSpreadsheet acExport, , "Q_report", "C:\Data\export" Now this works fine, I get the excel file with this...

Hi! I'm using Access 2000 on Windows 2000 and I hope someone can help me with the following question: In a query I'm selecting field A from a table. Now I would like to have 2 decimal places in the query for field A. Right now it is showing different number of decimal places, depends on how...

Hi, I've got a question about exporting data from an access database. I'm using Access 2000 on windows 2000. I'm using the following VBA in my database: Dim name As String name = "C:\Data\export" DoCmd.TransferSpreadsheet acExport, , "Q_export",name So I'm exporting the content of query...

Hi, I'm using Access 2000 on Windows 2000 and hope someone can help me with the following question: I've got 1 table with the following fields: articlenumber articlename weeknumber qty sales Example of first 2 records in table: 10/article A/200320/20/$2.000 20/article B/200320/15/$1.500...