Search results

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

I tried that. I'm getting the following error: Wrong # of arguments or invalid property assignment.

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

Welcome, Karen! I, too, am from Texas, and found this forum when I was hired to create an application for "non-Access" users. My skill set was about what yours is, it sounds like. This forum is wonderful! I have gotten a lot of help here. Here's a tip...don't make your initial question too...

Thank you. It was because I was relying on the code for each field and hadn't named a source for the reports in general. They are now bound nicely. I'm having one issue still involving the sub-report. The store address, city, state, zip are printing nicely now on the last page of the report...

I'm not sure how to link the subreport to the report? It's saying I can't do it. It says "Can't build a link between unbound forms."

It's saying I can't build a link between unbound forms? The subform is embedded in the main form...so why is it saying that?

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

Oh...and I haven't written the part yet that will clear the table and re-generate it for every report; that's on my "to do" list. I first needed to get the pictures generated correctly (done) and then ran into the error caused by these hazard classes not being in the table. Thank you so much!

Cheryl, The hazard classes are government-created, so unless the government changes something they'll stay the same. This is all HazMat-driven, and we have some MSDS sheets going back to the 1990s that have the same hazard classifications, so I think we're pretty safe. Thank you!

That's correct...the only columns that exist are for hazard classes in a particular store. Yes, the code bombs...which is why I'm commenting out the ones that I know don't exist in any of this company's stores. They are actively seeking new customers, though, and I'm not a permanent employee so...

Oops...the code didn't fully copy. Here it is again: Option Compare Database Option Explicit Public Function DisplayImage(ctlImageControl As Control, strImagePath As Variant) As String On Error GoTo Err_DisplayImage Dim strResult As String Dim strDatabasePath As String Dim intSlashLocation As...

Stand-Alone Module I also created a module as follows: Option Compare Database Option Explicit Public Function DisplayImage(ctlImageControl As Control, strImagePath As Variant) As String On Error GoTo Err_DisplayImage Dim strResult As String Dim strDatabasePath As String Dim...

That query gives me every single individual product in every store, grouped by the storekey/storename first, then by hazardclass within the store. It displays the QOH for each product that was calculated by the QuantityOnHandQuery. The information is used in the HmisReport that you helped me...

The process begins with the following query: [code] SELECT tblStoreInformation.StoreKey, tblStoreInformation.StoreName, qryProductsInStoreAisles.AisleNumber, tblHazardClass.HazardClass, Product.ProductName, Product.Chemical, Product.ChemicalAbstract, Product.PhysicalState...

Hi Cheryl. This pretty complicated. I'm attaching a copy of the report so far The code for this report so far is: [code] Option Compare Database Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim rsHazards As DAO.Recordset Set rsHazards =...

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