Excel Drop Down Boxes #2
Question; does anybody know how to add additional data to a previous
drop down box? I have created a form that has several drop down boxes
a while ago, and due to some information that has been change I need to
input more info in the drop down boxes but for some odd reason I cant
remember how I executed these actions!! If it helps I am using Excel
CRS's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27444
View this thread: http://www.excelforum.com/showthread.php?threadid=46...Box when opening File
Quick question...When I open up one of my saved files,
Visio automatically puts some kind of box (function box
possibly) around my heading and some of the text. I'll
take it off and save and it isn't there. But when I close
the file and then open it up again later it's there
again. I try to delete the box but it deletes my text
with it. I can't resize or delete the box (actually
conjoined boxes) by itself.
Any help would be greatly appreciated. Feel free to
Try changing the line weight of the shape to none.
John... Visio MVP
Nee...IMAP Rules Disappear
I set up a rule for IMAP messages to be sent to the users
main inbox. It will work for awhile and then the rule
will disappear. Our users have roaming profiles. Could
this be the issue? If so, is there a solution?
...Problem after e-mail server re-start
Hi, I have the prblem for OWA users to access the Exchange server every times
re-started the server, and Outlook users using IMAP connection also
experience delays or hangs.
The following is found in the event log
Event ID: 101
The server was unable to add the virtual root '/Exchange' for the directory
'M:\speedsourcing.com\MBX' due to the following error: The system cannot find
the path specified. The data is the error code.
From the Internet Services Manager, paths for Exchange, ExchWeb & Exadmin
are all unavailable. The first two can be manually r...Search box within access or third party addon to do such?
I have an access database with 6 columns. I am putting in an
inventory of all of my items with their corresponding sizes and
weights, etc. I will have over 2000 lines/records when I am done.
What I want to do, is either create something withing Access, or find
a third party add0on, that will allow me to search within the fields,
and return the corresponding results
here is what I have for example
category style size width weight notes
sample 1abc 5 2.2 2.1
sample 1add 3 2.5 2.1 for turning
stock 3bbb 3 ...Adjusting Text box size
In Access 2007, after creating a form using the wizard, all of the text boxes
created for entering data are the same size. When I try to adjust the width
of one, they all change width.
How can I unlock or change this feature?
I have deleted a box, and then re-added it. This sometimes works -- however
if you get the size close to the size of the other boxes, it “locks in” again.
I appreciate all sincere answers.
ah yes....a new feature in 07...
in Design View; select the 'Arrange' tab
then on the left side of my ribbon is:
You want t...Filter customerid
When I choose to sort the sales transaction records by "customerid", in the
Sales Transaction Entry screen, I would like to further filter the records
based on the starting character of the customerid. I would want to accomplish
this using VBA.
In other words if the customerid is chosen to be the sortby option, then if
I click on the nextbuttontoolbar/previousbuttontoolbar/
endoffilebuttontoolbar etc, I would want to filter the records based on the
starting character of the customerid, in addition to the sort by customerid.
...Show this folder as an e-mail Address Book #2
I have just created a new contacts list in our public folders.
When I go to all the workstations, the "Show this folder as an e-mail
Address Book" is unchecked.
To save me going to all workstations and checking this setting, is there
some way I can set it to "Show this folder as an e-mail Address Book"
....ms... <firstname.lastname@example.org> wrote:
> Hi all,
> I have just created a new contacts list in our public folders.
> When I go to all the workstations, the "Show this folder as an e-mail
> Address Book&q...newbie IMAP question
We've never used IMAP, but now have to in order to enable UM with our
For IMAP to work, do I just need to enable the protocol on our gateway
server, or does it have to be enabled on each and every mailbox server?
IMAP is not a "gateway" protocol because is not routed. If you're using a
front-end server, then, yes, you would have to enable IMAP on it and you
would have to enable it on every back-end (mailbox) server because the
front-end server passes through the IMAP protocol. Of course, if your UM
server talks directly to the back-end servers,...batch importing of mailing lists to Excel
I've got a mailing list of around 1000 names, stored in both Word and
Entourage like this: First Name Last Name <e-mail address>
Once I’ve eliminated the < >, do I then have to individually copy & paste
(or type) all the info in three Excel columns? Or is there a simpler solution
for batch importing of mailing lists to the Excel spreadsheet?
> I've got a mailing list of around 1000 names, stored in both Word and
> Entourage like this: First Name Last Name <e-mail address>
> Once I’ve eliminated the < >, do I then ...Multiple Exchange boxes in one domain
I have the following setup for my domain:
We have a branch office located on another industrial estate 1/2 mile
away, and we currently connect to them via WiFi (11Mb) and they are in
the same domain and subnet as us.
I am looking to add a second exchange box at their site so they can get
their mail "locally". When I look at setting it up tho ot seems that
exchange will still send the messages across the WiFi due to there only
being 1 MX record? Is there a way I can get them to recive their mail
directly over their own Broadband link?
Also ...Filter to specify which account is used according to email address?
I use outlook for work and personal email but i use two different
accounts to send/recive email. I have run into the problem of
sometimes mistakenly using my personal account to send work emails.
So my question is:
Is it possible to specify that addresses that meet a certain criteria
be send using a certain account. Say an email to Bob@amarc.mil will be
sent using my gmail account whereas a email to Jane@moog.gov will be
sent using a yahoo account?
Any help/suggestions would really be appreciated!
And my question is, what version of Outlook are you using? The answer =
is t...Mail Merge from Outlook Skips Records or doesn't merge at all
Outlook 2002 with Windows XP
I set up a mail merge from Outlook with several
contacts. The document seems fine, I can see all the
recipients when I "view merged data" and in the "mail
merge recipients" but when I complete the merge into a
new document only 2 records are merged. When I switched
to labels I received an error message "data records were
empty or no record matched query".
I've set the merge up "saving the contact data file to
another document" and not saving it, neither worked.
...List Box Change Event
I have a list box and have the following code in the worksheet module:
Private Sub MyListBox_Change()
My list box is called MyListBox but when I select it nothing happens. All I
want is to go to another sheet after the change occurs.
The only thing I can think is the name of my list box is incorrect but it
does show as MyListBox in the cell name drop down but it doesnt appear in the
defined names. Using 2003.
Can anyone see what I am doing wrong?
Thanks in advance
What sort of ListBox is it, from the Forms to...search box
when I type any information in to the search box, a message comes back saying
can not find this info?? That's on every thing I type in.
"Fred" <Fred@discussions.microsoft.com> wrote in message
> when I type any information in to the search box, a message comes back
> can not find this info?? That's on every thing I type in.
Which "search box" are you using, and what type of information are you
MS-MVP. MAIL. [DTS] UK.
http://www.ge...help with combo box
I have two columns in an excel sheet named as "Area" and "Territory". I want
to make two combo boxes, one for area and other for territory such that if I
choose a particular area, the entries in the territory combo box should
so, if i choose "2" in area combo box, the territory combo box should show
"cc" and "dd".
please h...Filter for time elapsed between 2 columns
I have Planned Start Time And Actual Start Time
I only want to return records where the Planned Start Time is equal to or
less than 48 hours from the Actual Start Time
Thanks for your help
I assume that this time fields include also the date, other wise you can't
know the different between two times unless they are both on the same day,
which mean up to 24 houres
In the query create another column that calculate the different between the
HoursDiff: DateDiff("h",[Start Time],[Actual Start Time])
That will return the different in hours, under that field create t...Junk Mail Filter Update
I just installed the latest Update for Outlook 2003 Junk-Email Filter
(KB956077) thought Windows Update (Vista Home Premium) and now my Junk mail
filter isn't working at all. What do I need to do to get it back working?
I also had a problem after installing this - plus a few other updates from
Windows. My problem was different - none of my Office 2003 applications would
To recover I used the System Restore utility ( Start | All Programs |
Accessories | System Tools | System Restore ) and restored my system to the
point just before the updates were applied.
Try it ...distribution lists sending out multiple mails
This a rather odd problem. My client has a distribution
list setup with about 50 members. Sometimes when he
sends an e-mail through the list some of the members
receive 5 of the same e-mail. This does not happen to all
of the members, only some of them. And the results are
not consistent with everytime he sends an e-mail through
the list. Just wondering if anyone has seen this.
Possibly it's a problem on the recipients end. Any ideas?
I am experiencing the same problem in Outlook 2003 with messages sen
from a bcc list. Did you receive any answers that might be helpful t...Auto dialer occurs when receiving html mail
I am using OL2000 and have been having some trouble with
the autodialer coming up when I just click on a message
sent to me that has what I assume is HTML. The problem
is that if that message is the most recent message in my
inbox then when OL auto connects on its regular hourly
schedule my mail delivery fails. The other problem is I
don't want to auto connect to the web every time I select
that particular type of message.
look under TOOLS | OPTIONS | MAIL SETUP
send immediately when connected deaktivate
under that option you have the dial up opti...Web-based Outlook bug: Cannot open mail when the subject field ends with a . (dot) character
From web-based Outlook, you cannot open any mail with the subject
field ends with "." (dot) character.
Outlook web will return HTTP 404: The page cannot be found.
It's URLScan doing this. See http://support.microsoft.com/?id=325965
For Exchange news, links and tips, check:
"Ken Jones" <email@example.com> wrote in message
> From web-based Outlook, you cannot open any mail with the subject
> field ends with "." (dot) character.
&...Cascading combo box 10-28-07
Cascading combo boxes and the considerable help in this Forum and its links
to examples on other web sites have overtaxed me.
I have a table with 3 fields: [Bvl], [Auth] and [Crit]
Using a query, the available field values have been limited to:
[Y] and [N] for [Bvl];
[A] and [B] for [Auth]; and
 and  for [Crit].
