can this be done? #3
Can we create forms in excel that would populate the corrensponding fields in
excel sheet? Also if we could create forms, can we make certain fields to be
Thanks a Lot in advance
yes you can make a field mandatory
'check for a project number
If Trim(Me.TxtProjectCode.Value) = "" Then
MsgBox "Please enter a project number"
To your first question you have to tell where to put the information
'copy the data to the database
.Cells(iRow, 4).Value = Me.TxtProjectname.Value
where 4 is the column wh...Can i create a rule for Sent items?
Like you can have a rule, that when an item arrives, it goes into a
particular folder, can you also have such a rule for SENT items. Like,
whenever i send an item to a certain Email address, that it would go into a
different folder from the SENT ITEMS folder? If so, can you tell me how to
do it, as i do not see an obvious way within the Rules Wizard.
No one can tell since you decided your Outlook version is not in play - =
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal acc...WHERE CAN YOU BUY MONEY 2007?
I have not seen any ads for Money 2007 yet. I know you can download
from Microsoft directly OR buy it via Amazon.com, but is there any
brick & mortar physical store that is CURRENTLY selling it in the
northeast? In the past couple of years COSTCO has had it available at
the same time it was introduced, but it appears that THIS year
Microsoft's marketing plan is to offer it first via the internet and
online stores and then open it to stores like Best Buy, Staples,
Cuircut City, etc. What are your experiences in your area? Thanks. Steve
Didn't find it at Sam's Club last evening...Can you change only one cell size in a workbook?
No. You can change the width of a column, or the height of a row.
And next time, please remember to ask the question in the body of the
message, not just in the subject line.
And if this is related to charting, it is not clear how. Was this intended
for one of the other Excel groups?
"Becky" <Becky@discussions.microsoft.com> wrote in message
...Any ideas why I can't print from Word v.X?
Operating System: Mac OS X 10.6 (Snow Leopard)
I just upgraded from a PowerMac G4 laptop to a Mac Mini. I had the MacStore migrate my data for me, and for some reason I can not print from Word. I'm able to print from other programs (Things and Firefox for example) as well as from Excel and Entourage. But when I try to print from Word all I get is a blank page from the printer. I've re-installed Word to no avail. <br><br>Any ideas?
Answered elsewhere. Please return to your original message to view
replies... It's pointless for a...deleting email in outlook, freezes before i can delete
i have a file with pics that symetec scanner says is to large.
i can receieve email but cannot send any.
it freezes before i can delete and says non responding.
I want to re-raise the old issue of Fax numbers showing up in the Outlook
Address book when one is sending an email. I know that this can be stopped
by prepending the Contact's fax number with a letter so that Outlook doesn't
see it as a valid fax number and therefore doesn't list it. What's always
puzzled me, however, is that this fix doesn't work if the fax numbers are
changed using an export to CSV...can't edit products anymore
My Sales Manager and Sales Administrator can no longer edit products. Both
have different security roles that include create, read, write, delete,
append, and append to privilege. However, both cannot edit products. The
text that they usually can edit is no grey.
System Administrator (me) can still edit products. I've created a new role
that includes all privs for product (and nothing else) and added that to both
users, but they are still locked out.
It could be that they are trying to do this from the Outlook client. There
are some admin functions tha...Can saved MS publisher documents be password protected and how?
Hello, I'd like to make some confidential Publisher documents password
protected - so that only I can open them. Can this be done and if so, how?
I can not find any info on this in the online or program help options.
There are several programs that can password protect files and even folders;
one I've used is EasyFP.
A nice feature with Easy FP is a file can not be deleted from your hard
drive without the password; a little extra protection.
or you can do a google search for file encryption for other programs.
Don - Publisher 2000...Why can't I suddenly not see embedded or linked pics in Publisher
NONE of my publisher files are displaying the pics in them. Even if I open a
new file and add a pic, it doesn't show up. It PRINTS out, but I can't see
it on the screen. I've embedded it, linked it, gone to VIEW and tried
everything. What is my next option?
qwerty <email@example.com> was very recently heard to
> NONE of my publisher files are displaying the pics in them. Even if
> I open a new file and add a pic, it doesn't show up. It PRINTS out,
> but I can't see it on the screen. I've embedded it, linked it, gone
>...Can't Find Delete when Adding to Blocked Senders Option
Here is my situation. I often add senders to the blocked senders using the
toolbar button that I have on my toolbar.
I remember in the past being able to click that button and the individual
message would not go to the junk mail folder but would automatically be
deleted for me. There is some check box or option for this somewhere in
OL2007 but I cannot find it.
Where is that option?
That was never an Outlook option. What add-ins did you have installed =
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited ma...a small COM to custom IE printing from JSP,shareware.
I developd a COM to custom IE printing,for Microsoft=AE Internet
Explorer 5.5 or later.It is not straightforward before I fixed several
bugs.Ii is some kind of a simplified scriptx and easy to extend.
May it help.
Where is it?
Not sure what your asking here. Do you have a problem with some of the code
or are you offering a version up for download?
"ianrosengren" <firstname.lastname@example.org> wrote in message
I developd a COM to custom IE printing,for Microsoft� Internet
Explorer 5.5 or later.It is no...Can I sort a column by its 'formatting'...
i have a column of values, some of the cells are in black
and some are in red.
can i sort the column let say by the color first, then the
---- cell format
after sorting by 'color' then 'value'
is it possible? thx.
I don't think you can do that directly. You could put formulas in a
neighboring column that reference the condition that produced the col...One person Can't Log into OWA
We have Exchange 2003, and OWA works fine for everybody but me. It did work
for me, but suddenly stopped. When I try to login it says to enter my user
ID and password, which I know are right. It doesn't think so though.
I can login remotely to do ANYTHING else, including Web Workplace and remote
To top it off, I am the fricken system administrator with domain admin
So far I have:
1. Tried other computers from remote locations
2. Cleared the cache on the computers that I access from.
3. Disabled OWA rights and reenabled them again in my user profile....defining a structure in vc++
I need to define a structure in vc++.I wanted to how it is possible
to define a structure whose variables are global
Well, define your structure and instant a global of it.
> I need to define a structure in vc++.I wanted to how it is possible
> to define a structure whose variables are global
but where should i write structure declarations,like what type of elements
}if i want to insert this declaration in a class.how do i go about i...Can't Get Line Number on Status Bar
In Word 2003, I was able to look at the status bar at the bottom of the
screen to see what line I was on in a particular document. Is it possible to
do this in Word 2007? Thanks.
Yes. Right click in the status bar. Line number is one of the choices.
>In Word 2003, I was able to look at the status bar at the bottom of the
>screen to see what line I was on in a particular document. Is it possible to
>do this in Word 2007? Thanks.
Message posted via OfficeKB.com
Yes it is...users with email address @child.domain.com
Our company has a AD deployed with one many child domains. I recently
installed Exchange 2003 in a child domain (east.company.com).
When I create a user in the child domain, by default they get an address
like email@example.com assigned. Email transport seems to work fine.
However, in this particular case I want users in this domain to get an
addres like firstname.lastname@example.org assigned (so the email dosen't come in
thru the company.com MX)
I have registered MX for east.company.com but if i send email to
email@example.com i get delivery error.
Create a s...Pub 2007 Can't edit Pub 2003 files.
Just d/l Publisher 2007 Trail to my Vista Home (hate it!) box. I can open
and view Publisher 200x files but can't edit, change, move anything.
Did you activate the trial version?
Microsoft MVP - Publisher
How to ask a question
"Paul" <Paul@discussions.microsoft.com> wrote in message
> Just d/l Publisher 2007 Trail to my Vista Home (hate it!) box. I can open
> and view Publisher 200x files but can't edit, change, move any...firstname.lastname@example.org
...Can I create a macro in Outlook 2007?
I started to get 3000 to 4000 spam a day. I set up a rule marked it
priority, etc, made it first on the list and it does not run. I have to run
it manually . I thought if I could make a macro, make a button on the
toolbar, then click instead of going through al the 'rulles and alerts"
clicks to run the rule. ANy thoughts?
I see macro but only runs ones that are already created. If I create a macro
in Word or Excel, it does not have "rules and alerts" in it so I can't
create it. I tried help, but there is no info , just blocking, etc of macros
What...How can I randomize the presentation of slides in Power Point?
I need to present some pictures to participants and it would greatly help me
if there is some option in Power Point for it to randomize the slides I want
There's no built in way to do this. We have a free AddIn that will though.
http://www.pptalchemy.co.uk/vbasamples.html (scroll to the bottom of the
"Cisco" <Cisco@discussions.microsoft.com> wrote in message
> I need to present some pictures to participants and it would greatly help
> if there is some option...How can I forward emails IMF catches to a mailbox?
I have a need to forward all email caught by the intelligent message filter
to an Exchange mailbox (moreso; everything that ends up in the UCEarchive
folder). I thought maybe a script of sorts may work, but am unsure where to
Any ideas/help would be greatly appreciated! Thanks!
You can go to the UCEArchieve folder and open the email. It will prompt you
to use OWA to open then just use the forward option.
"T" <T@discussions.microsoft.com> wrote in message
>I have a need to forward all email caught by th...Can I move the Mailbox Store?
The Following regards Exchange 2003 running on Windows 2003 SBS.
Exchange is in testing, has not yet been rolled out to the clients.
On Exchange the mailboxes (I'm assuming this is what is called the Mail
Store) is currently set to a HardDrive that doesn't have a lot of space.
I'd like to move the Mail Store to a local HD on the server that has a
lot more space.
I think this is possible through the Exchange Systems Manager Interface
Under "Servers" --> "<SBSServer>" --> "First Storage Group" --> "MailBox
St...Can't Edit Worksheet Comments
I'm running Vista Home Premium SP2, 2 GB RAM, Firefox, Spyware Doctor, MBAM,
SAS and CCleaner, Office 2007.
All of a sudden only one (of many) worksheets inside one particular (xlsx)
Excel file will not allow me to edit the comments in any of the cells where
the comments exist. When I right click the cell and select `Edit Comment'
(which is not greyed out) nothing happens. If I try this on any other xlsx
files I have or any other xls files, comment editing works fine. I tried the
help manual and a reboot to no avail.
I've been using/modifying this file for years. It conta...How can I change the color of the cell when someone enter any number or character?
Hi... =) I am trying to build a templete with a list of questions
where the users will answer YES or NO. Please help me to change the
color of the cell to Green if they answer yes, and Red if they answer
Look at conditional formatting in help.
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Saz" <Sajan.email@example.com> wrote in message
> Hi... =) I am trying to build a templete with a list of questions
> where the users will answer YES or ...Can I embedded a View in a TabCtrl
Ok, I'm writing a CAD program and I want a certain look which I can't figure
out how to make work. I want a window with horizontal and vertical scroll
bars. I also want a row of tabs outside this window along the bottom to
control the layers. All this embedded in an SDI frame. How do I do this?
1. What I Have Now
I have embedded Horizontal and Vertical Scroll bars inside a TabCtrl which
is embedded in a plain CView. The downside is I have to do all the
scrolling stuff myself. At the moment, the scrolling part is not working
2. What I Think Might Work
Create a CScr...