Running Sum Query
> Q.1: I have table "HMADetail" That has fields as
> Date Lot# SubLot# HMAPlacedToDay HMAPlacedToDate .......
> (1) (2) (3) (4) (5)
> I Have not created Query table from this table but created report with
> fields (4) and (5) same. I set property for Field (5) with Running Sum
> Overall. This report works good. But it writes all records from begining date
> to end date. I need The end date records only. How do I get this without query table?
> Q2: If I have to creat ...How can I add TERMS field to PO list report (store ops)
In store ops 2.0 there's a purchase order list report - I want to be able to
filter by the TERMS field which is not included in the default filter; how
can I edit the qrp file to add this option? Thanks
hi, add the following code anywhere on the .grp file to get the terms printed
FieldName = "POTerm"
DrillDownFieldName = ""
Title = "Title"
VBDataType = vbString
Formula = "MAX(PurchaseOrder.Terms)"
ColHidden = false
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1320
GroupMethod = groupmethod...how can you chane the font size in a combo box?
wondering if their is a way to change the font size of text in a Combo Box?
You can't change the font property of a combo box from the Forms Tool Bar
but this property is available if you use the combo box control from the
Controls Tool Box.
"Missile" <Missile@discussions.microsoft.com> a �crit dans le message de
> wondering if their is a way to change the font size of text in a Combo
...Help!Can't send mail in Exchange 2003
I running exchange 2003, I can got email from outside and very quickly, but
when i send email,it's seems exchange only put it in the queue but not send
out and after 2 or 3 hours, it sent out(one case it restart the server).I
just run routing group connector on server and route all outgoing mail to
other server(but the mail hanging on this server queue),is anybody can
What is the reason for messages to sit in the queue?
Anything relevant in App or Sys Event logs?
> I running exchange 2003, I can got email from outside and very quickly, but
> when i send ...what templates can be used to create a product user guide?
i need to make a product user's guide for a computer subsystem. i've been
told that publisher is good for this. I cant find the templates that would
create teh actual text pages, or am i looking for something that should be
done is word; just using publisher to make a fancy top cover page???
What version Publisher?
Publisher 2003 has a catalog feature.
Mary Sauer MSFT MVP
"Carlucci812&qu...CRM -- can I add USER role to CRM ADMIN account?
Can someone tell me how to change CRM administrator account rights so that
account would also include CRM user rights?
Our CRM admin account does not have USER access to CRM, which I believe is
the default behavior.
For testing/learning purposes, I'd like to add CRM USER rights to the of CRM
admin account , so that it can have combined ADMIN + USER rights in one
since we are still waiting for user CALs -- this would greatly help us with
learning our newly installed CRM 3.0.
And, can I create another CRM admin account without a need to purchase an
...Can't stop Outlook 2003 from sending read receipt response.
I mistakenly selected "yes" to sending a read receipt response sent to
an email account in which I cannot send email, only receive with Outlook.
Now, Outlook keeps trying to send the response but cannot connect to the
server. How do I stop it? I don't know where to look to delete the
response since nothing is in the Outbox.
This should help you out:
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to ...Validation Rule
I would like to use the this validation rule Is Null Or Not Like "*[!a-
Hwever my data base needs to accomodate spaces between the letters,
but excludes all other punctuation. What do I add and where do I add
You can use the ValidationRule property to specify requirements for data
entered into a record, field, or control. When data is entered that
violates the ValidationRule setting, you can use the ValidationText
property to specify the message to be displayed to the user.
ValidationRule --> Is Null Or Like "[a-z,"" ""][a-z,"...Run a Hyperlink from another cell
I have a master spreadsheet and a cutdown spreadsheet. I have a hyperlink to
a file in the master spreadsheet which I want to link to on the cutdown
At the moment if I click on the hyperlink on the cutdown spreadsheet it
opens the master and goes to the hyperlink cell reference. I want to open
the file from the original hyperlink when I click on the cell in the cutdown
I hope somebody can help.
...I can't send emails 04-23-10
This error keeps popping up and I can't send emails:( Any suggestions???
The message could not be sent. The authentication setting might not be
correct for your outgoing e-mail [SMTP] server. For help solving this
problem, go to Help, search for "Troubleshoot Windows Live Mail", and read
the "I'm having problems sending e-mail" section. If you need help
determining the proper server settings, please contact your e-mail service
The rejected e-mail address was 'firstname.lastname@example.org'.
Subject 'April's Newsletter!'
Ser...Combo box change to run Macro
I have a combo box on the frmAssessment with a list of Assessors from a
lookup table. I want to send an email to the Assessor who's name is
displayed in the box either when a new entry or a change of names when
editing. I created a macro with a condition of [RNAssessor] = "Jane Doe" and
the action SendObject with Jane Doe's email address - similarly for each
The problem I'm having is I cannot get the event to trigger. I tried the
OnChange and AfterUpdate events and they don't work.
Any help you can give me will be much app...running XP Money files with ME Money #2
after backing up XP Money files on a floppy, we could not
get the files to load on an ME computer. Obviously, we
don't know much about compatibility issues. Is there a fix
for this? Thanks
What happened? What error messages? What didn't happen that you expected?
A couple of points a) have you got the same version of Money on both PCs? b)
what Money files did you backup? All you need to move across is the *.mny
Microsoft MVP - Money
mnyukwsh@...How can I add a Gaussian curve to a histogram on Excel?
Trying to add a Gaussian (Normal Distribution) curve to a histogram, but I
dont know how. Any tips or advice?
This may help
"JC1379" <JC1379@discussions.microsoft.com> wrote in message
> Trying to add a Gaussian (Normal Distribution) curve to a histogram, but I
> dont know how. Any tips or advice?
> Trying to add a Gaussian (Normal Distribution) curve to a histogram, but I
> dont know how. Any tips or...Create a re-running rule
I have a case where I'm trying to validate that email is working and I was
trying to create a rule that once or twice a day would automatically send a
generic test email to a particular email address.
Is this something that can be done from Outlook?
JDR <email@example.com> wrote:
> I have a case where I'm trying to validate that email is working and
> I was trying to create a rule that once or twice a day would
> automatically send a generic test email to a particular email address.
> Is this something that can be done from Outlook?
Not by a...What does the message "object can not be found" mean in Outlook
After configuring my email, the tests go through fine. Then, when I send an
email I receive an error message of "object cannot be found". I am not sure
why I am receiving this message or what to do to fix the problem. Any help
would be appreciated.
...Exchange server is running out drive space on C: drive
I inherited an Exchange 2003 server with
2 x 36Gb drives - partitioned 10Gb for C: drive and the rest for files
( these 2 drives are mirrored)
3 x 72Gb drives partitioned 135Gb with a 72Gb hot spare. (this is where
my mail store is held.)
What I need to know,is the safest way to change out the 36Gb drives for
larger ones and not lose the partitioning structures excepting to
increase the operating ystem drive C: to at least 30Gb.
Any assistance would be greatly appreciated.
What is on the 10GB partition?
"Net" <firstname.lastname@example.org> wrote in message
news:1147984760.153...Can't receive e-mails in LAN.
When I'm working in the Local Area Network Outlook can't
receive e-mails. But when I'm working at home, changing
the outgoing server of course, outlook works perfectly.
The strange thing is that Outlook Express work perfectly
inside LAN and at home.
I setup send and receive for every 5 min. And Once a day
randomly, Outlook works and I receive my e-mails
So far I reconfigured my e-mail account in Outlook
several times, but didn't work. What can I do?
Sorry for my english, I'm from Chile
...Outlook 2007 Rule
Have just upgraded to Outlook 2007. I have created several rules that will
distribute emails from specific people into specific subfolders of my inbox.
Now I would like to write a rule that says if the incoming email is NOT from
someone in my address book, send it to the deleted folder. I cannot seem to
find how to apply the NOT from someone in my address book. Any help??
if all previous rules are moving messages, the last rule will be 'move all
messages to deleted folder' put a stop processing on each previous rule.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http:/...Printing only what can be seen
Ok, I have a worksheet or template rather with about 200 rows (each row
size 14 font), each row (after the 7th row) has the same conditional
formats and formulas in the same columns. The conditional formats and
formulas are done such that every cell is a blank cell until data is
entered into a cell on that row.
Now, each day I paste in data, but it's not everyday that all 200 rows
are needed. However, Excel still wants to print each and every last row
that I have those conditional formats and formulas on, despite the fact
that they have no visible data in them. Excel just prints up extra...Schedule a macro running
Is there anyway to schedule a spreadsheet to open and a macro containe
within that spreadsheet to run, daily without user interaction.
Hoping someone has a solution
okanem's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=930
View this thread: http://www.excelforum.com/showthread.php?threadid=38427
How about using the OS scheduler to run that file.
"okanem" <email@example.com> wrote in
message news:oka...Can a liscense be purchased for the Outlook 2003 preview?
Outlook 2003 comes with the Microsoft Windows Small Business Server 2003
Edition Preview Kit. I would imagine that Outlook 2003 works only for a set
period of time, but I wonder if you can purchase a liseence for it annd
enter the registration number.
Anyone know if this is this true?
> Outlook 2003 comes with the Microsoft Windows Small Business Server
> 2003 Edition Preview Kit. I would imagine that Outlook 2003 works
> only for a set period of time, but I wonder if you can purchase a
> liseence for it annd enter the regist...How can you draw a shape when the values change each time??
See example with worksheet Change event proc: http://cjoint.com/?erkFfzkxwN
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect( _
) Is Nothing Then Exit Sub
.Top = Range("Center_Y").Value - Range("Radius").Value
.Left = Range("Center_X").Value - Range("Radius").Value
.Height = 2 * Range("Radius")...Outlook 2007 Rules work and then get forgotten?
I have reset my rules and alerts more than once but still they work for 3
days and then they seem to be forgotten. I then get the "rule (1)", get a
duplicate email and start all over again, and reset - deleting all my rules &
How can fix this problem?
Living large in So Cal
"Laurie" <Laurie@discussions.microsoft.com> wrote in message
> I then get the "rule (1)",
What does this mean? What type of account are you using?
Brian Tillman [MVP-Outlook]
...How can I get the standard back ground color of a form?
I changed the color of my custom switch board form and could not change back
to the form original color as none of the colors in the fill/back color
matches the original color( one which is default when we create a new FORM).
Message posted via AccessMonster.com
"mls via AccessMonster.com" <u55943@uwe> wrote in message
> I changed the color of my custom switch board form and could not change
> to the form original color as none o...MFC can't open dialog box
Hey there. I'm guessing this is just a simple issue, but I've been
away from MFC for a while and need a hand.
I have created a MFC dialog application. This is just a basic rundown
of what I need to do.
The initial dialog box has a button that opens a second dialog box.
Then the second dialog box has a button that opens a third dialog box.
Under the button on the first page I use this code to open the second
page which is created as a resource and called IDD_D1. I don't know
if this is the most idea code, but it seems to work.