Advanced find issue OR
When using advanced find, there is a limitation with the OR clause.
Want to find ALL active contacts that have a certain str field populated OR
is on a certain Marketing list. This is not possible.
It should be possible to mark the 2 lines/groups and click the OR group.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader an...Excel graphing and equation issues
Okay so here is my problem. For work, I have a curve that I need to put into
excel and find the equation. So I look at the curve and record data points
from the curve into excel. I will then graph the points and it will produce a
curve just like the one have on paper. My problem comes when I ask excel to
produce equations for the curves. The equations it produces do not match the
curves when I enter a value into the equation. Why does this happen or how
can I fix it?
Make sure you start with an XY chart, not a line chart. Then make sure
the equation has enough digits, so apply ...Excel XP: Page Setup Issue
How can I create different page setup options for each worksheet in a workbook? As I change the page setup within one worksheet it changes all of them. Is there a way to do this? Am I missing something obvious
Thanks in advance
"Joe Mathis" <email@example.com> wrote in message
> How can I create different page setup options for each worksheet in a
workbook? As I change the page setup within one worksheet it changes all of
them. Is there a way to do this? Am I missing something obvious?
>...How can I find out what the firewall issue is on a Printer?
I was having problems reinstalling HP software for my All-In-One printer,
and HP Tech support had me add ten or fifteen programs to the Firewall as
allowed programs, plus about that many ports. I'm still having firewall
issues according to the HP networks diagnostic tool, and the HP software
does not "see" my printer on the network.
I can go to its IP address in Internet Explorer and see info about its
status, etc, and I can install basic drivers for other similar printers and
it will print, but not from the Full Software package that I need for OCR
scanning. It ...Time sheet issues
There are three questions
I am preparing a time shhet.
To strart with I have to prepare a blank sheet and give one sheet for each
Here are the blank walls I am hitting
1. I want to format a cell (E2 in my time sheet) in such a way that if
enter "1" it should display "January" and so on. How to do it?
2. The First cell of last row (A 34 in my of the time sheet) should have 28,
29, 30 or 31 depending the conditions of E2 and H2 which has month and year
3. The cells B4 to B34 should have days cooresponding to dates (number) in
A4 to B34
They sho...Issues after upgrade to Exchange 2007
After upgrading to Exchange 2007, we are experiencing these issues:
1. E-mails sent from CRM are not routing thru Exchange to the Internet (we
use a forwarding e-mail, and all lights are green within the Router Config
2. Incoming CRM-related e-mails in Outlook are not automatically tagged with
the CRM icon
Specific to item #1, we are seeing this error:
#27938 - An error occurred while checking for e-mail messages to process in
mailbox firstname.lastname@example.org. System.Net.WebException: The remote server
returned an error: (404) Not Found.
at System.Net.HttpWebRequest.GetResponse(...Form sizing issue
In my database I have one form with a running list of students. When you
select a name from the list, I want it to open the students form to that
student's record as a dialog form so that I can have some code wait for the
student form to close before it runs.
The code is DoCmd.OpenForm "frmStudents", acNormal, , "StudentID =
Forms!frmStudents.StudentID", acFormEdit, acDialog
All that works fine except that when the Student form opens, it maximizes,
removes the toolbars at the top and even covers the Windows start bar at the
bottom of the screen. I have played w...Card colors are not printed right?
I had a business card I am trying to reprint again, but the colors when I
print them are not right?
I cleaned the heads, other things seem to print correctly?
The color you see on your screen isn't necessarily the color you'll get on a
print. Think about the things that have changed since you last printed it.
Are you using the same printer/monitor/version of Publisher/brand of ink?
Have you made any changes to the screen resolution?
Microsoft MVP - Publisher
How to ask a question
"Bruce" <notreally@idon...Issue when combining fields
I have combined 3 fields (firstname, lastname, business) in a query to come
up with a concatenated field called custname. The only problem is when one
of the fields has no data it puts a space in where the data would have been
inserted into the string. For instance, if neither firstname nor lastname
have data, and business does, I end up with something like (space) Scott's.
The problem with this is that if I want to sort alphabetically, anything with
a space before it comes up first. Is there a way to fix this?
Trim(FirstName & " " & LastName )
If Fir...Outlook 2003 Drap and Drop Issue
If you take an email from Outlook and perform a drag and drop to the tasks,
the task is created but the message body text is empty.
Any reason why this should happen.
...Activity creation issues
I have coma across a couple of issues when creating activities:
1) When creating phone call, regardless of the direction, the sender remains
as the owner and the recipient the related customer (assuming this is created
from within a contact's view). This means that the incoming phonecall is
recorded as being sent by one of our staff, despite it being received by
them. I have attempted to create workflow to rectify this but it appears to
fail to fire (presumably because there is a conflict as one cannot simply get
the sender/recipient to switch, resulting in duplicates, and thus e...how can i print cards on a single page and edit side two and make.
This isn't. Post your message in this bit, describe it in the top bit.
That way, you see the entire message rather than just the start.
Ed Bennett - MVP Microsoft Publisher
Don't get me wrong here, I have received plenty of great
information from MVP's and other regarding MS software,
but to make us all sound like idiots because we used the
suggested password system for a product is unacceptable.
MS specifically tells you it is highly recommended to use
Passport. Now while we all wait for the fix, we get to
listen to all of you tell us how stupid we are for even
using it in the first place. Personally, I can get
around using it for now, but it is rather annoying that
it is taking this long.
Funny thing, I had always used Quicken in the pas...Discover How To Finally Unleash Your Computers True Potential!
Transforms Any Dead-Slow PC Into a Lightning Fast,
Stable and Secure System...In Just 15 Minutes
Dear Frustrated PC User,
=B7 If you've ever wondered why your computer seems to run so much
slower than it used to...
=B7 If you've ever heard of frustrated people losing all their data
because of an unexpected crash, infection or other disaster...
=B7 Or, if you've ever worried about having to fork over hundreds of
dollars for upgrades or a visit from your local computer geek...
You can kiss all the worries, wondering and frustration
http://pcsecretfor...Outlook /Calendars Delegation Issues.....
Maybe this is a question for the outlook or exchange user
groups, but I just setup SBS2003 with outlook 2003 on all
5 clients. I setup one (primary) of the clients outlook
calendar to allow delegate rights to the other four,
which works great. My problem is that when the "primary"
user goes in and creates an appt,event, meeting or even
just updates anything in their calendar the other four
recieve updates of the changes.
I've looked at how to stop this but cannot find anything.
Anyone have any Ideas.
Thanks in advance for your help.
Use a public calendar instead.
...Printing Membership Cards
I am trying to find a way to print membership cards... I have a database
that has a yearly membership with some 1000+ members... I need to print out
cards only for those members that I have selected... then update a field
that would flag the status of the card had been printed... also if I had a
problem with the printer... only the cards that did not print would print
If I could say select all surnames starting with A,B or C first then D,E and
F next and so on... this would not be achive on the same day...
Regards - Paul
Unfortunately, there isn't any way ...Visual C++ 6 support issue
I have a huge VC++ 6 MFC application (exe and dlls). How long will VC++ 6 MFC be supported by Microsoft....i.e. how long do I have before my application becomes unsupported and must be converted/rewritten to use .Net and/or MFC7?
It is a good question. A lot of us wonder the same thing. Bottom line: until VS6 actually
stops running, we consider VS7 only as a last-ditch solution. Since effecitively it hasn't
been supported in years (SP6 came as a surprise to most of us), it is not something we've
been overly concerned with. The real pain is fhe difficulty people have in getting VS6,
...Exchange 5.5 mailbox issues
We are currently using a exchange 5.5 server and one of our directors is not
getting all his emails sent. Its been when 3 or 4 external users send him
email but he does not get it and the external senders get an NDR. The NDR
sent to the senders refers to the exceeding storage allocation, but our
director is not over the storage limit, as we individually set large limits
for the director. It only happens occassionally and the director has said
it could be more than the 4 senders, as its difficult to monitor. And today
another user who was sent email from the same sender has the same problem...FP 2003 connection timeout issue
Hello All: Website is www.ttwcanada.com and hosted with www.bluegenesis.com.
I use FP2003 and have had some minor issues with publishing to site
(occasional timeout with cannot connect to server message) Now, however, I
can only stay connected to live site for a couple of minutes. I will be
working on a page, go to save, and get connection error message. Have talked
to their customer service and they blame FP. Say that it is old program and
lots of people having same issues. They have FP 2002 extensions and they say
they are uptodate and working fine. Any body else having these i...security issue!
Since we did the migration from 5.5-2003 I noticed that in
exchange system manager where it says last logged on
by ...it has my username (whic has admin rights) there
even though i'm logged in as "administrator" on the
server. This is causing a major security issue because
anyone using owa can access each other accounts. How do I
change this so that each person logs on using there own
This could be due to something like a virus scan that runs under the context
of that account has "logged into" the mailboxes to do a scan. Or a backup
agent ...Shortcut key issue
I have a shortcut key (alt+a) for a label next to a combo box in a property
page in an MDI form. If the short cut is pressed while the combobox is
disabled, my form gets closed. Is this a known issue?
It is known to happen if you haven't set your tab order properly. Placing
your label next to a combo box is not enough to establish that the label's
shortcut key should activate the combo box.
When you press the shortcut key for a label, label's cannot get the focus so
the dialog sets the focus to the next control that can receive the focus. In
the case of buttons, the but...How to refund Credit Card Payments to Customers in A/R
Using Great Plains 7.5
I have customers that pay via credit cards. I need to do
a refund to the customer with a return of merchandise to
damaged inventory (can't resale returned items). My issue
is how to/where to apply the return if the initial receipt
of payment had been applied to an open sales invoice,
closing the sales invoice? I need to make sure that when
the credit card company settles the return that the
customer account no longer shows the credit on the account.
Would greatly appreciate any help.
...credit card interchange fees -voiding transactions
I have a general question about interchange fees and my merchant processor is
of little help.
I also thought I would post my observations to help other people as well.
Credit cards are arguably a necessary evil, but the fees are crippling our
business. We have tried to find ways to reduce the fees but getting accurate
information is like pulling teeth. I guess the associations and processors
have an incentive to keep people in the dark.
My main question is how to handle a Void vs. a refund. If we run a charge for
$100.00 and later refund $100.00 to the same customer, are we charged per
tran...Issue passing DataSet as XML from WebService
I have a WebService that sends a client a DataSet as XML (I use a
DataSet.GetXml to get the XML). The DataSet is filled by a DataAdapter
in the WebService. The client coverts the XML Back to a DataSet (using
StringReader sr = new StringReader(xml); DataSet ds = new DataSet();
The client then makes changes to this DataSet, and sends the dirty dataset
back to the WebService using another GetXml on 'ds'.
The WebService re-converts the xml into a DataSet (using a DataSet ds = new
DataSet(); ds.ReadXml; )and executes a DataAdapter.Update(ds).
The problem is...subjest issues
I 've bought my new notebook in December. And it was setup office2007 before.
Now i need to enter the "Product Key" to setup before i use it, i 've been
enter it for many time , but it said that my password is incorrect ! *I am
sure that it is genuine.
Did your computer come with a limited trial of Office 2007? When the trial
period runs out you have to buy a license to continue using the program.
"wendy" <email@example.com> wrote in message
>I 've bought ...