How can I open a file saved in Pub 2000 version 6 in Pub 2000 ver.
The file is saved in Publisher 2000 v6 and I am trying to open it with
Publisher 2000 v9. can this be done?
Hi LaTrice (LaTrice @discussions.microsoft.com),
in the newsgroups
|| The file is saved in Publisher 2000 v6 and I am trying to open it
|| with Publisher 2000 v9. can this be done?
No. There is no such thing as Publisher 2000 v9, nor is there a version 9 of
Verify the version of Publisher that you have, and also verify the version
of Publisher that you received the file from then post back.
Microsoft Publisher MVP
http://www.publi...splitting one column into two columns ... not what you think
i have fixed column widths that can't be changed; nor can any other columns
be added to the worksheet ...
i've got data in one column that represents "results" ... within the results
column though, i need two columns (starting directly below the "results"
cell, one that reads "in range" and that other that reads "out of range" ...
if i'm on [column a] [cell 1] i want: "results" ... in [column a] [cell 2] i
want: "in range" AND "out of range" with a line down the middle. "text to
column" is ...SFO Stops working after IP Change
Last week I changed the subnet our network is one, so the IP address of
the CRM Server and Exchange server have changed.
Since then some of the users are having trouble with the Sales for
Outlook plug in. It happens on my machine as well. When I start Outlook
I get this message:
There is a problem communicating with the Microsoft CRM server. The
server might be unavailable. Try again later. If the problem persists,
contact your system administrator.
I've ...Can't use Merge feature
If I have a postcard file I've already made on the
screen, when I try to pull up the "Merge" feature under
Tools, it is shaded grey and I can't open it. It insists
that I either form a new database list of addresses or
edit the one that I want to merge. I don't want to edit
the one I want to merge. I just want to MERGE it.
If, however, I have just a postcard template on the
screen (without it having been made into anything), I CAN
pull up the "merge" feature under Tools. It is not
How do I un-shade the "merge" feature?
To merg...Finding duplicates in column
I have Excel 2002 and have 6000 emails addresses in a column.
How can I find if there are any duplicates in that column?
Assuming the data is in column A, add a formula in column B of
Cpy that down, then you can filter column B for Duplicate
Sorry to be so newby Bob, but when you say 'copy' down, what exactly do
I have entered the formula in B1 but..
Bob Phillips wrote:
> Assuming the data is in column A, add a formula in column B of
> =IF(COUNTI...Numbers in a text field-can I add them up?
Hi everyone! Using A02 on XP.
I have a table of data with survey response fields that contain a 0,1,2,3,4
or 5. However, the fields are formatted as text, not numbers. I need to add
up certain blocks (Items 1-6, Items 7-23, etc.) and then do some averaging.
I cannot change the field types from text. Must I append to a new table or
can I do something right in my query?
I've got one field in my query like this: ES:
My result is: 553453 or 554444, etc. I want: 25 or 22, etc.
I would really appreciate any help or advice. Thanks...Passing data from one form to another
Hello I have a form called frmMaindB and it has 5 text boxes on it
(txtEmployeeTime, txtDTRegular, txtDTReason1, txtDTReason2, txtDTMaintenance)
when I double click on the text box it opens up a pop up form named
frm_DecimalConversion. On this form I have two text boxes one box I enter
data into and the other calculates or converts the data to a decimal. The box
that converts the data is called txtDecimal. Then I have a close button which
I want to use to close the pop up form and insert the data into the text box
I double clicked in to get the pop up or (frm_DecimalConversion). I have r...data value in Form field if no table entry
I have a form with a field which pulls through and concentenates 2 fields
called [ContactFirstname] and [ContactLastName]from my table
There are however some customers for whom I do not have names and therefore
instead I would like Sir/Madam to appear in the field in the form
I think I have seen this done somewhere using ELSE? but can't find it
Any help/ideas gratefully received
Perhaps something like this:
Nz(Trim([ContactFirstname] & " " + [ContactLastName]), "Sir/Madam")
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access use...Change outbound server in header to fix 550 Can't verify your host name error
The headers on the outbound emails show the internal DNS name of our
exchange server; obviously this won't resolve properly at the
How/where in Exchange 5.5 can I force the IMC to use a real fqdn on
You can do this in TCP/IP properties\Advanced\DNS tab of machine. And
yes, this is not just for Exchange, so you may consider forwarding all
outgoing mail to some relay server (your firewall or ISP's server).
Professor Frink wrote:
> The headers on the outbound emails show the internal DNS name of our
> exchange server; obviously this...Recurring Transactions or Repeat Sales
Is there a way to process recurring transactions or repeat sales in Store
Operations or is there any third party add on available for this purpose?
We have a computer store and offer service contracts to our customers for
which we bill them on regular basis either monthly or quarterly. At the
moment we just have to make a not of when their next bill is due and then we
enter the transaction the store operations.
Ues a program Called ESC from costal Computer corporation. That is what it
is made for.
We are currently implementing ConnectWise PSA (connectwise.com). It is ...How can I tell if an email I have sent has been opened?
As per subject.
You can try using a Read Receipt but many users block the return of them
"AT" <AT@discussions.microsoft.com> wrote in message
> As per subject.
you pay for it:
you can try it out for a short time...then you pay...but it's pretty
much guaranteed to get you the results you want...
"AT" <AT@discussions.microsoft.com> wrote in message
> As per subject.
Request a read receipt.
it...can you tell me what an error 920 is?
I'm trying to save a visio file out as a jpeg, or gif, or png. I keep
getting the error with no explanation of what the error means - any help is
You can go to the following link and it explains the issue you are having and how to fix it: http://support.microsoft.com/default.aspx?kbid=295691
> I'm trying to save a visio file out as a jpeg, or gif, or png. I keep
> getting the error with no explanation of what the error means - any help is
...can you see what i am writting?
...Help ! formatting data to text
I am creating data in an Excel spreadsheet. I then want to get that data
into a simple text email. I have some problems and questions...
1) how do I get the columns of data to line up evenly when I copy the data
to email text ? Keep in mind I need to be in simple text format, not HTML
or rich text.
Every time I do this, all columns become chaos and are unreadable.
2) Is there a simple way to automate the creation of an email from an excel
file ? this is less important to me.
Thanks in advance
#1. I think it may have to do with what email client you use, too.
I copy and ...How can I choose alternate rows in a column?
My requirement is to be able to create a column whose elements consist of
difference between adjacent elements in a column, say column A. If I can
choose alternate elements and create 2 new columns then I can just subtract
the 2 columns easily.
"pnair" <email@example.com> wrote in message
> My requirement is to be able to create a column whose elements consist of
> difference between adjacent elements in a column, say column A. If I can
> choose alternate elements and create 2 new colum...How can I stop charts from refreshing when changing source data?
My problem is, that I am working with a lot of data and when I change some of
the ranges all charts in my view refreshes and it takes much time. My pc is
aP4 3GHz, 2GB RAM so that should not be the bottleneck. Is there any way to
force the charts not to update all the time?
...Assign values for one column to another.
I have in column T certain numbers and texts that that I require to assign a
value to as below, in the adjacent column. Again any pointers would be much
Well, imagine that two-column table occupies cells Y1:Z20. Put this
formula in U1:
and copy down.
Hope this helps.
On Oct 14, 4:26=A0pm, Celticshadow
>...how do I remove fx from the function line, can't enter data
I have the fx displayed just under my toolbar, and I can't enter or change
data in any of the cells in the file. I can't get the red X, the Green check
mark, or the black = sign to appear. There are very few areas that are not
"greyed out" under the headings at the top. This situation applies to all of
the excel files on this computer. I have Excel 2000. Please help.
Can you move the cursor around anywhere in the spreadsheet?
> I have the fx displayed just under my toolbar, and I can't enter or change
> data in any of the c...Column styles doesn't appear on the worksheet
one of my customers has changed the windows xp designs to its own. From this
moment excel doesn't show the font color and the background color of a cell
in the worksheet. Only in the print preview you can see the color settings of
I'm not shure if this problem belongs to the changing of the windows xp
designs, but from this moment it did occur.
This occurs on new excel-documents and on existing ones. With another user
account on the same machine the problem doesn't occur.
I have reinstalled Office 2003 and even deleted user registry entries for
Office...Exchange Stops Working
1. Primary server named STECNICIL (THIS HAS WINDOWS 2003 ENTERPRISE
2. Secondary server name TEC-EXCHNG (THIS IS THE EXCHANGE SBS SERVER
All the user connect through STECNICIL to get internet and every other
All users connect to TEC-EXCHNG to get their email through OUTLOOK 2003.
I don't know what's going on but approximatly every 30mn to 1 hour, the
connections between the clients and the EXCHANGE SERVER stops working. No
more email for clients after that period of time. I have restart the server
and restart the EXCH...how do i recover data in publisher
i have been entering addresses to set up a mail merge. i cllicked the "ok"
in the window and lost all data . can i recover it
Look in a folder in My Documents named "My Data Sources". Publisher data is
saved as .mdb(Access) file.
Did you try selecting "Edit Address List" in the Mailings and Catalog menu
"dee" <firstname.lastname@example.org> wrote in message
>i have been entering addresses to set up a mail merge. i cllicked ...Can't Stop External Hard Drive
I have a Western Digital 250 gb external hard drive connected via USB port.
I am also running Outlook 2007, which I believe has a function
searchindexer.exe that searches all my drives to index the files on them.
I want to be able to unplug the drive without first turning off my computer.
But I get messages saying that the drive can't be stopped. It used to be
that if I stopped searchindexer.exe, I could stop the drive. But that's
Here are two questions:
1. What is preventing me from stopping the drive?;
2. What is the worst that can happe...Using subtotals as single data entries
Sorry about the subject--I couldn't figure out how to describe it
I have a large file (16,000 records) of amounts billed by roughly
10,000 service providers. A number of these providers have multiple
office locations, so each record is unique to a specific office
location. In other words, a provider who billed from 3 different
office locations will have 3 entries. Each provider has a unique
provider ID number, which stays the same regardless of which office
location he is billing from.
I want to be able to subtotal the amount billed by each provider for
all their office locations...Hide columns if there are no entry's in column
I have a workbook with multiple sheets. One sheet is a overview from
all the sheets and had all dates in it.
Is there a VBA to hide columns when there are no entry's in it?
The code has to work when I open the sheet "overview"
Hope someone can help me with it!
Thanks in advanced!
If you have a row that when blank would indicate which columns to hide, you could use
On Error Resume Next
Rows("1:1").SpecialCells(xlCellTypeBlanks).EntireColumn.Hidden = True
MS Excel MVP
<email@example.com> wrote in message news:118...How can I keep track of when (date and time) data is entered into.
I am trying to create a spreadsheet for a high school class. I need to be
able to track when a student has entered data into specific cells of the
spreadsheet. Any ideas?
In the code behind the worksheet, enter (eg)
Private Sub Worksheet_Change(ByVal Target As Range)
Cells(1, 1).Value = Now()
This will enter in Cell A1 the date and time at which any entry is made in
If you need the location of the time-stamp to vary according to which cell
is changed then you can test the value of Target and vary the destination
Return email address is n...