Search results

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

Problem solved already. Should have Googled the issue first before posting here.

I'm working on an application using Access 2010. I'm using a split database. The back-end resides on the network. In that location, I have a sub-folder with PDF files that need to be accessed through the forms (and printed, if I can figure out how to do it in bulk through Access instead of 1 at...

Thanks Alan...I'm sure this will work! That's exactly what we need to do; there are 2 fields that will have to be changed for sure and so they don't need to be copied. Appreciate that! Thanks.

I know about database normalization. I'm not talking about having duplicate records. I'm talking about duplicating a record (these records have 25 fields of information) so that only the 2 or 3 fields that will be different have to be changed, without the user having to TYPE the information in...

I used a wizard to create a button that would supposedly copy the current record in a form to a new record. As far as I could tell, it didn't do anything. My record count didn't change. Macros crash Access, so I always convert macros to VB. I did that, and it still didn't work. I found...

I have a query, StoreAisleQuery. The query returns all products in each store with store name, aisle number, hazard class, volume of each product and other information. I used this query to create a crosstab query that would total the volume of each hazard class in each store. I see that it...

I understand what you're doing here...but I guess you don't realize that we're dealing with a large database that's divided several ways. The parameters that are passed from one form to another come from combo boxes, not user input. When the user makes a choice, the next form must present only...

Hello all. I have a query that must ORDER BY Aisle_Number I have 2 other fields that must GROUP BY for a report. The report calls the query. One field, tblStoreProduct.Storage, can be either "I" or "C". The report must start a new page for "I" and "C" in the same aisle. Another field...

My husband is a genius. He figured this out for me. It works PERFECTLY and I have incorporated it on almost every button and every form in this project! Credit must be given to Cheryl who frequents these boards (I don't want to mention her last name or user name as I don't want to violate her...

Hi. I'm almost finished with my big project! At least, the big stuff! I'm creating the menus now, soon will be modifying the back-end data tables to match the changes I've made in my test bed, and securing it all, finishing the user manual and conducting some training. My question at this...

I'll definitely do that, thanks. This has taken TOO long to let them mess it up. It solves the other issue of how to make sure they can't get to other parts that I don't want them in, too.

So, first I guess I need to determine whether I've got the tables set up correctly in the first place. The bolded fields in tblHazardClass may be unnecessary completely...when I first set up the tables, I thought I'd be referring to those totals but now it appears I may just hard code the...

My data tables: tblCompany CompanyKey CompanyName CompanyAddress CompanyPhone tblStoreInformation StoreKey StoreName (allows duplicates as more than 1 company may name their stores with the same name) StreetAddress City State Zip CompanyKey (links the Company to the Store) tblDepartment...

I'm working temp at a company; I'm here to develop an Access application. Whenever I try to go to a Macro within Access, Access stops and restarts. I thought it was a problem with the install on this computer. I recently purchased a copy of the same version (2010) to install on my laptop...

This is what that part of the report looks like: http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=45377&stc=1&d=1354315109 Additionally the report is grouped by AisleNumber...it can also be grouped by Inside/Outside (each set have to be printed separately; if there's an...

Thank you, Alan. This project is becoming intricate...and I feel like I'm drinking from a fire hose. Most of the new stuff I'm trying isn't working...I hope I begin to have success soon. They are asking me when I'll be done and I really feel like telling them "a month ago if you'd hired a...

Will this procedure work with a comboBox instead of a listBox? I've tried, using comboBoxToString where this process says listBoxToString; I'm getting a Type Mismatch error. I only want a single input-single return, and I want it to open a new form where the user can make the second...

Hi everyone. I've been on here a few weeks but I don't believe I've ever introduced myself. I'm a 50-something mom with a varied professional background. My degree is in Business Administration, which was actually a fall-back position after 2 previous degree plans and being in a private...

That's the way I have it set up in the table now. The report is a government report, so it has to be formatted their way. When the report is run, each page has to indicate the Use type: There has to be ONE check mark next to either "Open", "Closed", or "Storage" Right now I have 1 field...