Password Protect Two Sub-contact Lists
I have a regular contact list, and within this list I have two
subcontact lists. One is personal, and the other is personal business.
How can I password protect the personal and personal business lists?
Thanks for any help!
Sorry, I just realized that there's a newsgroup dedicated to contacts.
I'll post this there.
> Hi everyone!
> I have a regular contact list, and within this list I have two
> subcontact lists. One is personal, and the other is personal business.
> How can I password protect the personal and...change date on batch through sql
We use the same sales batch on an ongoing basis. I would like to have the
batch date update automatically every day so that users dont have to
remember to update the batch date manually.
I tried creating a macro but it did not work. I do not know if there is a
current date function that I can use in a macro. I am now trying to do this
through a sql job. I am planning on updating SY00500 table (GLPOSTDT and
MODIFDT fields). Is this all or do I need to update any other field/table? I
am open to any other suggestions. We do not have VB/modifier.
...Changing fonts in Client View
I'm trying to change the font in a Client View in an MDI application
(<name>View.cpp) and am having trouble. I used SetFonts(LOGFONT* lf) with
Courier and it didn't work. Any idea how to do the nasty deed?
Details: The project contains <name>Doc & <name>View. I and using the Client
Window controlled by <name>View as a logging output window. The current font
is a variable font type (system font I suppose) and I'm trying to change it
to a fixed font (Courier). I have used 'EnumFontFamiliesEx' to get the
LOGFONT structure for Courier and <...How do I change Column Headings from Letters to Numbers in Excel .
I am sure it is easy to change the headers from the default A, B, C,.. to
numbers (1, 2, 3, ...). The book I have does not mention it and I have not
yet found it.
The reason I am after numbers, is I want to import a comma delimited file
daily. The file is almost 100 columns and when setting the 'Text', 'General',
or 'Skip This File' there is almost no way to keep track of which column is
being formatted ('cept the finger & toe method)
Am I going about this wrong? I would like to create a template for this.
Any help is appreciated.
goto tools>options...Passwords #5
I would like to password protect a workbook so that when
the workbook is selected to open a dialog box pops up
asking for the password and after the password is entered
correctly the workbook will then open. Thanks for the the
Todd, do a save as and look under options, depending on what version you are
using and set a password to open
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address t...my switchboard prevents me making changes to the database
the database opens with a switchboard screen and doesn't provide access to
all the database tools so I can make changes, open tables, etc. In Access
2000 and 2002 you would hold down the control or shift key when you opened
the database and it turned off the switchboard control features to open
normally. I'm using Office 2003. Is there a similar key to press and hold
when you open a database to turn the switchboard feature off? Thanks!
Holding down the shift key works exactly the same in Access 2003 as in
If it's not working for you, perhaps someone set ...Passwords
Hi, I have a password field in a database. How do I set it so that a
user can only type in 7 characters for a password. and if they type
more an error message will appear?
> Hi, I have a password field in a database. How do I set it so that a
> user can only type in 7 characters for a password. and if they type
> more an error message will appear?
You may use the ValidationRule and ValidationText of the field in the
table design view. Setting ValidationRule to Len([YourField])>7) will
raise an error in your case.
--> stefan <--
...Changing Computer Name
I've replaced my POS station with a new machine. I want to take the old
system and replace one of my older workstations with that system. In doing
this, I would like to change the computer name. I thought I read somewhere
that you did not want to do this after you installed RMS. Is that the case?
That's only an issue if you have MSDE installed with the store's database on
it. Change away.
Get Secure! - www.microsoft.com/security
You must be using Outlook Express or some other type of newsgroup reader to
see and download the file attachment. ...ExchangeIS Schema Changing?
I'm temporarily in an environment that is using Trip Wire Mangager 4.5 to
monitor some of it's servers. Most alerts are false positives that can be
cleared. One, however, is appearing daily and cannot be cleared it indicates
has changed. I've checked the KB and Googled to see what may be causing this,
or how it works, but can find nothing. Is this a schema that would change as
part of its everyday operations?
Also, when comparing two day's errors, the changes are DACL changes,...Keep user passwords
We've just finished installing a new Exchange server and connecting it to a
separate DC. We used to have everything on the same server but we'd like to
be able to scale our solution better in the future - therefore the new
setup. Users are primarily connecting to Exchange by means of RPC over HTTP
from clients that are not part of our AD.
The old setup allowed users to save passwords if they configured their
clients to use NTLM authentication and followed the directions in this
This worked both for RPC...How to retrive password protected worksheet but forgot password?
I password protected an Excel spreadsheet and now can't remember the
password. Is there any way that I can gain access to my worksheet?
There are tons of FREE good Excel password 'cracking' tools. Your favorite
search engine should get about a gazillion hits on a phrase like "crack excel
password" or "excel password cracker".
A good one that many report great success with can be found at:
> I password protected an Excel spreadsheet and now can't remember the
> p...Spreadsheet password protection
How do you password protect a spreadsheet. I can't find anything in the help
You can prevent un authorised access by giving a password to open the
workbook itself, so that no one else can open it (Go to Tools, Options and
then Security Tab). You can do it there if you have already saved the file,
or you can go to "save as" then "Tools" and "General Options" where you can
On the other hand you can protect work sheets and ranges for different
people by using "Tools" and then "Protection" Tab
M Imran Buha...Change Font Color Based on Classification
Can I have the Font color in a specific row be a certain color based on a
value in one cell in that row.
I am looking at data for different room types classified as A,B,C,D or E.
Each row is for a different room with one of those classifications. I want
the whole row to dislay one or five different font colors (respectivley)
based on the classification.
How can I do this,
for 5 colors you need to use VBA to get it If four were acceptable use
Conditional formating (one default and three conditional)
> Can I have the Font color in a specifi...Password
I am working with publisher 2007. I finished my site last Dec. and went to
It is not letting me make changes because it does not like my password. I
can not figure out how to go in a reset everything from my provider.
I was also trying to see if I could find web publishing wizard, which
doesn't seem to exsist with 2007.
If you are saying you forgot your password then contact the ISP Tech Support
and they will reset the password to something like 1 2 3 4 or something
other that is very simple. They will also instruct you to change it to
somethin...Changing the Button Class
I have a question. I used the Resourceditor to draw a Dialog. The
resourceditor uses the CButton class. What do I have to do if I want to use
another class ... like a derived class with much more functionallity.
Make your derived class, then add a variable through the resource editor
but instead of using the CButton class, use your own. If you can't do it
through the app wizard directly, just edit it afterwards in the header.
You can also look into subclassing (if you don't use DDX), but I never
know where exactly to call SubclassWindow, you might find that info
throu...How do I change margins from imperial to metric?
How do I change margins from imperial to metric?
I'm using Excel 2002 sp2. Any help appreciated.
This is a Windows OS setting, not an Excel setting.
You would go to Windows Control Panel>Regional and Language
Options>Regional Options tab>Customize and set the "measurement system" to
This option will affect all programs.
Gord Dibben Excel MVP
On Mon, 25 Oct 2004 07:29:10 -0700, "Jojo" <Jojo@discussions.microsoft.com>
>How do I change margins from imperial to metric?
>I'm using Excel 2002 sp2. Any help appreciated.
...Can I change the Navigation Pane Buttons default?
Many of our users here use the Public Folders to share
contacts and/or calendars within a department. We just
upgraded to 2003 from 97. In 97, one could drag or add a
shortcut to the Outlook bar from Public Folders, and
remove or move other shortcuts. Along those lines, users
would like to click on the "Contacts" button in the
Navigation Pane, and have it go directly to a public
contacts folder (one click access). Is this possible? I
know all about the shortcuts option, AND the favorites
folder option, but I want to know if the default place
those buttons point to can be ch...Passwords #3
For some reason, it will not store the password. I have
checked the box that says "remember password", but, each
time I try to log in. It will ask me for it. Any ideas.
I am thinking about recreating the profile for thismailbox.
I am a consultant, and my customer doesn't know how (or
won't write down what I tell them) to do this.
...Table Field Data Type
I have a table called Equipment. I also have a report that displays all of
the information in the Equipment table. When the report is opened a form pops
up allowing the user to make a selection from one of four different combo
boxes. After the selection is made and the user clicks Set Filter, the report
is filtered to only show records based on the users selection.
The problem I have is with a field in the Equipment table. It's an Item
Number field with a data type set to Number. This form will only filter text
data & I don’t know how to change that (there must be an easier way....Change Password Next Login, Enforce Password Policy and Expiration
I'm curious why are the Change Password Next Login, Enforce Password Policy
and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a
user. my client want to know how to enable it. hope for your prompt action.
Only works for SQL 2005. If you client wants to use a beta database server...
> I'm curious why are the Change Password Next Login, Enforce Password Policy
> and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a
> user. my client want to know how to enab...What to do if you change domain names
What settings need to be changed after your Exchange 2003
installation changes from abc.com to xyz.com, say you
registered a new domain name and want to start using that
domain for email??
> What settings need to be changed after your Exchange 2003
> installation changes from abc.com to xyz.com, say you
> registered a new domain name and want to start using that
> domain for email??
See http://www.msexchange.org/tutorials/MF010.html - explains how to host
multiple domains for mail. You can make the default whichever one you want.
...password prompt when no password is set.
thru a series of unfortunate events I had to reinstall my os and all of
my programs. I was using ms money 2000. I have always kept the main
*.mny file but lost my backups. When i reinstalled money and tried to
open my mny file I get a password prompt. I have never password
protected the file and when i tried to run a password recovery program
it says "no password set". I do have older backups of this file but
they are too old to be of much use. But i am able to access them. any
suggestions would be appreciated. Thanks
The password prompt often appears when you open a dataset m...Network password #9
I don't use passwords and now i am prompted to enter a
network password or my computer will not connect to email
account. Any thoughts
If you are still having problems after applying both the SP 1 & 2 patches,
then see if this article addresses your problemL
OL2002: The Save Password Setting Is Not Saved When You Connect to a POP3
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
accoun...Changing Time format in Date column
When I review email messages in Windows Live Mail I would like to see the
time displayed in 24 hour format by each message. Ie, instead of Date:
05/03/2010 4:35 pm I would like it be shown as 05/03/2010 16:35.
Any help from anyone would be greatfully appreciated.
"Jon" <Jon@discussions.microsoft.com> wrote in message news:54D681D7-2367-434B-AC7A-29AD80A4A828@microsoft.com...
> When I review email messages in Windows Live Mail I would like to see the time displayed in 24 hour format by each message. Ie, instead of Date: 05/03/2010 4:35 pm...Problem with changing a cell validation through VBA
I have a problem with a macro which I have recorded in Excel. The macro
comes with an error in running the recorded script. This error is:
Run-time error '1004': Application-defined of object-defined error.
This is the VBA-coding which has the problem:
Momentarily the cell has the same validation, only the Vlookup has to
match "YELLOW". This rule has been manually ...