Query design help requested
hello to all
I'm fairly new at this! Here's my situation. qryA and qry B have identical
structures. The PKey used in both is EmplID.
I need to know how to construct qryC (again with the same fields) so that it
contains ALL the data rows in qryA EXCEPT those also in qryB.
Help greatly appreciated
Use the unmatched query wizard (first dialog when you create a new query.)
Use qryA as the first 'table', and qryB as the one to exclude.
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips...Stuck
Seeing how iam stuck in this area of MSoffice, with no appearant link to
other catigories i have to ask my question here concerning MSN explorer.
I downloaded explorer 7.02 now i want to uninstall it, yet i cant there is
no MSN explorer in my add remove programs, even when i click on show updates.
I am running windows xp and there is no folder in widows directory leading
me to MSN explorer, as some advice to type comands like :
to get rid of it, none of it seems to work at all...
PAthetic of Microsoft to stoop to ...Reviewing toolbar opens when I open an Excel attachment
Every time I open an Excel attachment from an e-mail, the Reveiwing toolbar
is opened as well. How can I turn this off?
(remove nothere from the email address if mailing direct)
"Jeff Bremer" <JeffBremer@discussions.microsoft.com> wrote in message
> Every time I open an Excel attachment from an e-mail, the Reveiwing
> is opened as well. How can I turn this off?
...UK stuck with old version
This is most probably a pointless question, but here goes.
I wondered why that in the UK the latest version is money 2005, where as if
you live in the USA you can get money 2007.
Is there many new things in money 2007 that are not in money 2005?
Remove nospam for personal reply if responding via newsgroup.
I guess that the cost of converting M2007 to work for the UK was a lot
greater than any potential sales! :-(
See http://money.mvps.org/product/US/2007/Default.aspx for a list of M2007
Microsoft MVP - Money
For UK tips & fixes see
I have Vista 64 and periodically I cannot send mail. My antivirus is Trend
and I have turned off the e-mail scanning function. Error message is :
Your server has unexpectedly terminated the connection. Possible causes for
this include server problems, network problems, or a long period of
inactivity. Subject 'Jessica's Phone Number?', Account: 'pop6.sympatico.ca',
Server: 'smtp1.sympatico.ca', Protocol: SMTP, Port: 25, Secure(SSL): No,
Error Number: 0x800CCC0F
hay alguien de argentina?
"Ken McLean" <KenMcLean@discussions.microsoft.com>...Tape Stuck in Drive
DPM 2007 refuses to let go of a tape in the drive. If I try to run a “remove
tape E/I port” I get following message
“Required tape resource is reserved by another task. Wait for the other task
to complete, or cancel the ongoing operation. Retry the operation."
The problem is that there are no other jobs running. I also tried to reboot
the server and tape library but no success. I am able to unload the tape from
the drive using the tape drive console but DPM refuse to acknowledge that the
tape have been moved out of the drive.
We experience exactly this behavior with our DELL...Newbie needs help
I'm trying to take an amount in a cell, give a date (3 november) and todays
and divide the days between now and 3 november by the amount in the cell.
Nov 3- 24 oct = 10
cell = 28
28/10 = 2.8
I've tried using the Today() and Now () function but I can't figgure it out.
I set cell a10 to Today() and a11 to 3-Nov then set a12=a11-a10 I get
What am I doing wrong here?
kg0wx at comcast dot net
"Ken Bessler" <kg0wx@IHATESPAMyahoo.com> wrote in message
> I'm trying to take an amount in a cell, g...Need Formula To Find Data
I am using Excel 2000.
I need a formula to find particular data within an array of data. I have a
worksheet displaying inventory activity. Cell A1 is a cutoff date. Cells
A4 thru A1000 are the dates of the activity. Cells B4 thru B1000 are
descriptions. Cells C4 thru C1000 are additions. Cells D4 thru D1000 are
subtractions. Each row will have a date, description and either an addition
or subtraction amount (but not both on the same row).
I need a formula to return the date, description and adddition amount of the
last row with an amount in the additions field where the date is ...Need a program that works with Outlook Express
I know there os a program for downloading that works with Outlook Express.
Fixes such things as missing < at the start of reply lines.
Can't remember the name nor came I find it searching the Internet.
Do you know the name of a program like that.
Imperial Beach, CA
" Cal Who" <CalWhoQQ@roadrunner.com> wrote in message
>I know there os a program for downloa...Need to use F9 to requery in subform
The data base consists of 2 key tables Scanner Models and Scanner Parts. As
this is a many-to-many relationaship and there is a linking table ModelPart.
When work is carried out on a Scanner a Service Report is input. The Service
Report consists of a main form (recording dates, work done etc, Scanner
Model) and a subform (to enter details of parts used). The Service Report
number is the Master Link Field and Child Link Field.
On entereing a Service Report the Scanner Model is selected from a combo
box. On entering the subform and clicking on the PartID combo box a list of
...I am stuck
The numbers represent rounds.
So a name will go with a round (number) but some names know more than one
Name a 1
name b 2
name c 3
name d knows round 1 and 2
name e knows round 2 and 3
Is there an automatic function that would allocate "name d" or "name e" to a
round if "name a, b or c" were not available for that day?
The table would look like this
Name a 1
name b 2
name c 3
Say for example "name a" was not available how would "name d" get allocated
to r...CTreeCtrl TV_ITEM labels
I am am drawing gradient color on CTreeCtrl background and i want to make
CTreeCtrl TV_ITEM labels ( text labels 0 trasparent ...
I am getting Image transparent
but not the text labels next to the image ... thats what is the problem
please let me know how to make it
thanks in advance
It is going to be somewhat difficult because of scrolling. But take a look
at www.codeproject.com on how to do custom draw tree controls, you will
basically have to draw the item text but before you do it you will call
"sarat" <email@example.com...Exchange 2003 stuck in maintenace mode
After applying exchange SP2 the exchange server is now stuck in maintance mode.
Any Ideas or how do I roll back the SP.
On Mon, 7 Nov 2005 04:27:07 -0800, James Deland
>After applying exchange SP2 the exchange server is now stuck in maintance mode.
In ESM, properties of the server, under the monitoring tab, do you
have the disable monitoring of this server checked?
>Any Ideas or how do I roll back the SP.
You can't uninstall or rollback an exch service pack.
...How Can I "sign" a spreadsheet to verify I reviewed?
...I need formula help please!
I need a formula to do this: I just can't seem to get the syntax right.
We have 2 types of buildings, 1 is permanent, 2 is portable. I am summing
all permanent buildings. I want to add the replacement cost of a portable
building to the replacement cost of the permanent building IF a school has a
portable building. . If a school has 3 permanent buildings and 5 portable
buildings, I want to add the replacement cost of all 5 of the portable
buildings to the already summed cost of the 3 permanent buildings. If a
school has no portable buildings, leave the value alone. Thanks so much!!!
...Need spreadsheet help
I have a spreadsheet with 5 columns. Column A is Category and Column E is
Amount. It is sorted by Category. I'd like to sum Column E for each value
in Category. E.G. if I have 10 entries with Category = Gas then I want
Column E totaled for the 10 Gas entries. And so forth for all the common
entries in Column A.
Can someone please help?
You can set something like this up for each individual category. For this
example we will use column F and G, starting in row 1.
Starting in F1, enter each individual Category
in G1 enter a formula like this:
=SUMIF(A:A,"=" ...Stuck in a loop.
1) Outlook crashes on startup
2) Sends error report to Microsoft
4) Goto 1
How do I rescue my system? I've tried the restart
in 'Safe Mode' and also allowed 'Detect & Repair' to run,
but to no avail.
XP Home SP2 running Outlook 2002 SP3
I assume by safe mode you mean you ran OL in safe mode, and not Win.
If you download and install this
then start and run OL through it, you may get a clue as to what is causing
"Ian Sweeney" <firstname.lastname@example.org> wrote in message
news:001e01c...Need to see which ODBC/server you are connected to
When in Great Plains, it would be VERY helpful if you could tell at the top,
which ODBC data source you are using. If we are in QA, we'd like to be able
to see that without having to change users first to see which server we are
connected to. I have had SEVERAL users express the desire for this feature.
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 ...Why are my emails stuck in my outbox?
Every once in a while my emails get stuck in the outbox. I deleted the
outgoing email, prepared another but still the same problem.
On Fri, 4 Jun 2010 18:21:58 -0700, Glen H <Glen
>Every once in a while my emails get stuck in the outbox. I deleted the
>outgoing email, prepared another but still the same problem.
Under Tools, Options, Mail Setup. Is the box "Send
immediately when connected" enabled?
To reply via e-mail, remove The Obvious and .invalid from my e-mail address.
I have data table with dates from AQ8 to BU8 and products in AP9-31.
In any one particular month the factory may only make on product, however in
other months it may make all 23. I would like to plot a graph of this data
that updates automatically - dynamic ranges.
As a result I have a graph that can move between one and 23 rows of data to
plot (series), each with its associated series name shown in the legend.
I have tried looking at Jon Peltiers website, C Pearson and several
questions on this discussion forum - no solution seems evident. Plotting the
data is no problem but getting...Need Driver Help after re-installing XP Pro!!
I was having some problems with my (somewhat old) Dell Dimension D600 laptop
so I decided to do a clean install.
Everything went well except now my Device Manager shows no drivers (question
I have no chipset install disk for this computer so using my other computer,
I went to the Dell web site and downloaded what I thought were a series of
drivers. The file is named DellDriverDownloadManager.application. I then
copied this file to my Dell laptop but it will not open except as a text
file in note...SRS still needed?
I have a front-end Exchange 2003 server and a 2-node back-end Exchange
2003 cluster. We migrated from an Exchange 5.5 system, removed all the
5.5 servers, and converted to Exchange native mode.
This morning I had to reboot the front-end server, and when it came up,
I saw a warning in the Application log:
Event ID: 1400
Description: The Microsoft Exchange Site Replication Service could not
initialize its Exchange database (EDB) and returned error 1. The Site
Replication Service will wait in a semi-running state so that the
database can be restored from back...Emails stuck in "Pending Send" state
Whenever emails are sent out from CRM using a Quick Campaign, they stay in
the "Pending Send" state forever. In the past, we've been able to solve this
simply by restarting the email router service, but as of a month ago that's
not working anymore. We have 2 exchange servers in a cluster, and I've tried
both... no luck. There are no errors in the event log on either the Exchange
server or the CRM server.
1. Under which user account are the quick campaigns being sent?
2. Does Send Email work for that user?
3. Does that user's profile properly have their...Need to obtain sum of last X entries that are greater than 0
Extreme thanks in advance...
In the above example column, assuming that the last four >0 are
needed, the result would be A2+A3+A4+A6. If A7 is updated to
something >0, the result would be A3+A4+A6+A7.
What if there aren't 4 values to sum?
Entered as an array using the key combo of CTRL,SHIFT,ENTER:
Use a big enough range to allow for added data. You can't use the entire
"Blue 58" <Blue58@set.hut> wrote in message
news...Outlook 2007 woes
I have had a lot of grief with my Outlook 2007 - periodically it
freezes. When I try to kill the process, and restart, it keeps getting
stuck at "updating cached messages (250/xxxx)". Everytime it is the
magic number 250. I have to kill and restart a few times (today has
been more than 10, hence this message), and then on one of these
tries, it seems to get over the hurdle and I am able to use it. This
usable period lasts for a few days/couple of weeks, and then I am back
to the same kill/restart/kill/restart routine to get it going.
My Outlook 2007 on one of these occasions ga...