MAPISP32 has taken over - uses almost all of the CPU (97
to 99%). Can't send or receive email. Restarting and
not launching OUTLOOK gives me back my computer, but no
email. Using OUTLOOK 97 on an XP machine. Have checked
the postings, but found nothing about this problem (I get
no error messages). Also tried renaming MAPISP32.dll and
then reloading OUTLOOK, no improvement. Will check back
later and thanks!
...Beginning Inventory Balance #2
I am trying to duplicate the Average Inventory, according to KB856731, the
formula is; (Beginning Inventory Balance + Summary of each months ending on
hand Inventory + Current On Hand Inventory) / (number of months elapsed in
the current year +2)
Does anyone know what the formula is for the Beginning Inventory Balance?
...Macro Security #2
I am trying to set the Macro security level to Low in Access 2003 but cannot
find the option in the Tools\Macro menu. It is not even grayed out. The
install is a complete install of Office 2003 and I tried a Detect and Repair
without luck. Any suggestions? Thank you.
Maybe a post in one of the Access newsgroups would get you an answer quicker.
> I am trying to set the Macro security level to Low in Access 2003 but cannot
> find the option in the Tools\Macro menu. It is not even grayed out. The
> install is a complete install of Office 2003 ...learning access 01-31-08
Inform me a reliable interactive source to learn microsoft access
On Thu, 31 Jan 2008 13:58:36 +0530, "Manas Ranjan Nayak"
>Inform me a reliable interactive source to learn microsoft access
Here's some places to look:
Jeff Conrad's resources page:
The Access Web resources page:
A free tutorial written by Crystal (MS Access MVP):
MVP Allen Browne's tutorials:
http://allenbrowne.co...Spaces issue not fixed in 12.2
Operating System: Mac OS X 10.5 (Leopard)
The previous threads have all been closed and none of them seem to have an answer. For anyone else struggling with Office not working with Spaces (and therefore having to disable Spaces to use Office 2008), here is the reply I just received from MS Office for Mac Tech Support:
"The Spaces issue is still being worked on, please watch for future OS and Office updates"
My guess is that as it has not been fixed in two service packs it is unlikely to change until Office 2012 (or whatever the next major release wil...Outlook 2003, Relaying denied error, Windows XP
I seem to have a problem when Outlook 2003 is first opened that it will not allow an email with an attachment to be sent. A 'Relaying denied' error message comes up. If I send an email without attachment this works OK and triggers the Norton anit virus software to check email before sent. After this the problem seems to go away i.e. I can now send attachments.
Any ideas on why this error occurrs ? Is there a setup feature I've missed ?
Have you set up authentication to your outgoing server ("More Settings..."
on your account page, go to the "Outgoing Server&qu...storing multiple list selections in access
i have 2 tables, table a and table b. is it possibile for a control
bound to table a (a list box, with multiple selections eneabled) to be
able to select multiple records from table b, and store them?
i.e. table A record 1 has table B records 1,2,3,4,8,12, and so on
while Table A record 2 only has table B records 3, 8 and 15 selected,
and so on..
is there some way to store those selections within table A?
for those curious, i'm making a character sheet for an RPG.. table A
is the actual sheet, while B is the list of spells.. i'm looking for a
way to store which spells each ...Conditional Formatting #2
I have a spreadsheet that has about 1200 rows many of which need to have
conditional formatting. I had a template set of rows that I was transferring
the conditional formatting from and it worked for 20 or so rows. Then in
attempting to both copy/paste and drag formatting even further I noticed
that the conditional formatting was not being transfered to the target
cells. I have even tried doing one row of formatting at a time but it seems
like it will not allow any more conditional formatting. The spreadsheet is a
good size (about 2MB). I recieve no error messages about this. It simpl...Password on access
I'm working on a database that has a few tables that everyone can access. I
want to give permision to other people to see them but not to change any of
I have tried to make users and administrators but it seems to work in only
Does someone know how to do this?
Thank u very much!!!
On Tue, 18 Mar 2008 07:34:02 -0700, Yael <Yael@discussions.microsoft.com>
>I'm working on a database that has a few tables that everyone can access. I
>want to give permision to other people to see them but not to change any of
&...how do i turn on overtype in microsoft access
how do i turn on overtype in microsoft access
Press the 'Insert' key once.
Build a little, test a little.
"Mandolin Man" wrote:
> how do i turn on overtype in microsoft access
Push the Insert Key on your keyboard.
If you want to do it in code, the key constant is vbKeyInsert
Arvin Meyer, MCP, MVP
"Mandolin Man" <MandolinMan@discussions.microsoft.com> wrote in message
> how do i turn ...Printing 2 worksheets to a 2 sided document
Is there any way to print - front to back - 2 seperate worksheets?
Turn the paper over and print the second worksheet????
Maybe you can create a worksheet with a picture of both ranges on it:
Insert a new worksheet
Edit|copy the first range
shift-Edit|Paste Picture Link (on that new worksheet)
Back for the second range
and shift-edit|Paste picture link (right near your first pasted picture link).
(insert a nice page break, too)
And by pasting a link, you can change the original range and your picture will
update right away.
(Keep that worksheet as long as you want and print from there???)...Export #2
How to export only the perticular group users.
What sort of information do you need?
"Mohammed Mustafa" <email@example.com> wrote in message
> How to export only the perticular group users.
See "IMI GAL Exporter" - http://www.imibo.com/imidev/Exchange/imige.htm
"Mohammed Mustafa" <firstname.lastname@example.org> wrote in message
> How ...solver and macros #2
Before you use the solver within a macro, you must
establish a reference to the Solver add-in.
With a Visual Basic module active, click References on the
Tools menu, and then select the Solver.xla check box under
If Solver.xla doesn't appear under Available References,
click Browse and open Solver.xla in the \Office\Library
...Closing registers #2
1. Is there any way too remove the closing figure when the registers are
closed... I don't want my cashiers to see the closing amounts.
2. Can a group of registers be closed out on a selected machine, e.g Reg 1,
reg 2, reg 3, reg 4 are all closed on reg 1.
If you don't want cashiers to see closing amounts, lock them out of doing x/z
reports and viewing the journal - apply this setting in SO manager - database
- cashiers - properties of each cashier - uncheck these boxes. On question
2, out of the box, RMS does not allow that - each register has its own batch
that must ...SP3 Problem
Ever since I installed SP3 for Office XP, I have been
getting the following error - "A program is trying to
access email addresses you have stored in Outlook. Do you
want to allow this?"
I get this error only when I use Word as my email editor.
Hence what is happening is that Outlook thinks that Word
is a rogue program trying to send unauthorized emails.
My question is, is there a way to prevent this - a
whitelist of programs for example?
Disable the PDFMaker addin. (See
http://www.slipstick.com/outlook/ol2002sp3.htm#problems for details on how
to do this.)
"Aj...CRM v1.2 for MSDN?
We are a UNIVERSAL MSDN Subsciber which means we pay about $4000 a year to
get the entire Microsoft Library. I have not seen CRM 1.2 in any of the
updates which is very strange since I normally see them before any other
subscription. Did I miss an update? I also notice on the MSDN downloads
section they still only have v1.0 listed.
CRM 1.2 is only just shipping to partners etc. I would not expect it to
appear on MSDN for a couple of months
"MEI" <MEI@MEI.COM> wrote in message
> We are a UNIVERSAL MSDN Subsciber whic...hyperlinks #2
When I click on a hyperlink in outlook IE opens and stays
blank, but another window opens and asks me to Locate link
browser. I have been closing this window, but it reappears
on every link. ???????????????
It may help you
>When I click on a hyperlink in outlook IE opens and stays
>blank, but another window opens and asks me to Locate
>browser. I have been closing this window, but it
>on every link. ???????????????
...Freezing Panes #2
How can I freeze two different rows in a single sheet.
Pl don't multi-post. Check responses in .misc
Downloads:17,000, Files:358, Subscribers:55
"Naidu" <Naidu@discussions.microsoft.com> wrote in message
> How can I freeze two different rows in a single sheet.
...Deleting Mail #2
This problem seems to be random over our network. We are
running Windows Server 2000 with Outlook 2002. Some
users are getting a notification that they have mail and
when they check, there is nothing in their inbox. The
new mail has automatically gone to the deleted items
folder. It doesn't do it with all mail for that
particular user or do all the users on the network
experience this problem. There are no rules set up to do
this. Has anyone else have this problem.
If you have a suggestion please respond to my e-mail
I have Outlook 2002 on...Pay commissions to 2 salespersons
Is there a way to pay commissions to two different salespersons for one line
item? When I try to enter secont salesperson in "Sales Commissions Entry"
window I receive a message "The commission amount may not be greater the sale
amount distributed to this salesperson"
Commissions in GP are calculated a little differently than what we think
about. If I have two salespeople and I want to give each a 5% commission on
the sale, then I need to give each of them a 10% commission on 50% of the
"Pay commissions to 2 salespersons" wrote:
> Is th...Excel or Access?
I have server data that is about 200-300 rows/records and includes abou
25 columns/fields. Coworkers have suggested that this data shoul
reside in a database, such as Access, and then import/link to it fro
Excel for reporting purposes.
Does anyone have a recommendation/comment/suggestion on this? I a
comfortable using Excel as my "database" for this data that will no
grow much larger than it already is, and is easier for me to perfor
the reporting in Excel simply on another sheet.
Message posted from http://www.ExcelForum.com
Why fix what's not broken? ...Outlook accessing Eudora
This has happened before. There are 2 of us, one uses outlook and I use
Eudora...again Outlook is doing the default email client thing and accessing
my email to his account...GRRRR! Does anyone know how to stop this? There
are two sides of the computer using XP Pro...I simply do not understand why
they set outlook up like this?! Is it to keep us from using other non
...Automatic open locked excel file through access control
We know,Excel has prompt password
to open it files.
Is it possible to create a code that can
supplies the excel prompt password?.So that when we
open the excel file through our access control in a form,
the excel files can be opened automatically.But when the
excel files opened from its default icon,it will prompt a
On Jul 10, 8:43 pm, "shiro" <s...@play.com> wrote:
> We know,Excel has prompt password
> to open it files.
> Is it possible to create a code that can
> supplies the excel prompt password?.So that when we
> open the excel file throu...Time #2
I need to be able to click on a cell and have it be populated with the
current HH:MM:SS. I know ctrl+shift+; will do the job but I need it to be
even more simple than that for the end users.
Put this in the worksheet code module (right-click the worksheet tab and
choose View Code):
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Not Intersect(Target, .Cells) Is Nothing Then
.Value = Time
.NumberFormat = "HH:MM:SS"
How do I make a hyperlink without underline?
refer to http://www.publishermvps.com/Default.aspx?tabid=30
David Bartosik - MS MVP
for Publisher help:
enter to win Pub 2003:
"jo" <email@example.com> wrote in message
> How do I make a hyperlink without underline?