Search results for query: *

Worked like a charm. Thanks!

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

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

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

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

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

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

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

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

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

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!

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

Thanks for your help. This worked like a charm!

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

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

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

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

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

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

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?