Search results

  1. R

    VBA for inserting topvalues in table

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

    attachment name

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

    record security

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

    exporting data

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

    decimal places in query

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

    exporting to current directory

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

    query that duplicates records

    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...
Back
Top Bottom