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 derfloh 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: *

  • Users: JoeF
  • Order by date
  1. JoeF

    Need To Remove Characters after "?" in URL

    Worked like a charm. Thanks!
  2. JoeF

    Need To Remove Characters after "?" in URL

    I have imported a list of urls with several other fields i need to analyze, but I need to cut the characters after the "?" out of the URL field. I was going to use a replace() formula to remove everything after the question mark, but i have no way of telling the formula what character to...
  3. JoeF

    Macro to Filter Items in a Pivot Table

    Unfortunately,the screenupdateing code didn't do anything in this case. If it was fast to do it manually, i wouldn't have bothered with the macro in the first place... unfortunatley, it isn't. I have lists of thousands of records to scroll through and many of the records begin with numerics...
  4. JoeF

    Link data to another Excel file excluding blanks

    I'm not a programmer, but I have some suggestions. I'm not sure what type of formulas you are using or how you are linking, but if your chart is picking up the blanks, are you sure they are truly blanks? It might look like the cell is blank, but you could still have space characters or other...
  5. JoeF

    Macro to Filter Items in a Pivot Table

    I don't think i was clear on what the issue is. It's not that i have a list of items i need to filter all at once. The problem is that the macro takes a very long time to filter just one record. This is because the data array upon which my pivot table is based, has thousands of diffrent...
  6. JoeF

    Macro to Filter Items in a Pivot Table

    Actually, one of the feilds that I want to filter has hundreds of records in it and takes over 60 seconds to run. If i use it 30 times, I have waited close to an hour combined for the macros to run. If you have any quicker solutions for that, I'm all ears. The previous solution is perfect...
  7. JoeF

    Macro to Filter Items in a Pivot Table

    Hey Skip, That worked great. My only issue is that there are a lot of records and the pivot table actually changes for each record that gets a true or false argument, instead of applying them all at once. This takes some time. I cut the time in half though by using ClearAllFilters instead of...
  8. JoeF

    Macro to Filter Items in a Pivot Table

    I'm trying to write a macro that filters a record in a pivot table. The only way i can figre to do it is to list each and every item and make their visibility false. This would be o, if the data wasn't always changing. I would need to change the macro code every time new records are added to...
  9. JoeF

    Share Custom Menus in Excel

    Older versions of Excel used to let you create a menu in a file and the menu would only be available in that file. Also, anyone who opened that file would have your custom menu available when they opened that file. The new versions of Excel save menu settings in Excel.xlb, so your menu bar is...
  10. JoeF

    Grouping in Access

    I have had a similar problem. I wanted to get the top 3 or 4 records by a grouping, but I had to write several queries to do that. Run a query taking the max by grouping to get the top record and create a variable that says "top record", then Run a second query with the top record...
  11. JoeF

    How Do I Pageby Groups in Access Reports

    That was my problem. I typed "Page Break" into the help menu and it didn't show me anything. I didn't realize that the page break command was right in the tool box, I never even noticed it before!! Thanks!
  12. JoeF

    How Do I Pageby Groups in Access Reports

    I have an Access report that is grouped by the categories within my company. I need to have each category distributed to a different person in the company, but I can't figure out a way to put page breaks between the categories. Even when I use the "Keep Together - Whole Group" or...
  13. JoeF

    Can I run a report or query on unlinked tables

    Thanks for your help. This worked like a charm!
  14. JoeF

    Can I run a report or query on unlinked tables

    Yes, most of the fields are similar. I'll give this a shot. I have never worked with a union query and I have very little SQL experience, but the code seems simple enough. I think I'll create a query off the import table where I include the desired fields and make sure the fieldnames are...
  15. JoeF

    Can I run a report or query on unlinked tables

    I imported data into table in my database of planned products and thier projected sales. I didn't want to import the data into my current product table because a lot of info is missing on these new products and some of them may not end up being sold by my company. Is there any way for me to...
  16. JoeF

    Can't have multiple users when any object is in design view

    Is it possible to have multiple users in a database when someone is creating/editing an object such as a report or a query? When I am creating a report and someone else from my group tries to get into the database, it says that I have it "locked." Or if two of us are in a database at...
  17. JoeF

    Add a menu item for a macro - In a file

    Donna, in Excel XP, there is no "save in" dropdown in the under tools - customize - Commands. Does anyone know how to do this on Excel 2000 or XP? Maybe it's no longer an option to cusomize the toolbar for a file????????
  18. JoeF

    Add a menu item for a macro - In a file

    I need to know how to add a menu item that can run a macro, but the menu item has to be attached to the file. This way, when someone else opens the file, they too will have the menu option to run the macro. Also, when the file is closed, the menu option goes away. In Excel 7.0, you just had...
  19. JoeF

    Debug Window

    I used to go into view Debug Window in the older version of Access, but I can't find this in the new version of Access. Does such a thing exist? I want to test the following: Public Function PRICE_RANGE(PRICE) 'TAKES A PRICE AND CATEGORIZES IT IN ONE OF THE FOLLOWING RANGES. Dim PRICE If PRICE...
  20. JoeF

    Debug Window in XP

    I just switched from Office 7.0 at work. In the old version of access, I used to be able to go into the view menu and choose View Debug Window in order to test any user defined functions I created in visual basic. Where is this window in XP?

Part and Inventory Search

Back
Top