Do MFC ActiveX Controls have dual interfaces?
Do MFC ActiveX Controls have dual interfaces?
...How do you get the attribute value using XPath in VB.Net 2003?
How do you get the attribute value using XPath in VB.Net 2003?
"aushknotes" <firstname.lastname@example.org> wrote in message
> How do you get the attribute value using XPath in VB.Net 2003?
Prefix @ to the name of the attribute value.
XmlAttribute attrib =
Anthony Jones - MVP ASP/ASP.NET
> How do you get the attribute value using XPath in VB.Net 2003?
...Data Validation using List (But needs unique list in drop down lis
In sheet 1, column A is my title name while column B is person name.
Sheet 1 is my database where i do data entry in this.
In sheet 2, contains my query page. In cell A5, i uses data validation -
list, on this cell. Say in sheet 1 :
column A column B
XXXXXXX Mr A
YYYYYYYY Mr A
ZZZZZZZZ Mr A
AAAAAAA Mr B
WWWWW Mr C
DDDDDDD Mr C
But In sheet 2, cell A5, I saw in the drop down list as follows:
But i want to see this in cell A5 instead (Unique name that is) :
...Use CountIf for a literal string
I am trying to count the number of cells in a range that contain the string
<0.1. I don't want the number of cells that contain numbers less than 0.1, I
want the actual string. Is there an escape character for comparison operators
like the tilde for wild cards?
Microsoft Excel MVP
"chadkwelch" <email@example.com> wrote in message
>I am trying to count the number of cells in a range that ...Posting Date used in Revenue Expense Deferral
I have a PM Invoice with Document Date 16/11/2009 and Posting Date of
Entered Deferral details starting 01/12/2009.
In GL the deferral charges commence 01/12/2009 and are all as expected.
The Credit entry for the full invoice is posted to GL with posting date of
The problem I have is that the Debit entry for the full invoice amount is
posted to the document date of 16/11/2009 and I want it to be the same as the
invoice posting date (01/12/2009)
Is there a way to do this?
...Can't Send Messages Using Outlook Web Access & XP
Our users with Windows XP cannot send messages using OWA. I've read a few KB
articles about some incompatabilities between XP and OWA, but none of the
proposed fixes (using the "basic" rather than "premium" client, or changing
the security settings in IE) seem to solve this last problem. When they
click on "send", it generates an unspecified "error on page". The problem
occurs using IE and Firefox, but just on XP machines. My Windows 2000
machine works fine using IE and even my Macintosh using Safari (gasp!) works.
...How do I specify an address when using "ActiveDocument.SendMail"
Here is my code:
If Not IsNull(([Forms]![Process Bookings]![Booking Form].Form.Email))
Options.SendMailAttach = True
How do I specify the recipients address?
...Could very much use a Field List
I apologize if this is out there already, but it seems that at least a few
field names changed from 1.2 to 1.3. Although I had downloaded a field list
before, from here, I cannot even find that original post, let alone any more
recent that might contain the correct field names.
I need to do some custom SQL and would prefer not to reinvent the wheel.
Thanks in advance very much to anyone who could help.
Do you have MS Access? Make a new project and attach to the database as
your data source.
You will be able to see all the tables and the field names. It has been ...How to Print string (Windows Printer) using RMS QSRules.
A windows printer is set as a receipt printer for a register.
I need to print strings to this printer using RMS QSRules.
How can I do this?
I tried using Register.ActivePrinter.PrintNormal(Station as Long,Data as
String) but it won't work. By the way, what is Station in the parameter?
...Adding a VCard to an e-mail using Outlook 2000 and Outlook 2003.
Hello. I have a question. Does anyone here know how to add a VCard to an
e-mail in Outlook 2000 as well as in Outlook 2003? I want to be able to do
this after I click new and I have a new blank message on my screen. Any and
all help would be greatly appreciated. Thank you.
Outlook provides no way to add a vCard .vcf file in this scenario. The
built-in way to do it is to start with a contact, not a message, and choose
Forward as vCard on the contact's Actions menu.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Admin...Can't use address book
I am not able to add contacts in my address book. I
receive the error: You cannot create entries for this
address book when I try to add a new entry. I use Office
2000, with full Outlook. I would like to have an address
I have uninstalled and reinstalled office 2000 - no
change in the problem.
You get this error in trying to create a new item in your contacts folder?
(sounds like you are select tools | address book | highlight "outlook
address book" and trying to create a new item. you can't create items in
the "outlook address book". this f...Monitoring directories using FindFirstChangeNotification
I would like to monitor a few different directories using
FindFirstChangeNotification. I have successfully used it in the past to
monitor one directory. All the directories I would like to monitor are on
the root of a drive, but I do not want to monitor all the directories on the
the root of the T drive,
How can I montor the T:\Test, T:\source, and T:\Backup at the same time
Thanks in advance.
You need to use the following API's to monitor the changes in
a specific ...Using outlook for email and outlook express for newsgroups
I had outlook set up for my email messages and outlook express set up for
reading newsgroups - now when I go to the newsgroups oe is automatically
checking for email messages and downloading them - this never happened
before and I think the only thing different is that I have installed a
broadband modem and am waiting on freeserve activating my account - could
something have happened to change this, and if so how do I change it back.
"Sharon" <firstname.lastname@example.org> wrote in message
> I ha...Using a OR() like function in an IIF statement
Hello, I am trying to create an IIF statement to test if the first character
in a field is a 1,2,8 or 9.
Something like the following:
IIf(Left([possible_SO_match],1)="1 or 2 or 8 or 9",[Possible_SO_Match],"No
Is there a way to create it without going to a 4 level nested IIF statement?
Message posted via http://www.accessmonster.com
kkulakow via AccessMonster.com wrote:
> Hello, I am trying to create an IIF statement to test if the first
> character in a field is a 1,2,8 or 9.
> Something like the following:
> IIf(Left([possib...Book about MFC
Hello. I want to read a book so I can create programs with Visual Studio C++
2005 that use MFC. I started reading a book "MFC with Visual C++ 5" by Mike
Blaszczak but I realized it is a little bit old-fashioned - meaning they
didn't use Microsoft Visual Studio 2005 and many things are different. Is
there any book that explains MFC with Visual Studion C++ 2005? What would
you advice me to do?
"Tadeusz Jordan" <email@example.com> wrote in message
> Hello. I want to read a book so I can cre...Print dialog box using VBA in excel
I like to add a print button (that will select several worksheets and
print them) in my excel worksheet. I have recorded my action using the
macro recorder the problem is I can't select the printer everytime I
run the macro it print in the background without asking the user to
select the printer and uses the default printer.
Can anyone help?? I just want the user to be able to select the desired
printer every time before printing.
My current code:
Sheets(Array("Sheet 1", "Sheet 2", "Sheet 3", "Sheet 5)).Select
'intent...Using DAO instead of ADO
I have an Access 2000 database that was converted from Access 97. On one of
my users computers, her system was re-installed with Access 2000, and the
database has not worked correctly since that time. If I remember correctly,
we had to set up the computers for these users to use DAO over ADO. It's
been over two years since we did this, and (I hate to admit it - but) I've
forgotten to how to set up the DAO to take precedence over ADO. Can someone
please remind me? I thought it was part of the Add-ins, but when I go into
Add-in Manger, I have NO add-ins available. I've checked i...How do a use a string as a param for a cmdlet when it contains opt
I have a script that cleans out old files, currently it is in this format
write-host "\\sapecc01\Integration\SCC\Archive\* -Include *.txt"
$a = Get-ChildItem \\sapecc01\Integration\SCC\Archive\* -Include *.txt
foreach($x in $a)
$y = ((Get-Date) - $x.CreationTime).Days
if ($y -gt 28 -and $x.PsISContainer -ne $True)
#Keep DESADV for 28 days
write-host "\\sapecc01\Integration\SCC\Archive\* -Include DESADV_*.xml"
$a = Get-ChildItem \\sapecc01\Integration\SCC\Archive\* -Include DESADV_*.xml
foreach($x in $a)
...very simple and useful, email password recovery tool
Outlook Password Recovery is a easy-to-use and wide compatiable tool,
capable of instantly recovering email passwords for popular email
clients, such as Outlook, Outlook Express, Windows Mail, Incredimail,
> Outlook Password Recovery is a easy-to-use and wide compatiable tool,
> capable of instantly recovering email passwords for popular email
> clients, such as Outlook, Outlook Express, Windows Mail, Incredimail,
> Eudora, etc.
> http://www.top-password.com/outlook-pa...can cells apply conditional formatting using the internal clock?
I am using excell to keep track of my production schedule
and I wanted to know if there was a way to tie the cells
in a worksheet to the internal date and time in the
computer,so that the cells will update automatically.
Example: Row A10 would be my production start date, Row
A1 would be my projected finish date, I would like the
cells in between to go from green to red as I near the
finish date without manually inputting the date in each
cell. Can you help me? Thyanks
Set the normal format as desired (I selected a Pattern of Green).
Select A1:A10, then select Format | Conditional Fo...Using Access database to "populate" Excel Sheets
Please help!!! I am willing to PAY anyone who can get this to run fo
I have been trying for 5 days now trying to use a DBVlookup function t
populate fields in Excel. I used examples from 4 different forums usin
this function, but I cannot get any of them to work. I am somewhat ne
to VBA so forgive me if I am not making sense in my questions.
I have Excel Spreadsheet called "Account_Number". It is set up a
Column A is called "Account Number"..... Column B is called "Looked u
description in Access".
Account Number Description...Fonts do not print in colur used when document created.
When I create a document in either Word ot Publisher the text is not always
printed in the colour selected. This problem seems particular to Red & Blue.
can any one help please.
Have you tried some maintenance on your printer?
Are you saving as a PDF? This problem has been reported using Microsoft's
save as add-in.
"Peter Piper" <PeterPiper@discussions.microsoft.com> wrote in message
> When I create a document in either Word ot Publisher t...Windows XP Embedded Service Pack 2 is anyone using this?
Is this something we would be able to use with RMS? Or is this just for
devices? I love the quick bootup.
I use the WEPOS operating system successfully in a number of installations.
Microsoft certified WEPOS with RMS when they introduced version 2.0.
Kinnard L. Kohler
Retail Management Systems of Arkansas
300 South Rodney Parham Road
Parham Place - Suite 1
Little Rock, AR 72205-4747
"Doug Pic-N-Pac" wrote:
> Is this something we would be able to use with RMS? Or is this just for
> de...Need to insert a picture using a function
I would like to know if it is possible to insert a
picture (.jpg) using a function. I have a simple quote
sheet setup for my customers and would like to insert a
picture of the product next to the quote information.
Is it possible to insert a picture based on what i enter
as my product number??
I know this is a vague question, sorry. Someone help
Try this link for a possible solution:-
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03
-------------...Disclaimer using IMSEXT.DLL corrupting SMTP mail
I have installed IMSEXT.DLL and configured it to append a disclaimer to all
outbound messages (article 258206). In order to work for our POP clients, I
also set up the IMS to route all messages through the IS (article 238471).
It works fine for messages originating from Outlook clients.
Messages sent via SMTP from POP clients, or routed through the server via
Custom Recipients get corrupted. Attachments (MIME) also get messed up. The
simplest symptom to describe is that all text styling gets stripped.
I haven't been able to find any more information on supporting non-Outlook