Where can I find an editable Contact Manager template for Access?
MS Access community,
I need to find a better solution to organizing a medical contacts list for
my non-profit naturopath referral list. I'm currently using Microsoft
Outlook and with over 9,000 contacts and counting, Outlook is starting to
show its weaknesses as a database app, not to mention performing search or
mining for a specific string is becoming virtually impossible. The DB engine
in Access is much more robust and I think its time to transition to something
more powerful than Outlook, thus my inquiry.
A best-case scenario would be some sort of ready-made relational Cont...Database in Excel
Would anyone be able to give a little advise?
I am trying to make a database in Excel, due to License restrictions (and
cost), Excel is the only program we have a site license for.
The database needs to be able to hold regions of data, which will show
contact details for each region. In each region it would show around 20
Technicians, 2 Supervisors, 1 Manager, a Field manager, and finally the Head
of Department. I would also like to make it possible that they just enter
the Region Code or Tech ID and it bring up the region they work in.
I know it sounds like a tall order but if so...when saving an excel spreadsheet
When saving an excel spreadsheet, I get a message saying that I will not be
able to reopn the file due to memory problems. But when I try and reopen it,
it works fine. What is causing this?
If not using now, try just saving as a "microsoft excel workbook .xls"
"AllisonStacey1984" <AllisonStacey1984@discussions.microsoft.com> wrote in
> When saving an excel spreadsheet, I get a message saying that I will not
> able to reopn the file due t...Cash vs accrual #2
how does one set up a business on a cash basis or accrual basis. "help"
doesn't seem to cover this though it does explain the difference between the
two, there seems to be no instructions as to how to set it up.
...Trendline vs. equation
I am plotting a series against the secondary axis (right
side of chart), with an included second order polynomial
trendline. Also, the following formula is calculates (I
thought) where the trendline intersects the "Y" secondary)
G series data is value
B series data is month/year
I should think both values equal; however, they do not
agree (for the month ending August 03):
Trendline $365,000 (at the trendline/axis intersect)
Is there a way to accurately calculate the actual value
where the trendline c...No Tree Structure in OL 2003 Folder List for Contacts
No Tree Structure in Folder List for Contacts
In the Outlook 2003 Folder List (left hand pane) I can set icons at
the bottom to quickly skip back & forth.
The only way to get a Tree Structure for Contacts is to Select the
Folders List Icon which shows all items, Emails, Contacts etc. in the
tree structure that I have set up just like Outlook 2000.
If I select the Mail Icon, I see my mail folders only as expected and
they are in the tree structure I have set up as expected.
If I select the Contacts Icon, I see only Contacts as expected HOWEVER
they are in one long list in no obvious ord...Can't use Contacts folder following move from XP to Windows 7
I purchased a new computer on Windows 7, installed Office 2003 and copied
across all the files including the .pst ones from my old computer which was
on XP. Outlook is working fine in every respect except when creating a new
message within Mail: it does not recognise the names from my Contacts folder
(error message "Microsoft Office Outlook does not recognize xxx" . If I open
the Contacts folder and select a contact, I can create "New Message to
"lynbristol" <email@example.com> wrote in message
news:309BEC36-C...inbox contents moved to contacts folder
I recently had a user of Microsoft Outlook 2003 report a strange
problem to me. She stated when she opened her inbox all the emails
were gone and upon investigation she found them all in her contacts
folder. Is this possible/ how can it happen and how do we get them
she probably accidently dragged them to the contacts folder. if they aren't
converted to contacts, drag them back.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/ou...Compare 2 spreadsheets dump differences into a new sheet.
I would like to have some idea of the VBA code to compare 2 spreadsheets
"old" and "new" and then dump the differences into a new sheet -may be named:
"changes"- created by the code.
If somebody can help me with this I'll be very grateful.
Thanks in advance and greetings.
Look for Compare.xla on this site
> Good afternoon
> I would like to have some idea of the VBA code to compare 2 spreadsheets
> "old" and "new" and then dump ...importing data into a contacts folder with a custom form
I created a new contacts folder and then created a custom form with the exact
fields I needed, rather than the default contact fields. I saved the form
with a name of 'customform' in my personal forms library and in the
properties of the contacts folder also specified that "When posting to this
folder, use 'customform' ". When I go to that folder and double-click to
create a new contact, the custom form appears just fine. However during the
import, when at the 'map custom fields' page, I am not seeing the fields that
I created in the custom form; I am o...Office 97 vs Windows XP
Will Office 97 function with WindowsXP without causing
Yes, Office 97 works fine with Windows XP.
Microsoft MVP - Excel
"Frank Miller" <firstname.lastname@example.org> wrote in message
> Will Office 97 function with WindowsXP without causing
More than 50% of my contacts do not have email addresses,
so it therefore clutters the Address book unnecessarily.
Is there anyway to allow the address book (the popup which
appears when clicking on "To:") to only show contacts that
have email addresses? I can use categories to assign
contacts as ValidEmailUser, but I can't seem to find a way
to force the address book popup form, to show based on a
That's odd. I have never seen the Outlook Address Book display Contacts
without electronic addresses. It simply won't do that. Do these Contacts
...Utility That Does Cell-By-Cell Comparison Of Two Spreadsheets?
.... and creates a report of differences...
Anybody know of such a thing?
Don't need anything sophisticated - just a simple-minded cell-by-cell comparison
of data values.
>Anybody know of such a thing?
Oops! Ill-considered post. Just Googled it (duhhhh...) and found a number of
Since you asked...
San Francisco, USA
"(PeteCresswell)" <x@y.Invalid> wrote in message
news:pnm1u19vu11tn6rt5mmite6gcglm3r3e8r@...How do you delete database macro?
I used the template wizard to create and populate a database
automagically. This process created a macro that is NOT visible in the
Tools/Macros window. I now want to dis-associate the template from the
database but cannot find a way to do so without re-creating the
Any help would be appreciated.
jamaz's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16636
View this thread: http://www.excelforum.com/showthread.php?threadid=320227
"jamaz" <jam...Exporting Contact Email Addresses
Email addresses in Outlook 2007 don't seem to export. Even when I map the
fields to make sure that email addresses are included, they don't export.
Everything else exports just fine. The column heading is exported but not
the information. Can someone help?
"Lerbi" <Lerbi@discussions.microsoft.com> wrote in message
> Email addresses in Outlook 2007 don't seem to export. Even when I map the
> fields to make sure that email addresses are included, they don't export.
> Everything...XL2003 won't print a col of my spreadsheet
I have a 2 column worksheet in Excel 2003 and one column has cells with large
amounts of text. The print area shows up in 'Page Break Preview' View but
not on print preview. I am using the "fit to 1 wide by 4 pages tall' in
'page setup' and have included the area in 'Print Area' . Thanks Bill
...Cashbook Bank Mgmt vs Bank Rec Module
Can someone tell me the advantages to each of these modules. They seem
similar but Cashbook seems to have more options and reports with your
checkbook balances. We were looking into purchasing the Bank Rec module when
I came across Cashbook Bank but I need some input on the advantages of each
module so I can see which is the better one for us.
Any input would be appreciated!!
cashbook works different from bank rec, say if you receive payment from
customer, you enter the transaction into cashbook post the transaction,
then you have to go to AR and post the cash receipt bat...outlook contacts
somehow I have changed a setting in my outlook contacts. As I pop from
contacts to e-mail to notes, etc. when I come back to contacts the first
record is no longer highlighted in blue so I cannot start typing for a
contact. I have to click on a record then start typing. Can you please
advise me on what I have changed and how to get back to how it was earlier in
the day? Thank you.
...create a spreadsheet from another app
I am creating Excel spreadsheets from our application. We start
Excel and then send DDE commands to it to create spreadsheets.
Is there a better way of doing this that is not so error prone ?
Excel seems to have DDE problems often and there seems to be some
mysterious re-entrency problems where both our application and
Excel will have be restarted in order to get the communication
On Jun 26, 1:43=A0am, Lynn McGuire <l...@winsim.com> wrote:
> I am creating Excel spreadsheets from our application. =A0We start
> Excel and t...Where did my contacts business cards disappear to?
Under the Current View heading when I checked Business cards I could see all
my contacts cards but today it only shows me two cards even when I click on
the alphabets on the side. How do I retrieve the business card function to
see all my contacts in that view?
So what you're saying is that all but 2 of your Contacts just disappeared
for no reason?
Tell us the rest of the story. There is some end user error involved here.
Are you viewing a folder other than the one that contains your Contacts? How
many Contact Folders are there in your Folder List view?
Ru...Populating appropirate account in look up box when selecting contact
I wonder anyone can point me in the right direction can help out there.
We have a CRM Case form where it has Customer lookup field (Regarding lookup
for Account/Contacts) and also Responsible contact lookup field (lookup for
What we want happen is as soon as Responsible contact is selected from a
lookup, automatic population of appropirate Account in Customer look up
We believe it should be possible because contacts in the system are already
linked to Account records
any help is much appreciated.
You will need to write a ...Upgrading 2000 std --> 2003 std sp2 when database full?
Any issues with that? I have a 2k std that has the 16gb limit full,
and i thought to do an in place upgrade to 2k3 std sp2, and set the
database size to 50gb or so. Any foreseeable problems with the fact
that the store is not mounted because of the limit? Anything else?
I have a win2000 sp4 server.
I thought i'd remove the M: drive beforehand as per
this necessary though, as exchange 2k3 (i think) removes the M:
drive automatically anyway?
On Tue, 20 Dec 2005 12:48:08 +0200, "Gripe" <nah@...Help with setting up spreadsheet and charts please
Hi, I would be extremely grateful for some help with my spreadsheet.
I have the following data which I need to use to produce charts for a
hospital report fairly urgently.
The rows are the names of patients. This could be up to 200 for each month,
but this varies from month to month. I will have each month on a different
Column F - Ward
Column G - Hospital
Column K - I have a number 1 in the row if the patient meets the criteria
I need to produce a chart(s) to show and compare the following:
How many patients from each ward met the criteria (as indicated by 1 in
column K) a...How can I display a value from a spreadsheet cell in a column in a document library?
I want to store expence sheets in a document library and be able to view the
total on each spreadsheet document in a column in the document library.
Does anyone know how to do this?
The suggestions in the following Sharepoint newsgroup thread may help you:
Roger Eriksen wrote:
> I want to store expence sheets in a document library and be able to view the
> total on each spreadsheet document in a column in the document library.
> Does anyone know how to do this?
&...Lost contact list 04-23-10
My Contact list disappeared a couple of days ago. I have no idea what could
have happened. One day it was available the next it is totally missing. Could
it be in the recycle bin? Is it kept online? It was fairly large and would be
difficult to rebuild with may broadcast lists. Any Ideas??????
If you have a Microsoft Live Id, you can have multiple contact lists.
When you start WLM you have the option of signing into a Live Id. Each
Live Id has its own contact list. And if you aren't signed in at all
you have still another contact list.
Look in the upper right hand corn...