Search results for query: *

I'm looking for someone to help me with a solution to my problem of importing data into a data table. What I'd like to do is have a command button on a form. When this button is clicked the records in a table are cleared out. Then I'd like for a browse window to come up to locate an Excel...

I'm looking for someone that knows how to link check boxes on a form to the "show" check-box in a query. Basically, all I'm trying to do is have the end-user tell the query which fields to show in the output. If checkbox "A" is checked on a form prior to kicking off the query, I'd like field "A"...

I'm having an unusual issue with one of my Excel documents. I have roughly 20 worksheets in an Excel file. Out of the blue, it is printing the tabs in a different order than it used to. For some reason it is printing the first two tabs at the end of the process even though they are lined up...

I have an Excel sheet I designed fo for our sales people to use. It has some VBA code written in it that will run an advanced filter function based on a users selection from a drop down box from the control toolbox. Problem is that it runs fine on my PC and runs fins on another users PC, but...

Is there a way to have Excel use a lookup function to return multiple rows based on a selection. For example vlookup will pull information based on a one record match. I would like for Excel to return multiple records (without using a pivottable, won't work for this). (example) Retailer Outlet...

I hope I can explain myself OK here. I want to create a vlookup function that will return to me all outlets that fall into a particular chain and then have the corresponding volume and sales data in the columns to the right. For example, let's say I'm working with 3 retailers (Retailer A,B and...

I have what I assume is an easy question. I have a form that needs to have a combo box and text box. What I want to do is have the combo box list our items, and the text box have our item numbers populate based upon the item description selected from the combo box. Two problems; 1) Some of our...

I have a problem here. I want to count the number of cells that meet a certain criteria. The problem is that the cells are not all immediately adjacent to each other, for example let's say I have a value in column e4,h4,i4,l4,o4 & r4. I want the formula to count how many of these selected...

I'm trying to use the "Or" function within conditional formating in Excel. I have the following in my condition: Condition 1 Formula is =OR($C9="Red Man","Red Man Golden Blend") but it isn't working right. What I want to do is have either of those values trigger the same format for the cells...

The following code is attached to a text box from which my query recieves it's criteria. The first four cases work great, the problem is that I would like for case 5 to return all records regardless of the tier value in the record. Is there a way to write a wildcard into the case 5 text box...

I have a form that has four check boxes, Tier 1, Tier 2, Tier 3 and All Outlets. Each of those checks has a value of 1,2,3 and 4 respectively. I was hoping to assign a text value to each of these checks, but it only allows a number. I have a table with 60,000+ records that contains a field...

I created an Access Report while working on another network that ran fine. We've since switched to a new location and have a new network. I went in and tried to run the report and keep getting the following error message "This document was previously formatted for the...

I have a pivot table that is embedded in one of my formatted Excel spreadsheet reports. Everything is working well, except, whenever I update the pivot table, it messes up the formatting in the cells above the table (mainly the column widths). Does anyone know how to lock the column widths on...

I want to calculate a weighted average of sales. To do this I thought I'd need to write a COUNTIF fromula that counts cells that contain values greater than or less than zero. The problem is that I can not get the formula to work. I had to write two seprate COUNTIF fromulas; one that counts the...

I have a button on an Access form that when clicked runs a macro that echoes, runs a query and maximizes the window. Now I added an option group that has two check boxes. What I want to do is, when the button is now clicked it will run either macro1 or macro2 based on which check box is...

I have a button on an Access form that when clicked runs a macro that echoes, runs a query and maximizes the window. Now I added an option group that has two check boxes. What I want to do is, when the button is now clicked it will run either macro1 or macro2 based on which check box is...

I am having trouble with one of my reports within an Access Db. For some reason it is putting a blank page in between the pages with data. The footer still has the correct number of pages, but double show up when previewed or printed. For example, if I have a 4 page report it will show 8 total...

I have a worksheet that is shared by multiple users. Since there were so many hands in the cookie jar, the formulas were getting messed up. I formatted only the cells that contain formulas to be "locked" when protected and left the rest unlocked. When I go and apply protection to the...

I have created an application in Access that will be used by multiple people within my company. What is the best way to turn off all menu bars and toolbars so the user can not monkey around with the file? I tried a number of ways, but everything seemed to be specific to "my" Access...

I have a combo box that references a data table field. Within this field I have multiple brand names in a list format. What I want the combo box to do is only show one value, instead of all of the same values within the field. for example...I may have 400 references to Brand A, 500 refs to...