Creating a new field based on conditions
I have a database that tracks insurance information for our various vendors.
Each insurance type has 2 fields - a requirement field (yes/no), and an
effective field (some show an expiration date, some are yes/no). I have
created a query that will return only the records for which insurance is
required but is expired/missing. My problem is that I want to create a new
field that is calculated based on the values in the other two fields in order
to make the resulting report more user-friendly.
For example, if GLRequired is True and GLExpiration is <Now(), I want the
new field to say...Having problem of Outlook not receiving new e-mails
I have been using Outlook for over 1 year with Comcast
Broadband. Suddenly last week, I received a message that
Outlook 2000 was experiencing a problem when receiving new
e-mails and was going to shut down. I re-opened Outlook
and it looked different and then it asked for me set up a
profile and I canceled it. But after that window coming up
a couple of times after it shut down, I decided to put in
a new name and then I could not get to my old e-mails and
it acted like a new set up. Then I really got frustrated.
I was eventaully able to get back to my old e-mails and
have been able t...MS Office 2008 home version with Pro for entourage
Hello and thanks for any help you can provide.
I have MS Office 2008 Home & Student edition. I want to install only
word, excel and powerpoint and then separately install Entourage 2008
Pro (as provided by my hosted exchange co.) in order to connect to my
exchange server. I have done this before and remember some convoluted
errors but it eventually worked. My latest attempt did not. Has there
been a change to prevent this from working?
...How to set Page Layout View as default when composing new eMail message?
I'm using Outlook 2003 (German) with MS Office Word as my E-Mail Editor.
When composing a new eMail message, default view is always "Normal". I would
like it to be "Page Layout" (or "Print Layout" in some Word version, I
I tried serveral things, from changing different templates (email.dot,
normal.dot, mail.oft) to changing the Form for messages. But I didn't find a
way to change the view here, because it's in Outlook style, not Word.
And I didn't find any setting in Word for it.
How can I change the default View?
And which templ...Office Assistants
I have a custom Office Assistant (like Rocky, Clipit, etc - you know, the
things everyone hates) that I'd like to use with my copy of Office X.
It's written in a Windows .acs file.
Is there any way to get it working in Office X, or am I just screwed?
In article <firstname.lastname@example.org>,
"Scott Ward" <email@example.com> wrote:
> I have a custom Office Assistant (like Rocky, Clipit, etc - you know, the
> things everyone hates) that I'd like to use with my copy of Office X.
> It's written in...upgrades
I own 4 gateway PC's with Windows 95. I would like to get
a few more years out of them. What is the least expensive
way to upgrade?
I would buy a 5-user Microsoft Open License to bring the cost down. You can
buy that from resellers such as CDW.
"Jim Weber" <firstname.lastname@example.org> wrote in message
> I own 4 gateway PC's with Windows 95. I would like to get
> a few more years out of them. What is the least expensive
> way to upgrade?
> Thank you.
...Exchange 5.5 to 2003 upgrade issue 3
We have upgraded our Exchange 5.5 server to 2003 and moved all the mailboxes
and moved and re-homed the folders following the KB articles.
We turned off the 5.5 services and for a week everything was working fine.
Now for some reason the messages to the main distribution list is being sent
to the old 5.5 server on a x400 protocol.
How can I stop this and assure that the 2003 server is self contained so I
can get rid of this server?
I'm going to do a major upgrade (Processor, Vid Card, RAM) along with an initial install of XP where a Linux distro now resides. Could someone provide a link giving me the process I should follow to successfully complete the upgrade ??
--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-
On 06/20/2010 04:52 AM, Dilly Dally wrote:
> I'm going to do a major upgrade (Processor, Vid Card, RAM) along with an initial install of XP where a Linux distro now resid...Add new record through Form view
I have a table which is linked to a form, i would like to have a command
button which will add a new record to my table.
On the click of command button it should view the last empty row of my table
in a form.
On Sat, 26 Dec 2009 11:11:01 -0800, Ranjith Kurian
>I have a table which is linked to a form, i would like to have a command
>button which will add a new record to my table.
>On the click of command button it should view the last empty row of my table
>in a form.
The Click event should show [Event Proced...Business contact manager install failure
Office 2007 BCM gives me this error when I try and install it:
Setup cant finish because it can't delete:
c:\Program Files (x86)\Microsoft SQL
...Office 2004 issue with documents NOT BEING ABLE TO OPEN APPLICATION, but application can open documents.
Just migrated all my files and apps from a G4-400 to a new Mac Mini
1.87ghz Intel running pre-installed OSX10.4.10.
Used CD to install 'normal' version of Office 2004 Mac on the new Mac
Mini. In fact its the same disk that I used originally to install Office
on the G4-400.
Neither old .xls and .doc documents (made on old Mac, nor new .xls and
..doc documents (made on new Mac)will not open their respective
applications, when clicked upon.
However, when I use either of the the application's "Open" feature,
theres is no pr...error on install to pocket pc
"window\mny2day.dll" is in use or is in ROM. IFthe file
is not in ROM, please close the application using the
file. I do not understand what file could be using the
same application or how to check the ROM.
...Can't upgrade companies to SP4
R [Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error: Column name or
number of supplied values does not match table definition.I had a base
installation of GP 9.0, no patches. Decided to download SP4 and install.
Install of the MSI went fine and upgrading the master databases worked, but
going company by company, I get the following error:
The following SQL statement produced an error:
CREATE Procedure SVC_POP_Make_PO( @PromisedDate datetime, @OrderedBy
char(15), @BatchNum char(15), @ItemNumber char(30), @VendorItemNumber
char(30), @LocationCode char(10), @Uo...DPM and VMM on same server using side-by-side SQL installation
Windows 2008 Std R2 Server, 64bit
VMM 2007 is currently installed (with the built-in default database) SQL
2005 Express Edition, SP3, 32bit.
I was advised by Microsoft that both VMM and DPM could be installed on the
same server (small DR environment)
The VMs are hosted on a Windows 2008 Enterprise Server w/ VS2005R2 - because
the hardware didn't support HyperV.
VMM works great to manage the Windows 2008 VS2005R2 Host running Win2K3
server instances ... after lots of trial and error.
Now, I need to install DPM 2007 onto the same server... DPM wants to install
the 64bit vers...Install 2003 after 2007?
I had Office 2003 and upgraded to 2007, other than Outlook I didn't like it.
I wanted to reinstall 2003 Excel & Word. Per instructions here I
uninstalled 2007 except Outlook and upon attempting to reinstall 2003 I get
the error message, "Business Contact Manager requires Outlook 2003, please
install Outlook 2003 before running setup". Help please.
Thanks in advance... Bob
Answered in the other group post
"Bob Newman" <email@example.com> wrote in message
>I had Office 2003 and upgraded to 2007, other tha...Only new email window?
Is there a way that I could have a shortcut on my desktop that does not open
the whole application, but rather ONLY open my new email window? I send out
a lot of email, and I also have a lot of other apps running.
Please let me know if that is possible. Thank you,
Steve F. <firstname.lastname@example.org> wrote:
> Is there a way that I could have a shortcut on my desktop that does
> not open the whole application, but rather ONLY open my new email
> window? I send out a lot of email, and I also have a lot of other
> apps running.
Create a shortcut whose target is:
"%Pr...Won't save office applications, appcrash
Help I cant save documents , excel etc in office 2007 on vista laptop. I have
tried open office but this suffers the same problem. Also tried uninstalling
and reinstalling office but no change.
see below for word report, in excel the fault module was given as PROPSYS.dll
Problem Event Name: APPCRASH
Application Name: WINWORD.EXE
Application Version: 12.0.4518.1014
Application Timestamp: 45428028
Fault Module Name: unknown
Fault Module Version: 0.0.0.0
Fault Module Timestamp: 00000000
Exception Code: c0000005
Exception Offset: 00000001
...Newbie needs help with new Exchange 2003 installation
I am TOTALLY new to Exchange. We just installed Exchange Server 2003
on a Windows 2003 domain.
I have one (test) account set up and it appears to work OK but I keep
getting an error message that says "Task "Microsoft Exchange Server"
reported error (0x8004010F): 'The operation failed. An object could
not be found.'
I know, I know...How could I possibly not understand THIS message?
I appear to be getting mail but I' can't be sure. How can I check to
see what's causing this (and more important...what object it's looking
Thanks for any help!
...MS Office Excel97: Removing Page Breaks
How do I remove page breaks? For some unknown reason they started appearing on a
spreadsheet recently. I see dotted lines dividing up the sheet and large "Page
...." in the background. According to an Office 97 book I have, I should go to
Tools->Options->View-tab and set the Page Break option off. There isn't any. If
I right click outside the page area, I see PG menu items but none seem to work.
There's also a PB View in the View menu, but clicking on it doesn't seem to do
Wayne T. Watson (Watson Adventures, Prop., Nevada Cit...Does upgrade to 2004 replace X?
Does an Office upgrade to 2004 from v.X replace v.X or would I have two
different versions of Office installed? Does the Remove Office program that
comes with 2004 remove v.X as well? I no longer have the CD for X so I'm
afraid I'll be wasting tons of space if I can't fully remove version X.
Sent using the Microsoft Entourage 2004 for Mac Test Drive.
In article <BD7F1503.email@example.com>,
"Armando A. Valdes Prieto" <firstname.lastname@example.org> wrote:
> Does an Office upgrade to 2004 from v.X replace v.X or would I have two
> different ...Help
I tried to work on Word today for first time on newish Mac and
realized none of my Office applications work.
When I double click on Word I can see something happening as I get the
circle of colours twirling, but half an hour later it still hadn't
opened. I just have to do this as quickly as possible as I have a
deadline for what I have to do Monday at 12.
I've tried reinstalling the software, but that didn't do anything for
me. Mind you I know absolutely nothing about installing anything on
Mac computers so I could be doing it all wrong.
Do any of you have any idea what c...Cursor on new message window but no text appears when typed?
When using Outlook 2003 for sending new e-mail, I'm unable to type text into
the message body. The cursor appears but no text shows. Text appears when I
use Word 2003 to send my new e-mail message. It is more convenient for me to
...How do I recover lost contacts etc after having to re-install?
I was instructed to reinstall Oulook and have now lost all my contacts
calander reminders etc.
Can anyone advise how I can recover these?
Reinstalling never loses data. Just find your previous data file (a hidden
file with a *.pst extension) and open it in Outlook.
For future reference, you should always know where your data file is and
back it up. Basic common sense with computers: back up your data or be
willing to lose it.
"Julz" <Julz@discussions.microsoft.com> wrote in message
...How do I set my office hours.
I work different hours than others in my department. They are always
scheduling meetings when I am not at work. Also there have been several new
members added to the team in another state that do not know my schedule.
How do I indicate in my calendar what my office hours are?
Ben Woodford <Ben Woodford@discussions.microsoft.com> wrote:
> How do I indicate in my calendar what my office hours are?
Tools>Options>Calendar Options. However, I don't think that will affect
what others view when they schedule a meeting with you. If you're using
Exchange, enable the Out...Outlook Cannot Run Add-In...Windows Installer Error 1605
I'm getting the follwing error message when I try use and
setup my new Office Outlook 2003 (SBE with contact
manager) for the first time: "Microsoft Outlook Cannot Run
the Add-In ... Windows Installer Error 1605"
I've found this article on the Microsoft Knowledge Base,
but it addresses only Outlook 2002:
OL2002: Error Message: Microsoft Outlook Cannot Run the
Add-In ... Windows Installer Error 1605
Does anyone know of a solution that will fix this problem
in Outlook 2003 or does the above article for 2002 also
apply for Outlook 2003? Thanks.