call me slow, but where is the magnifier in excel?
Where is the Magnifier in Excel?
In 2007, on the View tab, click "Zoom".
"cgotzeff" <firstname.lastname@example.org> wrote in message
> Where is the Magnifier in Excel?
View>Zoom on versions<2007
Gord Dibben MS Excel MVP
On Wed, 6 Feb 2008 12:09:00 -0800, cgotzeff <email@example.com>
>Where is the Magnifier in Excel?
...Query to Pull Most Recent Call with a Callback Date Scheduled
I'm trying to create a query that only pulls in patients that have a
scheduled callback date, but only if the callback date was scheduled on there
most recent call. So far I've been unsuccessful. Below is the SQL that I'm
attempting to use-
SELECT [Patients Table].[Patient ID], [Patients Table].[First Name],
[Patients Table].[Last Name], [Patients Table].[Home Phone], [Patients
Table].[Day Phone], Max([Call]) AS Expr1, [Calls Table].[Call Outcome],
[Calls Table].[Callback Date]
FROM [Patients Table] INNER JOIN [Calls Table] ON [Patients Table].[Patient
...Remote Access Connection (RAS) over satellite on XP3
Client Machine(where I connect from) - XP Service Pack 3, PcAnywhere 10.5/11.
Host Machine(where I connect to) - XP Service Pack 3, PcAnywhere 11.
When I connect using PcAnywhere 10.5/11 to a host machine, I have problem
whereby the remote connection is super slow. When the connection is
establised, you need to count of 20 - 30 before it gets to load other
For your information, how the host receive a signal is via satellite. So how
I connect to the host basically, the remote access has to go through the
satellite dish > Indoor Unit (IDU) > 3Com Swi...recover messages when remote session expires before sending
I was typing a long message and when finished wanted to send it via Outlook
but noticed my remote session via my office has expired. Can I recover the
"atesemin" <firstname.lastname@example.org> wrote in message
>I was typing a long message and when finished wanted to send it via Outlook
> but noticed my remote session via my office has expired. Can I recover the
If you had a remote session that timed out or otherwise dropped, then just
reconnect to the remote machine and...Access CRM remotely via internet browser
We have a few users in Hong Kong which we will like them to use MSCRM;
Currently, our main MSCRM server is located in London, UK.
Can CRM be accessed remotely via internet browser?
At the moment, we can only access them via internet browser if we are within
the local network.
You would need to expose the CRM website through your firewall. This could
be a security issue though with this approach. If you can, you would be
safer to establish a VPN connection. At a minimum, require SSL on the
exposed web port.
MVP - Microsoft CRM
"Alan" &l...how to enter call option transaction
I sold some call options that were eventually exercised. Under list of
selections available, there is an "exercise" option, but it's for the
purpose of ME exercising the option. The call options were exercised
by someone else. What I ended up doing is entering a "buy to close"
for the option for $0, then sold the underlying stock at the strike
price without commission. There must be a better way to do this.
In microsoft.public.money, namsilat wrote:
>I sold some call options that were eventually exercised. Under list of
>selections available, there is an "e...Execute Procedure on a remote Access Db file
I am trying to open another Access DB from my current Access DB and trying to
execute a SUB programatically. But I get a message that Microsoft Office
Access can't find macro "ParseMnAFileAGH" message. Any help on this is much
Here is my code:
dim objAccess as Access.Application
Set objAccess = Nothing
"Kumar" <Kumar@disc...CMyWinApp::InitInstance is never called in console app.
I'm using MFC, MSVC60. I created simple console application with MFC
support with MSVC wizard. Everything is cool and working. However, if
I inherit from CWinApp and override InitInstance, it doesn't have any
effect. The method is never called.
I searched sources of MFC and noticed that InitInstance is called
either from DLLMain or AfxWinMain. Both of them obviously don't exist
in console application.
Now my quaestions are: Should I call InitInstance manually? Should I
somehow to cause the MFC to call InitInstance indirectly? Or should I
abandon InitInstance at all and pu...Big problem with huge pagefile.sys on Exchange server
Win 2003 Standard 4GB RAM
Exchange 2003 SP2
Symantec Email security (Antivirus)
We've been ahving problem with low virtual memory on our exchange server.
Last time I check, the system used up all VM (4GB) and Exchange went to a
We use the /3GB switch in boot.ini as recommended by MS but not helpful.
Any tip is greatly appreciated.
On Thu, 15 Dec 2005 13:06:32 -0800, "Bill Nguyen"
>Win 2003 Standard 4GB RAM
>Exchange 2003 SP2
>Symantec Email security (Antivirus)
>We've been ahving p...Can't verify publisher for mf.sys
I've got a multiportSerial inf that uses mf.inf/mf.sys to enumerate x number
of serial ports. When I use this inf for my device, Server 2008 complains
that "Windows can't verify the publisher of this driver software". If I say
to install the driver software anyway then it will enumerate all my serial
ports correctly and it's happy to install the serial driver I have written
for the child devices.
What do I need to do in order to get the mf.inf/mf.sys portion of my install
to work without user interaction?
You need to sign your mf.sys file (and mf.cat) w...Application crashes in a call to PageSetupDlg
I have an application that uses the PageSetupDlg API. I fill in a
PAGESETUPDLG object and pass it on the address of it to the API. The
filling up is done with the following (VC++) code:
// Initialize PAGESETUPDLG
psd.lStructSize = sizeof(PAGESETUPDLG);
psd.hwndOwner = hwndOwner; // Handler to the owner of the
dialog. The owner is a VB app
HGLOBAL devIn = GlobalAlloc(GMEM_MOVEABLE, dev->dmSize +
dev->dmDriverExtra); //dev is the device passed on to this piece of
code by t...quick call on excel
Can I command a call to the pc's modem by a simple clic on a cell? I work as a sallesman. I've so many calls to do every day and it's really hard to me.
Thanks for any help.
try this. It could be converted to a double click event.
Sub CellToDialer() 'John Walkenbach
' Transfers active cell contents to Dialer
' And then dials the phone
' Get the phone number
CellContents = ActiveCell.Value
If CellContents = "" Then
MsgBox "Select a cell that contains a phone number."
' Activate (...Best way to setup Sharepoint for remote sites
I have a question about SharePoint setup. We currently have a site
setup with information at our home office however we have several
other offices and users in these offices that need to access
information from SharePoint. Dragging that information across the
wire is slow. I am trying to figure out what's the best way to setup
a remote SharePoint site that could either replicate data or if it was
possible just to setup a front-end SharePoint site in this location
and point the database to the one at the home site? Which one works
adequately? We are going to be migrating our fi...Remote Connection
I'm currently utilizing Great Plains 7.5 with SQL Server
2000. I have ten maintenance foreman who access the
service call management module via a broadband virtual
private network; average bandwidth of 400Kbps. The
computers the maintenance foreman have are 1.6Ghz
processor with 256Mb RAM. There is considerable latency
when the maintenance foreman access the service call
management module, is there any way to increase the
performance. Any ideas?
Have you thought about using terminal services to host your client
applications for remote users?
--...Dialog loosing focus when called from Tree Control
In our application a dialog has to be invoke if user select any item
from the tree control(CTreeCtrl Class variable )
The dialog is created properly as a parent of tree control dialog but
its loosing focus , as per our requirement this dialog should be at the
top of the window but tree control is coming at the top.
Can anyone tell us where i am doing wrong.
I have tried all calls like ShowWindow, killFocus from the tree
control.. etc... but it didn't work.
Let me see if got this correctly.
1. User selects an item from a tree control.
2. At that point you wan...Setting Up Relay for Remote Users
I am trying to setup my Exchange server (5.5 SP4)to allow relaying for several people in a remote office. They are using Outlook 2000 and access their email via POP3. They are able to receive all email but can only send email to recipients "in-house". How do I enable relaying for select users?
"Toney Barber" <tbarber@email@example.com> wrote:
>I am trying to setup my Exchange server (5.5 SP4)to allow relaying for several people in a remote office. They are using Outlook 2000 and access their email via POP3. They are able to receive all email but can only...Position form near control that called it
I would like to position a form (a calendar) near the control that issued a
call to open the calendar form. So, wherever on my calling form there is a
control that requires a date, the calendar form will open just beneath that
control. Is this a job for MoveSize? Any examples around to show the way?
I look forward to your input.
"Barry" <Barry@discussions.microsoft.com> wrote in message
> I would like to position a form (a calendar) near the control that issued
...Calling function pointers
I was looking at the Dynamic Array functions exported by commctl32.dll
(prefixed DPA_ and DSA_)
Although there doesn't seem to be anything there that really couldn't
be achieved in VB, I was still slightly disappointed that some of the
more interesting functions (DPA_Merge for example) are exported by
I'm assuming that this means those ones aren't callable from straight
As far as I know, we can call API using ordinal number.
Private Declare Fun...New so-called features in Outlook 2002 -- can they be defeated?
Hello all. Our office recently got "upgraded" to Outlook
2002. It has a couple of so-called "features" which I
find incredibly annoying and impossible to defeat. I'd be
interested if anyone has found a way, other than the
ridiculous workarounds listed on Microsoft's website. The
two features which annoy me most are:
Displaying both the name and the email address in email
Displaying two entries in the "Select Names" dialog box
for everyone who has both a fax and an email address, that
is, virtually everybody.
If anyone can te...Calling a DLL from the wrokflow
I am new to CRM. I need a clarification with respect to a error code that
appears to haunt the eventvwr often, when i am trying to call a .Net DLL from
CRM workflow. The error description looks like this in the eventvwr"<code> 0
X 80040217 </code>" it says that the workflow is stopped and i need to check
the workflow monitor for more details. When i do the same the workflow
monitor displays "Ok" to all the workflow events including the call to DLL. I
am confused Please help.
...How to use count for calls per hour
I am trying to create a pivot table and chart that will show me the # of
calls per hour by day for a range of dates Aug 1 - Sept 19. My data looks
like this where each line is the date and time of the call:
How do I get a count of the # of the calls per hour by day?
8/1/08 12:48 AM
8/1/08 1:53 AM
8/1/08 2:36 AM
8/1/08 3:24 AM
8/1/08 3:37 AM
8/1/08 4:04 AM
8/1/08 4:44 AM
8/1/08 4:55 AM
8/1/08 4:58 AM
8/1/08 7:02 AM
8/1/08 7:28 AM
8/1/08 7:43 AM
8/1/08 7:47 AM
8/1/08 7:56 AM
8/1/08 7:58 AM
8/1/08 8:13 AM
8/1/08 8:33 AM
8/1/08 9:07 AM
8/1/08 10:28 AM
8/1/08 10:38 AM
8/1/08 10:44 AM
8/1/08 ...Calling Workflow using onchange, onload or onsave
Can workflow be called using onchange, onload or onsave?
I would like to update the accoutn record when a bit field is selected on
one of the contacts (parent to the account).
A better approach would be to have a callout created that would be triggered
when when the contact is saved. The callout would check that particular
field and update the parent account accordingly.
Microsoft CRM MVP
"JamesE" <JamesE@discussions.microsoft.com> wrote in message
news:B13630D9-C6FD-4A41-9BDC-4316...System Calls from MFC Application
using system() command from mfc application, the black
screen pops-up before my dialog box is very annoying, how
do I automatically minimize it or close it and only show
my dialog window?
Instead of using system() , use any of the following API's.
Check Abdoul [ VC++ MVP ]
"Arun" <firstname.lastname@example.org> wrote in message
> using system() command from mfc application, the black
> screen pops-up before my dialog box is very ann...event 8250 win32 api call 'dsGetNamew" returned error code 0x862
I am getting the above event on my logs when starting up my exc2003 server
on server 2003. The rest of the message states that the specified component
cannon be found in the configureation information.
When I click for more information, it says that this error can occur
occasionaly and can be safely ignored however, I am getting it constantly
and I beleive this is related to anothre problem I am having where my
inetinfo.exe flakes out and uses up all the processor time, thereby bringing
the server to an absolute halt.
Any insite would be appreciated.
...Backup of remote Exchange Server, any Gotchas?
I administer a multisite network. Our head office is in Perth, a branch
office is in Sydney. The two sites are connected via 2Mbit VPN link. The
head office has approx 100 users, the branch around 20. We run an Exchange
2007 server in Perth. I am considering placing an Exchange 2007 server in
the branch office, and using DPM in Perth to back it up. The total mailbox
data size in Sydney will be about 6Gb.
1. Is this a valid configuration?
2. How well does DPM manage bandwidth in this sort of scenario? I hope to be
able to just do a delta copy each night after h...