linking drop down lists
hi, im trying to create a user friendly spreadsheet. i have 2 columns
need help with.
in the first column i have created a drop down list containing
continents of the world. in the second column i want another drop dow
list to display only the countries from the continent selected. fo
instance. in the first column i have selected africa. how can i make i
so that when i have selected africa from the continents drop down list
to make the cell next to it (the countries drop down list)( only giv
the option of selecting a country from africa instead of all th
countries of the world
reading2...Export to XML exports single row only
What I did: On XML source panel of Excel 2007 added XML map, mapped to
columns using ranges (i. e. A1:A1825), selected “Export” from “Developer” tab
in the ribbon.
Result: Output XML file contains only one record (first row from the
I’ve done this numerous times in Excel 2003 with no problem. What happens??
...Exchange 2003: Not all distribution list members recieving e-mail
We have 3 distribution lists that we use to send mail to our 3
different regions. I have users in each list that are not reciving the
e-mails sent to the lists. I have verified their email address's, made
sure they were in the right group. I can look at the email (it gets
sent to me as well) and I can see that they are in the list.
Now, if I send them an e-mail from their contact, they get it. Its just
when we send them e-mail on this list.
On 12 Sep 2005 09:59:33 -0700, firstname.lastname@example.org wrote:
>We have 3 distribution li...Message Tracking
when I use the Tracking Center, and select on of our two Exchangeservers,
the MMC will change the name to the second server automatically.
Message Tracking is enabled on both of the servers....
Are you specifying any other parameters such as a sender or recipient? If
you are, the Message Tracking Center is probably just matching up the user
you specify with their home server.
Read my blog!
http://feeds.feedburner.com/winzenz (RSS Feed)
"HWU" <HWU@discussions.microsoft.com> wrote in message
news:6A3F55D...Contacts export display X400 not SMTP
I'm not sure if this behavior is by default or not, but when my users try to
export their contacts to an Excel file, any internal (domain) contacts show
the X400 address rather than the SMTP address.
Is there a way to change this? I've read some about VB scripts with CDO or
something, but hoping there is an alternate way.
what version Exchange?
Susan Conkey [MVP]
"Mike W." <wallmr_snowpam@gmailDOTC0M> wrote in message
> Hi all,
> I'm not sure if this behavio...Export / Import Security
Ok, so I have setup my test environment again. Now I have to create security
all over from scratch to define what will be used in production. Is there a
way to export from the test environment and then import it into the newly
upgraded installation? In both cases security has been/will be completely
removed from the 8.0 install (restored on new server) before being upgraded
to version 10.
Security will be upgraded upon upgrading GP from GP 8.0 SP5 to GP 10.0.
Converting the Security structure from GP 8.0 to 10.0 will not be an easy
Mohammad R. Daoud
MCP, MCBM...distribution list #29
i have a list of email contacts in an excel spreadsheet . Is there a way to
convert them easily to a distribution list in Outlook 2000, without
copy/paste each contact indiviudally ?
thanks in advance ,
if the addresses are in a column, you should just need to copy the column
and paste it.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://w...Exporting Sent Email Addresses from Entourage
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I'm trying to export email addresses from an employee's Entourage, but would like to include email addresses in his "Sent Items" folder. Is there a way to export these email addresses aside from exporting the "MBOX" file, which has all the email content as well?
Thanks in advance!
On 3/12/08 8:49 AM, in article email@example.comR9absDaxw,
"Quinlisk@officeformac.com" <Quinlisk@officeformac.com> wrote:
> I'm trying to export email addresses from an emplo...Banging my head against the wall
I need some clarification of if a control exists that will fit into m
What I need to do is display a list of data horizontally in a control.
The data, is a question which can be 50 to 100 characters long and the
need to see the whole text of the question.
Preferably there would be 1 row of data and the questions would go int
the columns with a scroll bar to move along. Thus far I have tried -
A listbox - can't seem to toggle the height of the row so all of th
question text can be displayed in one go.
Listview - Same as above
Spreadsheet 9.0 Control - Thought I had ...Offline database cant be viewed
Outlook CRM Successfully copied all datas to local database for offline
browsing. but when trying to browse the offline database, it first shows
authentication error and clicking on Try again shows an empty page and no
records. For your information, the CRM offline database MSCRM_MSDE.mdf is
now more than 450MB but still couldnt browse any records in it.
How to rectify the problem?
On Feb 25, 11:43 am, TNa <T...@discussions.microsoft.com> wrote:
> Outlook CRM Successfully copied all datas to local database for offline
> browsing. but when trying to browse the offline datab...Export item ID?
Hi there. Having resolved my previous EMS Data import issues, I have
now moved on to more complicated things (importing supplier lists,
aliases etc). However, these operations require the item ID for each
item - something I don't have. Is there some way I can export these
from the database so I know what item ID corresponds to each item. I
have run a query in Administrator (select itemlookupcode, ID from item)
which tells me this, but I haven't worked out how to export this out to
a spreadsheet. Any help would be appreciated, cheers
After running your query goto File menu and Export....need help with list box?
I have a huge table of about 20000 records. how can I restrict entry for a
I am new to excel programming.
For example. I have a list of colors (red, green, blue) that I want to go
under the Color column. how can I allow the user to click on a pulldown or
list box similar to ms access for each cell.
thanks in advance.
you could use
'Data - Validation'. See:
>I have a huge table of about 20000 records. how can I
restrict entry for a
>I am new to exc...Re: Converting Access Database From 2003 to Access 97
jixiaoli <firstname.lastname@example.org> wrote in message news:...
> Tim <email@example.com> wrote in message
> I am developing applications in VB and Access. I distribute an Access 97
> database as part of the system. I have recently upgraded from using Access
> XP to Access 2003 to manage the distributed database. Since I still wish
> distribute the database in Access 97 format to clients, I convert the file
> from Access 2003 to Access 97 format before distribution. The distribution
> database contains ...List views
I have a list view in which I have selected grid lines in report mode. The
grid lines show ok until I scroll down and then the horizontal line fall out
of step colliding with the text.
Does anyone know what is happening here and how to fix it?
>I have a list view in which I have selected grid lines in report mode. The
>grid lines show ok until I scroll down and then the horizontal line fall out
>of step colliding with the text.
>Does anyone know what is happening here and how to fix it?
Sadly, the fix is to switch off the grid lines :(
PSS ID Number: 813791 "B...Exporting email in Outlook Express
I am unable to export all emails in Outlook Express. First
it had an error message mentioning MAPI so i followed the
instructions on Microsoft Knowledge Base to install
Windows Messaging - now when i try to export the following
error message is: MAPISP32 caused an invalid page fault in
module KERNEL32.DLL at 0187:bff7b9a6.
Does anyone know what this means?
tania jackson <firstname.lastname@example.org> wrote:
> I am unable to export all emails in Outlook Express.
Ask in an Outlook Express newsgroup.
3290 Patterson Ave. SE, MS 1B3
Grand Rapid...Exporting to Powerpoint
I have a small table in Excel that I am trying to export
to PowerPoint, for some inexplicable reason one column was
always missing even though it was specified in the range
which the Macro is supposed to export. My manager is the
only was able to see the value in that column and no other
can replicate his success. Do you know any reason for
this? We are all looking at the exact same file, why
could he see something that the rest of us cannot?
Why don't you simply copy and paste the whole table into a Powerpoin
Message posted from http://www.ExcelForum.com...tracking changes
I'm on a network with others. I've created a timesheet in Excel for others
to fill out. They password protect it so third parties can't see it but I
have the password, too. I need a method of preventing people from going back
and changing data in the spreadsheet after I have reviewed it. I know I
probably can't prevent them from making changes but can I somehow detect if
they've altered values to the spreadsheet at some point in the future? I
tried to set it up with a shared workbook using the "track changes" feature
but it doesn't seem to work wit...POP Receipt Edit List with Lot Numbers & Attributes
Has anyone successfully managed to edit the POP Receivings edit list to
include the Lot Number and the Lot Attributes? If so, could you advise me
how you created the table links please? I am on version 10
Due to the Temp Tables looks very difficult.
I would consider using another method like SQL Reports to get the Lot
> Hi Folks
> Has anyone successfully managed to edit the POP Receivings edit list to
> include the Lot Number and the Lot Attributes? If so, could you advise me
> how you...Export Image Package
I have an access application that has stored .JPG images within the database
as a "Package". How can I export the image back to a normal .jpg file so
that it can be read by a normal (non ole server) imaging application?
...Export registry key
Is there an API to Export and Extract a registry key in a text format ?
I need to simulate the operation that is done by the user of exporting a key
(and creating a .reg file in a text format).
I do not want to use RegSaveKey/RegRestorekey which work in a binary format.
I believe you will have to do this yourself. There is no Automation or exported function interface
to RegEdit, and that .Reg file concept is a feature of that program. However, it shouldn't be
terribly difficult to do this, using RegEnumKeyEx and RegEnumValue or the CRegKey class, use a
CStdioFile object...Export from Excel to Word
I have a 20 page Excel document that has a LOT of formating involved, it is
text not data. Is there a way that I get it into Word without having to redo
all the formatting? It is 11x17, landscape.
Select the area you wish to copy.
While holding the SHIFT key pull-down:
Edit > Copy Picture...
In the Word document, just paste.
Because you have pasted a picture, the formatting will be preserved. Also
because its a picture, yo can re-size it as you choose.
> I have a 20 page Excel document that has a LOT of formating inv...Drop down list help #2
Excel 2003I have created a drop down list in a cell(s) and I want the list
to show all values with out a scroll bar. The list is not long (maybe 20
values in the end)
Anyway to do this?
Only with a combobox....................Data Validation dropdowns are
limited to 8 items.
Debra Dalgleish has a sample workbook with a 12 item combobox tied to a DV
Can be easily changed to your 20 items.
Gord Dibben MS Excel MVP
On Tue, 16 Jun 2009 11:36:13 -0700, "Dave" <email@example.com> wrote:
>Exce...Splitting Database 12-23-09
Two main questions with one sub question in the second question.
First, I split a database, and if I try to open the front end while a user
is using a connected Data Access Page, it does not let me in. If I log in
during a time that no one is using the Data Access Page, I can get in and
after I'm in they can get in too, and the users of the Data Access Page can
have simultaneous use with me. What can I do so that I can get in the front
end at any time regardless of what activity is taking place with the Data
Second, how do I distibute copies of the front end?...Reverse of export to database
I would like to generate a Visio drawing starting from an Access
database which contains the results of an 'export to database' of an
existing drawing. I found import possibilities from Excel, csv, txt
files, but not from databases. I'm using Visio 2002 Professional.
Are you trying to import the data from the database tables or the database
If it is the database schema, run the Database modeling template (File \ New
\ Database \ Database model diagram)
If you want to get the data, try the "Link to Database" dialog (Tools \
Macros \ Visio Extras...Export email addresses including aliases
I have a medium organization with 5 different domains so each user has 5 to 10 email aliases. I can't find a way (an easy way) to export all email addresses into a script file so I can create accounts on our off-site anti-spam provider.
DOES ANYONE KNOW HOW TO EXPORT EMAIL ALIASES IN EXCHANGE 2000
Thank you, Shawn.
"Shawn" <firstname.lastname@example.org> wrote:
>I have a medium organization with 5 different domains so each user has 5 to 10 email aliases. I can't find a way (an easy way) to export all email addresses into a script file so I can create accounts on o...