Search results for query: *

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

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

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

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?

My company recently switched to Excel XP, as well as upgraded the network and the computers. While most actions are much quicker after the upgrade, there are some problems. One major problem is that since we upgraded Office, the links in Excel are much slower. Files that used to take less...

In the prior version of Excel, I could add a command to a menu in order to run a macro and the command would only be present when the file owning the macro was open. In Office XP, I can't figure out how to keep the menu item related to the file. Once I set it up, it's always there.

I created a report that has several columns of information. For example product, retail, and cost are written in the page header and the detail secion of the report contains the information. I also created a grouping header by year and placed some summary statistics there. The only problem is...

My company is switching from an old version of Office to Office XP. I have some Excel macros that go to a mainframe program on my desktop using the "AppActivate" command and then use a "SendKeys" command to enter information contained in my spreadsheet. In the old Excel...

I created a combo box that pulls "offer_year" in from a table and then runs a union query to pull in an asterisk as well. This lets me choose from any year where I have sales data available or select "*" for all years. I would like to create a second column that works off...

I have a combo box in a form in my database that links to a table with sales history. The combo box basically runs a select query off my sales history, grouping by year of sale. In this way, I am able to get a list of every year in which we have history. I want to give the user the option to...

I am trying to create an update query to update data in a table with the results of another query. I have other queries just like this that work fine, but this one is giving me an error that I am using a query that is not updatable. What could my problem, considering all the following are...

I was attempting to create a power point presentation the other day and I wanted to include some charts I had created in access reports. Is there any way to export these charts? I tried exporting to Excell and Word, but only the numerical data from the reports shows up; the charts were excluded.

I am running a report that has the following sort of layout. I am creating a report for a catologue type of business where there are several catologues sold by the company througout the year. Within each catologue there are a few different types of promotions (advertisements) used to advertise...

I am currently trying to create a database where I have information on recipes in various tables. recipe info table includes fields detailing name of the recipe, the date, type, location, etc. recipe directions table is linked to the first table in a one to one relationship and has fields for...

I set up a macro that runs a code that checks record counts for a few of my tables. It does this for 3 tables. The first two work fine, but I just added a new one that is giving me problems. When I first set up the macro, it works fine; however, when I close the database and go back into it...