Can't get help for word macros
I am writing simple macros for Microsoft Word 2007. When I am in the
document and want to work on the macro, I press Alt+F11 and that opens up the
macro workarea. If I click on the “Microsoft Visual Basic Help” and enter
almost anything, it is not found. I have even tried simple things like Save
or File and they aren’t found. I have gone into Tools -> References and made
sure things like “Microsoft Development Environment 8.0” and “Microsoft
Development Environment VB .Net” are checked. I know I don’t have something
set right but I can’t figure out what.
Anyone have a...Help with returning records given a date range
I was wondering if anyone could give me some pointers as to where to
start with the following?
I have a spreadsheet of data in a table. One of the fields is date. I
would like the user to be able to enter a date range and have all the
records returned that fall within that range.
What function should I use for that? DGET can only return one record.
Could I use something like VLOOKUP in an array? The number of records
returned will obviously change depending on the date range entered.
Or, should I use something like a VBA loop?
I need to do this in Excel - it can't be in Acce...Help Rules don't work anymore
Is it just me? Why is it that on some days, my Outlook rules work, and on
other days, they don't? On days when the rules don't work, if I run the
rule(s) manually, it(they) works, but still don't work automatically? I'm
really missing something!
Outlook 2003 or XP Pro SP2
Thanks for any advice.
Cut off: yourhead to respond
Try two things. 1) make sure your office product is up to date and 2) try a
clean boot in Windows XP by disableing every thing during startup by using
msconfig. If this works you may have a conflict with something that is
loading ...HELP dogs & cats in China please! [MUST SEE]
...Emails in HELP DESK enviroment
The clients in this case are people working inside the same organization
(using the same exchange) and when they opened a case the main comunication
between Help desk and them is by email. But those emails are arriving to
OUTLOOK and NOT to the CRM!! How can we change that?? We want to relate those
emails to the correct case.
The actual process is:
1. The request arrive by email to Outlook. Help Desk open a case and attach
the email to it.
2. Help Desk send an email (from CRM) to the user with indications...
3. The user responde and send other email... (we are loosing this email in
the ...Help with updating tables in many-to-many relationship
I am working on a database that contains a many-to many relationship.
I created an intermediate (linked) table between the two primary
tables. I have a Form1 that displays the info from Table1 and a
control to open a Form2 that displays records from Table2 that match
the Table1 record. Everything works great for displaying and editing
information on Form2 except for when I try to add records. I don't
seem to have the right code to update the Linked Table. Does anyone
have some sample code that works?
My tables include the following:
Table2 ...Excel formual IF statement Help
I am trying to make this IF statement work
On Sat, 01 May 2010 20:11:13 GMT, "Cerealkiller" <u59737@uwe> wrote:
>I am trying to make this IF statement work
...need help please
I am creating an html newsletter to email. This will be a
template that will be sent to someone else who will open
it outlook express through messaging\new message using.
They will copy and paste text from word into the file. I
want to create links at the top (news headlines) that
link down the page to the story. They will create a
different newsletter every week.
In HTML I have used anchors to do this. For this job I
need to do it in word. In word I have tried creating a
hyperlink to headline and also cross-referenced to a
The hyperlink apears when the email is sent but...Formula Bar
In my previous copy of Excel, when I typed in an equation in the Formula Bar, it would give me a little message window that showed where I was in a particular equation. Now that I have a another copy, I don't know what the "on" switch is for this function.
Please help, it's driving me crazy when I create very long equations.
it was introduced with excel 2002, you turn it on/off under
"ak" <email@example.com> wrote in message
news:BB2440A2-2883-4...Newbie-Pls help me with DataBase Connection in EVC++.
I need some serious helping with this code.Could you please help me
change my below given code from VC++ to EVC++.I know that i have to
use CCeDBDatabase in place of CDatabase and CCeDBRecord in place of
CRecordset but how to is the big Question. When i tried connection in
EVC++ with CCeDBDatabase i dont get any errors but this window
"Microsoft ODBC for Oracle Connect window" is missing.But i get
MessageBox(L"The DataBase is now Connected!!!"); which i've given just
below Open statement.I am emulating my EVC++ code into PPC2003, so i
should be able to see "...Using SUMIF i want to say IF A=1 & B=2 then sum C any help pleas
I want to single out a sum that has two common detonators row A and B, IF row
A=1 and row B=2 then sum row C
Try this, adjust the range to match your data:
=SUMPRODUCT(--(A1:A100=1), --(B1:B100=2), C1:C100)
Does that help?
"Actually, I *am* a rocket scientist." -- JB
Your feedback is appreciated, click YES if this post helped you.
> I want to single out a sum that has two common detonators row A and B, IF row
> A=1 and row B=2 then sum row C
That's quite an explosive worksheet you have<...Help: Creating an MFC dll
Hi, I'm trying to create a dll with which I can link another application to.
For starters I've added nothing to the dll.
I selected MFCAppWizard (dll), Regular DLL with MFC statically linked,
creating a project called DLL_TEST.
I added nothing, then built my DLL_TEST.dll (which also created
Then I created a MFCAppWizzard (exe).
I overid the New button to test my dll.
I added #include "DLL_TEST.h" to MainFrm.cpp.
In the Project->Settings "Link" tab, I a...how to access the config file from workflow assembly
my workflow assembly now works fine. But I put hard code for url and
userid, such as
_service = new CrmService();
_service.Url = "http://crm/mscrmservices/2006/crmservice.asmx";
_service.Credentials = System.Net.CredentialCache.DefaultCredentials;
_service.CallerIdValue = new CallerId();
_service.CallerIdValue.CallerGuid = new
I tried to use app.config and web.config to store the data, such as
value="http://crm/mscrmservices/2006/crmservice.asmx" /&g...Help importing .dtf Please?
Is there any way to import a .dtf database info from Q&A DOS v5.0 into Excel?
If anyone can lend a thought I would really appreciate it. I think I have
to export because, since upgrading to WinXP - the client gets an error
message in Q&A when trying to print lables. (it says not enough memory - but
I know that's not it). Any help you can give would be wonderful. Thank you!
What export options do you have in Q&A? Compare that list with the sorts of
text files that Excel can handle, such as comma or delimited (tab, other
On Mon, 15 Nov 2004 12:27:0...Help Please
I am using a vlookup to grab some data from a master list. My vlookup
works fine but here is the dilemma:
I am using a sheet that has retail items down the rows and divisions
where certain items are authorized. Each item has various information
including UPC numbers, which I am using for my vlookup. The
dilemma/problem/@#!$%%$#@ is that in several instances there may be
two or three lines of the item listed. What I get is say three rows
with the same UPC but different points of distribution. Obviously the
vlookup will only find the first instance of the UPC and give me back
the values in tha...Help with clearing name history
When I start typing a name in the To... field, Outlook
will automatically try to fill in the name and email
address, which is cool, but I want to be able to clear a
history of names that I no longer want to pop up. I tried
clearing the *.NK2 files, but there are not any on my
machine, even after showing hidden files. Any help would
If you're using Windows 2000 or XP, the .NK2 file will be in a hidden FOLDER
(or a system folder) -- it's not necessarily a hidden FILE. It also helps
to have file extensions showing in Windows Explorer.
You can either del...Pivot Table Error...Help!
I have created numerous pivot tables in my workbook. The refres
function was working fine. A couple fo days have passed and now when
go to refresh the tables i get the attached error.
does anyone know how to fix this?
mo...help reading xml doc
I'm new to XML, so please bear with me.
I'm using XPathNavigator and XPathNodeIterator to return a set of xml nodes
from a document that looks like this:
<book title="Some Title">
<number_of_pages>15</number_of_pa...Need help communicating with device on COM1
Does anyone have any sample code for controlling a device attached to a COM
port of a Win2K/XP machine? The modem code I have is from 1992 and doesn't
seem to work very well.
Bob Phillips wrote:
> Does anyone have any sample code for controlling a device attached to a COM
> port of a Win2K/XP machine? The modem code I have is from 1992 and doesn't
> seem to work very well.
This code was hacked out of a prototype terminal emulator I this any use?
HANDLE m_hFile ;
m_hFile = (CreateFile(_T("COM1:"), GENERIC_READ |...Please Help: I cannot create a mailbox all of a sudden
I have a single EXCH 2003 server with about 65 mailboxes on it. I have
never had a problem creating a new user account and creating the mailbox
from Active Directory users and Computers. Now, all of a sudden, when I
create the user, no mailbox is created. When I go check the Exchange
Advanced tab in the Account Properties, the Mailbox Rights says that the
only permissions on the mailbox is supposedly self and no others. I go to
the System Manager and the mailbox has not been created in the mailboxes
Can anyone direct me to what this problem might be?
All other mailboxes ...Update Ownerid in Account entity Help
I'd like to update owner for Account Entity but I don't know what code
should be in SDK using web services. I used code below but it's NOT working
AccountUpdate.ownerid = new Owner();
AccountUpdate.ownerid.type = EntityName.systemuser.ToString();
AccountUpdate.ownerid.Value = new
Anyone knows another code to make it works, I'd appreciate it.
Are you retrieving existing account and then updating it? i dont see
the rest of code .
This piece of code seems fine ...Windows XP Update problem help needed-
Operating System : Microsoft Windows XP Home Edition
Version : 5.01.2600 Service Pack 3
Problem is that when I go to the Windows update site it shows the
following updates available:
Microsoft .NET Framework 3.5 SP1 Update for Windows Server 2003 and
Windows XP x86 (KB982168)
Microsoft .NET Framework 3.5 SP1 and .NET Framework 2.0 SP2 Security
Update for Windows 2000, Windows Server 2003, and Windows XP x86
I tryed to install them along with others updates listed and it showed
they succeeded along with the others but when I rest...Access 2000 Help vs Access 97
I've finally upgraded from Office 97 to Office 2000. Lots of new features
made it well worthwhile except for the Help in Access 2000. What happened to
I've read the blurb on the MS KB but there is nothing like as much help as
on 97 whether or not you try to read the Help article with a Module . I
wanted to look up the sytax for using the Between (with two dates) operator
module rather than digging out my notes. Although the title came up in
the wizard (it didn't appear in the Index at all) with the title
Between...And (Microsoft Jet) when I clicked on it, I was told that t...wab.exe non-readable after XP re-install.. HELP!
Hi, I recently had to reinstall my operating system (XP) and before
doing so saved a copy of my address book as a wab.exe file in an
After reinstalling XP and Outlook Express I tried to import the
address book. But when using the import feature to view the back up
file, it doesnt show any file at all. It doesnt recognize the saved
wab.exe file. It appears invisable. But its there, when I look at the
I have extensive folders with 1000's of contacts in the saved wab.exe
file and now cant seem to find any way to access it. I know its still
fu...[HELP] Transaction logs grow rapidly
I need a help over here...
All of sudden one of my Exchange Server at the remote site stopped
working yesterday. I logged on remotely and found that the partition
logs was full, and this caused databases to dismounted. Normally
transaction log files grow at ~4 GB / day, but I noticed that since
yesterday the log files has grown to 15 GB however the size of
Pub.edb/stm didn't changed much around 20 GB and 5 GB respectively for
200 users. When the partition logs became full the databases got
I moved a few log files that has been committed to data...