I am working on a function to see if Ctrl + S is pressed. Useing the
GetKeyboardState Function is it possible to retirve this information? Also
What I have written crashes excel any ideas what i'm missing?
Dim Result As Long
On Error GoTo HandleError
anArray = Array(VK_CONTROL, VK_S)
Result = GetKeyboardState(anArray(0))
Chip Pearson has a page on this, but using GetKeyState API function:
> I am working on a function to ...Multiple if functions #2
I really need to know how could i do or use if functions :confused:
i have gotten all my students avarage and i want to put comments lik
if for example
Average ranges from 95 - 100 comments should be Excellent
Average ranges from 90 - 94 comments should be Very Good
Average ranges from 85 - 90 comments should be Good
Average ranges from 80 - 84 comments should be Passed
Average ranges from 79 - below comments should be faile
Message posted from http://www.ExcelForum.com
One way to do this. Put a following table somewhere. In this example
in area F1:G5
...Can't recover mail
I lost mails from Send Items folder and I wanted to recover them
I found dbx files - size of Send Files is 125MB...
I used DBXtract to recover mails, it cuounts for me more then 500 mails
but it shows me jus few of them...
How to fix that?
Is dbx file corrupted???
How to recover all 125 MB of mails, not just fex???
I urgently need help - thx!
"shtuks" <firstname.lastname@example.org> wrote in message
> I lost mails from Send Items folder and I wanted to recover them
> ...Using Identities in Outlook same as Outlook Express
I have always used OUtlook Express and am considering
using Outlook because of the increased security and
features. I have Outlook 2003.
When using Outlook Express I had 3 different email
accounts and could use each independently and switch from
one to another by just changing identities.
I tried to set up Outlook and I entered the various email
accounts and it downloads emails from all 3 accounts to
the same inbox.
Is there a way in Outlook to setup separate email
identities and keep my emails separate like I did in OE?
Is it really advantageous to change to Outlook over OE?
It ...How can I create a template equivalent to the Avery CD label one in Publisher 2007?
In Publisher 2007 the Avery CV label template has a circle marked out that I
cannot interact with in any way.
What is that circle and how can I create my own for my own templates?
Similarly the jewel case insert template has rectangles that I can't
Arrange, Layout Guides, Left & Right 1.938" Top and Bottom .688"
Grid Guides, 2 rows, .375" spacing.
Create two circles --- 4.625"
Create two intercircles ---1.625"
Mary Sauer MSFT MVP
"Y...Outlook Express default problem
When I go to options under Outlook Express and make it
the default mail handler, apply it and close it out I can
go back to it and it has made itself not the default mail
handler, why does it do this and how do I fix it?
this is an outlook rather than outlook express newsgroup.
"G.Werkema" <email@example.com> wrote in message
> When I go to options under Outlook Express and make it
> the default mail handler, apply it and close it out I can
> go back to it and it has made itself not the default mail
&...Add Buy X Get Y Functionality to define which is x and y
If you use Buy X get Y for Z in RMS 2.0, you can not define which is x and
which is y. All you can do is assign the discount to both items and the
discount is taken on whichever item is entered last. So, if you want to set
up where a customer buys a $20 T-Shirt then they get a pair of $2 socks for
free; if the cashier rings up the shirt first, then the socks, it works
perfectly. However, if the cashier rings up the $2 socks first then they get
the $20 T-Shirt for free! There needs to be a way to define that X is the
T-Shirt and Y is the Socks.
This post is a sugge...Speed up Login to Outlook Web Access
I'm Working with Exchange 5.5 SP4 on Windows 2000 SP3 the OWA is also on
The login is taken more the 6 Minute could I do something to improve it?
"news.microsoft.com" <firstname.lastname@example.org> wrote:
>I'm Working with Exchange 5.5 SP4 on Windows 2000 SP3 the OWA is also on
>The login is taken more the 6 Minute could I do something to improve it?
Would need to know a little more about the specs of the OWA box, the
network topology, what else resides on the owa and exchange servers
Mark Arn...Making adjustments to Calendar in MOS 2007
I need to wrap text, reduce the size when printed in calendar HELP!!!
"SuperReceptionist" <SuperReceptionist@discussions.microsoft.com> wrote in
>I need to wrap text, reduce the size when printed in calendar HELP!!!
Printing tools can be found here:
http://www.slipstick.com/addins/calendar_print.asp. The Calendar Printing
Assistant (a link to which is on the page I've cited) is a good place to
Brian Tillman [MVP-Outlook]
...Office 2004 and disk access
In order to evaluate Office 2004 for my lab, I installed it on a spare =
on an external hard drive. Now I can't unmount that partition under any=20
circumstances (that I've discovered). I'm running OS 10.3.4 on a G3 =
When I quite Word and then try to unmount the partition it resides on, I =
a message that files on the drive are in use and I should quit =
get the same message if I quit *all* applications, including force =
and relaunching the Finder. I've checked with Activity Monitor and ended =
any process with Mi...Mail queued on Front end server for Public Folder on Back End Server
I created a public folder on my back end exchange server
and mail enabled it. Internal email from the global
address list reaches the folder, however external email
smtp does not. The external mail queues on the Front end
Server with a retry status. Any idea why this would be
<email@example.com> wrote in news:1231e01c3f62c
> I created a public folder on my back end exchange server
> and mail enabled it. Internal email from the global
> address list reaches the folder, however external email
> smtp does not....Access Reports 06-20-07
Have a small employee database. Want to print ID cards for new hires.
report works fine for the whole file, but for one-at-a-time, it seems that
the report doesn't respect to filter - It wants to print all records
instead of the filtered table. Appreciate any help.
"gg" <firstname.lastname@example.org> wrote in message
> Have a small employee database. Want to print ID cards for new hires.
> report works fine for the whole file, but for one-at-a-time, it seems that
> the report doesn't respect to f...How do I hide gaps in an Excel 2007 chart?
I have a bar chart that is showing gaps and i don't want them. The select
data > hidden and empty cell button does not give an option to hide gaps. I
think by default they are hidden but if you even click on this to see what it
does the gaps are shown and no way to turn off.
If you hide the actual rows then with the Plot visible cells only
setting on the gaps will be removed.
In xl2007 the setting is on the Select Data dialog, Hidden/empty cells
> I have a bar chart that is showing gaps and i don't want them. The s...Trouble with Multi-Threading (VC++ opening Access DataBase)
I have an application which I did not write, but I want to improve it's
performance (Obviously I do have the code).
First of all I am not a database expert so my terms may not be exact, I
The application starts by reading a lot of data from the database tree
via ODBC (MFC + VC++ 6.0).
This process takes a few minuets, and I have more than one CPU, so
obviously I was thinking of multi-threading.
The point is that once I Multi-threaded the code, the program stuck
during startup. Looking with a debugger, I saw that all threads are
hanging while reading the DataBase....2003 vs 2007 Chart problem
When using Excel 2003 I asked this question:
"I have a sheet with 2 charts which get their data from some
calculated cells that I'd really like to hide, but when I hide them,
the chart dissappears. Even making the columns 0 width does this"
....and this was the answer that worked for me:
"You need to change the properties of the chart object.
Hold the SHIFT key whilst selecting the chart. This should give you a
set of white square handles. Press <CTRL+1> to bring up the format
dialog. On the Properties dialog select the option Do not move & size
Now ...Add-in function has #NAME error
I am using Excel 2000 and after I loaded my first custom-written addin, the
addin function is apparently not recognized because when I put the function
into a cell I get a #NAME error.
The function name appears in the function drop-down list (I think this is
called the Name Box) under "user defined" as you would expect. And I can
pick it from there to put it into a cell. This eliminates any typo problem,
but as I said I still get a #NAME error.
In summary, I can pick the addin function from the Name Box and yet I get
the #NAME error. I think "#NAME" means the item i...Personal.xlsb does not load automatically when I start Excel 2007
Although my personal macro workbook (Personal.xlsb) is saved to my XLStart
folder (In Microsoft Windows XP, this workbook is saved in the C:\Documents
and Settings\user name\Application Data\Microsoft\Excel\XLStart folder).
The personal macro workbook does not open automatically when I start Excel
2007. I get the following message when I try and record a macro using the
macro recorder "Personal Macro Workbook in the startup folder must stay open
Any suggestions how I can resolve this?
Try moving the file out of that folder, then start...Permissions inside public folder
I have recently started administering a windows 2003 SBS network. Inside the
public folders of the exchange portion, they have created some contacts and
other items. I have three users that are marked as owners to these folders
they created inside the public folders. Apparently these were created under
exchange 5.5 and then migrated into their current setup (I didn't perform
this as i recently started working for them). One user can perform
everything just fine. The other two users, when opening a contact that was
migrated in from exchange 5.5, get a permission error when tryin...Access 2000 collaboration via email controls
I am wondering if Access has a similar ability to MS Project: Whereby
tasks(Project) or rows(Access) can be e-mailed from within Access, the
recipient can update fields from their in-box(no need for a copy of
Acess here,) return the email, and have the database automatically
updated upon opening the note.
Is the abilty built-in, or must it be coded?
I have never heard of such an ability.
So you would have to code something.
"Barry" <email@example.com> wrote in message
&g...Are macro sheets and macro functions no longer available?
At one time I used Excel for some rather fancy programming. In those
days I was getting reasonably skilled at using macros. This included the
possibility of defining a function on a macro sheet that had an argument
and returned a result. As far as I can tell, that ability is no longer
I realize that Visual Basic is now used for macros. I do not have
experience with that. I do not know if it worth investing the time to
become proficient at it. I have so little use for that that I have
virtually forgotten all my regular BASIC.
As the years go by, dying just before hav...Able to DeleteDosDevice for a drive letter but can't flush FS cache without reead access on device.
Is there anyway to dismount (flush any information about) a drive letter
when you don't have read or write access to the volume directly.
Background: I was able to setup the device and assign a drive to it so only
the limited user could access it via the drive letter. That worked great
and no security issues with other users accessing/reading the raw device
while data was available. However, dismounting is a problem. I can't use
the LOCK/DISMOUNT FSCTL on the volume when opened with "0" permissions (I
have to have GENERIC_READ which fails unless I ...Writing an activex control to proxy calls to an unregistered activex control
One of my clients needs to support using two versions of an activex
control within Internet Explorer. However, both versions of the control
register to the same CLSID meaning that it is not possible to run both
concurrently without some intervention.
One idea that I had was to create a new activex control under a
different CLSID (and associate that CLSID with a different mimetype) so
that requests to the new mimetype will be sent to the new activex
control, which will in-turn proxy those requests to the unregistered
version of the activex control.
Has anyone had experience doing any...Read only access within a department
With the default settings in Project Server 2007, the Project Managers group
has read/write access only to their own projects.
How to give them Read only access to the projects belonging to other PMs,
but only within a specific department (their department) in the
Thanks for your help
Create a departmental structure in the RBS, then assign the PMs under the
department heading. Configure the My Organization category to allow PMs
to see projects owned by folks at the same level of RBS, and that should
work - probably with some tinkering to get it exa...Public folder Problem #13
We have just migrated from Exchange 2000 to Exchange 2003 in a F/B end
environment. We still have one Exchange 2000 server as a backend as well as
All public folders have been moved to the new 2003 exchange server. The
problem I am finding now. If I create a mail enabled security group add a
user to that groups and then add the group to a public folder and set the
correct permissions the user cannot see the folder, but if I take the user
out of the group and then add the user to the folder set permissions the
user can see the folder.
I would like to use groups to all publi...Missing public data store
I've recently taken over the sys admin duties for a customer site. After
looking through the event logs I discovered that the Exchange 2003 public
data store would not mount because the store itself was missing. When I
looked at the backups I found that inadequate backup processes were in place
and there was no backup for me to use. I fixed the backup problem. Now,
I've googled time after time looking for a way to regenerate the public
folder without success.
Does anyone have a pointer to a process for regenerating the missing public
store and all it's system folders?