Is there a way for a client to add contacts to Global Address List?
We are running Exchange 2007 at my company and since I am the admin I
have to constantly update our Global Address List and create Universal
Distribution groups using Exchange Management Console. Is there a way
to allow a user to create these contacts using just Microsoft Outlook
2007 client? And same for the distribution groups. (Right now I create
the distribution groups and give users permissions to modify them).
If someone has an answer out there I would greatly appreciate it.
...Re: How to lock input?
Is there any way to lock input in a textbox or cell once is entere
once... so it wont be altered???
Message posted from http://www.ExcelForum.com
May not be quite what you want, but following protects a
worksheet with a random password (i.e. you can't unprotect
it without a password cracker). Set any cells you want to
be still amendable to unprotected first.
ActiveSheet.Protect Password:="A" & Int(Rnd() *
>Is there any way to lock input in a textbox or cell once
>once... so it wont be altered????
>...forms not listed in database contents, yet can add data to them
Hi - there are no forms listed when I open up the database in design view.
All the tables, queries, and macros are there.
When I open up the database to add data, all the forms are there and can be
used. The data is stored. So, it seems that the forms are still there, but
just cannot be seen in design view.
The database, when I open it up in design view, says Access 2000 file object
even though I am using Access 2003 - could that be the problem?
You cannot open an entire database in Design View. Try opening it normally,
selecting a form, and choosing Design View from the V...Macro/VBA to loop through list of values and output row- Help Need
I am new to VBA/Macros and really don't know how to get this to work.
I have a spreadsheet which calculates distances between two postcodes for a
list of suppliers. Each supplier can have one or more branches at different
locations (postcodes). I need to return only the closest branch of each
supplier (i.e. copy the row of the closest supplier to a new sheet.
The sheet has 6 columns. Only 2 of these columns are needed to work out
Column A holds the Supplier Name and Column F holds the distance from us.
I have worked out the steps needed to complete this...group policy
I've looked in the group policy template from the Office Resource Kit,
and can't seem to find any way to add our RPC over HTTP settings. I'd
rather add this through group policy, instead of a login script to run
maintwiz. Is it possible?
Account-specific settings cannot be added with Group Policy Objects. You =
need to use a .prf file, as generated by CIW or CMW.=20
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Microsoft Outlook Programming - Jumpstart for=20
Administ...Query won't total...
Microsoft Access 2003
I have a query which is pulling from several numerical fields. Each
field individually shows up fine, but when I try to get a total of
several of the fields together the total field ends up blank. Here
is the formula I have in the query:
I have tried adding up just 2 of the fields and that works for 50% of
them, but the other 50% are still blank.
I have also tried entering the table name for each field within the
formula but nothing seems to be working.
Has anyone run into this issue before, or can a...VBA Macro change column contents
I have a column in a worksheet which has a list of 3 digit numbers. I want to
change the 3 digits to become 4 digits, the new fourth digit has to be a
leading zero, i.e 355 to become 0355. I prefer the format of the digits to be
a number but a text format would not be a problem.
The length of the digits in the column are not static. i.e one month there
may be 200 rows of data the next might be 300 and I would want the macro to
cater for this variation.
A macro simply isn't necessary, select the column and apply a custom format of
that...VBA Macro Error
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I�m running in a pretty bad problem: If I write in MSOffice 2008 a number followed by a letter like "5a" on a new line I get an error "This command is not available in this Version of Microsoft Word"
It seems that word want�s to make a lookup for a VBA script - which is not supported anymore, so in panic they write the message on the screen. But instead I really want to write only 5a. Is there a button to switch of those interpretations? It was not an issue with 2004 and not on windows.
Any...Query Builder Error: Unexpected Error
I am working with 1.2. I tried to print all cases for an account. When I
leave the bullet on 'all pages', and then click the 'print' icon, I receive
...Add value to a list box
How do I add stuff to a listbox, if it's not already in there? Just like the
"Not in List" event of the combo box.
...Excel add-ins - "xla could not be found"
Recently I started using Excel add-ins (xla files) -- which I have
found very handy. For example, I have an add-in that can add a
contents page to my workbook, or the list the file contents of a
folder, etc. The trouble is, if someone, who doesn't have same xla
files on their computer opens my spreadsheet they get a message:
"...xla could not be found. Check the spelling of the file name" etc.
After that they can open file fine. And apart from the messages, there
seems to be no other problem; but I don't see why it is necessary for
this message to occur. The add-ins helped me...Search and replace query
I need to be able to specify my search criteria including leading and/or
trailing spaces, and similarly with the replace text.
I could not get Excel to accept/handle spaces as part of the search mask.
How would I do this?
For example if I want to replace all uses of the word he in a database with
she how would I specify space he space for the search, and space she space
for the replace?
Works for me.
Gord Dibben Excel MVP
On Sun, 19 Sep 2004 16:31:09 +1200, "KiwiBrian&...Jewellery Add-on
Does anyone know of an RMS add-on specifically for use in a jewellery store?
Would you be interested for custom solution for Jewellery store?. If so
please drop a email.
> Does anyone know of an RMS add-on specifically for use in a jewellery store?
What are you looking for specifically? We have done some work with Jewelry
stores in the past.
Retail Information Technology Enterprises (RITE)
320-230-2282 ext. 4002 (Office)
320-230-1796...Need to get result of a select query in code
I have a select statement that I need to run in code. The select statement
needs to reference 2 variables which are in the code. I know that the usual
way to run a select in code is with DLookup. This if fine because I only
need 1 column of 1 record even though the select can return more than 1
record. But, the query needs to reference those 2 variables in the code.
How can I run a select in code which references 2 fields in the code and get
the result of 1 record (only)? If necessary I could put those 2 values in
textboxes on forms as I have several queries which reference textbox...ComboBox related query
On a form I have a ComboBox (Combo8). Is there a way to base a query on the
value of what is selected in the ComboBox?
Here is the SQL statement I've created, that is not working:
SELECT [Combo8.value].DRAWING, [Combo8.value].[EQUIPMENT/CIRCUITS],
[Combo8.value].[CABLE TYPE], [Combo8.value].[FND/SEQ], [Combo8.value].COMPT,
[Combo8.value].LEX, [Combo8.value].ZONE, [Combo8.value].BILL, [23Tag and TM
Data].[To Eq], [23Tag and TM Data].[To Desc], [23Tag and TM Data].[From Eq],
[23Tag and TM Data].[From Desc]
FROM Combo8 LEFT JOIN [23Tag and TM Data] ON
Combo8.value.[EQUIPMEN...Delete Query 03-27-10
Please Help - I have searched the posts and have found some ideas, but
nothing seems to work. Here is the sql statement
Error 3086 resolutions do not apply as far as i can determine
DELETE DISTINCTROW DistributedAnalyst.*, DistributedByMaterial.Material
FROM DistributedAnalyst LEFT JOIN DistributedByMaterial ON
DistributedAnalyst.Material = DistributedByMaterial.Material
WHERE (((DistributedByMaterial.Material) Is Null));
Thanks in advance
On Sat, 27 Mar 2010 15:55:01 -0700, dmoney <email@example.com>
>Please Help - I have searched the posts...VBA code for "Save as PDF"
I have developed a reporting tool in excel, where I need series of worksheets
to be saved as PDF one after another through a click of button (VBA
I need VBA code to save my print-area as PDF where it only once asks "where
to save" and then saves current series of PDFs. It should take file name from
a fixed cell too.
Check out this link...
> I have developed a reporting tool in excel, where I need series of worksheets
> to be sa...Add Text Together for Report
I tried to search for this one but not sure how to word it.
What I am trying to figure out is how to make a report that adds all the text
from a query together and displays it in one field.
I have a table that gets me the following data.
deconid logdate log
14 12/06/2007 This is just a test
14 12/07/2007 yes.. This is a log
14 12/08/2007 Yet a log number three
14 12/09/2007 This is number 4
I would like it to display this data in a report like this:
With DeconID 14,
"12/09/2007- This is number 4 ~ 12/08/2007- yes.. Yet a log number three ~
12/07/2007-...Including Null values in query design
I am using a form to enter the parameters for a report. The parameters
are drawn from a number of combo boxes on the form. The report is
based on a query. Several of the query fields have expressions such
This works fine as long as the fields that are being queried have no
null values - if they do, then in the situation where I want the "*"
to apply, the query only returns the records which have a value.
Really, I want to be able to replace the "*" pa...two sets of parameters..one query...but how?
I have a query to track when I must renew State Police Clearances AND Child Abuse Clearances. I want to use the "Between [date] and [date]" function on BOTH of the fields in order to bring up BOTH sets of dates for BOTH clearances.The problem I am running into is that when the query results come up, if one date doesn't meet the criteria NONE of the information comes up (even if the other date DOES).Any suggestions!??!?! Thanks in Advance....Database query won't open
I am trying to create a new database query from within Excel 2000. I was able
to do this successfully yesterday from the same PC. Today, when I go to Data,
Get External data, new database query, I get the hour glass and Excel then
locks up. Anyone have any ideas?
...Odd Add-in behaviour
We have created an Excel application for a client which consists of an
Add-In (xla) and a workbook. We tested it thoroughly under
Win2K+Office2K (client set-up) and WinXP-OfficeXP (our setup). All
One of our test users now has a problem in that when the Add-In is
enabled in Excel Tools>AddIns, his machine slows down tremendously
(most noticably using Outlook over a network), disenabling the Addin
speeds things up.
The Add-In itself is simple - just a user settings management routine
and adds a control to the Excel Menu Bar - with no complex references
etc. And perh...Need Help Filtering a Form with VBA
I have a form whose underlying data comes primarily from "Table1" (for this
example). On the form is a drop-down box that displays a field named
"Primary OBS" for each record. "Primary OBS" is stored in "Table1". It is
an index into another table "Table2" which contains a field named "Team
Code". "Team Code" can look like "JD130000" or "JG320000", etc.
What I need to do is to filter the records in the form by the first two
letters of the "Team Code". In other words, the user ca...How to add newsreader to Outlook 2003 with SP1?
I'm trying to follow the instructions of Start the newsgroup reader. But I
cannot find the News command in the command list of the Go menu. I'm using
Outlook 2003 with SP1.
To get the News command back, go back to the Programs tab in Control Panel |
Internet Options and change the default newsreader to Outlook Express. If
OE prompts you to make it your default newsreader the next time you launch
it, clear the "Always perform this check..." box and then click the No
"Peter" <Peter@discussions.microsoft.com&...VBA using an image as a toggle switch
Hi hope you can help.
I know next to nothing about VBA and have adapted code below from stuff I
I simply want to show hide portions of my page to cut down on screen
I have assigned my macro to a screen image but was wondering if I could have
a hide and unhide under the same button.
Any help would be much appreciated
Application.ScreenUpdating = False
Rows("25:75").EntireRow.Hidden = True
Rows("98:148").EntireRow.Hidden = True
Rows("171:221").EntireRow.Hidden = True
Rows("244:294").EntireRow.Hidden = T...