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...
Jeff,
I received your suggestion via e-mail and it works perfectly...Thank you!!!
For anyone that may be interested, here is how Jeff solved my problem.
He wrote this code and associated with "click" on a button on the form next tot he check boxes.
Private Sub cmdRun_Click()
Dim...
Here is the SQL of my query if anyone can help with how to build in a way to have a check box from a form dictate which field to show in the query output.
Thanks, Paul
SELECT DISTINCTROW [CORE TABLE].CATEGORY, [CORE TABLE].SEGMENT, [CORE TABLE].[SUB SEGMENT], [CORE TABLE].CORE_UPC, [CORE...
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...
OK it's me again. Sorry to be such a pain but I can't get the advanced filter option to work, Excel keeps blowing up on me?
I used Advanced Filter, set my data and then set my criteria based on the drop down selection, it appears to run right, but then shuts down???
Also, how would I (assuming...
That is how I will do it, thanks for the idea.
I would like to also play around with the MS Query idea, anyone know how to set an Excel cell as criteria?
Thanks, Paul
Because I have a front end that I need to work with that is pretty limited in size and how much I can manipulate.
Also, the filter function is too raw for the application I am making, need something with a little more Wow! to it.
Thanks, Paul
Thanks guys I appreciate your help, probably a good way to go but I was hoping to find a way to do this without using Pivots. I know there has got to be a way to list out the relevant rows based on a selection form a drop down control without using filters or Pivot tables
Thank you, Paul
I tried MS Query, but struggled with assigning the criteria. How would I link it to a cell or drop down control?
I also was confused as to how to update the query, it seemed a little different than Access
Thanks, Paul
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 can try pivot tables, but in the past I struggled with them because of how it shows data. Let's say all I want to do is show a value from my data, PTables limit the way I can see them to Sum..count...avg...ect. Is there an option that will just pull in that particular value without summing...
Could I maybe use the MS Query function and set the criteria for Retailer to link to an Excel Cell?
I tried to set the criteria to a cell or control (like I would in Access) but I can't get it to work.
Not sure which route to take?
Thanks, Paul
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...
The Zip file appears to be empty?
I did get it to work, I actually had to take out the primary key field, I had to use the group by function in the query behind the combo box to remove my duplicate descriptions to be listed, problem was that when I did that, it was grouping on the ID filed as...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.