data type mismatch in criteria expression
I have the following query as the source for a combo and I am getting the
above error message.
SELECT tble_employee.Employee, tble_employee.Dept
FROM tble_employee
WHERE (((tble_employee.Dept)<>"Operations") AND ((tble_employee.Work)=True))
ORDER BY tble_employee.Dept, Mid([Employee],InStr([Employee]," ")+1);
Hi
On the face of it the SQL looks ok.
From the error message I would want to double check the datatype of the
following...
tble_employee.Dept - Is this really text? or is it an integer foreign key?
tble_employee.Work - Confirm this is yes/no
tbl...
Microsoft Outlook Public FoldersWe use Microsoft Small Business Server 2000 and have
Outlook 2002 installed on all desktops. Some questions I
have:
How do I go about deleting the favourites folder
within "Public Folders"?
How do I go about deleting "Internet Newsgroups"
within "All Public Folders"?
I can not find ways to create folders directly in "Public
Folders". It seems I can only create folders within "All
Public Folders". Why is that?
Is there a way to delete "All Public Folders"
within "Public Folders"?
I would be extremely grateful for ...
Migrating all email / folders / address book from Outlook ExpressI am have been using Outlook Express for many years on what is now a
Windows XP computer.
Now I have a new laptop with XP and Office XP with Outlook 2003.
I want to migrate ALL of my Outlook Express email - preserving
headers, dates, attachments, folder structure, address book, etc. to
Outlook 2002/XP.
What is the best way to do this? It is very important that I not lose
any existing email message, attachments, headers, etc.
I couldn't find any useful info in the KB.. seems like there should be
a lot of help with this, assuming MS really wants me to move from
express to regular outlook ...
CRM3.0 needs to support single Exchange 2007Microsoft CRM needs to support Exchange 2007 without the need to have an
Exchange 2000/2003 server deployed.
It is not acceptable for customers to wait and be expected to wait to CRm4.0
is released then upgrade to this CRM version.
----------------
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 and then
click "I Agree" in the me...
Outlook 2003 HTML emailsHi,
I am using Outlook 2003 under WinXP SP3 with all updates
installed.
Quite often I receive HTML emails that has one of more solid
lines to the left of the text and/or pictures in the body of the
message. I suspect that these lines are the HTML equivalent of
> found in forwarded plain text messages.
Can anyone suggest how I can clean up the email by deleting the
solid line(s) before forwarding the message on to other
recipients?
--
Cheers . . . JC
In article <3n7o451ierhkjb2dltgturi1bu6m5fh94l@4ax.com>, jc@invalid.net
says...
> Hi,
>
> I am using Outlook 2003 unde...
Outlook 2007 SPAM issuesHi there,
I have been usinf Outlook 2007 for several months now and for a while it has
worked extremly well when dealing with spam. It is the past few weeks that
I have noticed a trickle of spam e-mails that are passing the Office spam
detector. The operating system (Vista) and Office 2007 is regularly updates
to as recent as this morning.
Is anyone experiencing the same or is it that there is a new attack on spam
e-mails?
Kindest Regards
I've been noticing a flow of spam from Quadrant (I think), it might be
taking time to craft a filter for the spam that doesn't remove t...
Exchange 2007/spam/windows mobileI have just installed Exchange Server 2007 and have moved a couple of
mailboxes over to it for testing. I am using the Anti-spam built into
EX2007. When a mailbox receives spam, it goes to the Junk Mail folder in
Outlook, but it is hitting the Inbox first. I have a Windows Mobile device
setup to sync to the Inbox (I checked to make sure that the Junk Email folder
is not selected and it is not). I have 2 different problems, but I believe
they both are related. The first... when the spam message hit my mailbox,
they are first hitting my inbox real quick and then being moved the Junk ...
outlook changes hyperlinks in Word table when document is attached to outlook e-Outlook changes hyperlinks in Word table when document is
attached to outlook e-mail. This is totally bizarre.
...
Additional info re: Word 2007 will not open files when you double click themI should have mentioned... I am running XP 32 bit SP3
Neil
...
InvalidCastException in outlook 2003Hi
In my VB.net application i got on different times (and not allways) an
System.InvalidCastException.
The line of code is:
objAppointmentItem = objItems.GetFirst
Does anyone know what to do???
Peter
Are you testing first for any items in the collection? Are you sure that all
the items you are getting are really AppointmentItem?
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm
"Peter van der Veen" <...
Cannot edit product entity in outlookI have verified that my user is a System Administrator, and that I have full
rights to the product entity.
When I access a product via the web interface, I can edit & delete my
products. I’ve verified my security rights by selecting: File -> Properties
from a product. I can Read, Append, Delete, Write and Append To.
After I install the Microsoft CRM Desktop Client for Outlook (online only)
on the same machine, I can no longer edit or delete the products. I’ve
verified my security rights by selecting: File -> Properties from a product.
I can Read, Append and Append To....
Curse of the winmail.datNo matter what I do, I cannot get rid of "winmail.dat" files with Outlook
2007.
I have gone through and changed all my contacts - (all 700 of them!!!) to
"let outlook decide" for the email type, and then within a week or two, it
changes back!!!!
PLEASE HELP ME!
I am also using a windows Smart phone syncing through bluetooth, if that
makes any difference - maybe that is causing the problems?
PLEASE HELP!
It is a BUG with either MS Outlook or Activesync.
If a contact is edited on the smartphone, then sync'd again, the Internet
type will be set back to Rich...
Outlook 2000 E-mail sluggishMy Outlook 2000 e-mail is very slow to open rceived new e-
mails or to open the "new" e-mail screen. It takes approx.
2 min. then opens the e-mail or the new e-mail window. I
have Office 2000 Premium Edition and Windows 98. I had SP1
installed and it was working fine. I have since installed
SP3 without correcting problem. I have used the Detect &
Repair without correcting problem. Did a necessary file(s)
go missing? Any suggestions?? Using the Detect and Repair
I received an Error 1328 C:\CONFIG.MSi\PTC2E3.TMP AND
C:\CONFIG.MSi\PT2321.TMP could not be updated...is this...
Changing Outlook from Exchange Services to IMO versionHow can you reinstall Office 2000 and change the Outlook
"type" from using Exchange/Internet Mail to Internet Mail
Only (IMO)?
I uninstalled my version of Office2000 and reinstalled it
from my CD. However it doesn't give me the option to
install the IMO version of Outlook. It installed the
Exchange/Internet Mail automatically. Without an exchange
server the checking of email is dog-slow.
Thanks,
Alex Moylen
Hi, Alex.
Alex Moylen ha scritto:
> How can you reinstall Office 2000 and change the Outlook
> "type" from using Exchange/Internet Mail to Internet Mail
...
Excel Not Talking To Outlook [Email Settings] #2This is a follow up to an older thread on the same problem. Search
groups.google.com for the same subject and you'll find the previous
thread (which lacked an answer). I'm just posting here for posterity.
When sending email from Excel and expecting to see your Outlook
contacts box come up for you but instead you see a strange box letting
you choose "shared contacts" or "this identity's contacts", the answer
is that Internet Explorer is set up to use Outlook Express for email
instead of Outlook.
Open IE, go to Tools > Internet Options > Programs tab. Chan...
Minimizing Outlook to system trayI have Outlook 2003. I was just wondering if there is a
way where when I minimize Outlook only the system tray
icon is showing and the Outlook bar on the task bar
disappears? I've looked in options and I can't seem to
find it.
Basically I want it to be running in the background so it
will still connect and download new e-mails and a message
bubble will appear telling if there's any new messages
(like it does already), but I don't want Outlook to be
showing on the taskbar.
Thanks in advance! Everyone on these newsgroups are
always so helpful :)
Right click the...
CRM tool bar disappeared in Client for OutlookHi,
The CRM menu Button bar ( on the main ruler: "File, Edit...") dissappeared
with no reason.
When I open a new mail I don't see anything to get the email tracked in CRM.
I tried to check in the Tool->Options->Other->advanced Options>Add in
specified at:
http://piyushmittal.wordpress.com/category/mscrm/ms-crm-troubleshotting/
but I don't see there any location path, so I can't follow the instructions
there...
I did not make anything yet using the Client for Outlook CRM 4.0, so I don't
see
why this should happen.
Thanks a lot
Has it worked at all...
Outlook 2003 and Hotmail #2OL2K3 does not play nicely with Hotmail, regardless of what the
marketing people want you to believe.
Every time I fire up OL2K3 and do a global "Send and Receive" I get an
error list like this: www.raindayspa.ca/emailerrors.gif
On a mass email recieve like that, my Hotmail folders almost never
populate.
I assure you my passwords and logins are correct -- after closing the
error window I can access the HM accounts individually and OL2K3 will
retrieve the mail. What's more, Hotmail access is still slow.
In contrast, OE6 integrates hotmail without any fusses. You'd think
th...
paste special picture from Excel 2007 to Publisher 2007 doesn't workI have a group of charts with text in surrounding cells that I want to copy and paste special picture enhanced metafile from Excel into Publisher. I have around 200 groups of these charts to paste into the Publisher file. What happens now is that the paste special command only reveals three options: new table, new text box, and HTML. When I copy paste special into Word the picture enhanced metafile is accessible and the image pastes fine. In Publisher pasting results in worksheet cells and the charts all in pieces and messy. I could copy the Word image into Publisher, but UGH!!200 TIMES. There...
Viewing and listening to Notebook notes on PC Word 2007Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
I created a .docx document in Word 2008 for the Mac and now i want to open the document in Word 2007 in windows and play the audio. Is this possible. <br><br>Michael
No. Sorry... Well... "Sort of..." :-)
Since it is a .docx, you can actually dig the audio out by unzipping.
Make a copy of the document and change the file extension to .zip. Open the
zip file and you will see a set of folders. In the Media folder you will
see one or more .mp3 files. That's your audio: copy it out...
Re: Outlook 2003, can it look like OXP?The Preview Pane is now called the reading Pane. Go to the View drop down
menu, go to Reading Pane submenu, select Bottom. The layout will be more
like XP. The Folder List and the outlook Bar buttons will stay the way they
are off to the left.
-Patrick
"John Smith" <etacr11inst@hotmail.com> wrote in
news:e3LvfVUpDHA.2592@TK2MSFTNGP10.phx.gbl:
> The Preview Pane is now called the reading Pane. Go to the View drop
> down menu, go to Reading Pane submenu, select Bottom. The layout will
> be more like XP. The Folder List and the outlook Bar buttons will stay
> the...
Excel 2007 startupHow do I start excel 07 with no blank workbook opening? On previous versions
one could start the excel program without opening the blank default workbook,
but, I can not find how to shut this off in 2007?
"RPB" <RPB@discussions.microsoft.com> wrote in message
news:189FFE77-92D4-4276-BE0E-82A85B0BA1EC@microsoft.com...
> How do I start excel 07 with no blank workbook opening? On previous
> versions
> one could start the excel program without opening the blank default
> workbook,
> but, I can not find how to shut this off in 2007?
Well I've been using Ex...
Outlook 2000-Open Note on top of all desktoplike a Post-ItI can't figure it out. I am a very, very technically challenged user and find
that the NOTE works great, but I can't use it like a sticky note and make it
stay on top. Is this easily do-able? Thanks for your time.
I find the free version of this much more suited to desktop display:
http://www.3m.com/us/office/postit/
--�
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After furious head scratching, Hello_It's_Me-C...
outlook 2000 changing msg class using utility?Hi-
this message is in 3 parts
DESCRIPTION OF PROJECT
I work for a small nonprofit group for pastors and outreach organization
leaders who meet once monthly as well as have an annual "love your city"
churches responding to neibourhood needs (free pop/ bbqs/ repair roofs/ clean
up yards) event......so need distribution centers for promo items, ect ...
comprehensive new form
I have permission from our Tech person to change all our contacts to this
form..... we'v backed up the hard-drive to cds, saved existing format of
contacts to excell files
so OBJECTIVES..KEEPING ...
Constant Outlook crash after Exchange 5.5 to 2K3 migrationWe are an Exchange 5.5 shop (gasp!) and we have finally begun our
migration to Exchange 2003. I was able to build our first 2K3 server,
and have it joined successfully into our 5.5 environment. The ADC is
up and running and is transferring data back and forth as I expect it
to.
Unfortunately I still have some lingering issues, one of which is a
complete showstopper. This main problem is that both of the accounts
I have moved from a 5.5 server to the 2003 server have *constant*
crashes in Outlook 2003. All I have to do is change to another folder,
and at least 60% of the time I will get a...