How to recover if a user "Undoes" a record?
When the AfterUpdate event of my Status field is triggered, I update several
other tables with dependent data. What happens if someone hits ESC twice to
Undo the record? Is there some way I can know that this happened? Then I
could roll back any updates. Btw, the Form_AfterUpdate event doesn't seem
applicable since one of the things I do is set a DateCompleted field on the
form itself. Any ideas or suggestions would be welcome.
You could trap the keystrokes, but it might be a better idea to use the
AfterUpdate event of the form itself to update the other tables. That event
only ...Trying to find out which numbers occure most often
I�m giving exams to students and want to see if the students are missin
the same questions in every class. I have a simple spreadsheet tha
has me enter the question number into the column each time a questio
is missed. The MODE function can tell me which number is occurrin
most often. However, I need to see if there is any other numbers tha
are occurring often as well.
Is there a command that will allow me to look at the second mos
entered number? For example, if I have 5,3,3,2,3,4,3,4,1,3,4, my mod
would be 3 as that�s the number that repeats the most. However,
happens 3 times and that...Crash on 'Send"
My wife's Intel Celeron running ME started having this problem
sporadically - now constantly.
Outlook 2000 receives OK - everything seems fine until you hit the 'Send'
button then Outlook crashes giving an error message that says 'Outlook has
caused an error in <unknown> and has to shut down. If the problem persists
you may have to restart your computer.'
Re-starting however has no effect.
I have re-installed Office. Used 'Detect & Repair' under the 'Help' tab, and
installed all patches/updates from the Office site. But this error
continues, now...Can I send a recurring e-mail automatically each week
I want to send a e-mail with the same verbiage to the same person once a week
and make it a recurrence with no end date. Can I set this up once in Outlook
so it is scheduled automatically?
Microsoft Office 2003 Version
Students and Teachers Edition
Windows Vista Home Premium
Happy new Year!!
...Recieve Mail Before Sending
How do I set up Outlook 2003 to recieve mail before sending
Set your send/receive group settings to receive and not send. Or are you
talking about setting authentication?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer:
Keith <firstname.lastname@example.org> asked:
| How do I set up Outlook 2003 to recieve mail before sending
...Exchange 2003 new install can not receive external email.
I have just setup a new Windows Server 2003 standard edition with
Exchange 2003 standard edition on it. I have been working for a while
trying to get it to receive external email. I can send out and send/
receive internal messages, but when someone trys to send me a message
from outside our network they get the following returned mail message
This Message was undeliverable due to the following reason:
Each of the following recipients was rejected by a remote mail
The reasons given by the server are included to help you determine
each recipient was rejected.
Recipient: <**...cant start outlook pst file to large
Hi I hope somebody may be able to help im new to outlook and now I cant start
outlook message says cannot open your default email folders pst file its too
large as I cannot open outlook I cannot delete old folders
See if this helps: http://support.microsoft.com/kb/296088
Ben M. Schorr, MVP
Roland Schorr & Tower
Author: The Lawyer's Guide to Microsoft Outlook 2007:
"Ray" <Ray@discussions.microsoft.com> wrote in message
news:B3B824DC-3C9B-4B1B-8EF3-61...Help with income/expenses
Running 2003 in home page I setup income and expenses I prefer to see one
whole month. Money some how shows it as 1/22/2006 through 2/20/2006 any way
to fix this?
----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
we have one client pc with Outlook 2003 where the following problem
if a mail is replied from a user created sub folder of the inbox, the
reply will not appear in sent mails, but will end up in the same sub
folder, sender and recipient appear as identical. The mail goes out
properly though, it's just that Outlook sets internally sender =
recipient and bounces the reply back to the subfolder in which the
original mail is stored.
This happens on a Win 2000 machine with SP4 and all updates, the other
clients use Outlook 2000 or XP and there is no such problem.
There are no ru...hyperlinking email addresses
I have a list of email addresses that have hidden text before the first
letter of the email address. I tried all the functionalities to get rid of
this spacing/hidden text, but, it does not work. Now I am trying to
hyperlink the email addresses, how do I do that?
Most likely a non-breaking space...........char 160
CLEAN and TRIM will not pick it up.
What: Alt + 0160(on numpad)
Gord Dibben MS Excel MVP
On Sat, 9 Jan 2010 13:44:01 -0800, CharlesZ
>I have a ...help with simple maths in excel
I want to do a simple arithmatic excercise in excel for my grand daughter.
It is stuff like 2+2 =4
Smart me has hit a problem at the first hurdle...
I need to put 2 in one cell the + in another cell and then 2 in another = in
another and then she puts the answer in the next one. So the above would
have 4 cells completed and she would put the answer in the 5th one.
When I use the + or = sign in a cell of its own it (excel) thinks I am doing
an equation, is there a way around this?
I will work on the answer like if she gets it correct or wrong how I will do
that...a sound or som...HELP! Need to export hourly sales data on POS (NOT RMS)
How can I export hourly sales data across a date range? For instance, I
want to show hourly sales for the month of October so I can graph it and
post it in our break room.
If I can't export hourly data, can I export daily sales?
The built-in reports don't address this data format.
This is a multi-part message in MIME format.
Mark, This should work for you. Keep in mind it takes up to 5-10 minutes to
load...Unlocking a User
I have GP10 and a user entered a password wrong too many times. I am logged
into GP and an under 'Admininstration' and do not see a way to unlock the
user. Am I in the right place? Where do I need to go?
Are you enforcing password policies for your users in GP? If so, go to
Microsoft Dynamics GP > Tools > Setup > System > User. Enter a temporary
password for the user and check the Change Password Next Login box. Provide
the user with the temporary password and the system will do the rest.
Again, this is all assuming your are enforcing pas...Find prev record on other requeried form
Using access 2003. I have a main form for name and address info. A subform
shows limited info on client placement.
Click a command button on the main form and user opens another form for full
screen entry of placement data. That form opens showing the client selected
on the initial main form.
When the full screen placement form closes, it requeries the original main
form with the placement subform to show the added placement. It goes to the
first record in the table though. It does not show the original client whose
placement was just added.
How do I set the mai...Need help with Auto Filter
I have a spreedsheet that is filtered in multiple columns. I am running a
"Subtotal" function to count certian rows when I filter the column. My
question is this. Is there a way to save or freeze the data that the
subtotal function counts in a different cell. In other words I want subtotal
to count everything in a particular column but I want to be able to save that
number somewhere so that when I filter again with another variable I am able
to still view the first subtotal to compare the two. I hope this makes
sense and thanks in advance for any assistance you can provi...HELP! remote data not accessible msg
I have a use who is currently using a Bloomberg DDE add-
in. Whenever he attempts to activate the add-in to
retreive remote data, the system hangs. If I go to task
manager, I then see a message stating "Remote data not
accessible. To access this data Excel needs to open
another program.... I have searched the knowledge base
and didn't find much help. Does anyone have any ideas? I
am desperate!!!! We are currently using Excel 2003 in XP
...Help with a simple database
I am attempting to use Excel to develop a simple database for my office.
The database basically lists a variety of orders purchased from various
vendors, and my goal is to categorize and sort each vendor seperately.
GC Group 4/24/03 7831.1 $1,000.00
Alpha 1/20/03 7003.1 $2,000.00
Chandler 5/6/03 7050.1 $345.50
Is what the main chart looks like. Now, what I'm trying to accomplish
is, suppose I added
Tomsen 4/20/03 7873.1 $200.00
to the very bottom, Excel would automatically create a new tab (or even
worksheet, if possible) tit...Looking for help on timing within a function
At the facility I work, our associates use a very basic access database to
sign out individual work orders on an interval of around every 12 minutes.
They have asked if it would be possible to put a timer on the front page of
the database to show how long they have been working on the current work
order, updating each time they sing out another order.
I am not very adept at access nor is the rest of our management staff. Is it
possible to add this function, so they can better keep time of their work
Use the Form Timer event. Here is an example of how it can be done. In this
ex...Email Router Failing with System.UriFormatException: Invalid URI:
I cannot seem to get a handle on this, even with a very basic email workflow
The rule is simply to watch email@example.com. If any email goes in, send a
notification email to firstname.lastname@example.org
The Server has the following error. Anyone have any ideas?
Event Type: Error
Event Source: MSCRMExRouterService
Event Category: None
Event ID: 0
Time: 4:01:50 PM
System.UriFormatException: Invalid URI: The hostname could not be parsed.
at System.Uri..ctor(String uriString, Boolean dontEscape)
at Sy...Incoming email slow to come in
Don't know if anyone can help, but here goes. We are running an
Exchange 5.5 server and I am running Outlook 2003. Email that is sent
to me internally is very slow to arrive (up to 30-45 seconds),
including email I send to myself. Nobody else in my immediate vicinity
is having the same issue, their email arrival is instant. We have
reviewed Outlook settings and they are identical. One strange thing is
this: If I send myself an email, don't do anything, it will come in
within 30-45 seconds. However, if I send myself an email, then
immediately send another email both of them will ...Can anyone help ?
I have created a holiday planner for staff with in are company
and i need a formula that gives us only 10% of the total number of staff are
off on holiday.
would be greatful if anyone could help.
Hello - If you have a total somewhere (I would suggest inserting a column on
your spreadsheet titled Total and then entering a "1" if the person is going
to be out, then total the column of "1"s by entering "=SUM(x:y)" where
x=first cell in the range, and y=last cell in the range), in a different
cell, enter "=.1*z" where z equals the total of people out...Need Query Help
I have two tables, Table A & Table B, in my database that have the
same fields (Name, SSN, etc). Most of the records in both tables are
identical, but each table has some unique records. I would like to run
a query that will select the unique records in Table A by comparing
SSNs, and then do the same for Table B.
I am a database novice, and have tried all the wizards and expression
builders with no luck.
Any help at all would be appreciated. Thank you!!!
Casa Grande, AZ
The "Find Unmatched Query Wizard" is what you need. If you only want to
check for SSNs ...Outlook freezes after sending one email after upgrading 4.0
We just upgraded from 3.0 to 4.0 this weekend. All client machines have had
the desktop client upgraded and 2 have the same issue. One is XP with Outlook
2003 and the other is Vista with Outlook 2007. Open opens and the CRM addin
initializes correctly. As soon as you compose and send an email, Outlook
locks up and you have to kill the process in task manager to close Outlook.
I've had the same problem and have tried all I can think of...how did you fix
> We just upgraded from 3.0 to 4.0 this weekend. All client machines have...Excel Problem
I have a 23.8 meg excel 2000 spreadsheet set for manual calculation saved to
my local hard drive. Every time I try to open it, it takes forver and
sometimes never opens but I do not get any error messages, let me just tell
you that I am running a P4, 1 GB memory, Office 2K with SP3, and nothing else
running when I try to open it. As I said it is set for manual calculation,
and it is cleared to not auto calculate when opening or closing. Any idea's
as to why this is happening?
I don't know why you're having this problem but I would like to point
something out for w...Is there a way to schedule a email to send out at a certain time?
I tried delay the mail, but the sent hour is not right.
For example, the email should go out at 8am, but the sent time is 5:30pm
which should be 8am also. Please help!
"Grace" <Grace@discussions.microsoft.com> wrote in message
>I tried delay the mail, but the sent hour is not right.
> For example, the email should go out at 8am, but the sent time is 5:30pm
> which should be 8am also. Please help!
The Sent time and the delivery time are completely separate. The Sent time
that people will see w...