Search results

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

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

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

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

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

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

I have a problem that was caused by bad database architecture. I didn't know I could set a unique key that was a combination of 2 non-unique fields. I know that now. Now I have a table with 1.3 million records. The true size of the table should be about one-tenth of that. I believe the...

Hi all. I would like some help in solving a problem. I have a main menu that uses 2 combo boxes to choose a company, then a specific store within that company, to manipulate store information and print store-specific reports. The client would like me to add a button with an "on click"...

I have a 3-page report, with a 3-page sub-report embedded at the end. They are linked (thank you to the people who suggested that). The report is called from a button on a menu, which runs 3 queries creates a temporary table. The menu also limits the reports to the chosen store, returning an...

I have what I hope is a simple question. I have a report that is mostly hard-coded (wish I could do it in Microsoft Word instead), with information from the database determining which of 2 graphics for checkboxes is printed. It's a 6-page report printed landscape, but Access will only allow me...

Hello all! I thought I was done with this project...just a few housekeeping things. I have a report that is grouped by Hazard Class. Each class begins on a new page. I have it numbering pages "Page n of nn" in the footer, and it's working fine...except for the last hazard class. It's throwing...

I've created a report (thank you for the help on the Modules & VBA forum!) that is 6 pages long. I had to actually create all 6 pages by hand (it's a government report and a long story). The problem is, Access 2010 won't let me create a report "longer" than 22 inches. I need a report that is 51...

Hi all. I'm creating a report that has to display 1 of 2 different pictures depending on the value in a table created from a MakeTable query formed from a Crosstab query. Clear as mud? There are dozens of possible Hazard Classes (44 to be exact), but most stores will only use about 10...

I'm generating a report with several fields that need to be able to display the appropriate graphic depending on conditions. What's the best way to do this? Do I create an OLE object in the report and code If/Then statements behind it, with a default graphic? It's basically "Have amounts that...