SUMIF Returns a #VALUE error when external source is closed
Can you help me out with this? if works fine if the external source i
open but returns a #value if its closed. is there anyway of correctin
this so that it will pull from the external when it is closed
ghynes's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2658
View this thread: http://www.excelforum.com/showthread.php?threadid=39856
No, the formula requires the second file to be open.
Bernard V Liengme
remove caps from email
"ghynes" <...Excel 2002 Formulas Book!!!
Can anyone help please???
I purchased 'Excel 2002 Formulas' by John Walkenbach a couple of weeks ago.
However, and I don't know how, but I appear to have lost the companion
Does anyone have a copy that they could possibly copy and send to me?? I
would be wiiling to pay any costs, postage etc..
Or even a p2p fileshare folder that I could download it from??? (I use
I've been in touch with the store where I puchased the book, but they were
pretty useless to be honest.
Any and all help would be most appreciated.
--Remove 'spam...Auto generated item lookup codes and customer numbers
Is there a way to have Item lookup codes and customer numbers automatically
generated in RMS? Apprecite the help!
you can do so to create the trigger of database, but there is one issue, the
UI(user intereface) has it own validation in RMS. mean whenever you create
new item the UI of RMS> Item Screen give you warning that you must enter the
item lookup code. you can do so by entering anything may be one numerical
character but the system generate the code base on the below trigger as item
lookupcode : here is the code:
CREATE TRIGGER CreateLoookupCode ON Item
FOR INSERT ...code needed, please
I have a list I need to do some arranging in. Column A
(moving down one after another i.e A1, A2, etc) first has
the company name, then under it is the street address,
then under that is the city. It now repeats with new
information (every 3 lines are the same and there are no
spaces between the companies although in the end I would
like there to be 1 space). Now comes the tricky part. In
column B cell number 1 is the contact information for the
company in cells A1,A2,A3 and I would like that to appear
directly below the companies, and in column c we have the
phone numbers which woul...Source code library.
My company has finally decided to upgrade from Visual C++ version 6 to
Visual Studio 2008.
Is there a newer version scheduled for release anytime soon?
What source code version control should we use? Is SourceSafe good? Are
there alternatives that people would recommend for a small company with
only a few developers?
With SourceSafe are there any concerns or things we should know from the
"TomChapman" <TomChapman12@gmail.com> ha scritto nel messaggio
> My company has finally decided to upgrade from ...transaction analysis codes and transaction analysis group codes
hi can anyone help me to resolve my issue on transaction analysis codes. my
client is a manufacturing company, so they used trasaction analysis codes for
their transactions in receivables, payables, including invoice match,
payables trx, sales voucher, voucher payable, sales invoices and journal
entries. the problem is when they enter transaction on the said modules, when
they enter the ff distributions w/ transactions analysis for every account #,
the system hungs when they lookup the analysis button which is the blue
after that, they took a few minutes to con...Cannot set the LOCALE IDENTIFIER of the data source #2
In order to use the "translations" feature of Sql Server Analysis Services
2008 we need to set the locale identifier of the OLEDB connection string.
However, it doesn't seem to be possible in Excel 2007.
Here are the steps to reproduce the problem.
1- Open Excel 2007
2- Data > From other sources > From Analysis Services
3- Select a server and a database (it doesn't matter which), click next,
4- Click properties, clear the "retrieve data and errors in the Office
display language" checkbox, go to the definition tab, add "Locale
Identifier=105...Code number for Microsoft Office 2001
My iMac crashed about two months ago. In the process of
rebuilding it, I removed Microsoft Office 2001 to free
space for the rebuild process. Unfortunately I have lost
the sleeve with the product code on it. What can I do?
Please reply to firstname.lastname@example.org
Wm. Neal Lewis
In article <email@example.com>,
"Wm. Neal Lewis" <firstname.lastname@example.org> wrote:
> My iMac crashed about two months ago. In the process of
> rebuilding it, I removed Microsoft Office 2001 to free
> space for the rebuild process. Unfortunately I have lost...Reusing Delete items lookup codes...
I have deleted items in the past and now would like to reuse the lookup code.
The program tells me the Item lookup code must be unique. If the old item
was deleted, and i do not have any items with that lookup code being used;
then how is the lookup code not unique?
Deleting items is bad. If the items had any sort of history, you are going
to cause yourself problems...
Try this query:
SELECT * from Item WHERE ItemLookupCode = 'abc123'
Substitute the actual ILC for 'abc123', you will need the single quotes.
If you get no results, you've got proble...Single value for Control Source
I have a combo box for which I want the control source to be a single value
in a table that has several rows and columns, like DLookup works. What would
the control source look like?
Sorry, Stu, but I can't figure out what it is you want to do. What does "a
single value in a table that has several rows and columns" mean?
This is what makes no sense.
Dave Hargis, Microsoft Access MVP
> I have a combo box for which I want the control source to be a single value
> in a table that has several rows and columns, like DLookup works. What woul...More background sources for MSPub 2003
Is there a site for more background patterns on the internet?
Input background in the search, there are many.
Mary Sauer MS MVP
"Carygee" <email@example.com> wrote in message
> Is there a site for more background patterns on the internet?
Hi Carygee (firstname.lastname@example.org),
in the Microsoft� newsgroups
|| Is there a site for more background patterns on the internet?
As an FY...Contact subfolders won't show up in Address Book
Using Outlook 2003 with current updates, not using Exchange Server...
I've changed the properties on the Contacts folder to "Display in Address
Book" but the only thing that shows up when you click the To button on a new
message is the contacts in the Contacts Folder. None of the sub folders
appear in the list box on the left of the form.
I am able to change the "Display in Address Book" property on Contacts
subfolders but that only puts them in to the drop-down list at the top of
the Address Book page. It does not put all the names into the list box on
the left side ...Starting Visual Basic Editor crashes Outlook and cannot send email from Access
MS Outlook 2003 (11.8206.8221) SP3
MS Access 2003 (11.6566.8221) SP2
MS Access 97 SR-2
MS Visual Basic 6.0 Version 8176 VBA Retail 6.0.8169 Forms3:
Windows XP 5.1.2600 SP2 Build 2600
Machine: Dell Precision T7400
Processor: X86 Family 6 Model 23 Stepping G Intel 2.6 Mhz
BIOS: Dell A03, 5/30/2008
Current system oddity: Documents and Settings is on the D: drive
instead of the C: drive (don't ask me why, I just work here...)
I recently migrated from a PC with XP SP2 to a workstation which runs
XP (32 bit). Since then I have been having a couple of problem...Passing a Date Variable from Code to Update Query in a Loop
My challenge is to pass a changing date variable from the code to an Update
I already have a variable declared (DateComplete) and in use within the code
that contains the value I want to pass, but just not sure how to make it
happen using the DoCmd.OpenQuery structure.
Below is some of the code to help scope this out:
Private Sub CmdImport_Click() 'Import Files -- using the dates input on the
On Error GoTo Err_CmdImport_Click
Dim dbMyDB As Database
Dim EndDate As Date
Dim PrevDate As Date
Dim StartDate As Date
Dim d As Integer
Dim DaystoImpor...Pivot table data source #4
I had some pivot tables in my computer. How can I find the
data source name or the database name where the data is
coming from? I went to the get data and view SQL but it
did not show me the database name and location. Any help
will be appreciated.
I normally right click on the pivot table, select wizard and then the back
button until you get to the window with the source data range in it.
"John Rozario" <email@example.com> wrote in message
> I had some pivot table...Printing Address Book 01-21-10
I'm using Outlook 2007 to try to print a medium booklet style address book.
An old program I had would print this so that when you printed both sides and
cut the full sheets in half and then folded the half sheets in half and
assembled them in the right order, you had a 1/4 page size booklet. Outlook
seems to print the pages in consecutive order so you can't assemble the pages
in any reasonable order (ie 1,2,3,4 on the first sheet and 5,6,7,8 on the
back side, so page 6 is on the back of page 1, etc). Anyone know how to make
...Updating the chart source data
i have many charts in a sheet. i want to make their souce data
dynamic. the source range of charts are like sheet1!$B$9:$CN$13
where $B$9 is starting range and " $CN$ " is ending range.
for every chart the starting range is different but the ending
Datarange is of same Column "$CN" . i want to make the column Letter
dynamic ,Row number are Static ... from "CN" it has to change it to
"CO" in all the charts.. Every occurence of CN DataRange has to be
changed to CO .Every month one column gets added up. i.e from co to cp
and so on. this change...Issues w/ v3c release
I've install MS CRM v3c, on Vista w/ Office 2207. Everything seems to work
find except when I select the "view regarding" or "view in CRM" in the task
w/in Outlook it opens up the web page "http://crm//_root/stage.aspx" which
doesn't pull up the regarding contact information. From within the Outlook
task it will show the correct Contact but cannot pull up an IE page with the
CRM data loaded. Any help would be greatly appreciated.
In Outlook Express I can view the message source of an
email. How can I do the same in MS Outlook 2003?
Diana Zaganjori <firstname.lastname@example.org> wrote:
> In Outlook Express I can view the message source of an
> email. How can I do the same in MS Outlook 2003?
I find the besk way is with this tool: http://www.xintercept.com/pkpeek.htm
How I can make script (or some changes of script) for events (PRE, POST,
CHANGE...etc) Where ScriptName is "(No Source)" ?
Looking into writing a trigger that fires off those events.
"Misa Simic" <MisaSimic@discussions.microsoft.com> wrote in message
> How I can make script (or some changes of script) for events (PRE, POST,
> CHANGE...etc) Where ScriptName is "(No Source)" ?
...Source for automatic name completion
Using Outlook 2003 and Windows XP.
On my previous installation, Outlook 2000,I was able to
specify the first source of data for automatic name
completion in email.
I can't seem to find that option in Outlook 2003, and the
program seems to look first in my secondary data source.
Outlook 2000 never had autocompletion. It only had autoresolution, for which
you could determine the order in which your folders were checked.
Outlook 2002 and 2003 have autocompletion, which will only reference the
cache created from messages you have sent, never your Contac...Partner Source / Customer Source
What is the best way to do searches? It seems as if I can only find KB
articles or hotfixes when I am searching for any information on a module
including sales information or help manuals etc.
...code to fine computer name
how to fine computer name? help me
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<email@example.com> wrote in message
> how to fine computer name? help me
...Outlook Client error on CRM 4.0 (Event Viewer Source: MSCRMOfflineSync)
With the completion of CRM 4.0 implementation, we setup Outlook Clients to
15 users. 13 uses it normally but we encounter serious problems with the
rest 2. They can not use their Outlook until we disable the CRM add-in. The
Outlook continuously restarts itself. Please find couple of Event Viewer
Event Type: Error
Event Source: MSCRMOfflineSync
Event Category: None
Event ID: 6000
Computer: <CRM server>
An error occurred during Offline Synchronization. Try going offline again,
or restart Micro...MS Word Drop-Down list linked to outside source?
I was wondering if it is possible to link a word drop down list to an outside
source such as an Excel list or and Access table.
I have created 70+ locked templates that use some similiar drop down lists.
These lists include Judges, Lawyers, and Arbitrators names that can change
monthly. So i was looking for a better solution than me editing every drop
down list on each template.
I would like to be able to link a drop down list to say an MS Access table
and so i can just edit the table and each drop down would just pull the info
Is this possible...