imap sent issue
Apply this rule after I send the message
through the IMAP account
and on this machine only
move a copy to a the Sent folder
but it doesn't work... instead all of my messages ending up in "Sent Items"
under my Personal Folders...
John Smith <firstname.lastname@example.org> wrote:
> Rule description:
> Apply this rule after I send the message
> through the IMAP account
> and on this machine only
> move a copy to a the Sent folder
> but it doesn't work... instead all of my messages ending up in "Sent
> Items"...Table Design Issue
I have a database the has a Parts Table and a Vendors Table. what needs to
happen is i need a form that will allow someon to view all the information
about that parts itself and the vendors that supply the part but every
part is available by all 5 vendors for different cost, and i need to
construct tables that when part information is undated or deleted it will
reflect across the board and on the form itself be able to see the vendor
name and the part information for that vendor.
what type of relationships will be involved here
Answered in tablesdbdesign.
...Two network interface cards problem
In my machine,I have two network iterface cards.One for Internet,and the
other for local area network.I want to bind the second card to send and
receive data with UDP.I have try to use bind() function to bind its IP
address,but failed because sometimes I can receive data.Who can help
me,thanks in advance.
bind() does not bind an IP address; it binds a port number, and "binding" means "publishes
to the Internet as a connectable port number".
There have been previous discussions of how to make a port available only on a particular
network segment, but as far as I kn...Address Labels
I work for a small business which has a large number of Excel wookboo
files, each of which holds the details of a customer.
Part of these details are - obviously - the name and address listin
for that customer, with the name and each line of the address bein
listed in seperate cells.
The owner of the business has asked that I build up an Excel databas
of every 2004-2005 customer (well over a thousand), which lists th
name and address of each, in such a way that it can be printed directl
onto sticky labels if necessary.
Needless to say, trying to do this manua...Outlook 2003 New Install Config Issues.
I've just had my PC reimaged and Outlook 2003 reinstalled. My PST file
has been imported and my mail is where it sholud me.
Problems is the veiws had changed from what i had before.
For example, all folders now have gridlines between emails. I know how
to remove these in customise view but is it possible to change the
veiw for all folders at once or do i need to do each folder
"moox7" <email@example.com> wrote in message
> For example, all folders now have gridli...Pivot Table Report: Getting average of difference of two date columns
I have data in excel sheet as:
WORK_ID PROJECT START_DT END_DT
1001 P1 1/1/2006 1/10/2006
1002 P1 1/25/2006 2/20/2006
1003 P1 3/15/2006 3/20/2006
I want to have a report that will give me average time taken to finish a work in a project. That is, I have to take average of (end_dt - start_dt) for a project group. How do I do this in a pivot table report. When I use a calculate field to get the days worked for a work_id using DATEDIF(START_DT, END_DT, "D") then excel computes only sum on that (pivot table report ...Bubble Graph where Both Axis are Categories
I would like to use a bubble graph where the two axis are categories
and not values. Only the size of the bubble will depend on values.
Can anyone tell me how this works?
Thanks for any hints!
...Problem setting BackStyle on Label
I have a problem with Properties on Label in particular, when added by
The sequence below works on CommandButton1 and Frame1 objects but
strangely with Label1
Public Sub addLabel()
Sheet2.OLEObjects.Add "Forms.Label.1", _
Left:=100, Top:=75, Height:=15, Width:=200
Public Sub nameLabel()
Sheet2.Label1.Name = "title1"
Public Sub setLabel()
Sheet2.title1.BackStyle = 0
Sheet2.title1.Caption = "My Text"
Sheet2.title1.Font.Bold = 1
Sheet2.title1.Font.Italic = 1
Sheet2.title1.Font.Size = 12
The one property that doesn&...How do I place two or more charts on a worksheet?
I can't figure out how to keep Excel 2007 overlaying a new chart on top of an
existing chart in a seperate worksheet. What I would like to do is create one
8.5 x 11 worksheet with four 3 x 5 charts on it.
Select each chart and move it into position.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"Rick@Draper" <Rick@Draper@discussions.microsoft.com> wrote in message
>I can't figure out how to keep Excel 20...NET Client calling Axis web service
I have a Net 2.0 client (C# Winform) calling an Axis web service. I can
authenticate, and send a request that is accepted and responded to, but I
cannot see the response.
The return for the call to the webservice is an object. Looking at the SOAP
message that comes in, I can see the response. However when I assign the
response to instance of the object, the result is null. Example:
1. WorkRequestServiceImplService myRequest = new
2. WorkRequestTO workRequest = new WorkRequestTO();
3. WorkRequestStatusTO workRequestStatus = new WorkRequestStatusTO();
...Entering the same value into two table fields at the same time
Say that there is a table which has 2 fields (A, B)
There is a form [Form1] (data entry type) to enter data for A by
There is also one more `TextBoxB` which is Not Visible.
My target is to record the value of (entered thtough `TextBoxA`) into
B field of the table as well.
So I write down a code "Before Insert" of the Form1 that:
" Form_Form1.TextBoxB = Form_Form1.TextBoxA "
It is not recording A values into the field B... Where am I wrong? Can
you help me please?
When I write down the same code into `OnExit` of TextBoxA, it is
yes, ...Change Legend Entry label of "Total" to actual name of field.
I have two pivot charts. One has multiple criteria and when I create a
pivot chart, each series field breaks out properly using the names
provided in the multiple criteria given.
Now, the issue is when I have a single (one) field name, the chart
automatically has the legend entry of "Total" since I am using the
'sum of' option. I've manually changed the name of the field in the
pivot table, but the label on the chart remains the same. I've go so
far as to read several tips on going to the source data to change this
but of course when working with pivot tables, you ca...Two formulas in on cell based on two numbers in another cell?
Not sure this is possible but...I have a cell that has a number range in it
and based on an amount in another cell want to calculate a new range. For
Initial Range: A1 = 10 - 12
Calc Amount: A2 = 5
Final Range: A3 = 50 - 60
I think I can get the results by concatenating two formulas I'm just not
sure how to enter the original numbers (A1) or how to distinguish between the
two in the final formula (A3)
Using Excel 2003. Hope this makes sense. Thanks.
I would put the range in two different cells (eg A1 and B1). Then the
multiplication is easy. If you ...Outlook 2003 asks for password two times
i am using Outlook 2003 and one IMAP account is
configured. everytime i start outlook it asks for the
password two times. it really irritates the users.
do anyone have any idea of why it is doing that.
> i am using Outlook 2003 and one IMAP account is
> configured. everytime i start outlook it asks for the
> password two times. it really irritates the users.
Oh good! Someone else with the same problem. I believe I posted a
question, but no reply. Same situation - Outlook 2003, one IMAP
account, and it asks me the password twi...Registry issue
I've been developing a Service in VB.NET. I set the serivce up to run under
the NETWORK_SERVICE account. I need to store several parameters for the
service to load on start from the registry. I tried to create a new subkey
in the service's ket that is created at install time, i.e.,
HKLM\SYSTEM\CurrentControlSet\Services\MyService. My idea was to create a
subkey called Parameters (like the Windows Time service does) and store my
data there. But I cannot even open that key - it always returns Nothing -
then I get an error missing parameter if I try to create it. So I figure...Weird Issues!
I am facing a rather perculiar problem. I recently added and Exchange 2003
server to an existing 5.5 environment. I followed the checklisted install for
the Exchange Server 2003 for a new installation into a Exchange 5.5
environment. Upon the completed installation and migration the Exchange 2003
server asked if I wanted to delete the connectors and I chose yes.
I then removed the Exchange 5.5 server from the network. Now the Exchange
2003 server is sending and recieving internal mail just fine and also
recieving External mail fine to all the clients......But it is not sending...How do I take two pictures put them side by side to create one
I am trying to create one picture by placing 2 of them side by side.
Use a photo editing program then insert the picture into Publisher.
MVP Microsoft [Publisher]
"coopskat679" <firstname.lastname@example.org> wrote in message
>I am trying to create one picture by placing 2 of them side by side.
> I am trying to create one picture by placing 2 of them side by side.
Insert two pictures. Turn on the Snap to Objects option (Arrange > Snap
> To Objects). ...How do I change the scale of logrithmic curve on the x-axis?
I would like to reduce the x-axis range on a logrithmic curve from 10 to 50,
but I am restricted to a scale of 10 to 100?
A logarithmic scale by definition goes up in decades. You have to use
multiples of 10, by this I mean 0.01, 0.1, 1, 10, 100, 1000 etc. You
cannot use anything else
Jon Quixley's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25803
View this thread: http://www.excelforum.com/showthread.php?threadid=465768
It's true that Excel's chart engine i...Joining two queries
Is there a way to join two queries together?
In query 1, i have Invoice ID, Description, and Total
In query 2, I have the same fields.
I would like to see all the records from both queries. Please advise.
"Tia" <Tia@discussions.microsoft.com> wrote in message
> Is there a way to join two queries together?
> In query 1, i have Invoice ID, Description, and Total
> In query 2, I have the same fields.
> I would like to see all the records from both queries. Please advise.
I believe what you're...Bookmark Issue
I had this working perfectly a while ago, and I've made some change and now
its not working. After my mainform went to the same record as my unbound
subform, my subform would stay on its selected record. Now it goes way back
to the 1st record, very annoying for a list thats 300 records long.
Can anyone advise how to fix this?
Dim rs As DAO.Recordset
If Me.Parent.Dirty Then
Me.Parent.Dirty = False
'Search in the clone set.
Set rs = Me.RecordsetClone
Set rs1 = Me.Parent...Primary/Secondary Axis series count
Hi, I have a VBA function like so:
Private Sub AddSeries(ByVal strName As String, ByVal rngValues As Range, ByVal rngValuesX As Range, ByVal xlAxis As XlAxisGroup)
.AxisGroup = xlAxis
.ChartType = xlLine
.Name = strName
.Values = rngValues
.XValues = rngValuesX
Sometimes I add a series to the Primary Y axis and other times to the
How can I determine how many series are on the Primary and how many on
Applicat...how to switch the primary and secondary Y axis to opposite chart s
Using Excel 2007, evertyime I refresh pivot table data, my charts lose almost
all of the formatting (ex. axis will disappear and chart type will revert
from lines to columns).
Most annoying problem I have when this happens is the primary Y axis moves
from the left side to the right side of the chart, and when I re-introduce
the secondary Y axis, it will appear on the left. How can I easily move the
primary Y axis back to the left side of the chart or switch the two axes?
I've tried choosing Layout - Axes to hide and re-display the axes but this
did not work.
Format the primary cate...rounding issues
I have a simple formula to multiple a cell with another and subtract
from another:=IF(K14<0,K14,IF(K17<K16,K14-K17*K15,K14-(K17*K15))) . I
also have the cell set for currency and two decimals over. The
calculations are automatically rounded up to the nearest $$. how can I
keep that from happening?
First, unless you have the "Precision as displayed" checkbox checked in
Tools/Options/Calculations, the value displayed has only a tenuous
relationship to the value stored.
So you should just be able to specify two decimals in the number format
of your target ce...Printing issue
Operating System: Older version
Arbitrarily whenever I print an Entourage message, the body of the message is now about quadruple line spaced. The message looks fine when I open it up but adds the line spacing when I go to print. A short 7 or 8 line message can now take 2-3 pages to print. Absolute waste of paper and can be very difficult to read! I didn't change any settings. This just 'happened'. But there must be something I can do to get it to print concisely. Thank you.
...Control visability of Label on a report
I have a label box on a report that I have set as Visable=NO.
However when a check box on the form generating the report is checked I want
to change the visability of that label on the report to YES.
Hope I said that clearly enough.
Any help here will be appreciated.
Thanks in advance
On Jun 7, 11:14 am, "Dave" <dave@accessdatapros> wrote:
> I have a label box on a report that I have set as Visable=NO.
> However when a check box on the form generating the report is checked I want
> to change the visability of that label on the report to YES.