Running averageHi Guys,
Been struggling a bit on this so a pointer would be great.
Just a simple example would do..
tableA with two fields "Startdate" and "Amount"
now i need a running average in the query which would give me the following
output:
[Startdate] - [amount] - [average]
1-1-2010 - 100 - 100
2-1-2010 - 50 - 75
3-1-2010 - 60 - 70
So in the average column the last value should be the average of the sum of
the previous records and the current records (being the average of the total).
I know that the fieldnames are...
Recieve Mail Before SendingHow 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 <anonymous@discussions.microsoft.com> asked:
| How do I set up Outlook 2003 to recieve mail before sending
...
docmd.transfertext problemHi,
I am using access 97 and tried to import a csv file to the mdb table. I run
a code as following:
DoCmd.TransferText acImportDelim, "Specification4", "input",
DEFAULT_PATH & "online.txt", 1
In online.txt, there is a field which is 10 digit number and I specified it
as a double datatype in the specification4. After the import, I found out
that the 10 digit number data in the field get empty in the destined table
while other fields are all right. Therefore I import manually using
specification4 instead of running code. This time the 1...
SQL deadlock problemI am currently having a big issue with sql deadlocking on the
PrincipalObjectAccess table.
The last few months I have been working on a synchronization process using a
Biztalk orchestration. The sync uses the crm webservices to create and update
account and contact records in CRM. But now deployment to the production
environment gives me some problems. It seems that when trying to update
account records (which is one of the first actions in the sync process) the
webservice gives me Generic SQL errors and SQL timeouts. After extensive
profiling and tracing in SQL I found that there are...
Transferring over outlook data to new XP machineHow do I transfer over my old emails, address book to my
new XP machine? I have looked over the internet and found
nothing the tells me EXACTLY how to do this, any help
would be greatly appreciated.
senior_tech@yahoo.com
If your using MS Outlook copy your .PST file across and import it into the new install.
>If your using MS Outlook copy your .PST file across and import it into the
new install.
No, don't import it. Simply use "File">"Open"
--
Brian Tillman
Smiths Aerospace
3290 Patterson Ave. SE, MS 1B3
Grand Rapids, MI 49512-1991
Brian.Tillman is the nam...
multiple Domain name delivery problemhi, I currently have Exchange Server 2003 Build 7638:2 SP2,. We have multiple
domain names being delivered to the exchange store. I have nothad any
problems, but i currently have one user that is not receiving emails with
attachments from one certain "internet" sender to one of her email addresses,
but the other address works fine & if they send emails without attachments,
everything works fine from either address. I have had the user send them
message with attachments to me & the user with the problem & i get the
message, but not the other user! I even use message...
Can I send a recurring e-mail automatically each weekI 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
Thank-you
Happy new Year!!
Carl R
...
Exchange update problemI have tried to upgrade exch2k3 sp1 to sp2, but the update fails with "the
file pcproxy.dll is in use, and setup cannot identify the app or srvc. setup
cannot continue"
Any clues/ideas/suggestions? Please.
--
-----------------------------------------------------------------------------------------------------------------------
This message has been checked for all known viruses.
The information contained in this e-mail and any attachments is confidential
and may be the subject of legal, professional or other privilege. It is
intended for the named addressee only and may not ...
Mail lMergeSorry folks. I asked a question and went to the hospital for a while and
the question expired.
I have an address list in excel 2007 and am using word 2007. In my address
list I have a code column which should allow the selection of addresses to
put on labels. I used to have a query section what allows for that but I
cannot find query any more. can anyone help me?
charles
Questions here never expire, though it may become difficult to find the
answer. The previous post received one reply, from Doug Robbins, as follows:
See the article "Mailmerge Labels with Word ...
How can I change 'Normal' Style for Word e-mails to 'Normal (Web)'?Hi, I'm using Word as my e-mail editor in Outlook 2003 and want to change
the default Style for e-mails from 'Normal' to 'Normal (Web)'.
The problem is that new e-mails and replies in HTML format use the 'Normal'
Microsoft Word 'Style', and this has no gap after paragraphs. The upshot of
this is that when sending an e-mail, I have to press return twice to create
a gap, but when the recipient views this, their software shows it as four
gaps (the extra carriage return I typed + their correctly viewed HTML
carriage return after each line).
E.g. I type this:
...
How To Copy MS Word mailing labels into ExcelI have a word doc that I want to put into Excel. I want to add some
more fields to the names and addresses. Is this simple or do I have to
learn how to program?
Michael Rodriguez
City of Grand Prairie
Michael, have you tried to copy and paste the data into excel?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
"Michael Rodriguez" <mrodrigu@gptx.org> wrote in messa...
[Exchange 2003] Mail enabled public folder and sender addressI have a Windows 2003 domain with a native mode Exchange 2003 organization;
there are some mail enabled public folders.
When a user replies to a message in a public folder, the outgoing mail's
sender address is the user's one; I want it to be the public folder's one,
or at least I'd like the "reply-to" address to be set to the public
folder's.
How can I accomplish this?
Thanks
Massimo
You would need to grant the user permissions to be able to Send As the
public folder. By default, when you reply to a message that is in a PF, the
PF is not composing the ...
Strange Access Denied Problem with Windows 7I got a new computer about six months ago that came with Windows Vista
Home Premium 64bit. Before that I had done all of my .NET development
either on an XP Pro VM or my former XP Pro computer at home. Shortly
after getting my new computer at home, I also got a license for VMWare
to be able to test my software on multiple platforms and
configurations.
I had wrote an application originally in VB.NET that was a simple
backup utility. It supports mutiple backup configurations. Any given
copnfiguration would define a backup which would be a list of files to
backup, a list of folders to ...
office 2010 and windows 7word 2010 is hanging (seems on autosave) a great deal, especially with larger
(>3MB) files. it hangs the system and I have to do a hard reboot (power
down). any idea as to why? system is windows 7 ultimate, office 2010.
Right-click My Computer, Disconnect Network Drive.
--
Mary Sauer MVP
http://msauer.mvps.org/
"KPTools" <support@kptools.com> wrote in message
news:0F5ACF22-111A-416A-BECC-8E83543259AE@microsoft.com...
> word 2010 is hanging (seems on autosave) a great deal, especially with larger
> (>3MB) files. it hangs the system and I have t...
Excel ProblemI 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?
--
Todd
I don't know why you're having this problem but I would like to point
something out for w...
SOAP ExceptionHi,
In my C# code, I have defined a Map object which is sent as part of a
request to a web service, here's an extract of the part of the code:
-
Map map = new Map();
map.item = new mapItem[4]
{
new mapItem(),
new mapItem(),
new mapItem(),
new mapItem()
};
.................
But when I submit the request containing the Map object, the compiler
throws an error with the following message:-
org.xml.sax.SAXException: No deserializer for {http://xml.apache.org/
xml-soap}...
Mails not appearing in Inbox although on Server and viewable by colleagueHi all,
I have searched the archives and found a few more or less related
topics to my problem, but unfortunately none of them helped.
Here's my problem:
I know that I recieve several mails at a specific time each day. Those
mails are sent to a colleague of mine and myself but only he recieves
them.
My admins looked on the Exchange Server and all say, that they can
definetely see these emails in the server logs and that the server
delivered them to the right mailbox.
If my colleague looks into my mailbox before(!!) I open Outlook, he
sees these mails as unread in my inbox. As soon as I op...
Pop Up WindowsSeveral sites pop up smaller windows with advertising. The opop up blocker
does not stop these smaller ad windows. How do I stop them?
--
Larry
"Larry" <Larry@discussions.microsoft.com> wrote in message
news:C0B01C98-66BF-4FA5-8CED-0C434CCCFC62@microsoft.com...
> Several sites pop up smaller windows with advertising. The opop up blocker
> does not stop these smaller ad windows. How do I stop them?
> --
> Larry
You don't.
They LOOK like a pop up to you, but the designer that wrote the page made
them not conform to the rules that define the...
Border problemsNot sure why all of a sudden all my borders in my tables created with
Publisher can only be white. No other color will show when selected. Opening
a pub file done on another computer where the borders show color, shows white
only. I have attempted to do a repair on publisher, which gave no help.
Have attempted to uninstalled and reinstall Publisher without clearing the
problem. Anyone have any ideas or suggestions?
Look in the Accessibility Options in the control panel, display tab, disable
"use high contrast."
If that doesn't solve the issue, read the third FAQ here....
Outlook 2002 XP SP 3 Archive problemHi there
I am trying to get my newly configured outlook to archive my folders.
I have ust configured it to download two POP email accounts and that
works fine. I have set up a set of folders below my outlook (Personal
Folders / pst) inbox node and placed the relevant emails in the
corresponding folders. I have gone into tools -> options -> other ->
and pressed the "AutoArchive..." button -> and set the "clean out
folders older than" selection boxes to "3" and "Months" and pressed
the "apply these setting to all folders" button.
I ...
Windows wont start with USB printer plugged inI have now got two club members that can not start Windows if their USB printer is connected.
In both cases the computer goes to the BIOS splash screen and freezes.
In one case it is a Dell Computer with an HP printer.
In the second case it is an HP Computer with an Epson printer.
If you remove the printer USB cable, the computer starts and load the desktop just fine.
Then you can plug the printer cable in and use the printer computer and printer.
But if the printer USB cable is connected, printer power off or on, then the computer go to the BIOS
splash screen. Dell in one case,...
Can not Remove Locitech stuff in XP Add/RemoveI have two entries in XP Add/Remove, "Logitech Desktop Messenger" and
"Logitech Camera Driver". I have tried all the tricks that I can find
including
going into the Registry, but nothing will get rid of them.
I would appreciate any tips that you may have to offer.
...
Redirecting Mail from my Contacts to My Palm TreoI get a lot of spam so I would only want to redirect messages from
sendersin my address book to an external IMAP account (which can be
read by my palm). So the rule is very simple: redirect all messages
that arrive and their sender is in my address book to another mail
address. However, this seems to be impossible given that the condition
"messages in my address book" is only local and the redict command is a
server based action. Any suggetion how to solve that?
Amir
does the imap server support redirection?
--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 i...
Reminders work when Outlook not running?Can I configure Outlook 2003 so the reminders will still go off even if
Outlook itself is not running at the time?
--
Thanks in advance... Bob
Please don't double post. Answered in Outlook General.
"Bob Newman" wrote:
> Can I configure Outlook 2003 so the reminders will still go off even if
> Outlook itself is not running at the time?
> --
> Thanks in advance... Bob
>
>
>
No,Outlook must be open to function. Use a third party add-in, such as
Magic Mail Monitor.
--�
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the disc...
display a notification when new mail arrivesHi
Not sure if this is an Outlook or a Windows question! But here goes. Until
a short while ago, I would get an 'unopened envelope' icon in the systray
when new mail arrived, but now its gone.... Don't think I've done anything
to change this - but it was really useful, so can anyone tell me how to put
it back, thanks
Dear,
Tools, options, preference, Email options, advanced email options, (when new
item arrive in my inbox), mark on show an envelope icon in the notification
area.
--
(Please respond to this question
Was this post helpful to you?)
Hope this helps you...