Anyone use Mailwasher?....
If so does anyone have problems with their outlook form time to time
If so is the kind of problem when outlook won't find your pop servers?
Not sure if this helps, but I love mailwasher...
Turn off your automatic receive. Use mailwasher with 2
minutes or so receive, after you open it when you see new
messages in the taskbar, clean up and confirm THEN press
F9 in outlook to receive mail.
p.s. get the pro version, its worth the 20 bucks!
>If so does anyone have problems with their outlook form
time t...Using Time in formulas #3
Thanks for the link. I found that if I add 0.042 I'll get the nex
hour. Every so often it needs to be adjusted to 0.041 instead.
SPenney's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=107
View this thread: http://www.excelforum.com/showthread.php?threadid=26920
...Using Foxpro from within Ms Excel using macros
Does anyone now how to incorporate the foxpro code "=sys(3050,1,100000) into
a VB macro so that the remote machines I am using restrict
foreground/background buffer memory. The following is taken from Microsoft's
"Using the commands COPY, APPEND, DELETE, INDEX, PACK or SQL-SELECT on a
large table in Visual FoxPro causes long pauses while the data is being
manipulated. The hard drive continues processing the data, but Visual FoxPro
seems to be inactive. This happens because computers that have large amounts
of RAM and are running Windows 95 or Windows NT g...Trying to use the INDIRECT funtion with a relative Row reference
I have a worksheet where I have rows of information. Each row is made up of
several columns of information. I am constantly updating the information by
inserting cells and moving the old cell to the right. I am trying to use the
INDIRECT function to reference the "G" column but I need the row number to be
relative because I sort the worksheet based on the information I get back.
INDIRECT works great until I sort then it is still refering to the row where
the information WAS at. . .not where it is NOW. I hope this makes sense and
any help would be greatly appreciated.
Tha...Access Version being used
This work only if the version of Access matches the version of Excel. How do
you detect the Access version being used?
Private Sub CommandButton5_Click() 'Go to customer database
Dim X As String
Dim nVer As Long
nVer = Val(Application.Version)
If nVer = 11 Then
X = Shell("C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE
If nVer = 12 Then
X = Shell("c:\Program Files\Microsoft Office\Office12\MSACCESS.EXE
If nVer =...I clicked a wrong button...am I destined to never use outlook now?
So I was trying to set up my new copy of Outlook 2007...I clicked on exchange
server instead of web based email system...now every time I open outlook it
says "cannot connect to exchange server" then it gives me the server
location and mailbox name, which I've tried to change...but then it just says
"cannot connect" and shuts down the whole program...how do I get back into
the setup page to fix my blunder?
I even tried uninstalling it and reinstalling it, but I guess that gets
saved? Wierd as all heck....Any help would be welcome....
Tools | A...Filtering reports on null date value
I am trying to create a custom report in RMS Active Reports which will show
me all items which have not sold since a specific date. I've got the
following report filter in my .QRP file:
FieldName = "Item.LastSold"
FilterOp = reportfilteropBetween
FilterLoLim = "8/1/2006"
FilterHilim = "8/31/2006"
FilterNegated = True
FilterConnector = reportfilterbooleanconAND
This filter will show me items which did sell at some time, but have not
sold since August 1. That mean that the item.lastsold date will be poplated
with ...Retreive emails Using MAPI in VB using Outlook 2003
Till outlook 2000 we had a way to retrieve emails by
Reconfiguring Mail Support. Clicking the Corporate or
Workgroup option you can download mails from a VB
application automatically using MAPI and other Outlook
objects without ever opening Outlook.
This doesnot happen in Outlook 2003 and there is no option
like this to set.
Can any one please help me.
Outlook 2003 is already in "Corporate" mode, and MAPI subsystem is
always installed even if you use Pop3/Smtp account only.
MAPI spooler is integrated into Outlook 2002 / Outlook 2003 (it...blank vs. 0 when plotting a dated timescale graph
I have a plot with dates on the x-axis and numbers on the y-axis.
I am importing database data into excel in the first tab, and
referencing that data in the second tab. The problem I run into is
that when the imported cell is blank, the reference in tab 2 displays
a 0 value. This presents a problem for my plot, which is auto-scaled
on the x-axis.
Example case (3x3 table):
x values: 03/01/07, 05/01/07, blank cell
y values: 50, 30, 20
The blank cell is for a future date that has not transpired. The y-
value is known, but the actual date realized is not, until it
(1) M...A useful tool for use with Visio (or almost any program)
For a while I've wanted to create a demo of the operation of some of
my software products and someone recommended a program called Wink for
creating Shockwave Flash files, well, I've finally tried it out with
Visio and it works really nicely. It would certainly provide a very
useful way of showing dynamic screenshots of problems or ways of doing
something that couldn't be shown with a single image file.
I've got a demo of the output from Wink at
and click on the Shockwave Flash demo link
You can get Wink at:
http://www.debugmode.com/win...How to rename messages using rightclick
I might have mentioned this previously, but our office recently got new
computers. The upgrade from Windows 95 to Windows XP came at a
we had to *downgrade* from MS Exchange 97 to MS Outlook 2000. So
naturally some things just don't work the way they used to.
Here's one: in MS Exchange, you could rightclick a message in the
message list and select "Rename" to rename it (you change the subject
line, other words). In MS Outlook, no such option seems to exist (I
even tried the customisation options). You have to open the message,
click on the ...Populate Chart/Graph Using Report Fields
Group: I have a graph that was created from a query which pulls from
linked tables with ODBC. When I create a report, everything populates
correctly in about 10 seconds, but when I try to create a graph using
the same query, Access runs basically forever (over an hour) until I
hit <Ctrl><Break>. The issue seems to be with Microsoft's graph object
and ODBC, so my thinking is if I can create a graph utilizing the text
boxes in a report, then there won't be a link between the graph and
ODBC, only the graph and the report fields. Then I could make the text
My ...Insert data using a query?
I'm not sure if what I'm asking is even possible but here goes. I have a
table that contains employees and the company they work for. I have created
a query on that table to identify those employees who dont list their company
based on their employee id number. Example, employees with an ID number of
2000 - 39999 belong to a specific company, so I use the query to find all
employees with that ID number range and is null for the company name.
Now my problem. I want to use the query to update their company name, since
I know that all employees with an ID number of 2000...How to count the number of values that fall within a range
8 A B C D E F G H
9 This seems to work This seems to double count those that are
between and single count the rest
<10 and >90 >30 and < 70
11 29.65 5.00000 28.00000
13 1.35 Equation in C11
14 97.13 =COUNTIF(A11:A30,"<10")+COUNTIF(A11:A30,">90")'
16 80.75 Equation in D11
17 8.62 =COUNTIF(A11:A30,">30")+COUNTIF(A11:A30,"<70")'
19 53.23 The question is, is there a similar function to counti...Add leading zero to date field for jan thru sep only
I have a field named invdate. this field data shows as 1/01/2001. how can i
write a query to add a leading zero to this date field for the months of
january thru september that will display the field as 01/01/2006?
thanks for your help,
Message posted via http://www.accessmonster.com
"Ricard via AccessMonster.com" <u7122@uwe> wrote in message
>I have a field named invdate. this field data shows as 1/01/2001. how can i
> write a query to add a leading zero to this date field for the months of
> january thru september that wi...use only SMTP / use only POP
I forward several Email accounts to Gmail. Now I would like to receive
all these mails from Gmail (POP) but send my mails via the SMTP server
of the original account providers.
When I try to set the POP server to (empty), Outlook does not allow me
to click 'next'.
Thank you for your help!
derobins <email@example.com> wrote:
> I forward several Email accounts to Gmail. Now I would like to receive
> all these mails from Gmail (POP) but send my mails via the SMTP server
> of the original account providers.
> When I try to set the POP server to...how to write unicode using XMLWriter?
I need to write some unicode symbols such as degree symbol
(for example 36=B0) by using XMLTextWrite but couldn't make=20
it work. I found the degree char in unicode is '\u030A'=20
and here is my sample code:
char myChar =3D '\u030A';
string myString =3D "36" + myChar.ToString();
it doesn't work.
"Linda Chen" <firstname.lastname@example.org> wrote in message news:email@example.com...
> I need to write some unicode symbols such as degree symbol
> (for example 3...Excel Reports Using Access
I would like to use Microsoft Access to store Data, and then use Excel to
produce the reports using the data stored in one Access Table. The data is
already in an excel table, but i would like to transfer it to an Access
table. I tried to import the table into Access but this resulted in an
error. Any suggesstions?
Also, once i get this data into Access, what are some ways to produce
reports in excel using the access data?
Any help would be much appreciate!
for importing the data to Access what error did you encounter?
For using this data in Excel either use ...Compile Error using Dmax funtion
Can any one help me determine why I'm getting a compile error when
using the dmax function?
Dim pk As Long
The line of code
pk = DMax("[OpLogJobDataID]", "tbl_OperatorLogJobData")
Do I need to install a reference or add a public function?
Any help would be appreciated
You need to prefix it with WorksheetFunction.
WorksheetFunction.DMax(..., ..., ...)
You'll note that the function requires 3 arguments, not 2 as you've supplied.
pk = WorksheetFunction.DMax([tbl_OperatorLogJobData], "OpLogJobDataID&quo...I want to bold the title in excel sheet using a VBA
I have done an Email automation program. In this case MS Access repor
output data to an Excel sheet. Then the program attach the Excel shee
to the email and send. All the programs have written in MS Acces
module. I want to bold the title in excel sheet using a VBA code whic
has written in the MS Access module.
Somebody please tell me how to do it...
Thanks in advance.
Jayani's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1681
View this thread: http://www.excelf...Calculate number of days in a column of dates #2
I still have a problem!!! In this list, with your formula, it returns 16
days. But the right answer is 14. Why? How can I have the right answer?
What was the original question?
> Hi again,
> I still have a problem!!! In this list, with your formula, it returns 16
&g...Paste changes ratios to dates
I'm cutting a table from Yahoo! Finance and pasting it into a worksheet. One
of the columns is called Ratio, and it's expressed as 3/2, 2/1 etc. Excel
thinks it's a date, formats it as March 2, 2005, Februrary 1, 2005 etc. and
stores it as a date number. I've tried preformatting the paste target as
text, but Excel is very stubborn, and persists in storing the data as date
number. If a do a paste special, I lose all the tabs, so can't do
text-to-table. How do I force it to paste everything as text?
Could you possibly manipulate your input to change those slashes...What is the overhead of using windows messages?
After getting a running prototype of my packet sniffing app on a production
machine, I have realized that I use the entire cpu under a 40% bus load.
I figured it must be because of all the messages being sent from the CANLIB
driver to my application. It sends a notification message when the receive
queue leaves its empty state. When no clients are connected, my apps then
simply drops the packets. This process itself takes 100% of cpu usage on a
Celeron 3.0ghz. When a client connects, a new thread is created to service
that client. the thread processesing incoming CAN packets then s...date...
how will i classify the dates according to its quarter. lets say
01-25-03 (january 25, 2003) is it under 1st quarter, 2nd quarter, 3r
quarter,4th quarter of the year? what date function should i use? o
what do i have to do? pls help me with this. thanx
here is a sample output..
01/25/03 1st quarter
6/18/03 2nd quarter
12/20/03 4th quarter
Attachment filename: date.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=53551
Message posted from http://www.ExcelForum.com
You can use the following fo...How do I make a poster using 4 sheetss?
I am trying to turn a 81/2 by 11 page into 4 sheet poster?
Use dimensions of aprox 16"x20"
You may have to adjust due to the margins.
"making a poster" <making a firstname.lastname@example.org> wrote in
>I am trying to turn a 81/2 by 11 page into 4 sheet poster?