Recalculate a field when another field's value changes
I know I have asked this one before but so far I haven't found anything to
I have the following fields I'm working with; they are all on the same
which comes from a query.
TotalTuitions is calculated by the sum of (4) other Tuition fields. I have
a check box to trigger the calculation of the MultiClassDisc field which
works off of the following code.
If MultiClass.Value = vbTrue Then
MultiClassDisc.Value = TotalTuitions * 0.1
MultiClassDisc.Value = 0
It works Ok.....when I check the ...Is there any italian user?
Is there any italian user?
How to adapt MS Money to Italy?
...Change lookups so that by default they don't show inactive record.
When doing any lookup in Great Plains it defaults with all master records.
Would like by default only active records to show up.
SmartFill from Rockton Software can do this.
"Catherine McDade" wrote:
> When doing any lookup in Great Plains it defaults with all master records.
> Would like by default only active records to show up.
...User in more than one user class?
Is it possible to add a user to more than one user class?
We have a user who will temporarily need the accesses of another user class
while retaining her current accesses. The only method I saw for adding the
accesses is to do them individually for the user. Is there a better way to
Perhaps adding the user to the second user class temporarily or create a new
user class with the accesses of the two classes in question?
For versions 9.0 and prior a user can only be in 1 security class at a time.
Dynamics GP MVP
Flexible Solutions, Inc.
"d...All User Global Address List
I have modified the security settings for the all user object in the global
address book. This was done to stop users from reading from it
The problem is that no one can read from it, that includes the exchange
IS there a way to restore the default security setting for this object I
have tried the ADSI tool but this cannot access it.
Would appreciate any help. Thanks!
How did you change it the first time? You can't undo what you did?
Celebrating a decade of Exchange peer support
"Phillip Davies" <Phillip Davies@discussions.microsoft.com> w...Migration
Problem : After the migration, a user X with outlook can access to their
mailbox X but the user Y can't access to mailbox X. The users rights are
I migrated Windows and Exchange 2000 to Windows and Exchange 2003 (Creating
of a new windows Intranet 2003 with a new servers, new forest and new
Before the migration the mailbox X (or agenda) was shared. A user Y could
access to mailbox X.
- wizard Exchange Migration
- wizard Clean Active directory
After the migration, on the new network Windows 2003 a user X with outlook
can access to their mailbox ...Show two value ranges on one axis
How do you show two value ranges of the same data on one axis? (the axis
range is separated by a zigzag/heartbeat style line). e.g. instead of showing
0-50, the axis could show 10-25 and 40-45.
Any help appreciated!
Take a look at Jon Peltier's Broken Y axis example.
"NOKIA" <NOKIA@discussions.microsoft.com> wrote in message
> How do you show two value ranges of the same data on one axis? (the axis
> range is separated by a zigzag/heartbeat style l...Paste Function box
I notice that in the paste function box that there are over 40 in the user
Half of them are duplicates.
1. I presume they are functions from add-ins??
2. Why the duplicates?
3. Can the duplicates be deleted and if so, how?
I would also like to know how best to use a User defined function that I'm
currently using in a workbook (that was created through this NG - thanks
Dave P.). I notice that if I'm debugging a procedure, that that process
will also run that function.
As I've stored the function in the actual wkbk to make sure that the wkbk
always has access t...How to provide users with a standard config of outlook
We would like to provide users with a start configuration
of outlook. Thinking about:
- Predefined shortcuts to some public folders
- A number of contact folders (public folders) added to
the Outlook Address book
- Would be really great to be able to supply everybody
with the same categories for appointments or tasks
- Standard color coding for items (tasks, appointments
I have no clue how to provide for this. I would think
about a way to export the settings and import them for
the users. But cannot find any way of doing this.
I tried to copy de userprof...Default Printer in GP changes in Terminal Services
We are running GP10 on a Terminal Server. Daily, as we log into GP10, we
have to check/change the Printer in Print Setup to make sure it's the right
default printer that matches the users Default Printer in their RDP session.
The default printer in RDP doesn't change; only in GP10.
We have four locations in four states and use named printers for the pick
tick & pack list to print to the right SITE ID per the order. But we want
the order page to print out at each users default printer (the user who
entered the order).
Is there a way around this without having to set...Average value only for the filtered area..
I have data in the range of cells A2:E1000. The row 1 has the headers to
which i had given filters.
The column E has a numeric value for which an average value is required at
G1 for only those cells in column E which reflect by a filter in column C.
For example, after selecting a particular name using the filter in column C,
it resulted in 10 numerical values, the formula should calculate average
value of only those 10 values and reflect in G1.
Try this in G1
When competing hypotheses are otherwise eq...Running Query Status bar in form
Is there anyway to add the 'running query' status bar (bottom left) to a
form? The form I want to add it to is a 'database busy' form so that the user
is aware that something is running and that the database has not fallen over.
Adding this status bar more visibly to the form would help some impatient
You can have a label on the form, showing the appropriate wording, but
hidden by default, and at the beginning of your code, something like this:
Me.NameOfYourLabel.Visible = True
Steve Schapel, Microsoft Access MVP
> Is there anyway ...Users not showing up All Users
Exchange 2k3 on a SBS 2k3 box.
I went in through AD Users+Computers, and created mailboxes for users.
Two days later, the mailboxes still don't show up in Exchange System
Admin-Recipients-All Addresses-All Users. As a matter of fact, the
mailboxes aren't showing anywhere, and we're not able to send mail
internally(external isn't a factor yet, as the box hasn't gone live).
Strange part is, is that if I right click on All Users-Properties, then
click on the Preview button under the General tab, all of the
users+mailboxes show up.
Is this normal?
And on a second note...wha...Default Wanted -- Plain Text
I'm using Outlook 2000. It currently displays emails as HTML when the
sender has used HTML. I subscribe to several listserves. I want to
stop receiving HTML mail frm the lists. I want to receive plain text
only. How do I do that?
Change your message reading format to plain text. You will not read any email
in html. On the Tools menu, click Options, and then click Preferences.
Click E-mail Options, and then select the Read all standard mail in plain
text check box. If you just want to change only the lists format, contact the
lists and request ...can't change default file location #2
When I click "open file", Excel always open "C:\Program
Files\Common Files\Microsoft Shared\PROOF". I have
changed the "Tools-Options-General-Default file location"
to "My Documents" but still no effect. Please help.
Did you exit Excel before trying again?
>When I click "open file", Excel always open "C:\Program
>Files\Common Files\Microsoft Shared\PROOF". I have
>changed the "Tools-Options-General-Default file location"
>to "My Documents" but still no effect. ...Find Last Yaer's Value
I have a query having two columns.
Now I want to add one more column:
Date Sales Sales(Before 364 days)
01/01/07 xxx yyy
03/02/07 xxx yyy
How can I do this?
Perhaps by using a subquery
SELECT T.Date, T.Sales,
FROM TheTable as T2
WHERE T2.Date Between DateAdd("d",-364,T.Date) and T.Date) as OldSales
FROM TheTable as T
Or by using the DSUM function
Field: DSum("Sales","TheTableName","Date between #" &
DateAdd("d",-364,TheTableName.Dat...cant change default font
I cannot get my default font on composed messages to
change, does not matter which one I select under tools
menu always reverts back to "verdana". set to HTML, not in
plain text format.... and cannot change font under
format/font after message is composed (but not yet sent).
You don't say what version of Outlook you are using? Are you using
Have you selected "Always use my fonts" in the Tools > Options > Fonts menu?
If you are using Stationery, perhaps it's reverting back to the Stationery
Just a thought
"LB" <an...OMA Error for some users
I have an error logged for some users trying to use OMA.
The user have an error "Domain Controller offline" and this event is logged
on the Exchange 2003 FE (running Windows 2003).
An idea ?
Event Type: Error
Event Source: MSExchangeOMA
Event Category: (1000)
Event ID: 1904
Unable to connect to the global catalog server. To fix this problem, verify
that network connectivity exists between this server and the global catalog
servers. Also, verify that the global catalog servers are working properly.
For ...Moving user data from Exch2K org to Exch2K3 org?
Hopefully an easy question:
If I want to use Exmerge to first extract data out from old Exchange 2000
server in a Windows 2000 AD and then import the .PST files into a completely
different Exchange 2003 server on a different Windows 2003 AD, then which
versions of Exmerge do I use?
Like this: Exmerge from Exchange 2000 SP3 to export into .pst files and then
the Exmerge that is part of Exchange 2003 to import the .pst files to
mailboxes on the Exchange 2003 server?
Is this the correct way to do it, if there are no connections or trusts or
connectivity between the two domains/Exchange orga...Select Case fails to fire with Data Users
Win2000 and Access 2003
I recently fixed the clutter of my form designs by going to a single
subform control and a tab control. The subform has a null source
object value which then gets loaded via the tab control's OnChange
Private Sub TabCtl_Change()
If Me.Dirty Then Me.Dirty = False
Select Case Me.TabCtl
Me.sfrmCtl.Visible = False
Me.sfrmCtl.Visible = True
Me.sfrmCtl.SourceObject = "sfrmLocationsLocationIDs"
Me.sfrmCtl.LinkMasterFields = "txtLocationID"
...How to delete a user from AD without CRM troubles?
Can you state the recomended procedure in CRM before a user is deleted from
the AD (eg. when someone leaves the company) so that there will be no
troubles in CRM?
Is there a way to retrieve the license of a user that was deleted from AD
before been disabled in CRM?
SiEBEN Innovative Solutions
������� ������ 28, 141 21, �. ��������, �����
���: +30 2 10 2724433 Fax: +30 2 10 2724439
here is a procedure:
1. Remove CRM license of the user
2. Disable the user in CRM
3. Delete the user from the AD.
"SiEBEN Innovative Solutions" <newsgrou...two CRM User to one AD user
I Have in MSCRM 30 two users which are connected to the same AD User. The
users in MS CRM has the same names two. No I Have a problem with the repair
fuktion of MS CRM, the protokol says it is one of this User in MS CRM. How
can I delete one of the two users in MS CRM.
Thanks you a lot for your helping!
...Setting Default Search Folders in Advanced Find
Each time i use the advanced find to search for related messages it searches
the Inbox, Sent Items and Mailbox folders by default. Is there any way to
change this default setting? i'd like to have it only search the inbox and
sent items folders unless i tell it otherwise.
Which version of Outlook are you using?
Advanced Find will only look in your currently selected folder by default.
In Outlook 2003 and previous it also included your subfolders of that folder
Since Outlook 2007, this default has changed and will not include any
subfolders unless you configure i...Restrict Users to Their Information Only
Here's a newbie question? I have a database that is used by several people
to log their work. Unfortunately, every one can see everybody elses work log
items. I would like for each individual user to only see their data and no
one else. Also, the supervisor of each individual would need to see all of
his or her employees work log items. What is the best way to do this? A
query or a linked database.
> Here's a newbie question? I have a database that is used by several
> people to log their work. Unfor...User Cant Create Items in Public Calendar
We are running Windows Server 2003 Small Business Server Edition with
Exchange 2003 version. One of my user cant create entries in Public
How can I fix it? Please help.
Have the user right click the pf, properties, go to summary tab, what
is the permissions that the user has?
James Chong (MVP)
MCSE | M+, S+, MCTS, Security+
On Mar 14, 12:58 pm, "ITPro07" <akun...@gmail.com> wrote:
> We are running Windows Server 2003 Small Business Server Edition with
> Exchange 2003 version. One of my...