Microsoft Access: How do I create a drop down list that stores the index value, but displays text value?
I have my primary table called Projects with headers as follows:
Projects ID, Project Name, Project Leader ID
And I have a second table called Project Leaders which stores Project
Leader ID as the primary key with headers as follows:
Project Leader ID, Project Leader Name
I am trying to create a Project Entry Form that displays and has a
drop down of the Project Leader Names, but stores the Project Leader
ID in the Projects Table.
Thanks for your help!
in your form, use a combo box control. set the RowSource to the Project
Leaders table. number of columns, 2. column widths...a question about creating mailbox enabled users in AD
Let's say i have 1 2k server that is a DC and one 2k member server. i have exchange 2000 installed on the member server and the member server is of course part of the DC's domain. i thought that i could just go into AD Users and Computers on the domain controller, create a new user account and that i would get the option to create them a mailbox as well. But i never got the screen that has the check box in it to create the new user a mailbox. it was not until i went to the exchange box, brought up an MMC and threw AD Users and Computers in it, and created the new user from there that i...Outlook Sends Non Exchange POP3 Mail Using Exchange, 553 rcphosts error results...
We recently moved one of our clients email servers. They have both
local exchange accounts and external POP3 domain.com accounts setup in
exchange. Domain.com is still their email server but it now has a new
IP. For some reason outlook appears to be sending the external email
through exchange even though all the outgoing servers are setup for
the account to use the external mail server. The emails bounce back
to the internal account with the following error even though they were
send from the external account:
553 sorry, that domain isn't in my list of allowed rcphosts
(#5....Exchange in cached mode not possible for 1 user
I have one exchange user which are not able to run in cached mode. When I
turn off cached mode - no problems. Does anybody have an idea?
I have tried setup on several pc's - same problem occurs
What specific issues or problems do you see?
MVP - Exchange
NEW blog location:
"Peter Jensen" <email@example.com> wrote in message
> I have one exchange user which are not a...Converting Publisher 2000 files to 97
I need to be able to convert several (hundred?) Publisher 2000 files to
97 so I can import them into PageMaker. Is there a tool that I can use
to do this?
Nothing I've heard of.
MVP Microsoft [Publisher]
"ingenious" <firstname.lastname@example.org> wrote in message
> I need to be able to convert several (hundred?) Publisher 2000 files to
> 97 so I can import them into PageMaker. Is there a tool that I can use
> to do this?
Nothin...MS Office 2010
I recently installed MS Office 2010 on my computer. I have windows 7 64bit on
it as well. When I login, it gives an error message stating:
Either there is no default mail client or the current mail client cannot
fulfill the messaging request.
I've tried the regedit fix by deleting
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Clients\Mail\Microsoft Outlook and
repairing Office after deleting.
I also tried setting as default from control panel but it did not work.
Deleting the MSMAPI\1033 did not work either. I still get the message when I
log off and log back in.
Is t...Accounts with Orfaned Exchange attributes
I need to uninstall the first Exchange server from our org, however, there
are still users that the uninstall detects that belong to that server. Here
is the thing: I would just move those users to the other server, but the
store that their mailboxes existed on doesn't exist anymore, therefore the
moveprocess would not have anything to move (if that makes any sense at
all). I can't delete the mailbox for the same reason. Does anyone have ANY
suggestions other than deleting and re-creating the users?
...I cant open Exchange system manager
I am facing a problem with opening Exchange system manager, i have a two
front-end servers (Exchange 2003 with sp1) in windows 2003, and Exchange
backend (EXch 2003 with sp1) on windows 2003 cluster.
The problem occures only on front-end servers which are located in DMZ, in
the backend i have no problem.
This is the message that comes after trying to open System manager :
( Exchnage system manager could not intialize MAPI because the current user
account does not have the SE_CREATE_GLOBAL_NAME privilege on this computer.
log on using another account that has this privilege, or grant th...search any files containing some words
I want to use Windows Explorer to search files that contain a word like PID.
The file type could be .hl7, .txt, .doc or .pdf. How can I do this?
Right now it does not show the result for .hl7 file. .hl7 is a text file
On Tue, 7 Sep 2010 15:43:33 +1000, Peter wrote:
> I want to use Windows Explorer to search files that contain a word like PID.
> The file type could be .hl7, .txt, .doc or .pdf. How can I do this?
> Right now it does not show the result for .hl7 file. .hl7 is a text file
S...fail to delegate exchange administrator right
we are running exchange 2003 enterprise , when i try to using the delegate
wizard to delegate a new user as the exchange administartor from the
organization level, after i apply it, i found that the new user is being add
in all object's the serurity tab but without being assigned any right.
anyone can help me anywhere wrong i make it ? the new account is a domain
admin group and local admin group already
...Creating a timesheet schedular spreadsheet
I'm trying to create an Excel schedular for my employees. I typically
type 9-5 or 10-6 and I know that the employees are scheduled to work 8
hours, so I manually type these totals in. How can I do this where
Excel automates the totals? I'm ok typing 9 in one column and 5 in
another and have it calculate. However, it's not convenient if I have
to type 9:00AM in one and 5:00PM in another.
If you could recommend a place to get a free template, that would be
even better :D
Thank you in advance for your time.:confused:
Message posted from http://www.ExcelForum.com/
Chip Pears...How to change a file types order?
I've got an MS Office 2007. When I want to save an e-mail, there is a
list of file types with extensions. How could I change it? And how
could I change default file extension?
> I've got an MS Office 2007. When I want to save an e-mail, there is a
> list of file types with extensions. How could I change it? And how
> could I change default file extension?
You can't AFAIK.....
...Add users to a Distribution Group using csv file
Is it possible? I have a list of approx 3200 users that I want to add to a
common duistribution group w/o having to do it manually. At present I have a
csv file with all the users that I want to be in the group. Is there a way
to import them into the group using this file w/o recreating their accounts
using csvde or ldife?
"kage13" <email@example.com> wrote in message
&...Exchange 5.5 Recovery
While replacing the batteries on our UPS, the power
managed to cut out, shutting down the network (rather
ironic). Anyway, everything seems to be ok except for the
exhange server running on our NT server. When rebooted,
the NT server indications that one or more services were
not started, etc...
When I try to start all of the services manually, I get
numerous 1068 errors: The dependency service or group
failed to start. Also, when I try to run the exchange
administrator, I get a "MS Exchange Server computer does
not respond. Microsoft Exchange Directory ID no:
DS_E_COMMUNIC...Is there a quick way to count how many emails are in my .PST file(s)
Is there a quick way to count how many emails are in my .PST file?
(Why? Because I want to know whether GoogleDesktop has managed
to spider my archive file properly...)
IN OUTLOOK? - Click on the highest level folder
Left-click and select properties
There should be a button there called "Folder Size"
"ship" <firstname.lastname@example.org> wrote in message
> Is there a quick way to count how many emails are in my .PST file?
> (Why? Because ...2010 date in Excel 2000
It appears that Excel 2000 does not like any year after 2009, as it tells me
date is invalid. Is there a way to fix this ?
What exactly do you do? Enter a date or use a date in a formula? What date?
What is the error message? What date system is your Windows using
(dd/mm/yyy, mmm dd yy, etc) for Long date and Short date?
Microsoft MVP - Excel
"BudW" <BudW@discussions.microsoft.com> wrote in message
> It appears that Excel 2000 does not like any year after 2009, as i...Create DDL
How can I create/generate DDL from a visio ER diagram (.vsd) ?
If you're have visio enterprise architect, AFAIK it is in the help facility.
"Alan" <NOSPAMalan_pltse@yahoo.com.au> wrote in message
> How can I create/generate DDL from a visio ER diagram (.vsd) ?
...Exchange services not starting...
We've recently been plagued by a few things on our Exchange 2003 Enterprise
server running on Windows Server 2003.
One of the main items is that the MS Exchange SA, MS Exchange Info Store and
MS Exchange MTA Stacks services are not automatically starting. We're having
the manually start each of those services.
The only things performed to the server has been the /3gb /userva=3030
switch added to the boot.ini file and circular logging turned on.
Does anyone have any ideas as to what might be causing this to happen?
i'm assuming you already checked the obvious..li...archive.pst file wont open
I have archived emails, unable to access.
"program not on computer"
Using Outlook 2002, XP Home edition
"Slater" <Slater@discussions.microsoft.com> wrote in message
>I have archived emails, unable to access.
> "program not on computer"
> Using Outlook 2002, XP Home edition
What program/version were they created with? How are you trying to access
Thank you Alan for the prompt reply. Outlook V.2002
1. Imported emails from Outlook express
2. tools/options/other/auto archiv...Creating New Users
I am running Exchange 2003 on SBS 2003. When I create a
new user in Server Management, it does not create a new
mailbox in Exchange. What am I doing wrong?
"Scott" <email@example.com> wrote:
>I am running Exchange 2003 on SBS 2003. When I create a
>new user in Server Management, it does not create a new
>mailbox in Exchange. What am I doing wrong?
Does it ask you if it should create a mailbox? (Not familiar with that
ridiculous SBS console)
The reason I ask is that you will not...Display a PDF file in Excel as a picture
I am trying to insert a PDF file in a spreadsheet so that it views as a picture, not an icon
I need to print a PDF picture of a machine toolpath to send out to our shop with our orders
Maybe you can copy it as a picture from within Adobe's reader.
Select the Graphics Icon in Reader.
Lasso your "picture"
back to excel and edit|paste
In simple tests, I had to do each pdf page one at a time. And it helped if I
copied from a zoom that was readable--if I blew up the picture within excel, it
looked very bad.
Stevie H wrote:
> I am trying to insert a PDF fi...File conversion window message with strange characters
Word documents open with the File Conversion window showing first. No matter
what encoding I select I still get incomprehensible characters. This occurrs
in all my saved and new files and I just can't get them to display normally.
That suggests that the files are all corrupt. Where are they stored? How did
they get there? How long has this been happening? Which versions of Word and
OS are you using? Are they fully patched up to date?
Terry Farrell - MSWord MVP
"jeangladi" <firstname.lastname@example.org> wrote in message
news:AA5629FD-30A4-44F7-B2...Can't view files with latest beta2 refresh
I downloaded the latest Beta2 refresh and now I cant access any of my word
and publisher docs. It says "can't find file" or some such thing. I thought I
read somewhere that the view and print functions in the latest refresh have
been disabled. This is MOST inconvenient as every piece of business on my
hard drive is now useless....is there any way of fixing this?
...MS CRM without MS Exchange server
This is a multi-part message in MIME format.
I am new to MS CRM and started it couple of weeks ago. My query is that =
"How we can use the MS CRM without MS Exchange server?" I had found =
couple of articles while googling which say that its possible to use CRM =
without exchange and some junkies did that too (they are selling the =
connectors created by them to achieve this). If I am right, it can be =
done in one of following ways:
...refuses to register my Office Pro 2010 MAK key
I received a message that I have 4 days to register my copy of Office
Professional Plus 2010 but when I try to register the MAC key I got from the
download, it says is an invalid key.
If no answer here try the Office 2010 forum:
"Pzzld" <Pzzld@discussions.microsoft.com> wrote in message
>I received a message that I have 4 days to register my copy of Office
> Professional Plus 2010 but when I try to register the MAC key I got from