Access OWA during exchange offline
AS we know, we can access Our inbox (via Ms Outlook) during exhange server
down or offline.
My concern is, can wee access our inbox or calendar during exchange server
Muhamad Taufik Khasim <Taufik@uniten.edu.my> typed:
> Dear All
> AS we know, we can access Our inbox (via Ms Outlook) during exhange
> server down or offline.
> My concern is, can wee access our inbox or calendar during exchange
> server is offline?
> thank you..
No.....only when your mailbox is accessibl...UPC calculating works in excel but not in access
Hi, ive build a query using the following module to calculate the
check digit (using mod 10) of an 11 digit upc number. In excel i can
use the same module to calculate the check digit on a 13 digit upc
code but in access it doesnt work.
Here is the vba (i didnt write it but found it to use on the internet)
Option Compare Database
Function Format_Upc_String(InString As String) As String
Dim OutString As String
Dim Multiplier As Integer, Sum As Integer, i As Integer
Dim CheckDigit As Integer
' Initialize the sum to zero
Sum = 0
Does anybody knows how to insert one picture that changes without use
intervention everytime the result of another cell changes?
eg.: If the cell A1="Alex" the cell A2=Picture of Alex. Then if
change the cell A1 to "Mike" the cell A2 displays the picture of Mike
Message posted from http://www.ExcelForum.com
This macro example from this group a long time ago you can use.
The jpg files must have the same names as the number you type in cell "a1"
Change the path to the files in the code.
Place the code in the Sheet module
Right click on a sheet tab ...Vista Access 2003 & Ole
I have a DB I've been using, updating for several years. I use a =
different BMP on every record. Today I started to update it again. Last =
update a few weeks ago on my XP.
Today I went with 'insert object' 'create from file'. with XP I couldn't =
use JPG's so I made bmp's. Today even a bmp is just an icon.
How do I get the create from file to work again ?
more pix @ http://members.toast.net/cbminfo/index.html
...How do i fix this error in access
I created a database in microsoft access. I have been trying to open some of
the forms that I created but after several tries I keep getting this error
message "Not enough memory. Please close un-needed programs." Can someone
please help in fixing this.
I created 13 forms and 8 of the forms are opening but the other five forms
arent. I get the above error when I try. I have uninstalled and
re-installed microsoft office several times, and no other programs are opened
when I get this error. Any help is appreciated.
Alicia, unless you actually do have too man...Identifying remote Outlook Access
I am running outlook 2002 on NT4.0 connected to exchange
mailbox on exchange 5.5/2000.
Is there any way I can identify whether the Administrator
or exchange Admin has my mailbox open on his PC or is
accessing my mailbox via his security access.
Can i tell on my PC. Is there something left locally on my
PC that will tell me.
No, you can't. Why the suspicion?
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tip of the month:
-Create your own fully customized Toolbar
Subscribe to the...Not Recognized Format
I've written large workbooks with excel xp, but at home I am using excel
2000. Is there any way to convert the xls file format that xp uses so I can
work with the spreadsheet at home?
All versions of Excel since 97 use the same file format, so no
conversion is necessary. If you can't open the file, it is
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"SKLwater" <firstname.lastname@example.org> wrote in message
> I've written lar...Custom cell formatting
I need to create a custom format for a series of cells that will begin like
I can't figure out what the code character is fora volitile potentially
Can anyone help me??
something like this might work for you but you'll need to put all the
leading digits in for the entry with the alpha character
"MDavison" <email@example.com> wrote in message
> I need to create a custom format for a series ...Date Functions & Formatting
I'm putting together a spreadsheet showing personnel recurring training dates
and whether they are overdue or current in that training. I have about 100
people with about 50 different training requirements that are recurring on
different timelines (ex: Mark Smith has to take CPR class every 20 months and
a driving course every 12 months). I'm trying to develop a function/format
combo that lets me type in the date they last had that training, paired with
the required frequency of the training, giving me a result of "CURRENT" or
"OVERDUE" and turning the...CreateDatabase / Access 2007
Question: Can Access 2007 be forced to create an Access 2000 database when
I have a "utility" database that I distribute in version 2000 to users which
is used to extract data from their main database (also version 2000) and
which then creates and dumps this data into a new database ("Homedata.mdb").
This new database can then be zipped up, emailed, and uploaded into our
The basic procedure is:
Data is extracted from the user's main database; placed in tables within the
"utility" database; "H...Stingray's MFC Objective Grid with Access 2K?
Has anyone had success using Stingray's Objective Grid v7.0 with the later
versions of DAO. I've seen the suggestions to add an entry to my source to
force MFC to use the later version. But, when I do this, I get a lot of
crashes after compiling. I wonder if there are any mods that must also be
made to the Stingray source?
...Keyboard hooking through Accessibility
I am looking for a method to hook the keyboard without running a
background process. I know there are APIs for hooking
(SetWindowsHookEx), but I want to avoid the overhead of running another
background process for this and make the task do by windows itself.
I am thinking of tweaking the Accessibility option in windows for this.
Can we anyway do this by writing any script or modifying or adding
registry entries for Accessibility? Or is there any Accessibility
specific APIs which can re-program the Accessibility feature to do our
tasks when we press a key with Accessibility feature-on.
An...how to improve shared mailbox access from branch office
Our organization has consolidated all mailboxes to centralize location. A
team of shared services specialist who often work on the shared mailbox
encounter performance issues when trying to access the shared mailbox due to
the shared mailbox are being accessed over the WAN in online mode. The shared
mailbox is attached as a secondary mailbox to their personal mailbox.
Personal mailbox does not have this issue due to all are configure to use
Exchange cache mode.
We have proposed to user Terminal server nearer to the centralize location
and Outlook Web Access but the team...unable to access mail after re-enable account
After enable an disable account and change its password,
it can login to its mail account. What's happening. Is it
Thanks a lot
What is the error message when user tries to access mailbox? Does the user
still show in ADUC has having Exchange attributes? Have you looked at the MB
using ESM to see if it is disconnected?
"Raymond" <firstname.lastname@example.org> wrote in message
> After enable an disable account and change its password,
> it can login to its mail account. What's hap...Formatting
I've always used MS Word as my email editor in Outlook. Is this possible in
Nope. I'm afraid that's only possible using Outlook.
In WLM you have to use the built in editor. Is there anything in particular
that's lacking from the built in editor that you're looking for?
"jrchambe" <email@example.com> wrote in message
> I've always used MS Word as my email editor in Outlook. Is this possible
> Live Mail.
In a Column 'A' sales Commission is calculated and resulta
is as 250, 200, 300, 330.
I wanted to format a cell with a Blinking colours where
value is 100 to 250, 250 to 300, 300 to 350 and 350 &
please help to format my sheet ... thanks
Getting your cells to "blink" is not in the standard Excel formats
What you want would require some extensive programming, certainly, ou
of my capabilities.
However, there are some great things you can do with Excel'
Let's say in column A you have numbers that are the result of formu...Pivot Table formatting #6
When I format my pivot tables I have "preserve formatting"
checked under "PivotTable Options", and "Autoformat Table"
unchecked. Even so, I either lose portions of my
formatting, or different formatting is applied when I
refresh. Does anyone know what I am doing incorrectly or
have any other suggestions?
Other things to try -- if they don't work, you could record a macro as
you refresh and reformat the pivot table. Then, run that when you want
--Instead of selecting the cells to format the numbers, right-click the
field but...how to turn off automatic format in Excel?
Excel automatically change the first character in a cell to be
uppercase. I just want lowercase. How can I turn off this function?
Go to Tools / Autocorrect and uncheck Capitalize first letter of sentence.
"ngoc" <firstname.lastname@example.org> wrote in message
> Excel automatically change the first character in a cell to be
> uppercase. I just want lowercase. How can I turn off this function?
...Date Format turn to Year
I tried to convert the date to YEAR and then the year plus 25 Years
=Year(A1) I'm getting the result 1900 instead of 1965.
I tried to add 25 years later to 1990 from 1965.
Your help would be much apprecated.
What's in A1?
Are you sure it's a real date?
> I tried to convert the date to YEAR and then the year plus 25 Years
> =Year(A1) I'm getting the result 1900 instead of 1965.
> I tried to add 25 years later to 1990 from 1965.
> Your ...Problem access variable in On Format
I'm using Access via Office XP Pro.
I am trying to format the Zip Code on the detail line of my report.
I have tried the following lines of code in both the On Format event and the
On Print event:
If len([PostalCode]) > 5 Then
if len(Me.PostalCode) > 5 Then
In both events and either code, I receive the error message:
Access can't find the field 'PostalCode' referred to in your expression.
If I put "PostalCode" as the source of the report's control...Background changes conditionally
I have a spreadsheet that shows the floor plan layout of my call
On each desk, the desk number and identity are displayed. I would like
to colour the background for those pcs that are on the same subnet.
I have a sheet called data - it contains Table Number, Desk Number, PC
ID, IP Address.
How could I get it to change the background colour if the pc is on
subnet 162, and set a different colour for those on subnet 167
PeterG's Profile: http://www.excelforum.com/member.p...Running an Excel Macro from an Access Command Button
Can anyone help me with this, I am trying to run an excel macro from an
access command button.
I want the macro to Bold the Headings on a excel spreadsheet.
The code runs without any errors but the macro doesnt seem to work, I think
I have got the line
ExcelApp.ExecuteExcel4Macro "RUN(""PERSONAL.XLS!BoldHead"")" wrong
Private Sub cmdRunMac_Click()
Dim ExcelApp As Excel.Application
Dim ExcelBook As Excel.Workbook
Set ExcelApp = Excel.Application
ExcelApp.Visible = True
Set ExcelBook = ExcelApp.Workbooks.Open("C:\Documents and
Settings\...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...Opening and formating a CSV file?
Could someone remind me how to handle CSV files please? I had assumed
the Text Import Wizard would pop-up when I use File|Open, but the data
goes straight into the worksheet. (Presumably because it is not
'delimited'?) Without the Wizard at my side, how do I get each
comma-separated field in its own column?
Terry, West Sussex, UK
Try renaming your .csv file to .txt
Terry Pinnell wrote:
> Could someone remind me how to handle CSV files please? I had assumed
> the Text Import Wizard would pop-up when I use File|Open, but the data
> goes straight into the worksheet...Formatting Cells in Excel 97
Sorry if I sound real stupid but is there anyway that we
can control the column formatting in Excel 97 like let's
say column A = GENERAL(6), column B = GENERAL(4), column C
= TEXT(18) etc?
Appreciate any form of advice, thanks!!
I replied in the programming group. Are you seeking a programming
answer? It's usually best to only post to one group, and include the
remark "Please tell me if I should ask this in another group."
On Thu, 28 Aug 2003 00:56:47 -0700, "Daryl" <email@example.com> wrote:
>Sorry if I sound real stupid b...