How to create 3 axes chart based on three series of data
Hello all. is it possible to have mulitple tags on controls? I am attempting
to hide/show certain controls based upon a selection, and i figured out I
need more than one option.
AFAIK a control can have just one Tag, although you can change a Tag
programatically. However, there may be other ways to achieve what you want
to do, depending on the details. For instance, you could have the code look
at the first or last character in a tag, or its length, or the name of the
>Hello all. is it possible to have mulitple tags on controls? ...How can I merge all my emails in outlook
How can I merge all my emails in outlook
On Fri, 9 Apr 2010 21:31:02 -0700, Gaston <Gaston@discussions.microsoft.com>
>How can I merge all my emails in outlook
Please ask in an Outlook forum. This group is for a different program,
Microsoft Access. The webpage can be confusing and may have misled you.
John W. Vinson [MVP]
"Gaston" <Gaston@discussions.microsoft.com> wrote in message
> How can I merge all my emails in outlook
...Merge Date Field
Can anybody tell me if it is possible to force a date merge field to display
the UK day/month/year format in Publisher 2003?
Its not the same as Word where you can display the field codes and force it
to show the required format.
Su <Su@discussions.microsoft.com> was very recently heard to utter:
> Can anybody tell me if it is possible to force a date merge field to
> display the UK day/month/year format in Publisher 2003?
> Its not the same as Word where you can display the field codes and
> force it to show the required format.
Is the date format s...merging the values of a field in a subreport
helloi am trying to prepare route cards for travels. I am preparing theseroute cards in an access reports. the route points, the stops oftravel, has been provided in a routeno-stop table. I am trying tomerge the values for a particular travel. for example, the table is asfollowsroute no: stops1 museum1 sports centre1 tennis court2 zoo2 city hallwhat i want is merging these values asfor 1: museum-sports centre-tennis courtfor2 : zoo-city hallis it possible and how?...Unable to record macro
When recording a macro an 'Unable to record' message appears when I try to
record a formula. Here is the formula that seems to cause the problem:
Anyone know why this should happen?
Thanking you in advance.
Sorry that is a typo error, even with the correction the error message still
"PC" <p...Sending multiple files in multiple mails at once
The situation is the following: I have a ZIP which is to large to send by
mail in once and FTP is in this case no option.
So I remade the ZIP out of 5MB portions, ending with a large number of ZIP
Now I looking at a way to get the files send one by one, in single mail
massages, but I don't want to make each mail one by one. Does any one knows
a program for example, where you choose the file, set the recipients address
and maybe more and then hit a button and . their all gone.
Anyone any idea how to do this?
Thanks in advance.
...outlook multiple e-mail selections
Within the past week, selecting multiple e-mails, deleting
multiple spam messages for instance, works differently
than before. Multiple selections now cause the selected
items to flicker rapidly and the cursor to turn into a two
headed spinning arrow while Outlook appears to process
each message in some fashion. This didn't use to happen.
Does anyone have any idea of how to fix this annoying
...money2003 merge files
Is there a way to merge two money files (.mny)into one?
"daveb" <email@example.com> wrote in message
> Is there a way to merge two money files (.mny)into one?
...Mail Merge and Access format of telephone number
I use mail merge for a directory using Access for my data. The telephone
numbers that are formatted in Access (555) 642-5555 aren't retained but come
in to merge as 555642555 so I have to go to each one and put in the (xxx)
666-666. Is there anything I can do to retain the Access format of the tele
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"terry50" <firstname.lastname@example.org> wrote in message
news:12784D...Update one text box based on another text box
I'm using Access 2007.
I have three date fields we use for follow up:
Then I have a text box I've named Status and a check box I've named Not
The idea is for us to enter a date in FU1 after the first follow up is
completed. Once the date is entered in FU1, the Status text box is updated to
read "First Follow Up". Same goes for FU2 and FU3.
If the Not Interested check box is checked off, the Status is updated to "Not
Interested". This all works.
My problem is if any of the dates are removed from any of the follow up date...How do you merge fields in a Publisher post card?
I am trying to print post cards to my students...4 per page. However, it
seems I am only to insert or merge their names and addresses using Microsoft
Word. My post cards in Publisher print 4 per page to the same student.
When you merge postcards there can only be one card on the screen. If you are looking
at print preview, it will reflect the same data on each card, this is a bug.
Mary Sauer MSFT MVP
"B C-ing 4 D Solution! �" <B C-ing 4 D Solution! �@discussions.microsoft.com> wrote
...Adding numbers from multiple worksheets using same format
Hi, I have a question about using Excel to add data from multiple
worksheets. I am a salesman and have a daily report I have to email in
(using an Excel worksheet) each night. The form is set up to hold one
pay period of data (or two consecutive weeks, Mon. through Sat.) The
form is set up to add the daily numbers for a given set of categories
on a weekly basis. There is a place for the sum of each category for
week 1 of the pay period and a place for the sum of each category for
week 2 of the pay period. Then there is a place where the totals for
both weeks are added together for the grand to...Spellcheck only current record
I am using the following AfterUpdate code when exiting a text box named
Private Sub Narrative_AfterUpdate()
For Each ctl In Me.Controls
If ctl.Name = "Narrative" Then
ctl.Enabled = True
If ctl.ControlType = acTextBox Then ctl.Enabled = False
For Each ctl In Me.Controls
If ctl.ControlType = acTextBox Then ctl.En...Getting CRM fields into outlook contacts?
Can someone point me to how to get one of my CRM fields (parent account) to
show up in outlook contacts. I know that in outlook I have to customize
current view and add the fields, just am not sure how I get that field to
show up from CRM. Thanks.
...Creating Lookup Field Between Two Tables
I have a main table with about 5000 records of companies I may want to do
business with. Now I've created another table showing the differences in the
business practices of the companies. I'd like to be able to lookup the
company name and information in table one by ID number rather than retype it
for table two. I know there is a way to create a lookup table in table two
in order to look it up and select the applicable ID number but I've tried
using the Wizard and I'm getting nowhere. HELP! Thanks, Ron
You need to create forms based on your table(s) or quer...Merged letter and made changes to merged letters. Final merged doc
Merged letter and made changes to merged letters. Final merged document has
date in field code and atty wants to change it from Jan 5 to Jan 4. She does
search and replace but the date automatically updates on print, even if we
change that setting.
"Serena K." wrote:
> Merged letter and made changes to merged letters. Final merged document has
> date in field code and atty wants to change it from Jan 5 to Jan 4. She does
> search and replace but the date automatically updates on print, even if we
> change that setting.
>...Merging a CSV and XLS file automatically
I have a csv fles on the network derive that is being updated every night.
I need to automatically put the CSV data into the first worksheet of another
XLS file and make it available for users.
I can have a scheduled task runs and merge the CSV into the XLS file.
What would be the easiest/automated way to do that?
Sounds like you need an auto_open macro in your workbook which you are
opening as a scheduled task.
Research Scientist with many years of spreadsheet development experience
In almost all the samples to create multiple views, there are some codes
UINT temp = ::GetWindowLong(pActiveView->m_hWnd, GWL_ID);
::SetWindowLong(pNewView->m_hWnd, GWL_ID, temp);
what's is GWL_ID, what's the purpose of the above codes?
Do I have to hook the newly created view to document?
Patrick Zou wrote:
> In almost all the samples to create multiple views, there are some codes
> UINT temp = ::GetWindowLong(pActiveView->m_hWnd, GWL_ID)...Displaying Access Database Remotely for Multiple Users
I've designed an Access database and I want to be able to hold it centrally
on my company's network so that multiple users can operate it at the same
How can I go about this...?? What's the easiest way, even if you can just
point me in the right direction...
If you going to deploy the application to your local area network, then the
suggested approach is to split you database, and then install ms-access +
the front end part on EACH computer.
I explain in detail this splitting process here:
http://www.members.shaw.ca/AlbertKallal/Articles/split/in...publisher printing wiht mail merge
I am having trouble printing a postcard in Publisher. I
am using mail merge to insert names on one side, and
address on side two. It currently prints page one, then
immediately page 2.I do not have time to change the
paper.So, I followed the directions online to make two
separate files..one for page one, and one for page two,
print one...reverse the paper, print two. The problem
then is the names do not print in the correct order. It
is not the order of the pages that prints incorrectly, it
is the names in the greeting line on the front of the
postcard do not match up with the name ...Can I merge 2 Profiles files into one?
I recently changed an email account and set up a new Profile. I'm using
Outlook 2003. This has caused complications and I'd like to now combine all
past emails into one profile, preferably into one of the existing profiles
and continue to use just that. Is this possible to do?
You can either import the mail from the second pst or use File, Open,
Outlook data file and move or copy it - or use two psts. Search for *.pst to
locate the second file.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickSt...multiple page fields in a pivot tanle
I am trying to have a pivot table react to a change in this dropdown
box. The user clicks on 2 groups of option buttons first but after the
code gets to this line "pfTYPE.CurrentPage = strPI(1)", it won't go any
further. This changes the first page field but won't go beyond this.
What am I doing wrong ?
Dim pt As PivotTable
Dim pfTYPE As PivotField
Dim pfRIM As PivotField
Dim pfSIZE As PivotField
Dim pi As PivotItem
Dim strPI(1 To 3) As String
Dim i As Integer
Set pt = ActiveSheet.PivotTables(1)
Set pfTYPE = pt.PivotFields("TYPE")
Set pfRI...How do I record this special transaction: Vodaphone
I own some Vodaphone ADRs. In July they made a mandatory exchange - sadly
using the same stock symbol. They exchanged .87 shares for every 1 share.
I am using Money 2004 (standard) - how do I record this transaction?
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in th...Help: Multiple Transactions for Multiple Accounts
I am attempting to use excel to manage my commission income.
My goal is to track my commissions to make sure I get paid for m
sales. If my commission pay is overdue I must chase it down or los
I have a large number of clients (500 clients)
I have a spreadsheet for each client as each client has their ow
UNIQUE commission structure.
When I make a sale, the client sheet calculates the expected commissio
Every week I receive a commission report that breaks down th
commissions I have received for that week. (I simply add them into th
"yearly commission activi...