Directory Problem When Opening Files
Had this problem with my PC at work last week and the solution chosen by my
company's Help Desk people was to uninstall and then reinstall the whole
Microsoft Office package of programs. And while that fixed my problem, I've
got to believe that there is just one single file that needs to be deleted
or somehow reinitialized. The problem was fixed last week with the
uninstall and reinstall, but popped up again this afternoon. Hope one of
you can help me with this.
Here's the problem ...
When I try to open an Excel spreadsheet or attach a file to an Outlook
message, the wi...crosstab query problem
I use MSO2K. When i create a new crosstab query using the wizard, none
of the fields are getting listed in the tables. Similar problem I find
with Unmatched query wizard also. I have used both these wizards in the
past on the same system. Unable to recall anything which has been done
on the system which could have caused this problem.
I have to do a Detect and Repair operation. Problem still persists.
Any inputs on what could the problem be?
Ive seen this happen before as well, certain fields just refuse to
show up in the wizards (seemingly always the one...Problem with frame formatting
I have a resume template that contains a frame on the first page. When trying
to apply a style to the text within the frame, the text within the frame
loses its positioning, i.e. it can end up anywhere on the page, or the whole
text within the frame ends up jumbled. (The style I'm trying to apply does
have the frame defined). The frame is defined with a left side vertical
By recreating the template from scratch, I thought I had gotten rid of the
problem, but if I copy and paste that frame into another document, the
I don't know if this all...synchiing two computers?
Is there a way to synch Outlook on two computers?
I end up with some email on my laptop and some on my desktop - it would be
nice if the two could be synched so that I could have all of my email on
Take a look here, it may help:
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Bill Andersen asked:
| Is there a way to synch Outlook on two computers?
| I end up with some...Rounding Problem
I have got a very simple accounting spreadsheet where column C is
determined by (A+B)*1.06. Cell C is formatted for dollars - two
decimal places. At the bottom of column C is a total which is usually
correct but sometimes it is out by one cent. All the calculations
across are correct. I am sure there is an easy way to fix this isn't
Check this link of John McGimpsey:
Please keep all correspondence within the NewsGroup, so all may...Compare two cells in two different files and return answer
I am attempting to compare two text cells and if they both exist, I want to
bring in a "yes" answer. If they don't, bring in a "no" answer. Here's an
example of text.
Col A Col B
Col A Col B
So, what I want to do is say in File 1 take cells A1 and B1 compare them to
File 2 and search Col A and Col B and if there is an exact mat...Real problems with DCount
I need to count the number of values in a column that have been
recorded with the Yes/No tick box on the main form of my database
So far, I have tried
and a few others that don't work either.
Secondly, I also have to count a number of dates entered in a column
[date fsmp sent] to give me the total number of date entries in that
column that were witihn the last 90 days from Date().
I don't know if Date() or Now() is ...Email Tracking Problem
I'm running Outlook 2003 with the CRM plugin but running into issues when
clicking on 'Track in CRM'.
I have two mailboxes in Outlook, my own and a support mailbox. I login to
Windows as myself.
Is it possible for me to track emails in the support mailbox? If so, How? As
I'm receiving this: "Only items in the default Microsoft Outlook store can be
promoted to Microsoft CRM"
I have this problem too! Does anyone know of a workaround, or heard of this
> Hi Guys,
> I...ProperCase problem
Hi there Excelers
I have a problem that I am unable to fix, is there someone that can
help me. Just learning VBA and have some trouble with the following
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Not Application.Intersect(Target, Range("A1:A10")) Is Nothing Then
Target(1).Value = vbProperCase(Target(1).Value)
Application.EnableEvents = True
The vbproperCase gets highlighted and a message, Compile Error,
Also should this be put in sheet1, or this workbook.
Any assistance would be greatly appreciated
Than...Pivot table for two different data variables
I have the following table
Name type Cost overhead
amy C1 23 12
bob C2 129 17
cat C2 36 45
doo C2 100 32
I owuld like to create a pivot table that looks similar to:
the standard pivot table. (Please ignore type for now.)
name Data Total
amy Sum of overhead 200
Sum of cost 12
bob Sum of overhead 130
Sum of cost 23
cat Sum of overhead 90
Sum of cost 19
doo Sum of overhead 87
Sum of cost 34
Total Sum of overhead 507
Total Sum of cost 88
But with overall total (overhead + cost) for ...problem about installation
Operating System: Mac OS X 10.5 (Leopard)
I bought a office:mac 2008 home&student edition, which can not be successfully installed. I have already type in the product key and verified my username and password, then it showed that no installation document can be found. what should I do about this?
> I bought a office:mac 2008 home&student edition, which can not be successfully
> installed. I have already type in the product key and verified my username and
> password, then it showed that no installation document can be fo...COUNTIF (?) on two criteria
I have a spreadsheet that logs work activities and records team
members' completion of project units.
Column B records team member names. Column C has project unit status -
'pending', 'beta' or 'completed'.
It's easy to set up a formula to count how many units are allocated to
each team member - =COUNTIF(B1:B1000,"Joe"). But what I need to do is
set up formulas to count how many units Joe has completed, or has
pending or at beta, and this means assessing data in both columns -
which COUNTIF won't do.
This doesn't strike me as an especially...Two IF Statements with two answers
In cell J9 I need a formula that would do the following:
If G9="Yes" then F9, If G9="No" then -f9
Note: G9 has a drop down list with Yes, No answers.
If there are no other alternatives that yes and no
> In cell J9 I need a formula that would do the following:
> If G9="Yes" then F9, If G9="No" then -f9
> Note: G9 has a drop down list with Yes, No answers.
=IF(G9=&qu...Excel Advancedfilter problem
Ive got some data
item blah MinSize Maxsize blah blah
1 26 32
2 18 24
3 20 26
4 28 33
350 28 30
I want to extract those results where eg 30 is between the minimum &
eg MinSize>29 or the MaxSize<31
if I put the on separate lines i get in an advanced filter i get
eg item 2 and 3 because the maxsize is <30
If i put the two statements on the same line it does and AND for each
record and i get nothing.
One ...Problems with a border of a list control
I'm having trouble creating a CListCtrl on the heap (i.e. new + Create())
whose border would look like a border of a control that is embedded directly
into a dialog box. To be more specific, when a list control is dropped onto
a dialog box in a dialog editor, its border is black but when the dialog is
displayed - either by 'Test Dialog' or running the app - the border gets
'softened' (e.g. 3d on W2K and light blue on XP). My problem is that a
dynamically created list control is always displayed with a black ugly
border (i.e. as seen in the a dialog editor). It l...Outlook Locks/Login Problem
I'm not sure this is an Outlook problem or not. If I have
DNS enabled, Outlook loads but locks immediately with the
mouse pointer behind the Outlook window. If I have DNS
Disabled, Outlook tries to load, but can't access the
email server and keeps asking for a userid, password, and
Domain name. Shut Down/Restart brings an End Task window
that doesn't have anything for a Program name. Pressing
End Now closes the window but returns to the desktop. The
only way out is to power off. Thanks!
...Problem Balancing Accounts Money 2002
The accounts never balances automatically when I import
my bank information. Unfortunately there is no direct
connection between money and my bank so I must import
information. However, it never reconciles itself!
The balance is always something that the actual balance
is not, then when I manually reconcile it there are large
discrepancies which simply sit there as nameless
So how does this work?
Lets say I have my account from Jan. 1 - April 14th.
When downloading the new transactions, do I download from
April 14th, or April 15th? Some transactions from April
14t...Problem with ShellExecuteEx
I'm trying to use ShellExecuteEx to display file properties for a file, but I'm getting an error saying it can't find the file.
The error is very strange. It says "Windows cannot find 'xxxxx'. Make sure you typed the name correctly, and then try again." But where I have "xxxxx" here there are what appear to be Chinese characters; there are also Chinese characters in the title bar of the error. I have verified that the file really does exist.
Can anyone shed any light on this?
Here's the code:
Public Const SW_SHOW As Short = 5
Public C...Address book access problem
I have migrated my old vista laptop to my new Windows 7 laptop and can not
get contacts to show up in the address area. Need help.
Sorry, but this newsgroup is for questions about Access, the database
product that's part of Office Professional.
You'd be best off reposting to a newsgroup related to whatever e-mail client
you're using, or one related to Windows.
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
"email@example.com" <firstname.lastname@example.org> wrote in
message ne...mail merge problem in publisher
I recently had to reload Office Small Business 2007 onto my computer and now
my publisher document won't merge with my excel spreadsheet. When merging
the spreadsheet with over 100 address I only get one page and one address.
Previously I got one page for each address. I'm sure it's a setting but
Are you doing labels? Do you intend to have multiple names and addresses per
page? Your problem isn't too clear.
If you are doing labels or similar:
After you input your fields go to File, Print Merge, be certain "Multiple pages
per sheet" is selected. T...WinCrypt problem
I'm trying to encrypt a password in my application. I use WinCrypt, but
it doesn't work on any computer except mine. I used it on pc with
Windows Xp and also mine OS is Windows XP.
When I include WinCrypt, I write this code:
#define _WIN32_WINNT 0x0500
On my computer is installated Net Framework, but not on the others I
"Mails" <email@example.com> wrote in message
> I&...Two axis
Positioning the Vertical axes:
I have a chart where there are two axes. The first implementation produced
the two scales on the right side, one inside, the other outside the chart
area. Unusual, but luckily it fits well the chart.
I tried to duplicate the feat with another dataset (similar in structure)
and did not even get the second scale to show right, left or center (data
plotted with two different scales allright).
Where is the info to control these functionalities?
On Wed, 29 Oct 2003 17:48:13 +0100, pl.carry <firstname.lastname@example.org> wrote=
> Positioning the Vertic...ToolBar problem
I am creating a tool bar in a dialog box. I have the tool bar created, no
problem. No I have 2 blank buttons in front of the toolbar for a font name
cb and a font size cb. The problem is when I create them they sit on top of
the first couple of buttons on the toolbar. I need to push the the toolbar
over when I put the combo boxes on it. how do I do that?
Did you follow example DLGCBR32 in MSDN to put a CToolBar in a dialog? It shows how to
adjust the area to accomodate the toolbar etc.
Ajay Kalra [MVP - VC++]
"William Gower" <email@example.com&...plot two groups of numbers on one series of xy coordinates.
how to create a plot from separate x and y values. i.e. y values do not
correspond to the same set of x values. example x1= 5, y1=10; x2= 8, y2=15
I can read your question 2 ways;
A) you data looks like this
Select the data and make an XY chart
B) you have two sets of data
Make an XY chart of the first data series
Select all the data (including headers) for second set, and use Copy
Click the chart to activate it
Use Edit | Paste Special .... indicate New Ser...Switchboard Problem
I want to have one form that I can call from a switchboard and filter for
several people using a macro. I’m using Access 2007 and my setup is as
This is a manually designed switchboard where I’ve put a tab control with 2
tabs titled “Input Forms” and “Reports”. On the “Input Forms” tab I have
placed a combo box named “cboExpItems”. This is a drop-down box which
displays employee names from a table. I want to select a name and using an
“AfterUpdate” event I want to run the following macro which will refer back
to “cboExpItems” for the name of the employee to fi...