Highlighted cell jumping to cursor location
Using MS Excel 2003. Highlighted cell for editing is moving on it own to the
cell where ever the mouse cursor is located. Is this normal?
...Problem with MFC
I am currently developing some kind of street directory program. It is an
MFC-based program. This program basically asks you where are you now and
where are you going to go, then the program will show you the best possible
way on the map. Since I am using small map pictures (bitmaps) which I arrange
like a puzzle to form a bigger area, I found that eventhough I am able to
scroll from one map to another but the scrolling is not smooth. Can anyone
help me to improve the smoothness of the scrolling? If you can provide a
sample source code or if you have a link that provides a solution to t...Problems Summing
I have a database with a few relationships in it. The patient and their
dependants are in two separate tables and a rate of Fee is in another. I
have a report which lists the patient and fee with their dependants listed
underneath. However, when try to put a sum field in the report header it
adds the fee for each dependant. How do set it up to add the fee once per
Sum it in the footer.
State of Arkansas
> I have a database with a few relationships in it. The patient and their ...File and start menu problem
as in, they won't open on mouse hover- I have to click them to open.
Not dangerous, just annoying...
Is there a setting somewhere? I've looked at system settings and
tweakui, but don't see it.
"blitz" said this in news item news:firstname.lastname@example.org...
> as in, they won't open on mouse hover- I have to click them to open.
> Not dangerous, just annoying...
> Is there a setting somewhere? I've looked at system settings and
> tweakui, but don't see it.
Opening a file when you hover over it would be disastrous.
I agr...templates problem
When trying to display the properties of distrubution
groups in Outlook 2003
I recieve the following warnings...
The properties dialog box could not be displayed.
Server is not configured to support details templates in
language(English). Contact your system administrator
-- then after clicking ok
The Properties dialog box could not be displayed. The
action could not
Wee are using Exchange 2003
Can anyone help me with this ?
"Anders Meyer" <email@example.com> wrote:
>The properties dialog box could not be disp...Activecell problem #2
I have a really basic question
I am trying to print a certain area which starts at a certain cell
which may differ every week. I have the code to get to the bottom
right of the area I want to print but then I want to select the area,
from the active cell to A3:
'go to the bottom cell in colum L
???????? what goes in here??????
'Print the selected area
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Any help appreciated.
remove your select line and add
-...Automation timeout problem
I have a program which is using the Automation Interface to PowerPoint. If I choose the
option to save a presentation, and execute CPresentation::Save, the save takes some time
(the PowerPoint presentation is large). The result is the user gets an annoying and
potentially confusing notification that the operation is failing because the target is not
responding, and options are to retry or switch to. Of course, switch to won't work
because PowerPoint is busy saving. Is there any way to (a) disable this annoying message
(b) explicitly set the timeout (c) detect it is going to occur and i...Outlook
I have set email to use HTML and chosen stationery (citrus punch for
When i create a new email and begin typing, the image at the top of
the screen (i.e. the orange/yellow/red block at the top of the screen
in citrus punch) moves along as i'm typing, and it's the same for any
stationery that has and image of some sort at the top of the page, as
soon as I start typing, the image moves along ahead of the text and
each time i hit return the image moves down a line and whatever i've
typed appears above the image block.
I'm sure it's not meant to be this way, any sug...Currency problem
Whenever I am in POS and I change the currency to something other than
the default, I lose the ability to use any on the button, like F2 lookup
or anything. I can't even set the customer.
I am getting ready to be able to import orders in the customer's
currency from Nitrosell, but I am concerned about POS not allowing
anything once I get out of US Dollars.
I can make an invoice in US dollars and THEN select currency to
translate to Pounds, Euros, etc. but I need to be able to make the
invoice in the foreign currency and then transfer it into US dollars
before I close...autofilter problem
I have two worksheets, the first holds original data. On the second
sheet I used copy (from page 1 data), paste special and paste link
....then I used autofilter to sort through the data for only select
information. However I seem to have a problem now...when I update the
original page 1, I can get the information to appear on page 2 if I
refilter the data....however that will only work if I had added the
information on page one to the last row or updated existing
information....if I try to insert a row to add information, it will not
appear on page 2. Not sure what I am doing wrong...Problems with latest vista update
I have a total of 4 updates that are ready to be installed on my computer,
when I turn off the computer it says they are installing, but the computer
stays on all night saying installing 1 of 4 updates but they are not
installing and it won't do anything else. If I manually turn the computer
off and restart, it won't let me log onto the internet and it also won't let
me log onto my administators account saying the password is wrong. Does
anyone have any ideas? I have done a system restore from safe mode and then
I am able to get into the internet but only until I tr...cursor color
How do make the cursor color change to correspond with
the section of the spreadsheet you are working on?
I have an OnClick event that does the following:
DoCmd.ApplyFilter , "[TicketNo] = " & Me!GetTicket
TicketNo is a column in my bound table and GetTicket is a textbox on the form.
When I enter a value in the textbox and click the command button, the code
works and I get the requested recond on the form.
When I call the command button Click() procedure from other code, however, I
get a prompt for parameter [TicketNo], the ApplyFilter is failing. I have
moved a valid value to GetTicket control.
Does anyone have a clue why this is happening?
"Give someone...Problem with ImageList
I'm using an Image list to insert bitmaps onto tab strips, but the tab
strips are blank upon execution. The code is:
m_tbCtrl is my tab control variable.
HIMAGELIST hList = ImageList_Create(32,32, ILC_COLOR8 | ILC_MASK,1,0);
m_ImageList.Add( &m_bitmapImage , RGB(255,255,255) );
m_tbCtrl.InsertItem(0," ",0); // 1 tab
m_tbCtrl.InsertItem(1," ",0); // 2 tab
m_tbCtrl....problems with personal.xls #3
I just updated to Office 2003, and ever since then I have been getting
the following warning when I open Excel:
A document with the name �PERSONAL.XLS� is already open. You cannot
open two documents with the same name, even if the documents are in
different folders. To open the second document, either close the
document that�s currently open, or rename one of the documents.
I click OK, and then close the personal.xls file, and can work
normally, and even open new files without any problems. I have tried
to hide the file, but everytime I close down excel and reopen, the same
message pops ...Outlook Problem #28
This is a multi-part message in MIME format.
I have a user who when closes Outlook and opens it again, it says that =
the Exchange server is no longer available. I setup the Outlook to =
point to the Exchange again and it works fine. But when you close it, =
it does it again. Any ideas!
We are tryng to create a simple chart for my daughters homework. It is to
show the resistance in relation to the length of a piece of wire, a line
graph is needed showing the plotted (slightly curved) line and a line of
The data is:
resistance length of wire
When plotted it shows 2 lines (although they dont look identical to the
school example), but stranger still it has changed the values.
Can anyone advise me how to do this, i am sure its sim...Problems with XY-Scatter
I have set up an employee table with around 1000 employees in a worksheet.
Each record consists of the following columns:
I want Grade on the y axis and Trend on the x axis. Each dot in the chart
represents 1 employee. To accomplish this I loop through the table adding
each employee (the code below is just a simple example):
Dim I1 As Integer
Dim sc As Object
For I1 = 2 To 1000 Step 1
Set sc = ActiveChart.SeriesCollection.NewSeries
I can read an email message in auto preview but not when it’s opened? Any
idea on how to fix problem?
Change the Encoding setting on the view menu.
> I can read an email message in auto preview but not when it’s opened? Any
> idea on how to fix problem?
...Pasting (replacing) problem
How can I prevent changing all my "01/1" to "1.jan" (or to "38353")
when copying tables from Word to Excel or when running Find/Replace
The only way I can get those "01/1" is to select text format of a cell
and type it manually.
But I have thousands of "01/1" (01/2, 01/3 ... 02/1, 02/2 ...)
berti's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29597
View this thread: http://www.excelforum.com/show...How do I fix a saving problem in Word 2007?
When I try to save documents in Word 2007, my computer freezes and then Word
crashes. I have run the diagnostic a few times and it has not picked anything
up. I do not have the disk to my edition so I cannot uninstall and reinstall
You don't need to uninstall and reinstall. That rarely helps. Instead, see
the first paragraph in the section entitled "Problems That Seem to Appear
Overnight" on my Web page at
http://makeofficework.com/mysterious_behavior.htm and follow the instructions.
Hope this helps,
My We...image problems
sorry if this appears as a double posting but my earlier posting 4
hours ago has not appeared yet.
A local business using Publisher 2000 has created a number of
templates (most of the content is images) They have now upgraded to
The basic pictures are all 529 x 358 pixels. (an aspect ratio of
1.477 : 1 ) The placeholders are at varying aspect ratios ranging from
1.33:1 through to 1.47:1 but it appears that the pictures all
autoresize ( and distort to a varying degree as a result) to fit the
placeholders in full ( the placeholders all have a border so this is
plainly vis...Windows Update problem
Every 2 minutes I keep getting the yellow shield pop-up "updates
available" (I have it set to notify me, not automatically) I keeps
saying I need Excel 2002 and Word 2002 security update. Funny thing
tho- I don't have 2002, I have Office XP. Plus I keep checking "Don't
remind me of these again", yet it keeps reminding me every 2 minutes.
I even went to Windows update (online) and checked then to not remind
It started this morning, I had about 20-30 updates available, mostly
Office. half were for Office 2002. I kept clicking do not remind me
again on ...Cursor
Why is my cursor jumping all over the page and putting in the letters at
places not designated? Annoying.
Laptop? Disable the touchpad or reduce its sensitivity.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
wrote in message news:CF344F8E-7805-476F-A13B-FCC32D0A75C4@microsoft.com...
> Why is my cursor jumping all over the page and putting in the letters at
> places not designated? Annoying.
when i attach a contact to an account i have an option - to choose an
account from the list, or to create a new one. but i dont have this
option when i work with two custom entities (1 to many relationships).
only to choose from existing when i want a assign a primary entity to a
is there a workarround? this way makes me press much more buttons in
different forms. i have secondary objects already created due to my
business proccess, so i need to go to the primary entity, create an
object, then to go back, to open a secondary one and to attach the
primary one to it.