Problem using Microsoft Web Browser control
I am trying to access the Custom properties of a Web Browser ActiveX control
on a form and I keep getting a message telling me that "The Operation on the
Microsoft Web Browser object failed. The OLE server may not be registered.
To register the OLE server, reinstall it."
I searched TechNet and MSDN and could not resolve this. I reinstalled Access
2003 (I have 2003 and 2007 installed on my workstation, XP Pro) and still no
Has anyone else seen this and if so, can you tell me how to resolve this?
Does anyone know the name of the file the message...Formatting four pages onto one 12x18 sheet
I'm trying to figure out how to format a 12 x 18 sheet with four individual
5.5 x 8.5 pages on it. Any ideas? The closest I can get is under page
setup...selecting "postcards" and that will give me three pages per sheet,
but I need four.
Any ideas or thoughts are greatly appreciated.
If your printer can be custom setup to 12 x 18 then you can divide it into four
parts. Are you sure you aren't trying to setup a 11 x 17 landscaped sheet? In
any event, setup your printer first.
File, Page Setup, Advanced on the right, type 18 width, 12 height or 17 width,
11 ...Table name length in microsoft query
Is it true that the maximum length of a tablename is still 8
characters. I'm useing Excel 97 and trying to get data from a Paradox
9 table via odbc-link and Microsoft Query.
I have heard a few years ago that long names are OK and supported all
over the microsoftian regime.
Is there any trick to avoid this without shortening all the names.
Greetings from Helsinki
...Inserting rows slow on large report
I have a large report I maintain with 3 data tabs and 2 report tabs, 1 for
top 10 customers, about 400 rows, and another for all other customers, about
4000 rows. Every month I have to update it for any new customer/product
combinations. I have optimized the formulas to the best of my abilities and
gotten a full recalc time down from 3 min to 30 sec, which is acceptable. My
biggest problem now is that every time I need to add a row (or delete one for
that matter) it takes about 15 seconds (on the 4k row report, adding to the
top 10 customers report takes 3-5 seconds), per row....click on page form tab to filter subform
I have page tab with following names: Flat Rate, Global Rate, MSRP Rate. I
would like to have subform only show the rates for each page tab. How do I
go about doing this. I am new to VBA and from reading all the threads, I
can't seem to find the one that fits my exact need. Please explain
step-by-step since I am new. Let me know if I need to provide more details.
Presumably you have a field in the RecordSource of your subform that
contains one of the three values (Flat Rate, Global Rate, MSRP Rate) or some
other text or code that corresponds to these values....Signature page not printed for Credit card transaction
I have set up new POS system and the POS system does not print
signature page for credit card use.
I check 'require signarue' for the receipt from tender type window and
print Z-out to apply it but it still does not printing out the
Please be advised.
thank you for your help!
This is a multi-part message in MIME format.
Make sure the receipt is set to print it. Manager | Database | Register =
Lis...Insert Row Under current row (with formulas/formatting)
I've got a sheet that gets appended to regularly but have to do a lot
of fiddling to make sure the formatting is correct, calculated fields
get added and chart series ranges collect all the data every time I add
a new row.
The insert (row) command seems to take care of all of this but it
inserts the empty row above the current row. As I'm always appending
data to the sheet, I would prefer this to be below the current row.
I've tried adding a dummy row under all the data containing the
formulas and formatting I need but unfortunately I get formula errors
and it screws up my chart....Word always asks to save changes to the template
For my work we have made templates for different letters we have to send. Our application (VB6) calls those templates when we want to send a letter.
Using the code we follow a few steps :
- open word
- open a new document using our template
- save the document (.doc) on a server
- sometimes print the document
- sometimes immediately close the document (when we don't want users to modify the document afterwards)
When they closed the document the users always get 2 questions :
- save changes to template for the letter
- save changes to normal.dot
I already found a solution to avoid the q...Saving Word E-Mail as a Revision/Draft
I would like to be able to use the E-Mail feature in Word 2003 to save an
email as a draft/revision for future use. I do not want to save the word doc
as an attachment. Is this possible?
Why don;t you just create the word doc, save it, and then email it when
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"JoshB" <JoshB@discussions.microsoft.com> wrote in message
> I would like to be...how to use a saved master page
I have created a new master page and saved it as a .pub file. The question
is when opening a new document, how do I apply the saved master file?
Open the master file, copy, paste to your new publication.
Mary Sauer MSFT MVP
"Colin" <Colin @discussions.microsoft.com> wrote in message
>I have created a new master page and saved it as a .pub file. The question
> is when opening a new document, how do I apply the saved mas...CAN'T OPEN PC-ORIGINATED WORD DOCS ON iMAC
Operating System: Mac OS X 10.6 (Snow Leopard)
sorry for the really basic new-guy question (i just got an iMac) but when i go to open some PC-originated .doc and all .docx files, i get an error that reads "Word cannot open this document. The document might be in use or might not be a valid word document." !? anyone have any guidance? i've installed all the updates ... no luck. <br><br>thanks.
> sorry for the really basic new-guy question (i just got an iMac) but when i go to open some PC-originated .doc and all .docx f...how can I use my e-mail addresses on excel xp with microsoft outlo
I need to use my addresses on Excel xp with Microsoft outlook. I want to use
my excel file as a database that I can change and improve everyday. I need to
send mails to more than 1 contact, so creating an e.mail link is not enough
for me: in fact, if I click on it, I send my mail only to 1 address... Txs
(remove nothere from the email address if mailing direct)
"Cat" <Cat@discussions.microsoft.com> wrote in message
> I need to use my addresses on E...Microsoft Mail
Is there anyway to setup microsoft mail in outlook 2002 to
attach to existing microsoft mail postoffice.
...Linking Word And Excel
I am trying to link several fields in Excel to a Word Doc. I'm linking the
fields using Ctrl-Paste as Hyperlink. The linking works fine. However,
when I try to save the files in different folders or move the files, all the
links are lost. This makes it very hard to replicate the linking for my 6
analysts. Any help would be greatly appreciated.
Brady T. Finney
Atlantic Management Company, Inc.
Orchard Park - Suite A12
875 Greenland Road
Portsmouth, NH 03801
617-413-4554 (Mobil...page numbers in Word 2007
I have a Microsoft Word 2007 document which has a title and
table of contents on the first page and the various chapters on
the following pages. I have used an automatic TOC and then
clicked on the Insert tab and then Page Number -> Bottom of
Page to insert page numbers.
My problem is that I don't want the first page to be numbered
so that the second page starts with the number 1.
I have tried clicking Page Number -> Format Page Numbers...
to set the first page number at zero but then when I delete the
zero all page numbers are deleted by Word 2007 just as th...How to quote cells when "IF" word is involved
On Sheet1, I have a data set (C1:C100) based on the input of cell A1.
When A1 has various method choices,say,"method 1","method 2","method
3", each cell in the data set will have a new value accordingly.
(=IF(A1="method 1",formula1,IF(A1="method 2",formula2,formula3))
I want to quote those three data sets on Sheet2. A lousy way is I could
just duplicate Sheet1, set A1 to different value and quote data sets
from different sheets.
Is it possible to quote three data sets simultaneously from Sheet1?
Perhaps use a 2 variable data t...Word Wrapping in Excel
I am having trouble with Word Wrapping in Excel. It does not adjust th
row height properly. I have tried Format, Rows, AutoFit and it stil
Mandy11's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1300
View this thread: http://www.excelforum.com/showthread.php?threadid=27632
do you experience this with merged cells. If yes->nothing you can
really do about this without using vBA
> I...Insert string into a Cell ?
How do I insert string into a cell ?
Dim myString As string
myString = "abcd"
shp.CellsSRC(visSectionProp, visRowProp, visCustPropsValue) = myString
'This will yield with type mismatch error.
You've got a reference to the cell but not the property of the cell object.
So if you want to set the cell's formula you need to use that property.
Also, as you're adding a string you need to wrap it up in quotes (note two
double quotes in a row get evaluated as a single set of quotes).
Have a go with the following:
shp.CellsSRC(visSectionProp, ...Microsoft Outlook Task Reminders
My task reminders have stopped working. How do I get the
reminders working again? Thanks for your help.
Ken Toews wrote:
> My task reminders have stopped working. How do I get the
> reminders working again? Thanks for your help.
I found the following website:
Search for "reminders" on this site:
If the reminders are in the default folders, you may need to open Outlook
using the /cleanreminders switch. Close Outlook and at the Start menu, Run
command, type "outlook.exe /cleanreminders"
Oliver V...Disabling Microsoft Money Background Banking Service (mnybbsvc.exe) in 2007
I found the instructions for 2008, which is a simple check box in the
settings, but is there any way to disable it in earlier versions?
In microsoft.public.money, Milhouse Van Houten wrote:
>I found the instructions for 2008, which is a simple check box in the
>settings, but is there any way to disable it in earlier versions?
You could remove your LiveID.
...blank page prints after group (sometimes)
I have report of students with the class_id defined as a group. "Force New
Page" is defined "Before Section".
Whether I have a page and a group header defined (they can be the same anyway)
or just a page header defined, I am getting the same problem:
27 students can fit onto a page. However, if there is a class of 25 students,
the next page is blank except for the header. (I have not seen a class of
27 students so I have not tested that yet).
I can't seem to find a way out of it. Where I am I going wrong?
Message posted via AccessMonster.com
http://www.acce...How do I publish to the web a 3 page web pubblication from Publis.
I created a 3 page web publication in Publisher 2003, but when I 'publish it
to the web', only the first page is converted. What do I need to do?
Review the FAQ - http://www.publishermvps.com/Default.aspx?tabid=30
David Bartosik - MS MVP
"Bazbo" <Bazbo@discussions.microsoft.com> wrote in message
> I created a 3 page web publication in Publisher 2003, but when I 'publish
> to the web', only the first page is converted. What do I need to do?
...Embedding a single workbook in a word doc
I prepare memos and I insert a bunch of tables out of a single excel
file with a bunch of interlinked sheets. I typically insert them as
pictures or linked pictures; however we often email the memo around
for comments and and it gets complicated to have multiple versions and
keep the links current. The other option is to insert the tables as
embedded objects; however, if I do that, each table becomes a separate
excel file, so I can=92t make changes to one and have it reflected in
the tables throughout the document. Is there any way to create a
single embedded workbook which I use several ti...Access 2000... how to import a word document?
I am told Access will allow inport of a Word document by
converting the document to Rich Text w/delimiter, then
Does that not work with Access 2000?
It depends what you mean by "import a Word document". If you have data
in a table in a Word document, convert the table to text, paste the text
into a new file, and save it as plain (not rich) text; then import the
text file into Access.
Alternatively, paste the table into Excel, save in Excel or CSV format,
and import the resulting file into Access.
Which of these works best depends on just what's in the data. ...Word to edit e-mail messages
I am unable to select 'Use Microsoft word to edit e-mail
messages' in the mail format options panel. The option is
not for selction, it is greyed out. I am running Office
2000 with Outlook 2002.
Do you have Word installed?
>I am unable to select 'Use Microsoft word to edit e-mail
>messages' in the mail format options panel. The option
>not for selction, it is greyed out. I am running Office
>2000 with Outlook 2002.
coz you have to use Word 2002 to use it as...