Change Y-axis tick labels to text, possible?
Suppose one has data scored from 0 to 5 for 3 variables and the
corresponding bar chart's Y-axis has 6 tick labels 0 1 2 3 4 5 running
along the Y-axis. It it possible to change these tick labels to text (say,
Strongly Disagree, Disagree, Neutral, etc)? I noticed that if one copies a
chart into powerpoint and then 'ungroups' the elements of the chart, the
Y-axis tick labels can be changed, but it doesn't seem possible within excel
(nb: I want to write a macro within excel to perform this task).
Thanks for any advice.
You can create your own axis label...Importing a folder of text files
I have a folder of text files (a few thousand) and I want to either
take the relevant bits of them into Access (one per record, memo
field) based on what's in the file or to import all of them into
Access and then delete the irrelevant bits.
As an example, I want to grab the data after <div
class="ext_description"> (which appears in all of the files (they were
html)) and put it into records in a table. I don't know whether to
remove the irrelevant bits from the files before or after import.
Thanks for any help you can suggest!
On Feb 24, 12:56=A0pm, Andy &...Drop down boxes #5
Could someone assist me with adding drop downs to my spreadsheet? How d
I do it
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
ntrain - See my post "Default Values" the spreadsheet there has dro
down boxes on it. Download the spreadsheet and you will be able to se
what I did. Basically for each box I created a lsit onthe second sheet
Then When I right Click on the box I got to format control, from ther
I can control the cells to be browsed for the values.
Good...Only one record shows in input form
I have created a database with Access 2003.
I imported 17 records from Excel into the products table.
When I open the input form to add new or correct the existing records,
the input form sees only one of the 17 records.
Can someone tell me why?
If it will help to look at the database, I have uploaded it to:
It is titled "trouble.mdb"
Thank you for whatever help you can give me!!
Mary Hartman <MaryHartman@smallville.og> wrote in
> Good morning,
> I h...Extender-Adding Buyer Information to POP Blank Form Header
I have added an extender window to the Buyer Maintenance window, to include
email address, phone number, fax number, etc. (Cards>Purchasing>Buyer)
I would like to print this information in the Header of the POP Purchase
Order Blank form. Can anyone give me some suggestions?
Using V9 on SQL
There is an article, KB 904575, that has pretty good directions on adding
extender fields to a report. But the article has a missing step in it. In
Calculated Field 2, there should be a step 3 just like step 3 in Calculated
Field 1, which changes the result type to string...How do I copy an Excel chart with added text boxes into Word or P.
I have created a chart in Excel and added a number of text boxes on top of
I need to paste the entire chart & text boxes into Word and/or Powerpoint;
however by selecting the chart and copying, the text boxes are excluded.
MS help suggests entering the text boxes outside the chart then moving them
into the chart and grouping the chart and text boxes; however there does not
seem to be the ability to group the chart with the text boxes.
If you had clicked on the chart before making the textboxes, all the items
would have been grouped. But you can do it later:
Hold down SHI...Pivot Table Drop Down Boxes
I want to be able to limit the drop down box content to information relevant
to what I have seleced on the page. Example: I select Region A at the page
selection, then open the District drop down box, and all districts
countrywide are shown. I only want to see Districts to choose from in Region
Excel 2003 - Windows XP
That feature isn't available in the pivot table dropdown lists.
Dave S wrote:
> I want to be able to limit the drop down box content to information relevant
> to what I have seleced on the page. Example: I select Region A at the page
> selection, then ...How to pass value from one form to another form.
I have the following code in BookList.aspx:
<form id="form1" runat="server">
<asp:GridView ID="GridView1" runat="server"
HeaderText="Accession No" />
<asp:BoundField DataField="Title" HeaderText="Title"
SortExpression="Title&qu...Urgent help: change outlook default conatct form
We added several fields to contacts in the standard form (design mode). We
want this form to become users' default conatct form. Also, old contacts are
able to launch from this new customized form. are these possible? exchange
Yes. This is possible. You need to change the form on the folder properties
and then run a program to change the IPM form used on existing items. See
the last two sections at
http://www.outlook-tips.net/beginner/publish_form.htm for details and link
to the program.
Diane Poremsky [MVP - Outlook]
...Hiding Personal Employee Information in Address Book
First off the environment is Exchange 2003 SP1 with Active Directory 2003.
Basically... our HR department was granted limited access to AD to fill in
user information (Home address, telephone, etc...) and I then modified the
default user ACL so that any member of "Group X" in AD was denied access to
seeing the above personal information. This worked on the Global Address
List as well....
But now there's a problem. We've been setting up users in Cached Mode, and
those users are able to see everything. I believe this has to do with the
fact that Exchange is generating t...Highlighting text using conditional formatting
I'm trying to highlight certain text in a list - namely all text that
end with river, stream or creek. I've been trying to use conditional
formatting but for some reason I can't seem to get it to go (I would
have thought * wildcard would have done the trick but no such luck).
Ideally you would have a different colour for rivers, creeks and
streams. The list is like this
and so on (about 3000 entries)
Any ideas about how you can do this?
Select the text ...combo boxes
Also, I just can't get my headr round combo boxes. I've always managed to
get it by faffing with the code, but every time I add a
function, I can never work out how it works, the string varialble attached
always seems to be one step behind, if you know what I mean?
Gives me NOT the item selected, but the item preivous displayed.
I've always maanged to get it right, by faffing lots with
UpdateData(TRUE)/FALSE, and but right now, I can't seem to get it right!!
Can anyone shed any light? int...Powerpoint Placeholder Text Box
I have a series of template pages with multiple text boxes. I would like all
the text boxes to auto fit consistently if one needs to. It works like that
on a two box that is in the basic package, but when I created a 3 box and a 4
box, they each auto fit based on the text in the individual box. I've tried
grouping them in slide master, and normal view. Any ideas?
...Search/Extract Data w/in Text File
Hello again! I am searching within a text file for the last row within the
file. After I locate the row I need to separate the data and place into
multiple cells on my worksheet. The code I have is as follows:
Dim TextPath As String
Dim DelimSrchChar As String
Dim METtime As String
Dim DataBuffer As Variant
Dim NCData As Variant
Dim DelimPos As Integer
DelimSrchChar = ","
TextPath = "C:\Temp\Formatted_NC_SN1008.txt"
Open TextPath For Input As #1 'open text file for SN1008
Do While Not EOF(1) ...Error upon exporting results of query to text file
Using Access 2000 and Windows XP Professional
I have a query that, when executed, returns a substantial number of
rows. This is exported to a tab delimited text file to be used in
correlation with other software. I've exported the results of the query
numerous times. Now, all of a sudden, when trying to export to a text
file, I get a "Permission denied" error with nothing more than an "OK"
What could be causing this? The only change made to the query in the
midst of all the exporting is a change in the date range criteria.
Thanks in ...Call database property in a control on a form and in my Switchboard variables
I have a database that I have developed for multiple units to use. For
reasons that I won't go into, each unit must have an individual copy
of the database to store their data. BUT the databases need to be
identical. So far, annoying, but no big deal.
Anyway, what I am doing is creating the master copy where I get it all
correct and then I will make a copy for each unit and drop their data
into it... again no big deal. BUT in order to help keep them straight,
I would like to have specific labels that refer to the database
property Title bc the DB is on a network buried in a file more the...Text From User Forms
I am creating a user form where data is entered into text
Once the operator has input data into a text box I want to
use a command button on the user form to save the file.
One text box will have a request date entered as the value
and another will have the name of the requestor as the
value. I want the command button to create the filename
as these two values.
Could someone offer some advice please.
Activeworkbook.SaveAs filename: ="C:\your path\" & Textbox1.Text & " " &
"Matt G" &l...Reference to other form elements or global variables?
I have developed a budgeting application in Access 2003. It's been steadily
growing when it comes to forms/sub forms etc. I have a main form with a
"page" object with some 8 pages. In each page there is at least one sub
form. I need values from different sub forms to be updated between pages/sub
forms when they're changed.
I keep calling "load" sub's to refresh sub forms values, but as the load
sub's are pretty heavy sometimes, it's a lot of processing for updating just
As an example, the user are allowed to enter a "t...Cancel button's ActiveControl reflects as value of text box
On my form I have an "on exit" code to test whether its text box is "empty"
or not. When I click the "Cancel" button I still get the msg that the txt box
Using Debug.print to show the Me.ActiveControl gives me the value of the
preceeding txt box.
What I'm trying to achieve is to ignore the "empty" test if cancel has been
selected by exiting the "on exit" before the msg box sub & clearly I'm
misunderstanding the usage here somewhere.
I'm a bit unclear what you want to accomplish...
...Text to Columns #4
I have a list of the Fortune 1000 companies in one cell.
Is there a way to convert this information into columns
Company City State Telephone
1 Wal-Mart Stores, Inc. Bentonville, AR 479-273-4000
2 Exxon Mobil Corporation Irving, TX 972-444-1000
3 General Motors Corporation Detroit, MI 313-556-5000
4 Ford Motor Company Dearborn, MI 800-392-3673
5 General Electric Company Fairfield, CT 203-373-2211
6 ChevronTexaco Corporation San Ramon, CA 925-842-1000
7 ConocoPhillips Houston, TX 281-293-1000
8 Citigroup Inc New York, NY 212-559-1000
9 International Business Machines Corporatio...Unable to cut text when forwarding
I have a recently new problem, when I forward a message I am unable to cut
and paste or in anyway alter the original message, I am using Outlook 2007
and it only started yesterday. Any ideas please
...publisher insists on underlining copied text ? do i remove it
I copied text from a Word Document and when it appeares in Publisher it is
always underlined and i can't seem to remove the underline. Any ideas?
Angelis <Angelis@discussions.microsoft.com> was very recently heard to
> I copied text from a Word Document and when it appeares in Publisher
> it is always underlined and i can't seem to remove the underline.
Paste Special as Unformatted Text?
Ed Bennett - MVP Microsoft Publisher
All the text? Try "paste special", unformatted text.
Mary Sauer MSFT MVP
http://msauer.m...Free Form Text Box in Report
I am running a report that runs from a Make Table Query, and then into a
cross tab query. The report is in a Switchboard and runs off of a Macro that
opens the make table, updates based off of the dates entered, closes it,
opens the cross tab. Closes it. Opens the report in print preview. I need
others to run the report with no intervention so I entered a text box (as I
have done before) into the header that reads: =[Enter Report Ending Date
mm/dd/yyy] to allow for the ending date to appear in the header. However,
this is not working. I am recieving the following error &q...How can I hide check box created via FORMS together with column?
Hey guys, how can I hide a check box created using FORMS together with column
it is placed in (or in some other way). "Move and size with cell" option is
not active in object positioning for check boxes created via FORMS as opposed
to those created via CONTROL TOOLBOX.
I think you'll have better luck (pronounced easier time!) with the checkboxes
from the Control toolbox toolbar.
But maybe you could have a macro that hides the columns/rows and also looks at
the objects to see if they should be .visible = false.
And the same kind of macro to make the checkbox...Open Form with macro and data from Selected Record
I am wanting a person to open a form, and have the subform display the
records that relate to the main form. This part works. I then have a
continuous form view for the subform and i want the user to be able to double
click on the record they see in the subform and have it pull up that record
into a blank form. I get the blank form to open up when they double click,
however I cannot get the data for that record to show up. I either get a
blank/new record or all records.
I am trying the SearchForRecord macro in an On Load Event. This loads after
the form has been opened.