Search results

  1. M

    Splitting out information in a report

    This is the VBA for the OnOpen procedure for the report in question: Private Sub Report_Open(Cancel As Integer) Set DB = DBEngine.Workspaces(0).Databases(0) DoCmd.SetWarnings False DoCmd.RunSQL "Delete * From ztblHazardClass;" DoCmd.SetWarnings True Set GrpPages =...
  2. M

    Splitting out information in a report

    I need to split out information in a report and I'm not sure how to do it. The report is based on the following query: SELECT tblHazardClass.HazardClass, Product.ProductName, Product.Package, Product.Size, tblStoreProducts.Cases, Product.Units, Product.ReportUnits...
  3. M

    Too Complex error...sporadic?

    I don't know if this is the correct forum for this question or not, since I'm not really sure what's causing Access to throw this error in the first place... I have a form where the user chooses a Company, and then a Store from within that Company. The user can then click on buttons to generate...
  4. M

    Conditional Formatting with 3 conditions

    I'm having to create a report that will print one of 2 graphics based on 3 conditions. Here is a piece of code I have already (it's in the On Format of the report Detail): If ztblAustinNFPARateTotal.GrpSub = "Flammability 3" And ztblAustinNFPARateTotal.PhysicalState = "L" And...
  5. M

    Problem with Grouping & Totals

    Thank you, David! I did something quite similar, actually. I had created a query, and that query created a new field through nested Iif statements. My solution was to create a second query, based on that first query. This second query looked at the value in the Grp field created by the first...
  6. M

    Problem with Grouping & Totals

    My report has a main level grouping on field GRP. There are 3 separate fields within a Group Rating: Health, Flammability, & Reactivity. Each of these fields may contain a number 0 through 4. I have designed a query that compares the 3 fields for any record and creates an entry in the GRP...
  7. M

    Make Table Query Problem

    Can you post the SQL code for the query in question so we can take a look at it? It sounds like somewhere, sometime since the last time you ran these queries, someone modified the database in such a way that one of these tables had a relationship created to another object, which is locking that...
  8. M

    Compare Data in 3 Fields in 1 Table & Group By the largest

    My solution so far: SELECT Product.NFPAFlammability, Product.NFPAHealth, Product.NFPAReactivity, Product.ProductName, Product.Size, Product.Units, Product.ReportUnits, (([Product].[Size]*tblStoreProducts.MaxUnits)/[Product].[ConversionRate]) AS QOH, tblStoreProducts.StoreKey...
  9. M

    Compare Data in 3 Fields in 1 Table & Group By the largest

    I'm trying to create a query that will compare the data in 3 fields in a record, choose the largest (I also have a criteria to order by if more than 1 field has the same entry and it's the largest of the 3), and then group by that. The fields I will need are as follows: PRODUCT table...
  10. M

    Problem Centering Report on Page?

    I'm using Access 2010. My reports are all crowding the left margin, with the reports printed in Landscape being the worst. My Page Setup shows Top and Bottom margins are 0.2 inches, Left is 0.35 and Right is 0.213. Paper size is 8.5 x 11, in Landscape Mode. 1 column. Column is 10.4" I'm...
  11. M

    Quick way to change hyperlink addresses?

    I have a massive database...100,000 records (well, it seems massive to me right now!). A part of each record is a hyperlink to a PDF document on the server. I didn't map a drive letter for the path, as everything I've researched has said to not use drive letters but the actual server name and...
  12. M

    Need help finding source of certain data

    I have a report that is pretty complicated in the page numbering, since it's grouped by Aisle Number (it's a report of hazardous products in a store), and the Aisle Number and the "Page x of x" is in the header. Someone here actually created all of the logic for me last year. I'm trying to...
  13. M

    Create an Alphabetized List & Truncate

    Mailman, Thank you so much for the tips. My next question...am I doing this in the report, or in a query? I'm relatively new at this, have just recently gotten very comfortable creating all kinds of queries, but I still struggle quite a bit with reports. Right now, the button on the form...
  14. M

    Create an Alphabetized List & Truncate

    The project I am working on includes a field that is actually hyperlinks to PDF files in a folder on the server. The hyperlinks all begin with \\WESERVER\Data2\Projects\Projects\Access DB Project\MSDS\docname.pdf I've created the query that will provide the appropriate list of hyperlinks, and...
  15. M

    Run Query from Form with Combo Boxes

    I solved this! Just in case this will help anyone else, here's what I did. In the query, I set the Criteria for the field in question (in my case, the field was StoreKey) to [Forms]![frmChooseStore].cboStore [frmChooseStore] is the name of the form that contains the combo box with the...
  16. M

    Run Query from Form with Combo Boxes

    I have a form with combo boxes that works beautifully, but I've been asked to add another feature to it. It requires adding a button that runs a query and displays the query results on the screen. The query code is: SELECT DISTINCT Product.MSDS FROM Product INNER JOIN tblStoreProducts ON...
  17. M

    Update Query using matching criteria from 2 tables

    Hi all. I think I am confusing myself; it seems to me this should be an easy query to create, but then I second-guess myself and now I'm all messed up. I have 2 tables that must be involved in this query. Both have the same fields; one is a temporary table created from an Excel import which...
  18. M

    Can't add or change data - HELP!!!

    Yesterday, I finally found and eliminated all duplicate entries in my tblStoreProducts table, so that I could create a 2-field Index called UniqueProduct that would prevent duplicate entries. Without it, uploading information from Excel (not the preferred method) would result in duplicated...
  19. M

    Query to delete duplicates?

    When I created a Totals query last night, it ran for 2 hours before I finally left for the night and came in this morning with the results up. I have no idea how long it actually ran. Is there a way to make it more time-effective? Thanks for confirming a thought that I had...just make a new...
  20. M

    Query to delete duplicates?

    Does using the HAVING Count(*) > 1 line mean that the products that already have only 1 entry per store will be left out? What is the next step after running this query, to delete the extra records so I'm left with one of each ProductKey/StoreKey combination?
Top Bottom