Import Excel 97 into Outlook 98
My company uses ACT & I use Outlook 98.
I had my company export a new database from ACT to Excel
so that I could import Excel to Outlook.
I am unable to do anymore than export the Company name and
I cannot get it to bring along the other vital information
such as address, phone, fax, e-mail.
I have tried importing the Excel file as an excel file...
I have also tried saving the excel file as a .csv
What do I need to do to "Name the range of data that I
need to import" ??
Thank You for your help....
...Help with conditional formatting with 2000
Any help would be greatly appreciated.
I am trying to group data together into increments of 10% of th
numbers and then chart them based on these groups. For example, I hav
300 data points that vary from 20 to 500 in value. I want them t
appear in a chart based on the number of values that fall in the lowes
10% of numbers (ie. 20-40) then the next 10% (ie. 40-60) etc. up to th
top 10% of numbers, but I do not want to manually determine what thes
ranges are. I want to see a distribution of how many numbers fal
within each 10% of values.
I am not sure if this makes sense, please let me know...access 2003 (sp3) The program stops responding
When I change something i a form (design view) ,the program stops responding
for while. Not used network connection are disconnected.
Hodde <Hodde@discussions.microsoft.com> wrote:
>When I change something i a form (design view) ,the program stops responding
>for while. Not used network connection are disconnected.
Check your table links. You might have some tables pointing to a
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://ms...How OMPM Scanner (offscan) Filter by Access/Modified Date ?
I have problem to inventory excel files on very big file server, but I
believe there are so many documents we no longer need to maintain.
I want to skip files if the access date or modified date longer than 6
month, but don't see the OMPM providing feature about it.
I currently running OMPM since 2 weeks ago and running out of time for
reporting to my manager.
Please help me, this is my critical assignment.
...Permission probs w/Split database for Access97 & Access2003 Multi-
I've successfully split an Access 97 database and set up an identical front
end in Access2003. I've verified multiple times that my user group
permissions are defined identically for the tables in the back end as well as
the tables and all other objects in both versions (97 & 2003) of the front
end. However, with the Accesss 2003 front end, I've determined that users in
Groups with no Administrator nor "Modify design" rights to any database
objects can if fact change object permissions. I don't have the problem with
the Access97 front end nor the back end...comdlg32.ocx and Access 2007
I have several Access databases that were originally written using an Access
version prior to Access 2007. I am in the process of converting the
databases and installing them on new machines running Win7 and Access 2007.
Over the years, one of the References I commonly used was comdlg32.ocx. It
does not appear that either Win7 or Access 2007 installs that particular
Active X file. I can copy it from an older machine, but that seems like a
Is comdlg32.ocx a "legacy" Active X file and has it been replaced with a
newer (and differently named) Activ...Exchange 2003 SP1 to get DST patch & Exchange 2000 patch is available to anyone for $4,000
This is a multi-part message in MIME format.
In the "New Highlights" section: "Exchange Server 2003 SP1 will now be =
supported for an updated version of the Exchange CDO patch to be =
"DST Hotfixes for products in Extended Support can now be purchased for =
...Error 2455 Closing Access 2007 database with form open
I have a form with a subform that is requeried when you select a new key for
the main form from a combo box.
Everything works fine - usually. But sometimes if you have the form open
when you close the database down you get the following error message (twice)
in a pop up. You say OK (twice) and the database closes OK
"2455 you entered an expression that has an invalid reference to the
If I close the form before the database I never get the error.
If I do not touch the form before you close the database I don't get the
If I update a field by t...Inserting Excel into Access Reports
Have a great Access application that produces a nice template (headers &
footers) report into which I'd like a spreadsheet inserted before going to
the printer. In the past, I'd just print the Access reports, then reload
them into the inkjet printer and run the Excel spreadsheets as needed. The
heat of the new color laserjet turns the paper grey if it runs through too
often, so it's time to get the reports printing on one pass.
Any suggestions would be welcome. I've of course also got Word XP, MS
Publisher XP, as well as Adobe Acrobat, if anyone thinks it m...Simple Access counting queries
Hi, hoping someone can help a relative newbie with a pretty simple
query. My database (Access 2007) has three tables:
Purchases (many-to-one links to both of the other tables, this is
basically a linking table)
I have two simple queries I'd like to get out of this database, but
I'm a bit stuck on how to construct the SQL. Any direction you can
give me would be helpful.
1. List of all customers who have purchased 2 or more products (or 3
or more products, or 4+, etc.)
2. List of all customers who have purchased both Product A and Product
B (or A, B, and C, or B an...Converting Money 2000 Canadian to Money 2006 Canadian
Can anyone confirm that such a conversion is possible? I was hoping to
convert to Money 2007 but was unsuccessful. I'll live with Money 2006
Canadian but I want to ensure the conversion is possible first. I don't want
to drop the money on it to find out it doesn't work.
Thanks in advance,
In microsoft.public.money, smurfgun wrote:
>Can anyone confirm that such a conversion is possible? I was hoping to
>convert to Money 2007 but was unsuccessful. I'll live with Money 2006
>Canadian but I want to ensure the conversion is possible first. I don'...Expression Too Complex in Access 2000
Consider the following query:
SELECT crTbl.acct_1, crTbl.amount, crTbl.date
WHERE (((crTbl.acct_1)="Supplies") AND ((crTbl.date) Between
The query works fine on my own computer in Access 2002.
When converted to Access 2000 and used on an other computer,
I get the following error:
"This expression is typed incorrectly or is too complex to be evaluated.
Try simplifying the expression by assigning parts of the expression to
The problem is with the "Between...Don't want to automatically open email Outlook 2000
I have recently started using Outlook 2000 instead of
Outlook Express. In Express - I was able to preview
messages without actually opening the file. In OL2000,
the file automatically opens up... is there any way of
...How to get only the year in the date format in Access
How to get only the year in the date format
I.e in the table in need to display only year
E.g 2005 - should be display " 05" automatically
Custom format the cell as:
Please keep all correspondence within the NewsGroup, so all may benefit !
"yanu" <email@example.com> wrote in message
> How to get only the year in the date form...groups detail section totals access 2003
I know this can be done, but haven't figured out how yet. I have what
basically is a summary report that my sql comes up with for the detail
rows. I want to total these rows in the report and display
immediately below the detail section. I don't really want to group
anything, but want to treat the whole detail section as a group.
That being said, how can I get a "group footer" on the designer so I
can add my total columns. If I use "sorting and grouping", it starts
grouping things and that is not what I want.
I don't want to use the "page foo...Language Support for all Office 2000 programs
Maybe I'm not looking in the right places, but I'm not finding any language
support downloads for Office 2000. Does anyone have a specific link to send
me to, so that I can do this? I have important documents that I have to
print, but I recently got a new PC with 64-bit Vista. I loaded my 200 Office
Suite on the PC, but it no longer is supporting the foreign language that I
have throughout my documents. I just get block shapes instead. I need help.
Deploying Office 2000 with Additional Language Resources
http://office.microsoft.com/en-us/ork2000/HA011383...Outlook 2000 #196
I have several computers with Outlook 2000 on them. When
they try to exit outlook, outlook just hangs there and
will not exit. Anyone have any suggestions on fixing
Cindy <firstname.lastname@example.org> wrote:
> I have several computers with Outlook 2000 on them. When
> they try to exit outlook, outlook just hangs there and
> will not exit. Anyone have any suggestions on fixing
> this. Thanks
See if something here helps:
...re install Pub 2000 problem.
Hello and I hope I'm In the right newsgroup. My problem is I've had to
re install my Office 2000 Disc2 and now when I want to start publisher
the message box tells me I am trying to access a program that needs the
cd. When I installed it, I checked for Publiher to "run all from my
computer" I've un installed and re installed, still need disc. what am
I doing wrong? Thanks for your help, John :)
> Hello and I hope I'm In the right newsgroup. My problem is I've had to
> re install my Office 2000 Disc2 and now when I want to start publis...Remote access to another company's Outlook calendar?
I have one client on Exchange 2003 that wants to access the calendar of an
employee (consultant?) at another company running Exchange (version not
known yet). How can the remote company share this person's calendar with my
client? He would need to access it and add appointments to it.
Thank you for the help!
On Mon, 30 Aug 2004 22:15:24 -0700, "Gregg Hill" <email@example.com>
>I have one client on Exchange 2003 that wants to access the calendar of an
>employee (consultant?) at another company running Exchange (version no...Can't connect to Exchange server after VPN access
I can connect to my office Exchange server when in the office (LAN) but I
cannot connect outside with Outlook.
I can only use the webmail after entering a web VPN access:
- First portal for VPN : https://xxx.yyy.com --> I enter my
- On the next web page, I have the choice for the webmail and it's a link as
https://xxx.yyy.com/go/webmail.yyy.com~ssl where I can enter my
So I can't enter the url in RPC as every slash is forbidden
In my Outlook, the Exchange server (EXC.yyy.com) is not reachable by ping
(or tracert) and I can't ...Access 2007 12-17-09
I am building a contact data base for my church. How do I get the phone field
to automatically format like this (xxx) xxx-xxxx when the numbers are typed
in the cell?
In the form design view select the phone control and open the properties
dialog. Goto the Data tab and use the Input Mask to define the format you
wish to use. If you click on the ... to the right hand side on the property
you will get another dialog where there are predefined input mask or you can
define your own.
For instance, I use
to format my telepho...Outlook 2000 will shut down on its own.
Outlook 2000 will shut down after a few minutes of
inactivity. It does not give any error and the program
works fine. It just shuts down.
...Can Entourage be used to access Google Groups
I am in the process of switching from PC to Mac. In Entourage, I see this
news server. Can I get some of my newsgroups in Google Groups to show on
Entourage or Mac Mail?
Responses off group will be welcome if I have asked something everyone
except me knows.
On 1/31/10 3:25 PM, Michael Plog wrote:
> I am in the process of switching from PC to Mac. In Entourage, I see this
> news server. Can I get some of my newsgroups in Google Groups to show on
> Entourage or Mac Mail?
> Responses off group will be welcome if I have asked something e...Publish A Workbook Onto The Web, Then Access Using My Web Browser.
How do I access my spreadsheet, or workbook, on the web once I've saved it as
a webpage from the file menu? I've found that even though I've save my
workbook as a webpage, it does not have an http:// address which I can type
in my web browser to access the workbook from my home computer or from a
Should I have to sign up with an http:// service provider or can this all be
done from using Microsoft Office XP without going through a third-party?
You have to have a website first of all, otherwise, where do you want to host
"sigmad&q...Excel 2000 crashes Win98 when I save. All reloads failed.
I'm running Office 2000 and Windows 98. Excel crashes badly when I save.
Two Ctrl-Alt-Deletes get me as far as "exit excel" but that doesn't work. I
always have to reboot.
I have reloaded Windows 98 twice. I have removed Office 2000 completely and
then reloaded it, again twice.
I don't have antivirus software on this machine. Other machines with
antivirus aren't detecting any virus activity on my zip disk files. I at
least have a router and I don't use MS Outlook, which cuts down on viral
attacks. Yahoo mail screens incoming email files.
Is there s...