Outlook turns into an explorer
I have a very worrying problem with a friend's outlook express. Every time
she launches it, the toolbar is filled with unwanted panels and the main
section turns into an explorer page and downloads some kind of website with
a blue background.
This is very annoying!
Obviously this is infected with spyware or something. I have tried running
spybot without success and was wondering if anyone had any ideas on how this
may be fixed.
Many thanks in advance,
Ask in an Outlook Express forum. This is an Microsoft Office Outlook forum.
Outlook Express is family of Inter...How can I turn off all formulas in Excel?
I am using Excel to make forms and I do not want any formulas. Even when I
choose text in the format of a cell, Excel still puts in the formula.
Example: When I type "+1% chance for 4 bolts to corrode" in a cell already
formated as text, excel still changes it to a formula. There has got to be a
setting I could use to turn off formulas when just using Excel as a form
Just format the range (or entire sheet) as Text beforehand
(eg: select range, click Format > Cells > Number tab. Select "Text" > OK)
http://savefile.com/projects/236895...Updating 20k+ rows from Excel to access. vbscript? VBA? SQL?
Some of these rows only need a few columns updated, and others need
all of them updated. If possible if say row 800 column 'S' is filled
in the access DB but is blank on the excel spreadsheet, if possible i
like to keep the existing data in access and over right it with a
The spreadsheet is a export of the access DB, changes were made/merged
from other spreadsheets so the Unique ID is the same and in column A.
A script suggestions to complete this?
set dbe = createobj("dao.dbengine.36")
set db = dbe.openda...Prevent User to grant mailbox access permission
By default, in Outlook user can grant other user access
permission to his/her mailbox folder. But, our company
doesn't want this. Is there anyway to prevent user to
grant access permission to his/her own mailbox and sub-
Any input is much appreciated.
...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...MS Access to MS excel
When I'm Access�.
After a report has been generated (in Word format) I usually merge i
with MS Excel and then email it off to our clients. However the forma
of some of the fields change when this merge takes place.
The date column will be in a date format in Access but when merged wit
Excel the date format changes to a text format (what this means is tha
the properties of the date column changes when the merge takes place)
This change affects how our clients ingest the data I send them Yo
can see this by going into one of the date cells in Excel and checkin
I am u...Turn Off SOP Transfer Log Report
Is there any way to not have the SOP Transfer Log show up? We usually just
hit the Cancel button on the Report Destination window but it gets annoying
when you transfer 100-150 orders a day. I know you can go into the posting
setup to cancel posting reports but I can't find anyway to stop the Transfer
No, there isn't a method built in to do this. You'd need a customization
using Dexterity or I think you could use VBA to do this as well.
mbs developer support
This posting is provided "AS IS" with no warranties, and confers no ri...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
...where databases are to be stored in Access
i don't know where databases are to be stored in access, im excited about
the search on access in order to be a professional user like others. cheers
Microsoft Access uses a single file, with the ".mdb" extension, to store
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
"darkus" <firstname.lastname@example.org> wrote in message
> i don't know where ...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.
...Newb question: How did my Form_.... Access Class Objects get crea
I have an access database that originally was created in office 2003 access.
I am not in 2007 Access. When I go into the IDE, I can see, under Microsoft
Office Access Class Objects, a set of what appears to be modules named:
- Form_form abc
- Form_form xyz
Each of these corresponds to an actual form I have created, and includes
Private Sub RefreshAssetTable()
Private Sub Command4_Click()
by default. Now, my question: How did this class "modules" (and I know
that is the wrong term) get created? I &...What can stop a PC from displaying Access 2000/2003 text & background colours?
Can anyone suggest a reason why a specific Dell Inspiron 9300 laptop should
be unable to display any of the text or background colours on an utterly
basic test form with only a couple of text boxes and no VBA code on an
otherwise empty test database?
The problem also happens with an application of mine using Access 2003
runtime - but only on this PC. It runs fine on several other PCs.
I have applied every available Windows XP Home update and every available
Office 2000 update to no effect. The laptop (set to 32-bit colour) can
display digital colour photographs without any problem and ...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.
...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...Unableto access "greater than or equal to" Where is it?
Hi. I'm trying to find on Excel, the thing that allows me to write a
function, so that all the numbers written in a specific area/column (greater
than some number but less than another) come out highlighted. Could you
please email back regarding how to access this "greater than or equal to"
function? Thank you very much.
greater than or equal to.......>=
less than or equal to............<=
remove nospam for email addy!
> Hi. I'm trying to find on Excel, the thing that allows me to write a
> function, so that...Please explain the steps to use the Dlookup function in Access?
explain me the steps to use the dlookup function like how we use in EXCEL
Getting a value from a table: DLookup()
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Balu" <Balu@discussions.microsoft.com> wrote in message
> explain me the steps to use the dlookup function like how we use in EXCEL
...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. ...Need access advise regarind linked versus imported tables
I have designed an application that uses a linked csv file as the main table.
The reason for this is because another user creates this file and jsut puts
it into a designated folder on their computer.
Here is the issue.
The csv file contains approximately 20K records. I cannot create any type of
index on a linked file. Am I better off importing the file into access (or
reading the linked table and inserting them into another table with an
index)? Is there an easy way to perform something like this? Will this
I am pretty new to access and am looking for any and all...How to access a category name and code from vbscript
I am modifying the lineitem.html for the status bar in Store operation. I
want to ask how can i access the category name and code for each item, i only
can find a categoryid function, which is in the
TransactionEntry.Item.CategoryID, but can not access the name and code for
You will need to retrieve the name and code via SQL using the ID:
resultSet=QSRules.OpenRecordset("SELECT Name, Code FROM Category WHERE
ID=" & TransactionEntry.Item.CategoryID, true)
New West Technologies
> I am modifying the lineitem.html for t...access 2000 workgroup security question
I haven't used workgroup security for many years and forgot how it all works
but have a situation now where I have an access 2000 database that uses
workgroup security and possibly other security and I'm trying to figure out
how to get it so I can design forms or export the forms out of the database
into an unsecured database.
I purchased one of those $30 workgroup password crackers and ran it, here's
Lets assume the database is called XXX.MDB
and the workgroup is called WWW.MDW
For the workgroup we have:
"wuser" and "wpassword"...OWA Access Is Denied for Win2k Users on internet
Dear kind MVPs,
Sorry for cross posting and the length.. but i am desperate for the
Heres the setup.
one Win2k Server (DC) ,
One Win2k3 Server (DC+Exchange2k3),
One server with Reverse-Proxy configured to direct all HTTP requests to the
Exchange Server (working OK ).
Assume my exchange server name is MyServer and Proxy Server is MyProxyServer
and domain is MyDomain - names assumed for clarity otherwise valid IPs are
I am able to login using
http://MyServer/exchange interanlly ( XP + Win2k )
http://MyProxyServer/exchange from XP clients from internet
but not from http://My...MS Access. Can't open file via network
I have the database on one computer and trying to open
it via network from another computer so I can simulateously
work on it. And yes I do have the option-default mode-shared
When I click on the database nothing happens not even an
error message. However, when I open the database
iniitially from the remote computer it opens fine.
Any words of wisdom out there?
Thanks ahead of time.
> I have the database on one computer and trying to open
> it via network from another computer so I can simulateously
> work on it. And yes I do have the option-default...A program is trying to access your Address Book...
We started getting the above message after we isntall Office XP/2002 service
pack 3. Does anyone know of a Registry hack that I can setup to either
prevent this message always or prevent it for a particular .DLL?
For more information on the security features, see
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Soluti...Accessing S/MIME properties
I need to access the PR_MESSAGE_CLASS property of a signed, encrypted
message in my drafts folder. However, when I read this property using
Extended Mapi, it always returns 'IPM.Note', instead of 'IPM.Note.SMIME',
which is what it should be.
Is there any way I can access this property?