Search results

  1. A

    Compile Error

    When I try to add a button to a form I get the follwoing error. Compile error. in query expression 'AppLoadString([bw_tblBtnActions].[Description])' I have other forms with buttons on them that jsut open reports. When I click any of them I get this next error. Compile error: Invalid...
  2. A

    Eliminating Duplicates in a Query

    I have a table that lists prospective sales as they travel through time in the sales process. Every month a snapshot is taken of the sales progress and uploaded to the table. This table has an autonumber as the primary key because the unique sales ID for all of these often duplicates when the...
  3. A

    Using a single Query for multiple Tables

    Alright I don't know if this can be done but I've been given this task by higher ups so I ahve to at elast try. The database I'm using has different tables going abck once a month for pending sales. These are each essentaily a snapshot in time of how far along the sales are and how many of...
  4. A

    consolidating report input info

    I have a report I created to that gives lots of different information on sales. The only problem is that it is made up of a bunch of subreports derived from queries and each of these need its own input. However, it is all the same input (a string that gives the year and month of the records...
  5. A

    Displaying categories with null values in a query.

    I have to list sales by divison and for a period from a table that includes all prospective sales successful or otherwise. So I have designed a query to display the divison name and then the sums and counts for sales in the division. I then have 2 "where" functions to get the correct time...
Top Bottom