Linking 2 workbooks
What is the formula/procedure to link an entry in a Source workbook to an
identified name in another workbook? Example: Sam makes numerous donations
over time that are entered into the main spreadsheet. Entry of a given
donation should automatically appear as a separate entry in his own
...2 different Deleted Items folders??
Decided to try Outlook after years with OE. Set up email and news accounts.
Imported messages from OE.
When I open Outlook, show Folders, I see Outlook Today - [Personal Folders],
Deleted Items, Inbox, etc.
I emptied the Deleted Items folder.
Then, View, Goto, News, show Folders, I see Outlook Newsreader, Local
Folders, then most of the same folders that I see under Personal Folders in
the Outlook window, including another Deleted Items folder, and this one
Where did I go wrong?
The Outlook Newsreader is actually Outlook Express which maintains its own
folder...MS Money small business for Canada #2
I would like to purchase MS Money small business to handle my company
accountings. I am located in Canada and was wondering how flexible this
product is to be customized for Canadian Tax system and payroll rules.
In microsoft.public.money, Alex wrote:
>I would like to purchase MS Money small business to handle my company
>accountings. I am located in Canada and was wondering how flexible this
>product is to be customized for Canadian Tax system and payroll rules.
The last such product was Money 2000.
Today only Standard is available for Canada.
Th...get number of monday, tuesday,... between 2 dates
Hi, how can I get number of monday, tuesday,... between 2 dates?
Racsus (Racsus@discussions.microsoft.com) writes:
> Hi, how can I get number of monday, tuesday,... between 2 dates?
DECLARE @offset int,
SELECT @day = 'Tuesday'
SELECT @offset = CASE @day
WHEN 'Monday' THEN 1
WHEN 'Tuesday' THEN 2
WHEN 'Mittwoch' THEN 3
WHEN 'Thursday' THEN 4
WHEN 'Friday' THEN 5
...Excel 2002 Create Workbook (merge/reformat)?
I have 12 seperate spreadsheets I want to combine into 1 workbook (12 tabs).
Any other alternative ways to do this other than copy and paste? Need to
reformat "most" of the worksheets, I assume this can be done if all 12 tabs
are selected. I may have to do this several times otherwise I would just
copy and paste. Each spreadsheet has an average of 3k-4k transactions.
You can open the workbook, ctrl-click on the worksheet tab and drag that
worksheet into another workbook.
(Then close that "sending" workbook and open the next...)
> I have 1...MSPOS 2.0
To change the behavior of the screen's min/max buttons one must enable it
through the POS View. Need to be able to set this in Manager View also for
non-POS machines without having to hack the database.
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 the message pane.
http://www.m...Auto Format #2
Can't find Auto Format, did excel 2007 decide not to have this function, is
there a similiar function to be used instead of autoformat?
If you want to select a formatting for your table select Format as Table in
the Home Tab of the Ribbon. I believe that is the replacement for the Auto
Format command in the previous versions of Microsoft Excel.
Hope this Helps!
Chester C. Coronel
Junior BSIT Student
University of Asia and the Pacific, Philippines
Read the StudentEmpowered Blog!http://msforums.ph/blogs/chestercoronel
> Can't find Auto F...If I buy and reinstall the download of office 2008 Stu.Teach from this website will i lose all my papers and documents and ppts?
Operating System: Mac OS X 10.5 (Leopard)
I need to do this asap. I cant find my product key and i dont have time to look for it. I am livid but now is not the time to deal with it. I have a deadline of tonight for a major assignment and need to know that what I have already wont be lost when i purchase and download microsoft office from this website. Please anyone help me, a fast response is needed and appreciated.
> I need to do this asap. I cant find my product key and i dont have
> time to look for it. I am livid but ...CListCtrl and paging???
I know CListCtrl can display items per page, for instance if table contains
1 millions records or 10. for display items from that table we should divide
all items per pages and display that pages in CListCtrl.
Question: how to do this - I mean API. If somebody have source - send me pl.
I'm not sure what you are asking, but a virtual list control sounds like a
"Nothing" <Vinnitsky@msn.com> wrote in message
> hi anybody
> I know CListCtrl can display items per page, for instance if tabl...Reinstall Publisher 2002
Due to drive limitations, had to install new drive. Reinstalled Windows
XP/SP2 and Office XP/SP3.
1) Can I either run Publisher 2002 directly from the disc, or install on an
external USB drive to conserve C drive space? or must I do a reinstall on C?
2) If I do install on C, can I later remove using Add/Remove and then later
I don't think you can completely run Publisher from the disk. I could be
wrong but I think those days are pretty much gone. I don't think installing
it on a removable drive will work either. Same caveat as before.
If you install/uninstall/re...Using Excel 2000 as Data source for Word 2000 document
Problem using Mail Merge using Word 2000 & Excel 2000.
After numerous problems - Word failed to connect to Data Souce file then it
would & then it wouldn't and so on - reasons which are unknown!
The 106 records in 19 fields from the Excel Data Source are only
transferring the information for the first 104 records.
I am looking to add further records but obviously need to overcome this
Obvious, perhaps, but are you certain that the records are in consecutive
rows & no vacant columns separating the fields of data? Does the data range
contain any Merge...extra blan page
I have a report and set footer force new page after section.
The report always has one extra blank page at the end, since force new
page after section.
Are there any way to eliminate the extra blank page at the end of
report when the report force new page after footer section set?
Your information is great appreciated,
I have a report and set footer force new page after section.
>The report always has one extra blank page at the end, since force new
>page after section.
>Are there any way to eliminate the extra blank page at the end of
I have uninstalled publisher 2002, and i am now looking
for a way to free up the 399MB of HD space that publisher
used. How do I do this?
Do a defrag
"John Marmolejo" <Daphatom@hotmail.com> wrote in message
> I have uninstalled publisher 2002, and i am now looking
> for a way to free up the 399MB of HD space that publisher
> used. How do I do this?
If you uninstalled Publisher 2002 you have that free space available - NOW.
The US should free all those
illegally held prisoners they are
torturing, abusing and ...Tax details on Order/Invoice document printout
Does anyone know how to show the all the Tax detail IDs from the Tax
Summary entry screen on the SOP documents report, i.e. SOP Short Order
Your help would be much appreciated.
Unfortunately I don't see a good way to do this.
For this, you have a 1-m releationship between the sop document and the
details. GP only allows you to have only one 1-m relationships on a report
and you already have this: the line items. So I guess you could remove the
line items of the report but that probably isn't what you were shooting for.
About the only other thing I can ...Fix Publisher printing failure
I hope the deficiency in Publisher 2003, referred to in the following
exchange of posts, will be remedied promptly. Or is it just a turf war
between Microsoft and HP, conducted at both your customers' expense??
The text of the earlier posts follows:
#1: I am trying to print a brochure with a four-way bleed. I set up for
borderless printing on glossy brochure paper, but the program keeps
defaulting to regular 8.5X11" letter paper and leaving a 3/4" white border.
In 'page setup' under printer properties, I call for 8.5X11" borderless
paper size, bor...Unable to send emails #2
My mail server is not sending out emails. When I perform an NSLookup on the
server's IP address I get an UNKNOWN for the server name.
Any ideas would be appreciated.
"TPSchaefer" <TPSchaefer@hotmail.com> wrote:
>My mail server is not sending out emails. When I perform an NSLookup on the
>server's IP address I get an UNKNOWN for the server name.
>Any ideas would be appreciated.
Fix your DNS or your network connection to your DNS.
MCSE+I, Exchange MVP
MS Exchange FAQ at http://www.swinc.com/resource/exch_faq.htm
I have...XML ASP.NET 2.o Issue
I have the following code and I'm using News.xsl to read the XML file -
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
THIS PAST (myXml.Document) IS NOT WORKING IN ASP.NET 2.0
myXml.Document = getXML(nSource.SelectedItem.Value)
Function getXML(ByVal sourceFile As String)
Dim myRequest As System.Net.WebRequest =
System.Net.WebRequest....ms pos 1.2 weird word jumble
Store Operations Manager was not working, so I did a repair install.
After the repair, the wrong phrases were in the wrong spot. For example,
instead of cancel it says "category code" and instead of file it says
"Filter:" Does anyone has an idea how to fix this?
I took a screenshot of the home screen so you can see the weirdness for
Newsgroup Access Courtesy http://www.rockryno.com/
Tax and Account...Budget error in Money 2002
I am experiencing a budget error in Money 2002 for which
I can find no Knowledge Base article. Has anyone else
experienced this problem?
I have two annual expenses of $8.50 each for dog
licensing. Money somehow absurdly calculates this to be
a $9.21 monthly expense, which makes the budget feature,
naturally, useless. There is no way to work around it
that I can see.
...How do I create a 46 page member directory?
I was wondering if publisher can create a membership directory that would be
46 pages in length? The front of the handbook would be the names/adresses and
so forth and the back part would be images of each businesses business card.
Is publisher the right software for this? I was volunteered for this job, so
any help would be most helpful!
I'd use Publisher if I was doing that job.
MVP Microsoft [Publisher]
"Bryan" <Bryan @discussions.microsoft.com> wrote in message
>I wa...auto display names sent
When I send a message it will only keep the name for auto populating for
about a week. How do I change that setting?
WYSIWYG. Autocomplete for TO line will only offer the last 29 contacts
you'd entered. There are no plans to fix this or any other bug.
> When I send a message it will only keep the name for auto populating for
> about a week. How do I change that setting?
Windows Mail auto-completes from a separate list of 29 addresses you type
in, not from your contacts. This list is stored in the registry.
If you wish to remove old or incorrect ad...Sent Items CRM 3.0
If I am standing on an Account in CRM 3.0 and sending an email to the
account. An activity will be created in the history field but no mail will be
saved in the SentItems folder in the Outlook Client. Does anyone now why?
Unfortunately it just doesn't do this. The CRM Web application has no
knowledge of your Outlook client
David Jennaway - Microsoft Dynamics CRM MVP
> If I am standing on an Account in CRM 3.0 and sending an email to the
> account. An activity will be created in the history field but no mail will ...Each new window showing up in start bar--want to turn this off
I'm a new user to Outlook. Everytime I open a new email it puts a new item
on my Start bar. Now my Start bar is cluttered because I have more than one
message open at once. Where is the option to change this?
"pickytweety" <firstname.lastname@example.org> wrote in message
> I'm a new user to Outlook. Everytime I open a new email it puts a new item
> on my Start bar. Now my Start bar is cluttered because I have more than one
> message open at once. Where is the...How do I Insert 2C Mac EPS file into Publisher ?
In commercial printing we get a lot of logo's and other art that is created
as a Mac EPS and I cannot seem to insert it into Publisher. What are the
correct steps for doing this and for it to display.
According to Pub 2003, you need a graphics filter to insert .eps files. The
following is copied directly from the Help file:
The Encapsulated PostScript (EPS) graphics filter (Epsimp32.flt) supports
the Adobe Systems Encapsulated PostScript Specification versions 3.0 and
earlier. The filter supports .eps images from Tagged Image File Format
(.tif, .tiff) (Tagged Image File Format (TIF...Page No display
How to insert page no in a particular cells.
I had tried with Header option in Print Preview menu, but after
applying the same , Page no is not exactly comes in particular
cells,either it may displayed above or below the cells.
NITESH G's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17590
View this thread: http://www.excelforum.com/showthread.php?threadid=497514