Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ccepaulb

    Import data into table from Excel using command button

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

    CheckBox Function In Queries

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

    CheckBox Function In Queries

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

    CheckBox Function In Queries

    Wow! Seems a lot more complicated than I had hoped! Thanks, Paul
  5. ccepaulb

    CheckBox Function In Queries

    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"...
  6. ccepaulb

    Excel Worksheet Print Order

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

    Excel Multi-user problem

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

    Excel VLookup Question

    Huh??
  9. ccepaulb

    Excel VLookup Question

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

    Excel VLookup Question

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

    Excel VLookup Question

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

    Excel VLookup Question

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

    Excel Lookup Question

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

    Excel Lookup Question

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

    Excel VLookup Question

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

    Excel VLookup Question

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

    Excel VLookup Question

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

    Combo Box Duplicates and linking to text box

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

    Combo Box Duplicates and linking to text box

    I already have a primary key on a unique ID. I also did pick the third option, still not working right??? -Paul
  20. ccepaulb

    Combo Box Duplicates and linking to text box

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

Part and Inventory Search

Back
Top