Search results

  1. E

    Form appears blank when I add grouping to the underlying query

    I have a query that uses needs two dates which are entered through a form. The query was working fine to list the items that occur between those dates. When I added grouping to the query the form started to appear blank. The form opens and there are no fields or controls on it. Just the...
  2. E

    Printing Multiple Copies of a Report

    I need to print multiple copies of a report and number of copies is varrying each time depending on the entry. Is there any way that I can indicate the number of copies on the report just like I indicate the number of pages. (Like "Page 1 of 5"). I can't use ([Page] & " of " & [Pages]) because...
  3. E

    Truncate or Trunc()

    How do I truncate a decimal number in a VBA code? Currently I am using MOD to overcome this problem but it is a pain and takes too many lines of code to do a simple task. There must be something to use instead. All I need is to cut out the decimal part of a number and use the whole number part...
  4. E

    Finding a record by using 2 combo box!

    I used the wizard to make my form go to a record by using the content of a combo box. But I need the form to go to a specific record depending on the values from two seperate combo box because none of the two combo box create a uniqe value. I changed the code to insert one more arguement for...
  5. E

    Error: Update or Cancel Update without Add or Edit

    I am using two text boxes that gets their values from another form. And using a code to make the table go to a specific record depending on those values on those two tex boxes. The form opens without any problem on the record that I want it to be. I need to add some information to other fields...
  6. E

    Sorting Data in A Table-Type RECORDSET

    When I make Access read the data in a table-type recordset, it follows an order that I could not figure out. I need to sort the data according to a field in the base-table. The help files are not helpfull. The only thing I understood was, I must use Index for a table type recordset, but I...
  7. E

    Can I Append an Array to a table???

    I need to copy the data in a table to another table and simultaneously enter a number under a particular field for all the records. I created a recordset. But I don't know how to enter data (the same number) to that particular column for every record and copy them to another table. Can I do it...
Back
Top Bottom