Highlighting the active row with special colour
Is there a macro that highlights the whole active row (not only the active
cell) that the cursor is in, in an Excel worksheet?
Highlight it in a particular colour, I meant... that would move along when I
would move the cursor onto another row....
"Raj Mazumdar" wrote:
> Hi there
> Is there a macro that highlights the whole active row (not only the active
> cell) that the cursor is in, in an Excel worksheet?
Private Sub Workshe...Activities don't show up until we hit the refresh button
We upgraded from 3 to 4 and it appears that the upgrade did not complete
successfuly, but the users used the system.
Everything appears to be working well except for a couple of strange things
like when we create an activity the activity does not appear until we hit the
Refresh button, going to history and coming back does not fix the issue, only
the refresh button any quick fix on this one?
...How to monitor wireless switch activity?
Hello, how do I monitor activity of the wireless switch on my laptop?
Is there an interface that can be monitored via
Basically, I want my application to know if/when the user disable the
wireless subsystem on the laptop.
On some Windows versions you could use the WlanRegisterNotificationFunction
and look for power setting change.
Thomas F. Divine
"rf" <email@example.com> wrote in message
&...Messages stuck in Queue with status Active and eventually fail.
I have an exchange 2000 server with SP3. The scenario is this; Everything
has been functioning great except emailing to AOL, so I setup a smart host to
use our ISP's smtp server. Well, they are getting flagged as open relay and
the mail is rejected. So I had them setup a reverse dns lookup for our IP so
I could send mail directly.
I found a site that allows me to check RBL's and we came up good on about 25
of them, so we aren't black listed.
Now we can email aol users without any problems, but all of a sudden, I
can't get the server to deliver mail to other exchang...Job Listing- VC++ MFC with Isofttech
Position: Technical Lead
Experience: VC++/C++ with MFC
Good to have: Wireless 802.11 Skills & Windows development experience.
5-6 years of experience.
Work Location: Chennai
Education: BE/B Tech, ME/M Tech ( CS,IT,ECE,EEE)
Do send in your CV to
...Remove records from lookup
Not sure if this is possible but I would like to remove all records except
the account records from the look up records dropdown menu of the
appointment entity. The associated schema is regardingobjectid and the label
is regarding. I see the other entities listed under relationships but there
is no option to delete. Is there a way to create a new lookup and have it
added to my appointment form?
There is no supported way to change this. The system is setup to allow you
to set appointments that are related to specific records (Opportunities,
Quotes, Cases, etc) and it will then ro...Listing Activesynce users
Is there a way to list the users who are actually using Activesync? I
can get a list of all the devices but have not run across a method of
seeing if they are actually sending and reciveing mail.
Jeff Senter <firstname.lastname@example.org> typed:
> Is there a way to list the users who are actually using Activesync? I
> can get a list of all the devices but have not run across a method of
> seeing if they are actually sending and reciveing mail.
I Need To Get The Path Of The Image Saved In An Image List
Any One Know How
Browse to the field
Select view all field types
Cut the path from the box
Be aware the you will have extra "" around the path (just in case you are
using the path in a code)
> Hello All
> I Need To Get The Path Of The Image Saved In An Image List
> Any One Know How
I'm not sure whether this info is retained but even if it ...enter value based on drop down list of another field?
I have an excel 2003 spreadsheet with 3 worksheets. In sheet 1, I created a
drop down list in column A based on values in sheet 3, column A (item
number). Thisd data comes from sheet 3, where I have column A (Item #'s),
column B (Item desc)an Column C (price)
In column B of sheet 1, I have Item Descriptions and in column C I have
price. I want this to automatically fill in based on what I enter in the
column A sheet 1 and it should get the corresponding values from sheet 3
column B and C. I can make the drop down list in sheet 1 column B and C, but
some of the descriptions need ...Mailing List Duplicates
Is there a software program that works with excel to
delete duplicate names? Our mailing list is in the
thousands. Thanks for any and all help.
data>advanced filter, copy to another location and unique records only
"Gordon" <email@example.com> wrote in message
> Is there a software program that works with excel to
> delete duplicate names? Our mailing list is in the
> thousands. Thanks for any and all help.
...combo box list updating
Hi - I would like my combo box list to change base on the value of A1.
That is, I have its input range being B1:F1 - "Year 1", " Year 2" etc.
-If cell A1 is the value "10" then the combo box default list item would be
"Year 1" (which is cell "B1")
-If cell A1 is the value "20" then the combo box default list item would be
"Year 2" (which is cell "C1") ETC...
Thanks for your help - Jim A
...Not able to view activities
I have a MS CRM 3.0 VPC running. I have allocated 1GB memory as recommended.
However, whenever I try opening Activities(any entity for that matter), it is
throwing an error dialog "An error has occured. For more information, contact
you system administrator."
I checked the event viewer, but there is no information about any
error/exception. I searched for the CRM log, but couldn't locate it. Pls help
me fix this issue.
Thanks and Regards,
...C#, .net 3.5sp1 and Visual Studio 2008 sp1 errors list
What kind of errors will the errors list show when using C# 3.5sp1 with
Visual Studio 2008sp1?
"Andy B." <firstname.lastname@example.org> wrote in message
> What kind of errors will the errors list show when using C# 3.5sp1 with
> Visual Studio 2008sp1?
Why would you expect any?
On the face of it vs 2008 sp1 will target .Net framework 3.5 sp1 by
Andy B. wrote:
> What kind of errors will the errors list show when using C# 3.5sp1 with
> Visual Studio 2008sp1?
That all depends on what ki...CObarray and list
Can any one give me some pointeres?
I have a CObArray, say, with 4 items.
I have a list box, of which the content is generated from the string
variables of the 4 items.
The list box is sorted alphabetically.
When a users clicks on an item in the list box, what's the best way to
reference back to the original array, i.e which array has been selected?
I can't use GetCurSel() as the list box is sorted alphabetically. I can't do
a direct comparison either as the list items are generated from a bunch of
variables within each array object. In some cases, it may be possible for
dupli...need help with list box?
I have a huge table of about 20000 records. how can I restrict entry for a
I am new to excel programming.
For example. I have a list of colors (red, green, blue) that I want to go
under the Color column. how can I allow the user to click on a pulldown or
list box similar to ms access for each cell.
thanks in advance.
you could use
'Data - Validation'. See:
>I have a huge table of about 20000 records. how can I
restrict entry for a
>I am new to exc...List all row source for all forms, reports etc.
I'm doing some work cleaning out old unused forms, reports and
queries. I have been going through each report in a database (There
are A LOT), determining its row source query, then marking it for
deletion. I will eventually end up going through and deleting all the
unused queries. As you can imagine this is time consuming, and I was
thinkg 'there must be a FASTER way"
Does anyone have a suggestion, or link to a pre-built function or
model that could assist me?
On Thu, 17 Jan 2008 22:14:18 -0800 (PST), Darragh <email@example.com>
>Hi...ACCESS 2000 is deleting records
Just yesterday I converted an Access 97 database to Access 2000. Have a large
problem I need help with. After converting the DB I "split it" in order to
use it as a backend, same way it was in Access97. After converting the
database to Access2k we began to have a problem with Access2k deleting
records. it deleted a total of 4 out of 62 records. the records are not
together ( record #289365 then 289048 then 289128 then 289178 then this
morning 289405) these record are auto-numbered incerement of one. They were
entered by different people so I know its not just an operator probl...MSN account list
How come I can't get a CASH account to show up in MSN. I want to enter
transaction on MSN site from work and on the road, and sync them when I get
...Remnants of Active Directory Connector
I have been using MS Excahnge Best Practice Analyzer for a few months now. I
recently upgraded from Exchange 2000 to 2003. I ran the analyzer and it
states that I have an orphaned connection agreement, an old connection
agreement version, public folder agreements and a disabled connection
agreement. After I upgraded from 5.5 to 2000, my domain controller where this
ADC was, crashed and we rebuilt it without the ADC because i didn't need it
anymore being on Exchange 2000. I since deleted the exchange reference in
Sites and Services, but the message still shows. Does anyone have an id...list view problems
basically I have a few questions CListViews that I'm trying to use:
1. are the rows uniform in height, and rowheight cant be adjusted?
2. How can I set column width as per my wish. i tried SetColumnWidth and
3. is there a setting so users cannot resize the column or in other words
make column width fixed?
Thanks a lot.
1. There are several ways by which you can set the row height of a list
Create an owner-draw list control and handle the WM_MEASUREITEM message,
and set the itemHeight attribute of LPMEASUREITEM struct.
Create a C...getting consolidate list of "follow up" items
I would like to get a consolidated list of items (sent and received
mails)that have matured - i.e. whose follow up time is up.
I have the habit of tagging a sent mail (after actually sending) for
Similarly, mails received are also tagged for my further action (for
Would appreciate a consolidated follow up report generation way -
rather that opening each folder and looking for mature items (i.e.
Thanks in advance.
...query to make a list of products based on delivery history
I have a table which lists all deliveries made of our product. From this
table, I'd like to make a list of all products. My problem is the products
will have many duplicates as they can be ordered multiple times and I just
want a list showing all the individual products that we offer.
Try something like:
SELECT DISTINCT [our product]
FROM [which list all deliveries made];
If you can't figure this out, come back with table and field names.
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Def...MDI App will no longer open file by double clicking associated filetype
OK, I had an app which was originally based upon an MDI app. It has been
'modded' to add various functionalities with code from www.codeguru.com and
Unfortunately, I just recently noticed that the ability to double click on
the associated filetype (from a folder, desktop, etc) now no longer works.
Instead, I get a messagebox:
Title: (pathname of file)
Message: Windows cannot find '(pathname of file).' Make sure you typed the
name correctly, and then try again. To search for a file, click the Start
button, and then click Search.
This is on Windows XP. ...Drop Down List in a Cell
How do I get the drop down arrow to stay in the actual cell that I have the
info in? It only shows up when you click on the cell and the arrow is
outside of the cell. Thanks for any help.
That's how data validation works.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
"Mike" <Mike@discussions.microsoft.com> wrote in message
news:A0546DF8-1E97-4D93-A46E-D718A3C4F00D...Changing icon for list item
I would like to change the icon for the first column of the list
control in report view. Right now, the method I used is remove the
LVITEM at that location and reinsert at the exact same place with a
different icon. I know this is not efficient compared to directly
changing the icon. I had tried GetItem adn SetItem but even though i
specified a different icon using the index into the imagelist, it still
won't change. Could someone please enblighten me on this? thank you very
> I would like to change the icon for the first column of the list