Conditional commands on filtered lists
-I'm a spreadsheet neat freak, so I like to keep my data in as few cell
as possible. Just a warning that I don't want to generate columns o
rows that won't have useful end-product info in them.-
I have a sheet of business transactions, and I'm really only concerne
with From, To, Type, and Cost. Only transactions of the "service" typ
matter to me, and I'm supposed to make a summary of each division'
transactions to itself.
I also don't like messing up the original formatting I was given--I wa
given the chart with autofilters on the top line. For any ot...Exchange 2003 / Groupshield 6 problems
Sitting here at 1pm on Sunday - NT4/exchange 5.5-->2003/2003 migration
has gone reasoably well and is now "live".
Thank god for a test lab!
Only problems we can now find are that some messages when read "hang"
RPCServ.exe on the server which is a Groupshield 6 module. When this
hangs, a client mailbox will also freeze. Killing the process
releases the client, but then the message body doesn't show....
Can't find anything on this anywhere apart from some references to a
Beta version of GSE - but no solution. One message that kicks this
problem off re...Service provider
Is anyone out there a Publisher service provider? I heard somewhere tha
Microsoft has a program where the list you as a provider on a web site. How
does one get into this program?
While in a state of withdrawal waiting for components to arrive to repair
his dead laptop, Ed notices a message from "Rich Sommer"
> Is anyone out there a Publisher service provider? I heard somewhere tha
> Microsoft has a program where the list you as a provider on a web site.
> does one get into this program?
http://mspublisher.saltmine.com/...taking the techchek test for visual C++ 6
a prospective employer wants me to take an on-line test on ikmnet.com
on visual C++ 6. it has been about a year since i have done anything
with VC++ 6, and then it was a rather small document/view application
and help files to go along with it. i have until 8/16 to take it. any
> a prospective employer wants me to take an on-line test on ikmnet.com
> on visual C++ 6. it has been about a year since i have done anything
> with VC++ 6, and then it was a rather small document/view application
> and help files to go along with it. i have until 8/16 to take it. ...Import/Export command missing
I am running Outlook 2002 on XP Pro. I can't find the
import/export command under the File tab!!! How can I
...Provider: Named Pipes Provider, error: 40 & error 53?????????????
How can I access SQL server on WAN????????????????????????????????
(provider: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server) (Microsoft SQL Server, Error: 53)
Windows Sever 2008 (64bit OS) Service Pack 2
Microsoft SQL 2008 Server Management Studio (10.0)(64bit)
Microsoft .Net Frame work 3.5 SP1
Additional Inform...Interface into GP 8.0
I'm running GP 8.0 and SQL 2000.
Does anyone know of any interface for order release plus sending orders
information extraction by FTP? What I’m trying to do is when the line items
become allocated / fulfilled to automatically extract the information and
send it via FTP or any other none source.
For billing purpose once the orders have been shipped I want to find a way
of creating a batch from the shipping report, possibly automate the transfer
from Sales Order to Invoice.
What is the easiest way to accomplish these interfaces?
Do you have a Warehouse Management Syst...Internet Explorer. 6.0
I have purchased the 2003 Basic version of Quickbooks.
One of the requirements is that my system upgrade Internet
Explorer to 6.0. This update is included on the disc
purchased. However every time I try to install it it
freezes at 87% of the download. I have had competer
technitions here to assist and even they cannot figure it
out. I am getting desperate. anyone with ideas or
solutions, I am willing to listen. Please advise. Thank
...Commands will not run
I converted from Access 2003 to Access 2007 my previous commands and queries
will not run.
On Oct 13, 1:10 pm, guycpsi <guyc...@discussions.microsoft.com> wrote:
> I converted from Access 2003 to Access 2007 my previous commands and queries
> will not run.
Access 2007 will disable your code if the source file of your DB is
not in a "Trusted" location. If you click the Office button in the
upper left corner, then go to Access Options, you should be able to
add your source file to the trusted locations list.
...Future for VC++ Programmers
Being a VC++ Programmer what are your future plans? are you changing
from VC++ to anything else? what new technology are you learning? what
kind of projects you are concentrating on??
> Being a VC++ Programmer what are your future plans?
> are you changing from VC++ to anything else? what new technology are you learning?
Moving on to C#, mostly by need rather than choice. I personally dont
see any major threat to C++ programmer for years to come.
I would consider managed VC++ as something I should be looking at; and I know enough C# to
be dangerous, altho...GP Support Providers
Anyone know of a good list or website to find companies that provide service
and sales of GP products in U.S.? The distributor for our area provided less
than ideal initial startup support and we are looking for an alternative. We
possibly need new modules and support for existing modules.
Email me at firstname.lastname@example.org and I can help you locate one.
> Anyone know of a good list or website to find companies that provide service
> and sales of GP products in U.S.? The distributor for our area provided less
> than ideal initial startup suppor...Design puzzle
I have a form with several combo boxes on it, the last of which allows the
user to type in new data. Depending on the contents of all of the combo
boxes, a routine executed in the before_update event enables or disables a
command button. The users don't learn to tab off of the combo box after
typing new data into it because when they choose from the list, the command
button gets enabled or disabled immediately. I can't find any way to
ascertain the contents of that last combobox until the user tabs off of it.
Key_up and similar events only know about the previous contents. ...CRM Provider for Service provider
does microsoft provide a trial version or where i can download the CRM 3.0
Professional for Service Provider Edition?
A very good and easy-to-remember link is www.microsoft.com/dynamics/crm. In
includes a download link
(http://www.microsoft.com/dynamics/crm/using/downloads/default.mspx) and on
this page you find trial versions and a lot of related documentation.
Michael H�hne, Microsoft Dynamics CRM MVP
Custom Lookup Dialog: http://www.stunnware.com/crm2/?area=customLookup
--------------------------...Command Button #5
I have a command button on Sheet 1. I want a user to go to Sheet 2 if value
in L4 = 0, Sheet 3 if value in L4 = 2, Sheet 4 if value in L4 = 4.
How do I do this?
THK in Advance
try to introduce this code under command button code
If Sheet1.Range("L4") = 0 Then Sheet2.Activate
If Sheet1.Range("L4") = 2 Then Sheet3.Activate
If Sheet1.Range("L4") = 4 Then Sheet4.Activate
see whether you get what you want
Chris Hale <ChrisHale@discussions.microsoft.com> wrote in message
> I...External mail from the command line
I hope someone can help with my exchange 5.5 problem.
In the environment we have 2 IMC servers which are both giving different
results when sending mail via a command line to external recipients only,
internal is fine.
Both machines are windows 2000 with exchange 5.5ent both at the same patch
and SP level (4) and have been configured the same and to forward mail to a
host (our mail appliance).
The one that is concerning me is the one that just returns the mail back to
the sender stating that it cant find the recipient (external recipient). Now
surely it should just be forwarding...ESS unable to load consumer provider NTEventLogEventConsumer from provider subsystem: 0x80041013
Any one Please tell me root cause of this Error and Resolution
This error occured in C:\WINDOWS\SYSTEM32\WBEM\LOGS\wbemess.log file,
the error is the following
ESS unable to load consumer provider NTEventLogEventConsumer from
provider subsystem: 0x80041013
Failed the first attempt to retrieve the sink to deliver an event to
event consumer NTEventLogEventConsumer="SCM Event Log Consumer" with
error code 80041013.
Please answer the following
1. Which component is causing the issue
2. Why is it happening?
3. Fix for this issue.
When trying to ad Google or any other search engine as new search provider, I
got an error page.
Of course, we all know what the error message said. And no need to tell
us what version of Internet Explorer you're using or what version of
Windows you have. We'll just consult the spirit world.
Errare humanum est
> When trying to ad Google or any other search engine as new search provider, I
> got an error page.
If you type 'http://www.google.co.uk'
you will see the Google home page.
If you type 'http://www.google.c...Messaging Interface Problem in Outlook 2003
The messaging interface has returned an unknown error. If
the problem persists, restart Outlook.
Was doing normal work online and to my knowledge, nothing
happened across the board. Now, I cannot open a new
eMail form or forward an existing eMail...also, I
can "see" what's on the HOTMAIL server, but cannot
send/receive (does nothing). I looked at the above
problem and found a MS KB issue for this in Outlook 2002,
but not 2003. Restarting OL or the CPU does nothing.
Please try to start Outlook in Safe Mode. Safe Mode will disable all
add...How can I get all commands to show on the menu
Other than selecting "show full menu", how do I get all commands to show on
the menu? For example, the file menu does not display "save as", the tool
menu does note display "options"
It would help if you would tell us which version of Word you're using, as
the settings vary slightly among versions.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Pam D" <Pam D@discussions.microsoft.com> wrote in message
>...Need Keystroke Commands to Recover a Deleted Item
Does anyone know if keystroke commands exist for Recovering Deleted Items? I
have a blind user who uses JAWS. She does not use a mouse, but rather a JAWS
cursor. The JAWS cursor does not access the necessary button to recover a
deleted item. Do keystroke commands exists for this function? And if so, can
someone please post them here? Thanks so much!!
...Lost my menu bar commands
I don't know what I did, but somehow my menus have been corrupted in Excel.
The Insert menu contains only the Format command, and the Tools menu contains
only the Spelling, Autocorrect and Goal Seek commands. How do I get the
normal menus back?
Go to Tools>Customize>Toolbars
Select Worksheet Menu Bar from the list, and hit Reset
(remove nothere from the email address if mailing direct)
"pod" <email@example.com> wrote in message
> I don't know what I did, but somehow my...Linkmasterfields property setting has provided this error: 'Return
I'm currently getting this error message when I open my database:
Linkmasterfields property setting has provided this error: 'Return without
How do I resolve this issue?
This message started after I created a text box which I use to calculate the
age of a student.
Thank you for your help in advance.
When you get the error message, click the button on the error dialog. It
will take you back to the procedure where the eror is occuring. You have a
Return statement that does not belong on the routine. Probably you once had
GoSub code to branch...Logon Credential Prompts When Using Third Party Exchange Providers
After migrating to a third party Exchange provider (i.e. with an external
domain) the MS Outlook clients with Full Exchange prompt for authentication
credentials to sign-in with their password every time they open Outlook. Is
there a setting or a script (or anything at all) that could be run or
implemented in order to disable the constant and frequent prompting for a
password every time they open Outlook.
> After migrating to a third party Exchange provider (i.e. with an external
> domain) the MS Outlook clients with Full Exchange prompt fo...Ole Db Provider
I want to use my custom Ole Db Provider that I wrote, to get some data into
excel. I have tried the "Get External Data" feature, but my Ole Db provider
does not appear in any of the lists. (However it is registered, as Borland
Builder included it in it's list of providers it can access)???
...MDI design question (kind of long)
I have some legacy code that needs a slight tweek and I'm
having trouble figuring out how Visual C++ is supposed to
help me accomplish the task. I didn't write the original
code and it seems to do things a bit different than what
the documentation states things should be used for.
After a couple days reading documentation and notes
on the MDI Template Documents I've decided a little
help is needed.
Okay, my application is based on the MDI Templates.
Each of these documents is roughly a view into a
database. One of these views, I'll call it "UserView"...