I want to connect my Sharp Aquos flat screen TV to my computer, and see my desktop on both the TV and computer monitor.
Windows Vista Home Premium.
HP Pavilion a1610n computer.
Galaxy GeForce 8400 GS graphics card, outputs: 1-VGA, 1-DVI, and 1-SVGA. There is no HDMI port on the card.
I connected a VGA cable between the motherboard "on-board" VGA port and the TV, figuring that I could use that output to work with the TV. The computer monitor is plugged into the GeForce graphics card.
Tried the Desktop "Display Setting". It says, the number 2 monitor is "N...Outlook 2003 fails to launch
Am trying to install Outlook 2003 on a machine brought home from work. Once
I launch after installation, it automatically attempts to migrate account
settings, then displays an error message that reads as follows:
"Failed to register a VB Script DLL. Reinstall or run Regsvr32.exe
Vbscript.dll to self register. The form cache file 'C:\Documents and
Settings\Robin Martinez\Local Settings\Application
Data\Microsoft\FORMS\FRMCACHE.DAT' is not valid. Contact your
A dialog box then indicates the operation fails and Outlook terminates. Any
thoughts on w...How to handle blank date and time?
I use MFC Visual C++ 4.2
I am developing a database application using MS Access 2000.
The problem I am dealing with is how to handle if the user does not enter
the date. There is a condition where they can do that for Finish Process Date
/ Finish Process Time.
I make the Date and Time as separate fields, both in the database and the
application. On my application I use the COleDateTime data type.
I have to save the blank Date and the blank Time, and I also have to acquire
them back in order to display the data using the CListCtrl.
What I am confusing is how to make the query?
Is it...Message stuck in queue in Exchange 2003
I have two messages that are stuck in queue of ESM. ESM doesn't give me
the option to delete these messages. The sender is blank if that helps.
Which queue? What is the status of the messages?
"Sabo, Eric" <email@example.com> wrote in message
>I have two messages that are stuck in queue of ESM. ESM doesn't give me
>the option to delete these messages. The sender is blank if that helps.
> Eric Sabo
> NT Adm...One more TIME
After downloading data it is presented with a decimal(period) between
the hours and minutes i.e.7.20 is really 7 hours and 20 minutes. Some
data appears in hundreds eg 985.35.
I need to compare this data with other correctly formatted timed data
ie 7:20 to establish variances.
I realise that i could use Tools/Autocorrect replacing the decimal
with a colon but this changes the 7.20 to 07:02 and there is the
danger that I might forget to change it back later.
Is there a solution?
Can this be done automatically by macro etc as there is quite a lot of
Thanks in advance.
Hi ...Display a message box "this entry is a duplicate"
How can I display a message box on a form if the shipment number is a
duplicate? I need a message box to pop up when user attempts to tab out of
Private Sub txtShipNum_BeforeUpdate(Cancel As Integer)
If DCount("*", "MyTable", "ShipNum = '" & Me.txtShipNum & "'") > 0 Then
Msgbox Me.txtShipNum & " already exists."
Cancel = True
This assumes that your text box is named txtShipNum, that the name of the
field in table MyTable is ShipNum...Folder could not be displayed
I am running Windows XP and Outlook Express 6 just fine
then one day my husband does something to my computer and
his email account won't work. My email is working just
fine but in his he cannot open his inbox. It says folder
could not be displayed, and when you send and receive it
gives you this error message:
"An unknown error has occured.
Server:'incoming.verizon.net'.Protocol:POP3, port: 110,
Secure(SSL): No, error number: 0x800C013B"
If anyone could help me with this I would greatly
T...how to display values in 3 cells into one cell
Anyone can help me how do I display the 3 separate different values in 3
cells into just one single cell ?
thanks so much in advance.
Either there was a typo or there's an echo in here.
That line should have been:
= A1 & " " & B1 & " " & C1
"Bradley Dawson" <firstname.lastname@example.org> wrote in message
> In the target cell, type:
> = A1 & B1 & C1
> where A1, B1, C1 are the cell addresses that you want to concatenate.
> If these have number...How to setup notification for Resources in Exchange 2003
We have our conference rooms setup as resources in Exchange 2003. This
works very well. However, I have a person who wants to be notified
every time there is an addition to the calendar... I added this person
to the Forwarding Address in Active Directory. However, the automatic
addition of calendar appointments does not send anything to this
I need to know how I can automate something to this person every time a
new appointment is setup for the resource...
...Excel Slooooow. It takes 4 to 6 seconds to perform each input or command
Operating System: Mac OS X 10.6 (Snow Leopard)
I have just installed Excel 2008 on a new installation of Snow Leopard and it does not work properly. It takes ages to register every input or command, like a large Lag. <br><br>EG. each figure or text, input into cells takes 4 seconds from hitting enter to accepting the input. Changing the width of a column takes 6 seconds from letting go of the mouse after dragging to the new width. etc etc. <br><br>I have checked for updates. Any ideas?
> I have just installed Excel 2008 on a n...How to select & display distinct values
I need help with a form please.
My form has two controls, the first being a combo box. This box should
select the company name from a lookup table. The lookup table has only two
companies in it, however, they each are repeated several time. Company 1 has
about 10 rows, company 2 has 3 rows. I used the query builder and came up
with the statement:
"SELECT DISTINCT Lktbl_Role_Master.CompanyName
When I run the statement directly from query view, it executes perfectly and
returns exactly two rows (one for each company, in a datasheet view) ho...Display Time in Outlook
The time setting in my Outlook is one hour behind my
actual time. I cannot determine how to change the time.
Outlook is the only item that is incorrect. Other display
times in operating system are correct. Thanks, Jodi
...In nameing a sheet in Excel it puts a .xls] in front why?
Every time I go to name a sheet it puts an .xls] in front of it and I do not
Did you try to put brackets around the name?
"EZE" <EZE@discussions.microsoft.com> wrote in message
> Every time I go to name a sheet it puts an .xls] in front of it and I do
> know why
Remove the bracket or other illegal character(s) from the workbook name.
In article <C9045E70-AD04-4C91-B223-8851A0DFE55D@microsoft.com>,
EZE <EZE@discussions.microsoft.com>...serial number formula for excell sheet
when im making to much rows data like more than 30 thousand, i want to put
the serial number by puting formula and it put serial number with out scroll
or copy system. plz help if u got it.
Place this in the startcell,
say in A2: =ROWS($1:1)
Then just drag A2 down all the way
Or just double click on A2's fill handle (if the adjacent col is filled)
voila? clap it, click the YES button below
Downloads:25,000 Files:300 Subscribers:70
> when im making to much rows data like m...outlook web access 2003
web page downloads ok to my home 98SE based PC with 5.0
IE browser, but will not load ok with 6.0. The outlook web
access program from work is on a 2000 Professional based
server. thanks. all other webpages download ok but when
i login to this remote email the page hangs up.
try emptying the browser cache and if it's still a problem, repost in the
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for W...Excel: Subscript shortcut
Can I create a keyboard shortcut that will apply subscript formatting to
selected text in Excel?
By typing extra characters you might be able to do what you want
with autocorrect. Make sure is not something you would actually
type for something else.
You could use a macro to change them after entry, you would use superscripts
but here is a a solution by David Hagar for subscripts., programming, 2002-01-22
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps....Hide rows with value "Hours"
I would like to toggle rows to hide/unhide based on the value "Hours"
in column B. I think filtering is an issue to some blank seperator
rows and merged cell headings. There are no merged cells involving
Column B. Thanks.
Public Sub ProcessData()
Const TEST_COLUMN As String = "B" '<=== change to suit
Dim i As Long
Dim iLastRow As Long
iLastRow = .Cells(.Rows.Count, TEST_COLUMN).End(xlUp).row
For i = 1 To iLastRow
.Rows(i).Hidden = .Cells(i, TEST_COLUMN).Value = "Hours"
...Activate my Excel 2003 but it still runs in reduce mode
My Excel 2003 is showing that it's activated but it is still running in
reduce mode. what I'am doing wrong?
Rightclick on the excel icon on the windows taskbar (usually at the bottom of
Maybe it's just off the screen (not really minimized--just off the screen).
> My Excel 2003 is showing that it's activated but it is still running in
> reduce mode. what I'am doing wrong?
...PK and FK Displayed
I am a complete Visio newbie, and cannot find the answer I need in books or
I am trying to create ER diagrams from scratch, and not connected to real
tables, using VEA. I have added tables ('Entities') to the form, connected
them with a Relationship connector, and, in the Database Properties window
I've assigned the end points to a Primary Key on the left and a Foreign Key
on the right. But the model shows the connector as running between the top
colums on both sides, whereas I want the keys to be in that upper box and
provide the connector's end points. Wh...Excel error message not understood
Has anyone ever gotten the error message "Too many
different formats"? If so, what exactly does it mean and
what can a user do about it?
The following MSKB article has information on the error message:
XL: Error Message: Too Many Different Cell Formats
> Has anyone ever gotten the error message "Too many
> different formats"? If so, what exactly does it mean and
> what can a user do about it?
Excel FAQ, Tips & Book List
...How do I shade a region between two selected points on the x axis?
In a line graph of monthly unemployment rates over many years, economists
like to shade a region between 2 selected months (x axis) in order to denote
a recsession. How can this be done in an Excel chart?
I am sure that someone very cleaver will tell you there is an automated
way to do this. But given the irregular nature of the data, and not
frequently the easiest way to do it would be to dislay the drawing
toolbar. Now choose the rectangle shape and draw the area you want high
lighted. Once you have the area you want covered, right click the rectangle
and choose format autosh...Formulas are displayed, results are not
Hello, For some reason, when I enter a formula into a cell and press
enter, the formula just stays there. Anyone know what I can do to show
I tried pressing Cntrl + `, but that didn't work.
FYI, when I cut and paste a column from a separate workbook, that
column works like normal (i.e., the formulas produce results).
Thanks for any suggestions!
Maybe your cell is preformatted as Text.
Try formatting to general then erase your =
and type it in again.
"Mike C" <email@example.com> wrote in message
news:f699bcd4-ad82-4a88-9759-5638c147b...reading data from Excel Sheet
i want to read the data from the Excel sheet using vc++6.0. How can i
read it. i don't want to create any DSN
You can use the Excel.Application com object
> i want to read the data from the Excel sheet using vc++6.0. How can i
> read it. i don't want to create any DSN
> thank you,
...Stop displaying a line
I have a line graph/chart and it gets its values using a formula and the values of another column. However this poses a problem because if there is nothing in the targetted column the formula returns 0 cause the line to drop to the bottom, instead of casuing the line to just end until a value is added to the target column. How can I do this?
Change your formula to use NA() if the cell is empty. For example:
To hide the resulting #N/A errors on the worksheet, you can use
conditional formatting. There are instructions here:
http://www.contextures.com/xlC...Problems saving in Excel
When trying to save a document in Excel, it says that it can't because =
not enouh memory of free disk space, although both are available.
Did anyone encounter / resolve this?
In article <firstname.lastname@example.org>,
"Roy Schwartz" <email@example.com> wrote:
> When trying to save a document in Excel, it says that it can't
> because there's not enouh memory of free disk space, although both
> are available.
> Did anyone encounter / resolve this?
What version of XL? What ...