using ADO from Excel 2007
We just upgraded to Vista from XP and on some PCs get an error message
about MSRDO20.dll not being installed when I try and connect to a
SYBASE database using ADO.
I have asked the technology group for help installing this (some PCs
have it, some don't)
My question is - fromteh VBA Developer screen (inside Excel) under
Tools - References - which referneces do I need to include to be able
to use ADO?
What I'm wondering is if in Vista there is a reference I should add in
that I have not used before.
Is it sufficient that I just downlaod MSRDO20.DLL from the internet
an...Advanced Find Select dropdown disppearing
Is it a known issue in 4.0 that when you click on the Select dropdown as
soon as you begin to scroll down the list disappears? It's very annoying!
If anyone else is having this problem and has a fix for it please reply.
...On status bar, sum of selected cells doesn't automatically appear.
Excel 2003 -
when you use the auto filter - nomally the sum of cells selected
automatically shows up on the bottom left hand side of the status bar - eg:
32 of 100 records found..
but this is not always the case when i open or start a new worksheet
Can anyone tell me if there is a function to activeate this on my
Debra Dalgleish explains why and offers some workarounds:
> Excel 2003 -
> when you use the auto filter - nomally the sum of cells selected
> automatically shows up on the bottom l...OMA is not what it used to be
Hello, I have installed SBS 03 with exchange, and whenever I would log on to
OMA I would get that nice welcome screen that I managed to modify and put the
company logo on. After installing SP1 that screen is gone, now I just get a
pop up that wants my user name, password and domain. Also I cannot do
www.mywebsite.com/exchange it wants https://
"Dima" <Dima@discussions.microsoft.com> wrote:
>Hello, I have installed SBS 03 with exchange, and whenever I would log on to
>OMA I would get that nice welcome screen that I managed to modify and put the
>comp...Before you can use US Payroll Extensions...
A client recently installed GP on a new client workstation with GP 10.00.1410
- they also installed the PayrollSP4 and HRSP4 files for the Human Resources
and Payroll Suite. This had previously been installed on all of the other
clients, as well as the server.
Now, after this one installation, all client workstations are receiving the
Before you can use US Payroll Extensions, PTO Manager, Advanced HR, or
advanced payroll, a system administrator must first log into GP to initialize
or upgrade database objects.
We've logged into all companies as 'sa' and...Using LINQ to SQL
New to LINQ to SQL...
When I added a stored procedure to the project, I noticed that the
auto-generated code contained a hard-coded reference to the Database name.
Is there any way to pass the DB name as a vaiable instead (like from the
config file) ?
> New to LINQ to SQL...
> When I added a stored procedure to the project, I noticed that the
> auto-generated code contained a hard-coded reference to the Database name.
> Is there any way to pass the DB name as a vaiable instead (like from...Selecting certain letters in address book closes Outlook
I'm using Outlook 2000 Pro with Windows XT. When you open
the address book, then select u,v,w,x,y,or z, Outlook
immediately closes. PLEASE HELP! Thank you.
Try running Detect and Repair from the Help menu.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to the
Swen virus, all e-mails sent to my actual account will be deleted w/out
After searching google.groups.com and finding no answer
ALB <email@example.com> asked:
| I'm using Outlook 2000 Pro with Windows XT. When you open
| the address boo...choice selection button in a cell
I need to have a choice/radio button in a cell, wherein the user can
just choose only one option instead of choosing from the drop down menu
that appears against a cell when data validation method is used.
Ex : User has to choose one of the 3 options shown in a cell.
Can someone in this forum share the knowledge of how to go about
achieving the same ?
my skills are very limited and have only used the existing functions in
jkkumar's Profile: http://www.excelforum.com/member.php?action=getin...Exchange 5.5 (latest SP and hotfixes) and Outlook 2k and 2003 Send/Receive Issue
I am running Exchange 5.5 Standard with latest of everything. My clients
are running either 2k or 2003, most being 2k. I have an issue with all
clients when sending receiving e-mail. Mail is no longer instantly sent or
received. Mail sent stays in the Outbox until I change folders or click on
a different e-mail message. Same way with receiving mail. People will have
Outlook open and sitting in Inbox. If they don't move around no messages
come in. But the moment they select a new folder/e-mail, etc. a slew of
messages come in.
What is the problem and how do I correct?
...xml using datasets
hi i am new at this...whats the better way to read xml files..create a
dataset and read them using xml only for validation ...
use xmlreader to validate and read them?
thanks in advance
"Ramakant" <firstname.lastname@example.org> wrote in message news:e1WM5dwMFHA.1268@TK2MSFTNGP14.phx.gbl...
> hi i am new at this...whats the better way to read xml files..create a
> dataset and read them using xml only for validation ...
> use xmlreader to validate and read them?
If you already have an ADO.NET DataSet, then it's more convenient
to use ADO.N...Excel Display formula, not result
I'm modifying a formula and rather than the result, Excel is displaying
the formula -- Yes, my equals sign is in place still.
The formula I'm modifying is =SUBTOTAL(9,E2:E45) to
I'd rather not re'run the subtotal again to get the count I need unless
I can get it on the same line as the sum. When I run them separate, I
am getting two groups when I only want one.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
Your cell ma...need to add large amount of selected users to a distribution group
Is there an easy way to create a distribution group by importing a list of
users into it using a .csv? This is on Exchange 5.5. I'm not ready to sit
here, choose and select 900 users!
"dude" <email@example.com> wrote:
>Is there an easy way to create a distribution group by importing a list of
>users into it using a .csv? This is on Exchange 5.5. I'm not ready to sit
>here, choose and select 900 users!
You can use the directory import tool. The details are in the
maintenance and troubleshooting guide you'll find in the the online
docs. You'll still h...error in using vterm sample
I am trying to use mscomm32 in visual c .net
and so I run MSDN sample (VTerm)
but it do not receive any thing
plaese tell me why?
I am using Win2k advance server
Thanks a lot
...Using more than one OR Statement
I am working on producing a time sheet for my work. I have the
following function happening in a box :
where B12 = time started, C12 = time finished and D12 = length of
Currently if someone puts either A/L, S/L, P/H or FLEXI it will show
the value of 7.00 in the total colomn.
What I would like to happen is that is somoene inputs "FLEXI" to the
box that the value 0.00 would be shown. Reason being that tthis is
time that a staff membe...Selection Transparency
I just started using Excel 2007, and I am having trouble actually seeing the
range of cells that I am selecting when I click and drag my mouse. Does
anyone know if there is a way to make the selection darker and more visible
like in Excel 2003? I have searched the options and menus and can't find
anything in Excel, so maybe this is a Vista problem.
There is no way to adjust the color for the highlighted cells. However if you
are having difficulty, try adjusting the brightness and contrast of your
monitor to a level in which you are comfortable. If you are using an LCD
M...How to use my application to download a file on a http server?
<a href = "1.rmvb" >download</a>
I use WebBrowser ActiveX in my application.
If I click download on WebBrowser ActiveX,My application will use IE to
download.But I want to use my download application
to take the place of IE.How to do I should?
Try using URLDownloadToFile.
Ajay Kalra [MVP - VC++]
"Z.Smith" <z...using "Last" in query desgin
I am trying to build a query that sorts data ascending order by date, so that
when I select "Last" in the Total row for other fields in the query I will
get the newest value (I have an account field that doesn't change but I want
to retrieve the newest account description which can change from one day to
the next so I want the desciption of the newest record). The problem is I
don't want the date column in the query since I am trying to also trying to
group and sum the data and don't want a new row of data for each date value.
I would use Max in...New to powerpoint 2007. How to use macros to move picture.
Hi. I am not very good at ppt but can someone tell me if there is an
effect to re-size an image. What I would like to do is have a page
that shrinks the image to the top left corner and then displays text.
I know there are lots of special effects for images.I want the top
of the image fixed so that the image retreates up and right.
I have been asking this question for over a week now. A reply takes a
I have a presentation ChildrensTalk.pptm
On Slide 8 I have a jpg file called WaterWine.jpg
Dim oSh As Shape
' Create a variable to hold a reference
'...Upgradeing a published website using ftp. Many questions
I published my website using vs2010.
I checked the box that made it upgradeable.
As a check I ftp copied default.aspx and default.aspx.vb to the site
replacing the published files.
Looks like it still works.
So I can update the site files using ftp?
I noticed there is no App_Code folder.
Suppose I need to update something in that folder, can I? How?
I also noticed there is a file: PrecompiledApp.config
Might I ever want to delete that file?
What is it for?
Would it make sense to delete all the files and ftp the entire site to the
host. Can a site be uplo...I cant seem to figure out how to use Proper in excel. The help op.
I keep trying to figure out how to change data in excel so that instead of
all CAPS, it will have the first letter be capatalized and the rest small
cap. (its names and addresses that I'm trying to merge to a word doc.)
The help option is 0 help. It errors and will not tell me how to change the
whole doc at all.
> I keep trying to figure out how to change data in excel so that
> instead of all CAPS, it will have the first letter be capatalized and
> the rest small ca...When Using a PropertySheet in Wizard Mode Can we Change the Order of sheets at runtime
I am creating a Wizard Using Property Sheet
According to User Selection of Data in First Page
I want that only one of the PropertySheet should be visible with a Fnish
But I have added 4 More Property Pages
Whereas i want only one of them to appear.
Take a look at the CPropertySheet::SetActivePage() member function.
Check Abdoul [VC++ MVP]
"vikrant" <firstname.lastname@example.org> wrote in message
> Hey Friends
> I am creating a Wizard Using Prop...Does anyone know how to get a read receipt from Outlook 97, 98 or 2000 when using Outlook 2003???
Does anyone know how to get a read receipt from Outlook 97, 98 or 2000 when
using Outlook 2003???
Is Outlook 2003 backwards compatible???
On Mon, 24 Jan 2005 21:11:53 GMT, Paul wrote:
> Does anyone know how to get a read receipt from Outlook 97, 98 or 2000 when
> using Outlook 2003???
> Is Outlook 2003 backwards compatible???
Outlook 97 and 98 definitely don't support read-receipts (the Internet
standard for read-receipts didn't exist when they shipped). I forget
whether Outlook 2000 suports them - but I think not, for the same reason.
Outlook Develo...Can I use an animated graphic in Excel 2002?
We are trying to use an alert, animated graphic in our document when a
certain condition exists. For example, if a home is not ready to close, then
we want an animated graphic to appear (it is alert.gif graphic). Any ideas?
...Import text from Access results in squares at end of para
I have an Access database that I query from Excel. The
fields that are defined as TeXt or Memo fields in Access
have squares at the end of each paragraph in Excel. I can
manually remove them from Excel, but the next time I
refresh the data from Access, then they are back of
course. Is there some way to prevent this or to remove the
squares via an Excel macro. I tried to record a macro that
would remove the squares, but it would not record my
You can create an query in access that does not include
the memo fields and import that.
Alternatively, I seem to remember t...where do i get info on how to use excel?
i don't have a manual or anything. can i buy one? is there a college course
all of the above. most good book stores with have an excel
for dummys book. microsoft site has books for all version.
college course tend to be generic and way too short. books
are better. and cheaper.
the net is a good source too. try these sites
and you can hang ar...