How do I expand the Name Box?
When I name a range, it is posted to the Name Box (next to the formula bar).
However, the full name is not displayed due to the size of the name box.
"JohnnyQuick" <JohnnyQuick@discussions.microsoft.com> wrote in message
> When I name a range, it is posted to the Name Box (next to the formula
> However, the full name is not displayed due to the size of the name box.
You can do this only through code...how do i openexcel spreadsheet sent via e mail
how do iopen aspreadsheet sent via email windows need to know what programme
created it .i dont understand
Always copy the file on your harddisk first before you open it
Never open it in the mail.
Maybe they send a link to the file to you instead of the file ?
You can try this
Tools>Options>General uncheck "Ignore other Applications"
Exit Excel and try again
If this doesn't work try to re-register Excel
Close Excel first and
On the Windows Taskbar
1 ) Start>Run "excel.exe /unregserver"(no quotes)>OK.
2) Start>Run "excel.exe /regserver&qu...form entry based on combo box/lookup
ok. I have been marauding these forums for awhile now and first of thanks to
all those whom help others out... makes a difference.
This is my first post in here and hopefully this will make sense...
I have three tables.
one for clients
one for employees
and one for hourly charges
this database is going to end up being remotely accessed > still working on
that part as well... but here is my current hurdle...
I have a form that outputs to the hourly charges table but pulls information
from clients for the "PROPERTYNAME" and "COSTPERONSITE". and from employees
for...Two combo box for a report 09-11-07
A blessed day to you all! I have another question regarding reports.
Let me try to explain this as far as i can..Please bear with me..
What i have done so far..
I have a simple report to display Issue Vouchers for a Certain Site.
I have created an unbound form with a Combo Box (List of Site i have
created base on the Site table) which will ask the user what Site only
to be displayed in the report, so basically the user is trying to
So when the user choose a site example, Head Office and press the
Preview button then the report will filter and display the report with
only th...Auto Fill Text Box
I am having trouble getting a text box to auto fill from a choice made from a
Combo Box Name is Address_21
Text Box Name is City_1
My code is as follows:
'Auto Fill CES Spec Written Office
Private Sub ShowCity_1()
Dim Address_21 As Variant
Dim City_1 As Variant
If UserForm1.Address_21 = "2306 Long Green Court" Then UserForm1.City_1
If UserForm1.Address_21 = "3440 Oakcliff Road" Then UserForm1.City_1 =
If UserForm1.Address_21 = "7015 East 14th Aveneue" Then UserForm1.City_1
= Tampa...Disabled Users / Deleted Mail Boxes
I have accounts that are disabled in AD an their MB's are deleted. My App
log is full of 9548 warnings. All I have read so far is to change permissions
on the MB, it no longer exists. Get the NoMAS Tool and I am not sure if it
Any Ideas Guys? I can't believe that you can delete a MB without deleting
the AD Account. Don't ask why... I work for a Law Firm, I need to keep the
Account but I can delete the MB's...
On Mon, 15 May 2006 10:32:02 -0700, George
>Exchange 200...SETTING UP MAIL BOX
I have tried various combinations of server & address for both outgoing and
incoming mail without any success. Please advise a novice on what should be
in the signing up boxes.
Thanks in anticipation of your advice.
"GEOFF HUTCHINSON" <email@example.com> wrote in message
>I have tried various combinations of server & address for both outgoing and
>incoming mail without any success. Please advise a novice on what should be
>in the signing up boxes.
> Thanks in anticipa...Sent to as attachment command
I was wondering if there is a way to set up a hyperlink
that when clicked sends the workbook as an attachment to
the person specified by the hyperlink??
A hyperlink can't do this as far as I know
But you can use a macro that will send it
to the address in the activecell
If ActiveCell.Value Like "*@*" Then
ActiveWorkbook.SendMail ActiveCell.Value, _
"This is the Subject line"
See for more mail examples
Regards Ron de Bruin
(Win XP Pro...Sent Mail, have mail in sent box not sent by me??
This has now happened two weeks in a row. How can I correct this? My
computer is turned off when this is done. Email is being sent to people not
in my contact list. Do I have to close this account in order to correct?
Is it a Hotmail account?
Recent reports of Hotmail Account hijacks
If from another mail service, You can use the above as a guide for the
sorts of things to check/change.
Mike - http://TechHelp.Santovec.us
"eve" <firstname.lastname@example.org>...Combo Box Populating
I have two fields on a table, called Type1 and Type2. I created a form based
upon these fields and i need help in what i want to do. On this form i have
two combo boxes, combo1 and combo2. From combo1 i want to be able to select a
value, and upon doing this, combo2 will be populated with specific data based
on what i selected.
...Requery a Combo Box List
I have a combo box in a Tabular Form which has a drop down box select, but
if I put the word Green in the list , the option to select it in the next
box doesn't show untill I close the form and open it again is there a way to
update it straight away........Thanx ....Bob
Use code like the following in the AfterUpdate event of the combo:
Private Sub MyCombo_AfterUpdate()
Arvin Meyer, MCP, MVP
"Bob" <email@example.com> wrote in message news:evmhs8$d3q...Can not leave the Edit box empty when associate it with a float variable
I am using an Edit control in Dialog to input float data, I associated a
float variable with the Edit control. When I try to change the input, I use
backspace to delete all the digits, but the program was terminated with an
error at this time. I have to be carefull for not deleting all the digits in
Edit box(one digit have to be there). But you can not always avoid that.
Does anybody know how to avoid this problem?
Thanks in advance!
>I am using an Edit control in Dialog to input float data, I associated a
>float variable with the Edit control. When I try to change the input, I...Finding "missing" Sent Mail
My Boss just came to me in a panic as he had a message on his screen about
consolidating his mail (how he describes it) and he told it Yes.. He now
can not find his saved Sent Mail.... Can you help? Where did it go?
Perhaps he archived his email? Open Outlook, click on Tools > Options > Other > Autoarchive and see if autoarchive appears to be turned on. If it is, this will show you the exact file the
items have been moved to.
Next you will need for Outlook to display this file within the user interface. To do that, click on File >...Populating appropirate account in look up box when selecting contact
I wonder anyone can point me in the right direction can help out there.
We have a CRM Case form where it has Customer lookup field (Regarding lookup
for Account/Contacts) and also Responsible contact lookup field (lookup for
What we want happen is as soon as Responsible contact is selected from a
lookup, automatic population of appropirate Account in Customer look up
We believe it should be possible because contacts in the system are already
linked to Account records
any help is much appreciated.
You will need to write a ...List Box Values
Can I use values from a list box/combo box in a formula and if so how do I
Sorry wrong NG
"Mike Cramsey" <firstname.lastname@example.org> wrote in message
> Can I use values from a list box/combo box in a formula and if so how do I
> do that?
...No labels for sent or forwared mail
Sometimes when I am forwarding or replying mails label of message is not
changing as forwarded or replayed. Where is problem and how I can solve it?
You mean the icon doesn't reflect the change?
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real World Questions, Real World Answers
"girts" <email@example.com> wrote in message
I want to have a dialog box pop up when I open an excel workbook. I just
want it to say something like 'enter name in cell A6" and then have an "OK"
button that closes the pop up.
Any assistance would be appreciated
Open the VB editor (Alt F11 or similar).
Menu Insert > Module.
Paste this into the module:
MsgBox "enter name in cell A6", vbOKOnly, _
"Any assistance would be appreciated"
Save, close, reopen.
HTH. Best wishes Harald
"webster" <firstname.lastname@example.org....old email sent back randomly
I'm running exchange 2000 on a server 2000 professional, both exchange and
windows with the latest patches installed.
One user sent an email in september to a bunch of people with an attachment
of around 800 KB.
Randomly this email is sent back to some of the people recipients of the
first email. The user who sent the email and who is in destination of this
email, does not receive it. Some of the recipients do not receive it and a
NDR is generated however their email address is correct.
I've checked the outbox on both outlook and outlook web access on the user'...Preventing End users in Outlook from Deleting sent folders
I want to be able to prevent users from deleting their sent emails. Is there
a way to do so on the server side?
I've never heard of any way to do this...all you could do, if you need to
ensure you have copies of all data, would be to enable journaling...
Susan Conkey [MVP]
"brenda" <email@example.com> wrote in message
> I want to be able to prevent users from deleting their sent emails. Is
> a way to do so on the server side?
A user has full control over their *own* mail...mail not sent
User had an Excel spreadsheet open and tried e-mailing it
from with Excel. It would not send. Message would
appear at top saying that the file has not been sent. Has
happened with other users.
...Sent Items Disappear
For some reason, after an e-mail has been sent and it is
moved to the sent items folder, it doesn't always stay
there. Go back a day later and some of the e-mails you
sent will be there, and some won't be. It seems to be
doing this at random.
We're utilizing Outlook 2003 with Exchange 2000 Post SP3
Rollup on the backend. The cache exchange feature is
also being used if that makes a difference. Any help
would be greatly appreciated.
...list box 06-08-07
I have two list boxes, one shows the list of creditors,"listCred", and the
other,"listAR", shows the list of accounts receivable. How can I make the
latter list show only the accounts of the creditor that i clicked from the
Message posted via AccessMonster.com
Answered in UtterAccess, where you posted the same question.
Is it possible to assign the comment box (ctrl +F10) to an item, so when that
item is sold the comment box appears to force the cashier to enter details.
Any help would be great. Thanks
yes it is a small development - is it for all items or some items?
Afshin Alikhani - firstname.lastname@example.org
= = = = = = = = = = =
"Gary McManus" <GaryMcManus@discussions.microsoft.com> wrote in message
> Is it possible to assign the comment box (ctrl +F10) to an item, so when
> item is sold th...Outlook 2003/Sent to folder
Does anyone know why my sent to folder will not display the id of the person
I sent the email to even if I select "to" in the arranged by section???? It's
making it difficult to grab previously sent I without having to scan the
subjects and do a search. I would much appreciate the assistance!
Did you try resetting the view?
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a ...Scroll to specific list box entry
I am trying to scroll to a specific line entry in a multi-select list box in
response to a user-input search criterion (in a separate text box) so that
the desired record becomes visible to the user. I can locate the matching
record and determine the line number, but I can't find a VBA method to scroll
to reposition the record.
My intent is to enable a user to enter the beginning character(s) to locate
the section of entries that begin with the user search criterion. From that
position, the user can then select the entries of choice.
I will appreciate any help.