how to find on screen amimated character
how do u get an animated screen character to come up on ur screen? i have
I'm sorry there are no animated screen characters in the Microsoft
Project software, so I am guessing that you are not discussing Project?
I suggest looking again at the software program you are trying to view
the animated screen character in (Word?, Excel?) and then reposting your
question to the appropriate newsgroup. See the listing at:
I hope this helps. Let us know how you get along.
Pr...how to delete rows #2
I have a work sheet that has many rows like this and 3 coloums
1 chair custom 24
2 table custom 0
3 spoon custom 3563
4 hat custom 0
now I would like to make another colom and only extract those that
their sum is greather than zero. in other words I would like to delete
rows 2 and 4
how can i do that using if-function or any other function
You can use Auto Filter ,First select all then From menu choose Data -
Filter - Auto Filter , Now you can select 0 Value from drop down o...help with SQL query for HQ
Need two queries.
1. to clear the bin location field for all items
2. to assign a numberical value for the bin location field for each of our
stores. ex. store 1 bin location field to read 1, store store bin location
field to read 2
any help would as always be greatly appreciated...
1. To Clear bin location Run this
UPDATE ITEM SET BINLOCATION=''
2. To Update the bin location with store id
UPDATE ITEM SET BINLOCATION=storeid
> Need two queries.
> 1. to clear the bin location field ...Need help grouping charts
I have identical charts which occur on multiple sheets. Is there any wa
to group them for editing?
When I group the sheets themselves, it seems to deactivate the charts
I tried doing it with a macro as an alternative and then flipping th
sheets one by one and keying the macro, but I get a message box with:
"Run-time error 1004", "Unable to get the ChartObjects property of th
Does anyone have any ideas
Izzy's Profile: http://www.excelforum.com/member.php?action=getin...Can't get Word Mail Merge to find my Excel file of names and addre
I can't get my excel file to show up in the Select Data Source window. I
clicked on "New Source" then selected ODBC DSN, selected Excel File, and got
a Select Database and Table screen with no options for me, except ack and
Cancel. I'm sure I'm doing something wrong, can anyone help? Thanks.
Did you navigate [using the Directories list] to the folder where your Excel
file is stored? Double-Click the folders following the path to that
directory. Once you get to a folder containing Excel files they will appear
in the left list of Database Nam...Group policy 2k8:an old software (test) package is causing GPO err
At one point in time, forwhatever reason, there was a package "tested" in the
default domain policy.. (which also meant it got pushed to servers
I removed this from group policy a long while ago.. now, as i'm preparing to
goto 2008 R2, i ran dcdiag and noticed a ton of errors.. like these:
An Warning Event occurred. EventID: 0x00000065
Time Generated: 01/29/2010 12:25:17
The assignment of application Wise InstallTailor 6.0 from policy
Default Domain Policy failed. The error was : %%1274
...cannot find Adobe Acrobat previewer for Outlook
There does not appear to be an Adobe Acrobat previewer for Outlook. Does
anyone know where this can be found?
If you receive a pdf attachment, and open it, it will open in Acrobat
reader, if that is installed.
"ec96" <email@example.com> wrote in message
> There does not appear to be an Adobe Acrobat previewer for Outlook. Does
> anyone know where this can be found?
Yes...this works OK. A double click takes me out from Outlook and opens up
the Acrobat file in a separate windo...Group by field the Inbox
If I group by "Recevied" field the Inbox folder, Outlook 2002 (10.xxx ver.)
create a gruop for every message (!!!) because it gruop by
year-month-day-hour-minute and second too (like in the example image at
Is there a way to group only by day (year-month-day) and not even by second
(hour-minute and second)?
Thanks and sorry for my "englian"
D�vide from Italy
Try going to View | Arrange By | Custom. Click the Group By option and make
sure that the check box on top is selected (Automatically Group According to
Arrangement). ...AfxBeginThread failure
In an MFC pgm under VS2005sp1, I am creating a worker thread using
AfxBeginThread. Under certain circumstances which I can't quite pin
down, AfxBeginThread returns NULL, indicating it has failed. Is there
any way I can find out the cause of the failure, such as an error
code? I have tried tracing through the code with the debugger, but
what is apparently detecting the error condition is in MS code for
which I don't have the source.
My specific code is
and a test for pThread==NULL im...find a date on sheet 2 and count text in that column
I'm lookung for the formula to use that if I was under one date on one page,
to look what date im under go to the 2nd page, find that date then count the
text specified under that date. My pages are set up as follows:
A B C D
1| 1-oct 2-oct 3-oct
2| john text 1 text 1 text 2
3| jack text 1 text 2 text 1
text ...Search does not find messages in Outlook 2007
I have Outlook 2007 and Windows Desktop search trunning on a Windows
XP Professional machine. The indexing has been completed but I noted
that the search will not find certain emails, which contain the text
that I am searching for in the content. I can find the message by
author, subject, etc. but not based on the keyord.
This makes me dowbt of the reliability of the search.
Any ideas of what might be going on?
...Option group controlling objects
Is there a faster way of doing the following. It's kind of choppy when the
objects disappear then reappear. I'm sure it's pretty obvious what I'm trying
Private Sub OptionButton1_Click()
If OptionButton1.Value = True Then
Label3.Visible = False
Label4.Visible = False
Label5.Visible = False
Label6.Visible = True
ComboBox1.Visible = False
ComboBox2.Visible = False
ComboBox3.Visible = False
ComboBox4.Visible = True
Label7.Visible = True
Label8.Visible = True
ComboBox5.Visible = True
ComboBox6....Query Question - Friend - Friend - Friend
There are two tables.
Table1 has names of all people in town, and Table2 has friend relationship
of people in Table1.
TABLE 1 | TABLE 2
NAME | IndexID NAME FRIENDNAME
A | 1 A B
B | 2 A C
C | 3 B A
D | 4 B D
E | 5 C A
F | 6 C E
G | 7 D B
H | 8 D E
| 9 ...Moveing rows
I have to move a block of rows in order to have the spreadsheet in the order
I did a move and paste to move the rows and the existing rows ware
How do I move rows and not have them overwrite existing rows?
If you do ctrl + x and then select where you want it, then right click and
select insert cut cells
or copy and do it, then after you are sure you got it right delete the
Excel 95 - Excel 2007
Northwest Excel Solutions
"It is a good thing to follow the first law of holes;
if you...AD Group Members Disappear
Why would most of the domain members disappear from thier assigned Security
and Distribution Groups? This has happened twice to our server. Once
during a swing migration about a month ago and then again more recently.
The only change I recall doing yesterday was editing the Standard User role
and unchecking the Enforce the shared folder quota box. The first time this
happened I blamed it on a fluke with the swing migration and possibly a bad
replication or something. To fix it, I reassigned members to thier groups
manually. Any thoughts on doing this again to get people work...Can't find origination module
In GP 10, we have some invoices we need to delete - errors from when we just
started up about a month ago. When we go to Transactions>>Sales>>Posted
Transactions, we can bring up the invoice, but when we hit VOID, it gives us
this message: "this transaction didn't originate in Receivables Management.
Reversing entries will be made in Receivables Management and General Ledger
only. Do you want to continue?" We hit NO because we don't want to screw up
the system, but then we can't find the invoices anywhere else. We entered
them in Transactions>>Sal...Move Public Store to new Storage Group
I have 4 Storage Groups, one of which contains the Public Folder Store
(running Exchange 2003 SP2). I want to move the public folders to one of the
other Storage Groups. What is the best way to do this?
- You can't move a Store - public or mailbox Store - between Storage groups.
- One PF store can be associated with one tree on a server.
- If this is the only replica of PFs you have - you can replicate all public
folders using pfmigrate (to another server with a PF store). Once they're in
synch remove the Store, create new Store in new SG and replicate stuff back.
- You will need ...Q: open a query with parameters
I think I took a stupid pill today because I can't figure this one out.
I want to programmatically open up a query like when you use the
docmd.openquery("query name") function. But the query I'm using has
parameters which need to be filled in. I vaguely remember something about
querydef objects, but I can't seem to get it to work.
Can someone point me in the right direction?
Thanks so much!
...Need to find and replace
I have two Sheets. I have a list of numbers in FIRST sheet and another list
in the SECOND sheet. But in the second sheet there is another column with
What i want to do is that Excel could find the value of the first sheet in
the second sheet and could write that data next to the list of values in the
Here how it shoud look:
Column A | Column B
Column A | Column B
30 | 1.5
31 | 2.1
40 | 3.1
25 | 4
Column A | Column B
25 | 4
35 | NO DATA
40 | 3.1
50 | NO DATA
The VLOOKUP function will do much of what you want.
...progressive totals in a query for a chart
I would like to be able to create progressive totals in a query for display
on a chart.
The total required only has entries every few months while remaining data
is this possible?
...Coloring Alternative Rows only if data is there
I have a spreadsheet with [ =MOD(ROW(),2)=1] conditional formatting
in it. I want to highlight this only if there data in there. I have
googled if but cannot find the method can anyone post the method or
provide me with link. It will be 2nd conditional formatting I think :l
"BetaDocuments" <firstname.lastname@example.org> wrote in message
> I have a spreadsheet with [ =MOD(ROW(),2)=1] conditiona...Highlight rows with certain condition in some cells
I want to highlight every row that has a certain word in one column and a
different word in another column of the same row. How do I do this?
Here's a great site to learn about conditional formatting
davesexcel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31708
View this thread: http://www.excelforum.com/showthread.php?threadid=520844
> I want to highlight every row that h...Last transaction in a query?
I have a table with 5 fields
ID PersonID EDate Amount and TransType
I want a query with the last record of each person based on date and
want the results like this
PersonID LastOfEDate Amount TransType
if a person has tow transactions in the max date I want only one of
How can i do that?
You must have a "main" table with a single list of PersonID.
Lets assume it is called tblPeople, PK = "ID"
So, use that table to provide a unquite list of PersonID.
The query can be like:
select FirstName, Lastname, WorkPhone,
PersonID, EDate, Amount, Tr...Update table with data from rows with previous dates from specifie
I need to update a table where if a row contains a specified stat value I
need to change a date value to the date value of a row with the same subID
but a different stat value. My primary question would be if I need a cursor
to perform this operation or if it can be done without a cursor (Sql Server
2000 Tsql please).
In the sample data below if a stat value is in ('A', 'E', 'U') I need to
update that row - I need to update the date2 column with a date1 value from
the closest row with the same subID but the stat is in ('N', 'R') and ...How Do I Add The Letter P in Front Of Each Number in a Seriers of Rows in one collum?
I have a collum with different numbers in each row.
I'd like to add the letter P before each number all at once rather then
P before each one manually.
Was wondering to go about doing this?
Dno's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33947
View this thread: http://www.excelforum.com/showthread.php?threadid=537242
Enter in an unused column (say, column B):