Changing the hotspot of a cursor
I am using a custom cursor, which is a target. How do I make sure
the hotspot for the cursor is the center of the target, not the
Normally, you would use a cursor editor to design the cursor and specify
where the hotspot is.
Available for consulting: http://www.softcircuits.com/jwood/resume.htm
"Sam Carleton" <firstname.lastname@example.org> wrote in message
> I am using a custom cursor, which is a target. How do I make sure
> the hotspot for the ...Calender Fields
How can i create a date field where the user defines the date using a calender.
Go to settings/customizations/ select the entity you want to add the
field to. Click on attributes/ click new/after you give it name select
the attribute type/ select date/time. Save and close\ publish
...Setting a date in the Header
I have a report that I need to print every Friday, but the report is for the
following week. So, I want it to say "For the week of: Monday, November 5,
2007." How do I calculate the date to be next Monday?
IF you run the report on Friday (and never on any other day),
-- Add a control to the report
-- Set its source to
= "For the week of " & Format(DateAdd("d",3,Date()), "Long Date")
If you run the report on any other day of the week this will fail. So you
might want to use
= "For the week of " & Format(DateAdd("d&...Launching Form from another Form
I am sure there are a few ways, but what is the preferred way to launch
a Form from another? When my user saves a new Case, I want to pop up
the Contact form.
Ernst Kuschke (C# MVP) wrote:
> Hi guys,
> I am sure there are a few ways, but what is the preferred way to launch
> a Form from another? When my user saves a new Case, I want to pop up
> the Contact form.
FWIW, a "Contact Form" can be displayed by navigating to the aspx page
Con...Change default currency of Opportunity when convert Campaign Respo
Whenever we convert the campaign response to Opportunity, the currency on the
Opportunity is always base currency and it cannot be changed.
Is there anyway to make this auto created opportunity has another currency??
The transaction currency in Opportunity is drived from the original campaign
from which you created campaign response. If you want your Opportunity has
other currency, you need to set it when you create your campaign from the
> Whenever we convert the campaign response to Opportunity, the currency on the
> Opportunity is a...Change in restriction needs
I was not given correct information.
The internal user wants to refuse mail from an external sender. Otherwise
the senario is the same. We just need to block an external mail address for
one particular internal user in SBS2000. pse help.
You could do this globally using System Manager otherwise, create a
mail-enabled contact for the external user, add it to the internal users
Delivery Restrictions tab then hide the contact from the GAL.
"Lane Hoskins" <email@example.com> wrote in message
> I was not given correct i...changing the icon in the topleft corner of an applcation
How do you change the MFC icon in the top left corner of an MFC applcation?
I've edited the icon IDR_MAINFRAME, and this makes my icon appear on front
of a file, but doesn't change the top left icon.
Hamish Dean, PhD
ShapeShifter Technology Ltd
+ 64 3 377 3140
You have to change both sizes, 32x32 as well as 16x16. Size of the icon
appears as a choice in resource editor.
Ajay Kalra [MVP - VC++]
"Hamish Dean" <firstname.lastname@example.org> wrote in message
news:pm0Ra.80775$JA5.email@example.com...Re: Outlook 2007 create background
I played around with this further. You can still use any HTML editor to =
create stationery and place it in the user's Stationery folder. You can =
also use FrontPage 2003 to create new themes with background images. =
Details at =
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developers
=...change the formula by changing contents of cell
I have a table that ranks a list of players by their statistics, for example,
when I change cell B2 to "walks", my formula (large) lists the player with
the most walks in cell B4, 2nd most in B5, 3rd in B6... that works well
because more walks are good. But, when I change cell B2 to "strikeouts" I
want it to list the player with the fewest number of strikeouts in B4, next
fewest in B5 and so on.
Is there a way to change the "large" function to the "small" function within
I have set up a helper cell (C2) that changes fro...Calculating dates
A quick question before i'm off to bed :)
I got several dates, all in the future. I'll just give an example, cause
it'll be hell to explain otherwise :p
I have a date (Belgian format) 26-07-2008 (= July 26th, 2008). Now I need to
know how many days have past from 26-07-2004 untill now. So, day and month
stay the same and year needs to change to the year before the current one.
Then count the days untill the date now.
I need this to calculate accrued intrest, should someone wonder (or if that
makes it easier to understand ;) )
Preferably, a short function (if possible) since it...Auto Update in Forms
Please help. I am totally terrible in Access and need simple instructions.
I have a form that all it has is the employee name control and the employee
id number control listed like this:
requestor (employee name)
tag number (employee id)
Can someone give me a simple method for putting in the requestor name and
the tag number will pop up automatically. Created a query called qrytaguser
which has both fields in it to try to make this happen. Read several forums,
but I don't understand VBA code to translate the suggestions.
Thanks in advance.
...My forms will not work with my email when I click submit.
Sending Form Data via E-mail, it will open up my Email but, the data is NOT
contained in the body of the e-mail message. The e-mail address I entered
for the ACTION attribute shows up. BUT NOT DATA IS CONTAINED IN THE BODY.
<FORM METHOD=POST ENCTYPE="text/plain" ACTION="firstname.lastname@example.org">
Name: <INPUT TYPE="text" NAME="name">
<INPUT TYPE="submit" VALUE="submit button">
why is my Email NOT working anymore and adding the data to the body of the
e-mail ...Problem with a date and concatenation
I got some data out of one of our in house databases and it comes out
as 01/022206, for example..a missing second "/" (we need to FIX that
damn databse too)
I have thousands of these rows, and I need to do some analyses by
date, so I need a correct date.
So I was going to use text to columns> fixed width and separate the
01/02 from the 2006, then I would concatenate with
(replacing the actual contents with the cell name of course)
But when I do the text to columns, I get the 2006 but I I don't get
01/02.. I get a...How Do I Change Where Outlook Store It's Information?
I have several profiles in my Outlook 2000. For some reason two of
them are using the same .pst file. Is there somewhere in Outlook that
I can change the default .pst file name where that profile stores
Any help would be most appreciated.
Change the pst-file name or location to anything or anywhere you want. When
you start Outlook it will prompt you for the file.
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tips of the month:
-Create your own fully custom...How do I change the value in cell based on a future date
I would like certain cells to be cleared after a certain date
Put this in the ThisWorkbook code module (Right-click the workbook title
bar and choose View Code):
Public Sub Workbook_Open()
If Date > #12/15/2004# Then _
Note that this won't work if the user opens your workbook with macros
Note also that there's no way to prevent a user from accessing your data
- i.e., they can set their clock back and open the file. You can make
things more difficu..."Changed by" Column is empty
Outlook 2003/Exchange 2000
in my mailbox, the "Changed by" column remains empty throughout all folders.
When I change to my Team Mailbox, the "Changed by" column has the desired
Even when I move a mail from the Team Mailbox to my mailbox, the "Changed
by" column remains empty.
Is this a bug or I am doing something wrong.
Thank you very much.
...shortcut ket to change formatting of text
whats the shortcut key to change numbers to dates, and vice versa.
Message posted from http://www.ExcelForum.com
This may be the sort of thing you want:
Apply the Date format with the day, month, and year.
This is a quote from Excel Help ( use "Keyboard shortcuts" for th
Message posted from http://www.ExcelForum.com
ctrl-1 will pop up the Format|cells dialog
ctrl-~ (ctrl-tilde, aka ctrl-shift-backquote on my USA Keyboard)
will format a cell as General
ctrl-# (ctrl-shift-4) will format as d-mmm-yy
Try searching excel's...Changes to requested ship date in SOP should roll down to lines
When changing the requested ship date at the header on open SOP orders you
should have the option to roll this change down to existing SOP lines.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/News...Transfering a changing cell value progressively through a workbook
I am creating a payment application form in excel 2007 using windows 7. Each
worksheet represents one months invoice. Say I have a formula in "sheet 1/
cell Q7" that sums the total billed to date for a particular budget line
item. This value will be transfered to a the next months payment application
"sheet 2/ cell K7" this becomes the total amount of previous applications,
then "sheet 2/ Q7 is =sum(K7,M7,O7) this value is transfered to "sheet 3/ K7,
and so on and so on, until the completion of the job. How do I acomplish
...Updating all Fields in Word Document
I need to update all fields in the Word document.
I have some of the fields in drawing canvas too.
I have tried this, which works fine, but except drawing canvas.
Windows Vista Business SP2, Office 2007 SP 2
Dim oStory As Range
For Each oStory In ActiveDocument.StoryRanges
If oStory.StoryType <> wdMainTextStory Then
While Not (oStory.NextStoryRange Is Nothing)
Set oStory = oStory.NextStoryRange
...recieving reminders since re load of exchange 2000
I have recently done a reinstall of exchange 2000 using setup and selecting
reinstall all components. Before doing this I did an offline backup of
After reinstall moved backed up mdbdata back.
All is working okay all emails and public folders are as before. However a
few users are complaining that they are recieving reminders from months ago.
Any ideas all I can see is the outlook.exe /cleanreminders
to fix it.
...Preventing users from saving forms into unprotected formats
I need to stop users from saving forms into unprotected formats, e.g. RTF
(believe it or not, my users like to mess about with form layout, creating
business interoperability problems) I have successfully intercepted the
FileSave and FileSaveAs commands. I also need to intercept the Save As
dialog which comes up for a new dialog when the file is closed, so I'm using
a BeforeDocumentClose event handler. I would like them to be able to choose
not to save, so I give them a YesNoCancel message, but I can't prevent the
regular message coming up if they click No on my message...Updating a form after using a workflow rule to update the entity.
I have a workflow rule that, on create of a contact, calls an assembly and
updates an attribute of that assembly. It works a treat, but after saving,
the attribute does not appear in the form. I have to close and re-open the
contact to see the attribute. Is there any way to have this display
...Fully qualified domain name change
When I first installed Win2003 and Exchange we didn't have a fully qualified
domain name yet so the installation of Exchange used the email format of
"email@example.com". While this is OK for internal email external email
cannot recognize company.local. We now have a fully qualified domain name so
how does one change the current "company.local" email addresses to
Thanks and I apologize in advance if this is a stupid question.
You need to 'apply' a new RUS policy to add the new e-mail addresses to each
Is there a way to have excel automatically add a new date to the end of a
column each day? My goal is to have an automatic date in column A and daily
closing prices for the S&P500(in column B) corresponding to those dates that
are updated via web query. Thanks so much!
Dim LastCell As Range
Set LastCell = .Cells(.Rows.Count, "A").End(xlUp)
If LastCell.Value = Date Then
'already opened and populated