Search results

  1. B

    Compile error: User-defined type not defined

    I just wanted to submit this solution out here so in case someone runs into the same error they will know how to fix it. I have a module that sends emails out of Outlook based on information that is pulled into Access via an Excel worksheet. When I went from Access 2003 to Access 2010 I was...
  2. B

    Multiple Reports Outputing to one file

    Hello all, I have two reports I have made in Access. Is there a way to create an Access report that allows one report to flow right into the other report? Or have Access export both reports to the same file in Word? That way if I was to print out the report in Word it would just be one...
  3. B

    Duplicate Numbers in Report

    Hello, I have a report that is pulling its data from a query. In the query I have two tables. One that pulls in the invoices and the amount of each invoice and the second table that pulls in the total amount of the invoices by account, the account total. The problem I am having is when I run...
  4. B

    Duplicate Numbers in Query

    Hello, I have a query. In the query I have two tables. One that pulls in the invoices and the amount of each invoice and the second table that pulls in the total amount of the invoices by account, the account total. The problem I am having is when I run the query The account total duplicates...
  5. B

    Subreport Problem

    Hello, I am new to creating subreports. I want to create a subreport that just shows up on the first page of the report on the right side. The problem is when I add the subreport it moves everything in that Header field up. So I have the titles and under the titles a bunch of space and then...
  6. B

    Update Query - Delete Part of a Field

    Hello, I have a table with an account number field. It has about 400,000 account numbers. The problem I have is every account number has two zeros infront of the account number. For example, 00712394. Is there away to do a update query to delete the two zeros from the front of the account...
  7. B

    do.command Button code - Form

    Hello, I have a form that has a list of Employee numbers and when you double click on an employee's number it opens another form that list all the accounts under that employee number. Everything is working fine except there're a couple of duplicate employee numbers for the US and Canada so...
  8. B

    Duplicate Records

    I have a query that matches amounts to invoices. So when I run the query there can be 5 of the same invoice but different amounts for each of the same invoice. Is there a way to make the query only return the largest amount for each invoice?
  9. B

    Selecting Top 10 Values

    Hello, I have the following union query, is there away for this query to output only the Top 10 values? select * from [Highest Impacting AR Reserve Invoices] UNION select * from [Highest Impacting FM Reserve Invoices];
  10. B

    Delete/Update Query question? Is there a way to do this?

    Hello, I have a table that gets updated data monthly from an update query that I run at the beginning of every month. The table has the fields Account #, Acct Amt, Days over due, and date of last payment. This table keeps track of any accounts that have any over due balances that have not been...
  11. B

    Multiple IIF statements in one column?

    Hello, In a query I have 3 seperate columns outputting information based on 3 seperate built expressions. They each are outputting the invoice amount by the date they were due. One is doing invoice amounts from 31-90 days over due, one is doing 91-180 days over due, and the other is doing over...
Back
Top Bottom