Forced Password Change
Is their any way to force a Dynamics GP user (v9 or v10) to change their
password when you are NOT using SQL 2005?
There is a third party product available call OMNI Tools. This product is
available from Rocton Software. Please find the link attached to their
> Is their any way to force a Dynamics GP user (v9 or v10) to change their
> password when you are NOT using SQL 2005?
...Forward misspelled names to user account if doman is correct.
Is it possible to catch for instance a misspelled name like email@example.com
that should be firstname.lastname@example.org and forward it to another account? It should
be able to pick up anything (like *@domain.com) and forward it to
Thanks in advance.
Are you really sure that you want to do this? If so, you can take a look at
the methods listed here.
"pakitloss" <email@example.com> wrote in message
news:24DB863D-49F5-457A-BA47-B7D26F422...need registration name and key for reinstall
I purchased Money 2007 Premium in August, 2006, via Digital River download
and I also ordered a backup CD. Everything worked fine until my computer
died. Now I am trying to install Money on a new computer using the same
backup CD. But it pops up a window entitled "Key Expired". It appears that
I need a "registration name and key", "exactly as given to you". Perhaps I
did receive this information before but it would now be lost on my dead
Is there a way to retrieve the requisite magic cookies from someone's web
site? And what credentials...Exchane 5.5 IMC Naming
I need to change the FQDN display name on a 5.5 Exchange
IMC. Currently the server displays
netbiosname.localdomain, where it should read the FQDN of
the server. I've searched the registry and misc. config
files in the Exchange directory to no avail. In Exchange
2K + you can set this in the server SMTP config. However
there is no place to set this in 5.5.
Any ideas? Thanks for the help.
We ran into a similar issue. We found our options to be either configure
our reverse lookup records to our internal namespace or change the domain
suffix of the smtp machine. We ended up changing ...Where to change my own internet adress in "FROM:" field?
I am using Outlook 2003 with Exchange server.
My own eMail address is presented to recipients as
Note: mixing of capital and lower letters
I want my email address completely changed to lower letters:
Where in Outlook can I change this?
or is this a setting in Exchange Server ?
This is a setting in ADUC/Exchange. I would guess that everyone is set up
with the same format throughout the company.
Kathleen Orland - MVP Outlook
Outlook Tips: http://www.outlook-tips.net/
"Joe deAngelo" wr...Return the name of the object I click on in a form
How do I go about returning the name of an object on a form. For example if
I set the "On Click" event procedure on a rectangle object to return:
I get the form name. What I want to do is click on the object and be abe to
reference it's properties such as Tag to run other code based in these values.
As always any assistance is greatly appreciated.
For the name of the control try
For the control itself use
"John Dumay" <JohnDumay@dis...named range scope...
i get confused...
a named range can have:
a global level (to the entire workbook),
a worksheet level (to the active worksheet),
also, i've really looked, but can't find good information on how to define 1
level name vs. the other... (any direction on this ?)
Just the two.
A workbook name is created by just inserting a name in the Names box, such
A worksheet name is created by adding the sheet name to the name in the
Names box, such as Sheet1!myRange. You can then also create Sheet2!myRange.
You can only add a worksheet name if ...Excel 2007
We have a spreadsheet that was set up to link to a database via a
system DSN. To simplify deployment of this, I'd like to change this
to connect via the connection string below:
I've done this for another spreadsheet, and it was easy (Data tab-
>Connections->Properties), but in this next spreadsheet the Connection
Properties for one connection are greyed out/disabled, so I can't
change the string.
Does anyone have any ideas how to enable these values again so I can
change the connection string?
...File Name Length
Does anyone know if filenames can be longer than 31 characters in Office
In article <firstname.lastname@example.org>,
"JM" <email@example.com> wrote:
> Does anyone know if filenames can be longer than 31 characters in Office
> 2004? Thanks.
FIrst, you *can* have filenames longer than 31 characters in Office v.X
already - you just can't generate them. While v.X apps display a hash at
the end of a long filename, it keeps the filename intact when you save.
MS hasn't announced anything regarding long file names in 2004 ye...What is the _T() Function for?
What is the _T() function? How do you use it? What needs to be included to
allow use of it?
Thanks a million.
Oops, forgot. It is defined in tchar.h, which is implicitly included in all MFC
On Thu, 03 Jul 2003 21:29:00 GMT, "CLEAVEAGE" <firstname.lastname@example.org> wrote:
>What is the _T() function? How do you use it? What needs to be included to
>allow use of it?
>Thanks a million.
Joseph M. Newcomer [MVP]
MVP Tips: http://www.flounder.com/mvp_tips.htm
...How to remove contacts when email changes
If I receive an email from a sender not on my list, that sender's email
address is not automatically added to my contacts but will appear on the
automated list when I enter the first letter of the sender's email address.
If that sender changes email address I cannot delete the old email address.
Instead I am left with two email addresses for that sender both of which will
appear on the automated list. How can I remove the old email address?
You seem to be confused. Receiving an email does not add an address anywhere
in Outlook. Sending an email might, a...Multiple AND OR functions
Is it possible to make this function work?
I need to find out if Cell B9 = Z and if Cell AE9 = 35, if this true then
check cell J9 and check if it equals 1, M or C then return the value as 1000.
(that bit works OK)
I also want it to check if an alternative statement is true if the first is
false whereby it checks the the same set of cells but this time, check if B9
=A+, if Cell AE9 = 35, if this true then...creating a function for dividing two columns
I am trying to keep track of softball stats. I trying to make a column of
batting averages. I have at bats in column b, hits in column c with the
results in column d. I cant get the function right so it will display the
use this =SUM(C1/B1) in cell D1. Format D1 as a number with 3 decimal
"cflan" <email@example.com> wrote in message
> I am trying to keep track of softball stats. I trying to make a column of
> batting averages. I have at bats in column b,...VBA project password
I've locked one of my ms access vba project by password for sometime and now
i forget abt it, are there any utilities can review maybe just 2 charaters
or more ? if i can know that i can remember. Thanks
"Daniel" <firstname.lastname@example.org> wrote
> I've locked one of my ms access vba project by password for sometime and
> i forget abt it, are there any utilities can review maybe just 2
> or more ? if i can know that i can remember. Thanks
Did you Google on all the words "Access" "password" and "recovery&qu...can comment indicator color be changed?
Hi when you put a comment in a cell the indicator is red but I have cells
that are conditionally formatted to come up red if out of spec and can't see
the indicator. Can the color be changed and if so how please. Thanks Karl
AFAIK, no, you can't change this. Maybe you can change your CF color. Bright
On Wed, 27 Oct 2004 16:27:02 -0700, "Karl" <Karl@discussions.microsoft.com>
>Hi when you put a comment in a cell the indicator is red but I have cells
>that are conditionally formatted to come up red if out of spec and can't see
>the indic...Change QuickFind to search contains
Is there a way to change the QuickFind to use the contains operator
rather than begins with? Custom dev or third party recommendations
simply put a wildcard * in front of your search term in the query box and it
will match the defined search fields for that entitiy type on a 'like"
...Counting of Names ?
I have some names in some cells like " Abraham" " Sathish " etc . I
want the number of occurances of each name Counted ,within a range of
cells and made known at a perticulat cell
Name No of Times
Put the unique names in a column and use (eg)
If you want a fast way of extracting the list of names see:
Norman Harker MVP (Excel)
Excel and Word Function Lists (...map data (x-y axis) with diffent series name
I have a set of x-y coordinate data set and i would like to plot them showing
the respective series name. Is there an automatic way of doing this without
haing to plot the data points separately. eg
Name x y
A 1 6
B 2 3
C 3 4
D 4 2
E 5 5
.. . .
.. . .
.. . .
I will like to have a plot of x and y with A, B, C as series name without
having to plot the points one after the other.
Here are a couple of free addins that allow you to link data labels to
Rob Bovey's Char...i can change the font on the screen to be large but can't print t.
i am trying to make the print on my spreadsheet larger. i can change the
font on the screen but it still prints the smaller font?????help!!!!!!!!!!!!!!
Maybe in the Page Setup you have this setting
"fit to1 by 1 page"
Regards Ron de Bruin
"tj" <email@example.com> wrote in message news:244325C6-A407-4CD8-BE76-75AB3C93A78A@microsoft.com...
>i am trying to make the print on my spreadsheet larger. i can change the
> font on the screen but it still prints the smaller font?????help!!!!!!!!!!!!!!
...Display Field Name as Text Listing if Value True from Checkbox Fields
I have 40 or so columns in a table using the yes/no data type. Each
record in the table represents an audit of a paper form. Those items
filled incorrectly or incompletely on the paper form receive a check
on an access form during the audit process.
I would like to create a feedback form based on the audit record that
displays a listing of fields that received the check boxes, or rather,
were incomplete or incorrect on paper form that was audited.
On the feedback form, I only want to display something like this:
"Your form had the following errors:
Erro...Error with VBA code
I am having error with this statement. Do anyone know what's the error
with this line:
..CheckBoxes(i).Value = False
Dim i As Integer
For i = 1 To 19
..CheckBoxes(i).Value = False
I would guess that you have fewer than 19 checkboxes.
<firstname.lastname@example.org> wrote in message
|I am having error with this statement. Do anyone know what's the error
| with this line:
| .CheckBoxes(i).Value = False
| Dim i As Integer
| For i = 1 To 19
| .CheckBoxes(i).Value = False
| Next i
I have about 20 columns in an Excel spreadsheet that
contain name, address, etc. in various forms of
capitalization. I believe I can use the proper fucntion
to capitalize the first letter of each work and make all
other letters lowercase.
My question is how do I do this for a series of columns,
or selected columns all at one time. I see to be getting
an error message related to a circular pattern or
something like that
Any help is much appreciated
If Columns A through T are the columns you want to change, then you nee
U1 to say:
Drag that column to t...Changing header and footer details in queries???????
Reports are simple in design view but queries are what I am interested
I have not found a way to alter the header information in a query
other than to turn it off.
Is there a way to add information????
open the query in design view
put the cursor in a column of the query
open the query's property dialog
in the row for Caption, type the name to show for the heading for that
To do this in a more automatic way,
create a calculated field for that column by putting the heading followed by
a colon in front of that field
Field called ODate
in the row...Using INDIRECT in named range for chart data series
I recently read a post that described how to use the indirect function to
define named ranges for a chart series. I attempted to do the same, but still
get a message from the data series editor that my formula contains an invalid
reference. This is the formula for the series:
and Time is defined in the Data worksheet as:
Load is defined as:
Where the values in Q6, Q7, Q10, and Q11 refer to the desired starting and
ending addresses of the seri...GP 9.0 Modifier/VBA Cannot close lookup window
The look up window ( VendorDetail(Grid) ) for vendors still open when close
the vendor’s maintenance window.
I tried this:
Private Sub Window_AfterClose()
If VendorsDetail.IsLoaded = True Then
VendorsDetail.IsLoaded = False
But I had
Method or Data member not found.
Any idea to close this window after VendorMaintenance close will be
Regards for all of you
what i followed from your question here is you want to close the lookup of
the vendor list when you close the window of vendor maintenance.