check mark colour
Is there any way to change the colour of the check mark in a checkbox?
> Is there any way to change the colour of the check mark in a checkbox?
Sorry, no, not with a single form field.
If you use the technique at http://gregmaxey.mvps.org/Add_Toggle_Objects.htm
to make fake "checkboxes", and use an EQ field to make the checked box from
two separate characters, you might be able to make the box black and the
check mark another color. I haven't tried it.
Microsoft Word MVP FAQ: http://word.mvps.org
Email ca..."All Users" address list secutiry settings problem
I added "deny" to "Everyone" for the "All Users" address
list. Now I can't see the object in the Exchange System
Manager. I can see the object in the Outlook Address
book list. I can also see the object in ADSIEdit only it
does not appear in the left pane as All Groups, etc. do.
It appears in the right pane only when I select the All
Address Lists node in the left pane and it has a document
icon rather than the folder icon the other objects have.
When I attempt to open its properties the cpu usage gets
pegged and I get an error "an invalid pa...Printing distribution lists on 1 page instead of 2
My office just upgraded to Outlook 2007. In our previous version of Outlook,
when you printed a distribution list, it printed on 1 page (provided all the
contacts fit on one page), with the name of the distribution list on top.
Now, when I try to print the same distribution list, it prints the name of
the distribution list on 1 page and the contacts on the second page.
Is there any way to fix this? It is fairly inconvenient. I have looked in
the printing options to no avail.
There is no fix. It's a new feature.
"Kathy Dake" <Kathy Dake@di...check left mouse button state anywhere on the screen
I think none of the WM messages let me check the mouse button outside
the application window.
If anyone knows how to do it, please let me know how.
"wanwan" <email@example.com> ha scritto nel messaggio
>I think none of the WM messages let me check the mouse button outside
> the application window.
Have you tried SetCapture/ReleaseCapture?
To do so, you need to do a SetCapture().
SetCapture is not really good for clic...How do you sort a multi-column list by rows?
I'm a worship leader, I need to create an index for the songs in my notebook.
I'm using Excel (I'm an absolute beginner, just got it yesterday) and need
to know how to sort a list with several columns (song title, tempo etc.) by
any one of the columns and keep the rows intact. Thanks 4 the help.
If I understood your problem correctly, this should help, at least a bit.
Select ONE cell in the column you want to sort by. Then click on a button in
the toolbar, it should say AZ and an arrow downwards. To do an ascending
sort, click the button with and arrow upwards.
If you don&...Search a worksheet, extract rows using a list from another sheet
I am trying to use a list of names (first, last) in a colum in worksheetA to
find corresponding entries in an imported worksheet B, Once I find the name
in worksheet B I want to extract the entire row of data into another new
Place Overall Name Swim Bike
1 12 Bill Jones 24 anytown ST 13:45 54:45
4 78 Fred Smith 56 anothertown ST 15:00 56:12
24:34 1:48:34...List of built in functions
Does anyone know where I can get a list of all built in functions in access
along with a description of usage?
On Mon, 21 Jan 2008 08:41:01 -0800, juliejg1 wrote:
> Does anyone know where I can get a list of all built in functions in access
> along with a description of usage?
Did you look in VBA help?
Search for function
Please respond only to this newsgroup.
I do not reply to personal e-mail
Your success with this will vary with the version of Access. A2007 will
give the best results and A2003 has been updated also as long as you allow
help to search the web. AXP and...changing contacts frm global address list to contacts in outlook 2003
This is a multi-part message in MIME format.
How do I change in outlook 2003 so that the first place when I address a =
email it looks at my contacts instead of my global address list. I'm =
using the office Microsoft exchange server version.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Trans...Drop Down Lists #2
Hello how do i create a drop down list in a cell?
I can create a list but cant figure out how to create a drop down list
You can use Data Validation. There are instructions in Excel's Help, and
> Hello how do i create a drop down list in a cell?
> I can create a list but cant figure out how to create a drop down list
Thanks Debra that was quick
"Debra Dalgleish" wrote:
> You can use Data Validation. There are instructions in E...Generating Data based on a List
Hi all, Just wondering if someone can help me.
I have Sheet A with Col A with Town Names... and Col B with
the postcode. there is about 150 towns.
I then have another sheet... Sheet B... which has about 20
rows of information...some of which grabs information the
contents of A1 and B1 from Sheet B.... into functions.
That works fine. However I dont want to have to enter the
150 A1 and B1 items manuelly... and then have to save them
as text files manuelly each time....
Basically If i could have it somehow read the values from
Sheet A and put them into Sheet B... one by one.. it would
then ...franco to check e-mail
...Checking for two values
Hi, sorry if this is a really easy question but it's driving me nuts
because nothing I've tried seems to work. Basically, I am looking for
a way to do this:
If cell A1 contains the word "email" and cell B1 contains "@", give
the result 1, otherwise give the result 0.
I have tried using the AND function and wildcards, but I either get an
error message or it returns an incorrect result.
Can anyone help please?
Thanks very much
=and() will return True or False. The -- s...Creating Price Lists and Products
Tell if it is impossible to create a product catalog in this order according
to these instructions.
Creating the Product Catalog
The Microsoft CRM product catalog is the central location for storing
product information. The product catalog is a collection of information about
your organization's products and services. The items in the product catalog
are created or managed through the Settings area of Microsoft CRM.
Additionally, you can view the product catalog either online, when you are
connected to your corporate network, or offline when you are at a customer's
site by usi...Open dialog box.
I have looked at the code at http://www.mvps.org/access/api/api0001.htm......however
am unsure how to use it. It's a lot of code, but what and where do I
paste it? I want an open dialog box to come up when I click a certain
button, so the user can choose the CSV file that will be imported to a
table. What is the easiest way to do this?
1.Create a new module and paste the code from the MVPS website
2.Create a button on your form and select to create a click event (using
they provided a Testit function which illustrates how to call it from
Dim s...Bank balance issue on Account List page
Just noticed after converting to '08 that two accounts are showing Zero (0)
Adj Balance but the Bank Balance column show a negative entry. I viewed
each account and confirmed that the starting balance was 0 and the current
balance was 0 so not sure why these two accounts are showing up having a
negative Bank Balance. I also confirmed that at least one account was
Balanced to the bank but that didn't fix the issue.
Besides a possible repair fixing the issue, is there another solution or
something else I didn't do?
In microsoft.public.money, Geekster wrote:
>...Check 3 cells for specific content
Is it possible to use code to check the value of 3
different cells at the same time for specific content?
A1 should = Part Number
B1 should = Order Quantity
C1 should = Order Date
If the spreadsheet doesn't have this cell content in thid
Then MsgBox '"Wrong File"
Your help is appreciated so much!
in VBA try
str=.range("A1").value & .range("B1").value & .range("C1").value
if lcase(str)<>"part numberorder quantityorder date" then
msgbox &...Sorting for Specific words/ numbers from list
I am trying to figure out a way to sort some information from data tha
appears in a worksheet via an import. The import works like
straightforward paste function from another program (in this case
Quickbooks). The information pastes the same every time, i.e. dat
appears in the same columns every time. These columns have a name in
column (ex. A1)and a monetary value in another column (ex. D1). Wha
I'm having to try and do is make a formula that will sort similar name
and sum up the monetary values that match up with them. The "simila
names" are actually numeric codes...Customizing 3.0 Marketing List Members View
When I open a Marketing List and click on Members, a view of the lists
members is displayed.
I would like to add a column to the list from the Contact record. Is this
I'm trying to do the same thing. If I use Advanced Find to create my list
(from leads in my case), it allows me to select columns. However, when my
Marketing List Members list is displayed, the columns appear fixed, showing
Name, Business Phone, and City. I can't find anywhere in the entities to
change this. It's not very useful as is.
"Rocco P" wrote:
> When I open a Marke...List of fonts required to be enabled for Office 2004?
Where might I find a list of fonts that Office 2004 requires to be enabled?
I used Tiger's Font Book to disable several Asian and other font families,
but avoided disabling any that Font Book dialogues said were needed for the
Later, when I tried changing fonts within Entourage messages or Notes,
before any other fonts than the one displayed could show up, Microsoft
Report came on and it and Entourage went into spinning beachball mode. A
subsequent force-quit showed that both were "not responding."
When even a rebuild of the Entourage databa...Rules Wizard List
It seems that the 'list' of contacts that I want to
receive e-mail from grows and grows and grows. You can't
sort it but I've discovered multiple addresses when I've
only added them once.
Any suggestions or answers as to why this occurs?
...Forms List box relations
How do I relate two list boxes on a form? I want to populate one list box
automatically depending on the first list box value or selection. ie. When I
select a PersonID ın the first list box I want the second box to populate the
name automatically that is related to the selected ID.
You could try using a query as a source for your second listbox. Set the
parameter (PersonID) to the first listbox. You'd have to do a requery after
you click on the first listbox to get the results in the second listbox
> How do I relate t...Distribution list
Is it possible to sort the names in a distribution list by last name?
John Pinback <firstname.lastname@example.org> wrote:
> Is it possible to sort the names in a distribution list by last name?
The DL "Name" field reflects the "Display As" field of the added contacts.
If you specify the Display As fields the way you want (i.e., "Last, First"),
then the Name field in the DL will be alphabetized by last name. You can
resort either ascending or descending by clicking the Name column header.
When you are in the process of choosing the...How to show dropdown list from another workbook without running it
I created a dropdown list using as a source a column from another
spreadsheet. When I colose the source spreadsheet the dropdown list doesn't
Copy the choices for the drop down to the main workbook..
If you don't like seeing them in the main workboook, put them on another
worksheet and hide that worksheet..
> I created a dropdown list using as a source a column from another
> spreadsheet. When I colose the source spreadsheet the dropdown list doesn't
> work anymore.
> Any idea?
...comparing check box values to a table
Hope you can help, I have a worksheet with five check buttons on it
Depending on the combination of buttons selected I want to select
value for use elsewhere in the sheet.
I've built a table with five columns which has every possible logica
combination but don't know how to get my check button link cells t
look at the table. compare them and select the result.
I've attached the file
thanks to anyone who helps
Message posted from http://www.ExcelForum.com
If checkbox 1 is clicked, add/subtract 1 from a global variable
If checkbox 2 is clicke...How to check client version
Is there a way to check which version out the Outlook client the users a
running without having to ask every single user? I have added the Rollup5
update to the database, so the users can download/update it manually, but
I'm wondering if there is a way to find out how many of them has actually
applied the RollUp.
If it was stored in the database and synced back to the server it would be
quite easy to find out, but I haven't been able to find such a field yet.
Steen Schl�ter Persson (DK)