Recent content by MarcieFess

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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