[A] and [B] each correspond with each of [Y] and [N].
 corresponds with [Y].[A] and [N].[A] AND [Y].[B]
 corresponds only with [[N].[B]
In other words, the choice of combinations are: [Y].[A].; [Y].[B.; [N].
[A]. and [N].[B].
I want Combo2, incorporatin...Multiple check boxes
I have a list of multiple check boxes on a form, how do I make to where only
one check box can be checked?
change to option group
"Marc" <Marc@discussions.microsoft.com> wrote in message
>I have a list of multiple check boxes on a form, how do I make to where
> one check box can be checked?
I suggest that you use a radio button option group. This allows only one
option to be selected at a time.
>I have a list of multiple check boxes on a form, how do I make ...Hexadecimal & Text Box
I overrided WM_CHAR to allow only some
characters to be entered in a text box..
But the text box allows the paste command...
How can I know when the user "paste" so I can
verify the input !?
Thanks a bunch
You have to catch the WM_PASTE message and check the content.
take a look at this example
"Mike Gleason jr Couturier" <firstname.lastname@example.org> wrote in message
> I overrided WM_CHAR to allow only some
> characters to be entere...How to size static text box?
I've got a relatively simple dialog that includes some static text along the
border containing a mini-help message. On my two systems here with Win2K
and WinXP at both 1200x1024 and 1600x1200 resolution the text displays fine.
At another location with both WinNT4.0 at 1024x768 and Win2K at 1200x1024
part of the text is cut off because the box is too small for it.
It's possible, I think, that the problem isn't the resolution of the
displays but the size of the "standard text" font, but I don't want to start
changing a dozen different desktop fonts until I find which ...