Add Code needed!
If I have four text boxes on my form tbA,tbB,tbC,tbD what code do I need for
tbD to add the other three totals into tbD
Thanks for any help.....Bob
On Thu, 13 Sep 2007 10:35:53 +1200, Bob V wrote:
> If I have four text boxes on my form tbA,tbB,tbC,tbD what code do I need for
> tbD to add the other three totals into tbD
> Thanks for any help.....Bob
As the control source of [tbD], write:
=Nz([tbA])+Nz([tbB]) + Nz([tbC])
The result should NOT be stored in any table.
When ever you need the calculated total, re-calculate it as above.
Please...How do I add a manual button to exit my slide show?
I have created a slide show that I will send as an email attachment. I would
like to insert the button in the lower left corner that can be used to exit
the slide show. How do I do this?
In article <5CAD3D4C-946E-491A-991C-B4B84F5D388D@microsoft.com>, Vonar wrote:
> I have created a slide show that I will send as an email attachment. I would
> like to insert the button in the lower left corner that can be used to exit
> the slide show. How do I do this?
Add any sort of button or shape you like and assign it an END SHOW action
we are trying to x-fer our money 95 to our new system.
If I use backup and restore, I am not sure where to
restore it to.
Money will ask you where to store it. On an XP machine, My Documents is a
"AF" <firstname.lastname@example.org> wrote in message
> we are trying to x-fer our money 95 to our new system.
> If I use backup and restore, I am not sure where to
> restore it to.
...Add text to automatic page number so it shows up in TOC
This is something that has been a problem for me at work for awhile. We have
large documents and use all the Heading styles up, but then we have pages
that need to be numbered "FO-1, FO-2" etc. and have that show up in the TOC
as the page number. Is there some way to add the "FO-" to the page number
field so it shows up in the TOC?
See the following page of fellow MVP Shauna Kelly's website:
Hope this helps.
Please reply to the newsgroup u...Problem creating new users programmatically
I am coding an application with should create new user in AD and their
I am using VB.NET on Windows 2003 with Exchange 2003 SP1
What I am doing now is this:
- Creating new user in AD using DirectoryServices (lately I tried pure ADSI
- Setting its properties and CommitChanges
- Getting its NativeObject and assign it to a CDOEXM.iMailboxStore and try
creating its mailbox using CreateMailbox method.
- After that I set the property "msExchUserAccountControl" to 0 for
Every thing goes fine till here.
In next step I am going to make the user's m...OUTLOOK New Mail Field Availability
I have code when invoked on a new mail item with subject = 3089 and cursor
left in subject field that acts differently (in debugging) when locals myItem
is expanded or not. When not expanded, sr_number ="", when expanded,
How can I accomplish the assignment? It appears the information exists,
just how to get to it??
Public Sub SSP_Req_Notification()
Dim initialSubj, finalSubj As String
Dim objOLApp As Outlook.Application
Dim NewMail As Outlook.MailItem
Dim myRecipient As Outlook.Recipient
Dim sr_number As Stri...naming a new file
For some reason whenever I try to do a "save as" and type a name for a new
worksheet it will only accept the first letter of the file name. If I try to
name it alph.xls it will come up a.xls. any ideas. I have Office 97 on a
Windows XP machine. I never had this problem before. Thanks
There have been a few posts describing the same problem. I searched google and
The last post in the thread suggested an answer. (I think it has something to
do with WindowsXP). I don't think I've ev...Security on New Email Address
I am getting some really dirty spam. I opened a new e-mail account hoping to use the old as a default for when anyone is on the internet so that I can keep the new one clean. When I open Outlook I don't want my email account to open automatically and if I am not there I don't want someone else to access it. However as soon as I open Outlook I am prompted to open my new account and unless I sign in my password I cannot receive mail for the old account, I get a mail error message. How can I keep my new mail private and let others access the other account automatically?
Let's approac...How to move my mail to a new machine
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: pop
I've been using my Mac to work in Entourage but am getting a new MacBook Pro. How do I transfer all my mails to the new machine? <br>
On 2010-06-02 11:56:02 -0400, Beandog9@officeformac.com said:
> I've been using my Mac to work in Entourage but am getting a new
> MacBook Pro. How do I transfer all my mails to the new machine?
Move the Microsoft User Data from your Documents account in one
computer to the same location in the other.
Actually, if you us...How to add Open dialog property to Active X control
I have designed one activex control, in that i added
color & font properties
i have added. I want to add one more property like picture, how can i
add that one.
When i am selecting that property one OpenDialog should come in that i
ll select that picture that should disply on that control.
...Reminders as new email arrives
This is regarding the crop of Oversized file (2 GB
pst) and then getting enormous pop up reminders as new
mail come in.
The Switch of /cleanreminders does not work.
Enormous amount or size?
Dismiss them once and they will be gone.
Tips of the month:
-Create an Office XP CD slipstreamed with Service Pack 3
"Jishnu" <email@example.com> wrote in message
> This is regarding the crop of Oversized fil...attachment add in
I had a free third party addin that allowed you to choose
which type of attachments you want to open. It makes
Outlook work like Outlook express, adds a tab to your
I bought a new computer and don't remember where I got
Have you tried google.com?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the SWEN virus, all mail sent to my personal account will be deleted
After searching google.groups.com and finding no answer, deb asked:
| I had a free third party addin t...can't seem to add a line break in a cell
This is a multi-part message in MIME format.
I'm working with excel 2002. I want to hit enter and create a new line =
within a cell, yet I am unable to do that.
Does anyone have any suggestions?
Meg Darnell, LMT, CD
Director of Alumni Services
Swedish Institute College of Health Sciences
Conte...Add user Icon
I have a CRM 4 Workgroup Edition, with four users.
So, at this time I want to add a new user, but the add user icon in the user
section disappears only show "print, excel, reports...etc".
My user is "System administrator"
There is another way to add users?
Thanks in advance!
...add new domain virtual directory
I have installed an Exchange 2003 in my machine. I have setup my exchange for a domain. But
then I add an additional domain. It works fine but I can't add a virtual directory for this
domain. for example I create mail.newdomain.com but I can't add virtual directory for this
domain. How can I add this domain virtual directory for web access.
Thanks for your help.
"caldera" <firstname.lastname@example.org> wrote:
>I have installed an Exchange 2003 in my machine. I have setup my exchange for a domain. But
>then I add an additional domain. It works fine but I can't add a...Accepting New Transactions
I have merged two accounts and now I have over 1,000 old transactions that
need to be "Accepted." Is there a way to accept all of these transactions en
masse instead of clicking on each, individual transaction?
In microsoft.public.money, DougW wrote:
>I have merged two accounts and now I have over 1,000 old transactions that
>need to be "Accepted." Is there a way to accept all of these transactions en
>masse instead of clicking on each, individual transaction?
In the checking or credit card register left column,
ReconcileTransactions->AcceptAllT...How do I set my default for any new document to 300 dpi?
This is a printer option. If you want the best printing for all your documents do the
changing in the printer & fax folder, right-click your printer, properties...
Mary Sauer MSFT MVP
"gopdx2004" <email@example.com> wrote in message
...Joining a Windows NT Domain from a new computer
I want to join an NT Domain from a fresh computer setup as a BDC but I keep
getting the error "could not locate domain".What could be wrong is there
anything I am not doing right?
The main thing that you are not doing correctly is posting this to the
correct newsgroup. This one is for Exchange; try a Windows/NT newsgroup.
For Exchange news, links, and tips, check:
"Buchi" <Buchi@discussions.microsoft.com> wrote in message
news:00EDA6D8-88DB-4451-B31B-D26DE6FE7667@microsoft.c...transfering data to new laptop
help, I have a new computer and I am trying to move my
existing information (settings, contacts, inbox etc.)
from the old computer. Can this be done?
Rob <firstname.lastname@example.org> wrote:
> help, I have a new computer and I am trying to move my
> existing information (settings, contacts, inbox etc.)
> from the old computer. Can this be done?
Certainly. See http://www.slipstick.com/config/backup.htm
...Moving Exchange 5.5 on NT4 to new Windows 2000 Server.
This is my first post and I'm hoping to get a little advise. Hi.
I need to move Exchange 5.5 running on NT4 Server(BDC) onto a new
machine running Windows 2000 Server. The new server must have the
same name as the NT4 server. There is no AD in the network as yet.
Just a PDC and a BDC(current NT4 Exchange box), plus several member NT
and 2000 boxes.
The new hardware is not compatible with NT4, so I am forced to load
Windows 2000 Server onto it. I'm familiar with the process of backup,
restore, mailbox moving etc, but I do not know the consequence of
doing a backup of Exchange on ...New trend, new business, new year a new beginning
New trend, at start of new year.
"If you want things to work different, you must try a different...whatever..." Does that seem obvious?
Brighten up with this "reading" and attack the money issue with
I am finishing my year 2005 with some regrets and some joy.
For some the year passed has not been "tip top" in their view.
But I believe it has just been very well as the page I shall bring you
that has this statement which I believe wholeheartedly:
"THINGS ARE UNFOLDING AS IT SHOULD" (paraphrased) I invite you to read the whole "poem&quo...EXCEL add-on for multi-way tables. Download the OLAP product.
CODEWORK announces version 8.2 of the 3-way TANGRAM OLAP for the
Excel can read TANGRAM hypercubes with an add-on.
3-way TANGRAM is a self-help or survival OLAP - it caters for the
who has no time and budget to install a major OLAP and yet must
respond to requests
in a time-scale of hours.
The product is very lean (8 Mbytes in the minimum config.) and is
installed by file-copy.
Yet it can handle any typical hypercube problem and features several
operations on hypercubes.
The limits of version 8 are: 250 million cells and 15 dimensions for
eac...New Software Development Articles Directory #2
A new links directory of articles related to software development is
"under construction" on http://www.softdevarticles.com/
Please feel free to use it in you next research and to contribute with
your articles on XML and .NET
...My new edition of office 2007 is missing the outlook platform .
What can I do to get microsoft to correct this and the other problem. I keep
trying to download office templates. And I keep getting a message saying. I
son't have office 2007?
What Office Suite do you have?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
ALWAYS post your Outlook version.
How to ask a question: http://support.microsoft.com/KB/555375
After furious head scratching, Darren asked:
| What can I do to get microsoft to correct this and the other problem.
| I keep trying to download office templates. And I keep getting a
| mes...Outlook 2003 unable to add public folder shortcut to favorites pane
I am running the following environment :
- Exchange 5.5 sp4
- Outlook 2003 sp1 running in LAN mode (not cached mode)
and I am experiencing this problem : when I try to add a public folder
shortcut to favorites pane nothing appens (then public folder is not
added to added to the favorites pane); if I try to add shortcut from my
mailbox works well.