New Db For Contacts And Invices

Jan 13, 2007

Hi, I’m new to access and I have read through a couple of books but still struggling.


If I make a tables with my info in it say customer details, use quires to sort display and print that info. Now is that query saved and do I end up with lots of query’s (hundreds.) Or
I’m assuming that that query is then lost (don’t know the correct term) and the only way of getting this info back is make a query asking for the same info criteria.


I’m thinking of an invoice made up of info from a contact table
My invoices are very simple I only supply labor and materials and don’t have set prices for ether, so I need to insert prices that I input and text that I input Both will be manually inputted although some sort of auto text that can be edited to make each invice individual would be nice

Hope this makes some sort of sense, can any one point me to some key areas that I can read up on

thanks

View Replies


ADVERTISEMENT

Retrieve Specific Contacts

Aug 10, 2006

Hey Everybody,

I have 2 tables, one called [Addresses] and the other called [2006_Contacts]. The table [Addresses] has a number of various fields relating to contact data of people. The [2006_Contact] table has 2 fields [Last Name] and [First Name]. I want to run a query that pulls the contact data from the main [Addresses] table, but only if the contact name ([First Name] and [Last Name]) are present in the table [2006_Contacts].

Does anyone have any suggestions?

Thanks,
Chris C.

View 4 Replies View Related

Changing Email Contacts

Jun 2, 2006

I have a form that I am in the midst of creating.
On this Form there are several football club names (e.g. A1, B2, C3 etc.).
These buttons contain the Team List for the club. I have set a macro up to email the list to the relevant contacts for each Club.
But if some club changes the contact person, is there some way I can have the macro open in design mode on the form so that the end user (who may not be familiar with Access) can just change the email address. Or does this involve code, which I am not great with, but am trying to learn.
Any help is greatly appreciated.

View 1 Replies View Related

Importing Outlook Contacts To Database

Jun 24, 2005

I created this database long time ago, but now my boss wants to import the contacts list from outlook into the database. Now, these lists will differ per user. Right now there are 6 users, who are using the database and they all will have different contacts lists. How can I import it in a manner, when they login the outlook will will search for their contacts only and let them make changes.

I want to create a form and this form will already be filled with the contact info from the outlook, and half of the form is for the user's comments so they can circulate the information through a report to different people.

I hope I was able to send my msg across. I am pretty bad at explaining stuff.

Thank you in adv.

View 1 Replies View Related

I Modified The Contacts Management Template

Sep 14, 2005

and it works mainly except for two problems:
(1) I renamed all the forms on the Database main window. But when I open the forms, on the top blue bar, it still reads the old names. How do I change that to new names?

(2) I've changed the "Calls" table and forms to "Actions." I've renamed the "Calls" button on the main "Contacts" form which is now "Projects." The old key field "ContactID" is now "ProjectID."
When I click on the "Calls" button to go to the "Calls" form/subforms, box says "cannot find field "ContactID" referred to in your expression.
How do I fix it so that it recognises the new key "ProjectID"? They are linked correctly on relationship--or at least they're linked exactly the way it was linked in the template.

HELP!

THANKS!!!

--Joy

View 2 Replies View Related

Assigning Check Boxes To Contacts

May 8, 2006

Hi there, I am pretty much a newbie on Access. (yay). Now I am doing a simple contacts database and need to assign whether specific contacts wand information being sent to them. Now I have all the other fields required. But the check boxes that I have put on the form are not changing according to the contact. (as in if the check box is ticked, it is ticked for all of them):( :confused:

How do I go about assiging it specifically to that contact? - If I am making sense. Any hints/tips would be greatly appreciated:)

View 1 Replies View Related

Import Additional Columns From Contacts

Feb 3, 2015

I am using Access 2010 on a Windows 7-64bit machine. I am trying to begin an employee database using the faculty template. It would be exceptionally useful if the "Add from Outlook" command that is built into the "Faculty list" form would fill more than just the name, email address, and phone number fields. There are fields on the form for Department which match available info from the Outlook address book, but isn't imported.How can I tweak the command to fill the additional fields?

View 1 Replies View Related

Link Table To Outlook Contacts Problem!

Dec 19, 2006

my custom have a big table in the outlook, in the contacts.

in the outlook table that possible to insert also the birthday.

my custom want to send mail day-before the birthday to wish.

I want to do it with access, to link the table to the contcts and send mail if the birthday is tomorrow.

but when I try to connect to the contacts in the outlook, i get the fileds:
first name
last name
email
....
but no the birthday and the anniversary
(the table design attach)

how can I use this filed in access?

View 1 Replies View Related

Contacts DB - Single Organisation, Multiple Addresses

May 9, 2005

Hi.
Im a beginner-intermediate access user (I guess) and I am working on a stakeholder management database, which essentially enables me to separate organisations, individuals, the affiliation between the two, and addresses of either individual or organisation. (pic of relationships included).

Originally, I stored address values on each respective table (ie. org address was on the org table, individual address on the individual table). However then it became apparent that one organisation (in my line of business) can have many address sites, therefore the need to nominate multiple addresses.

So I figured that the best method would be to have an address repository, and orgs or individuals are assigned to that address via a MultiAddress table. The preferred postal address would be nominated by an address preferred field in another junction table.

Seems to work ok through the form (see form pic attached), but Im concerned that when I try to run queries/reports that I'll get duplications or other anomalies.

Can anyone provide me with some tips or advice???

Cheers

View 2 Replies View Related

Table Design For Simple CONTACTS Database

Aug 20, 2005

Hello All,
At work we have a large and messy Contacts list so I decided to set one up using a database.
At present I have 3 tables:-
Companies (custID,companyname,address,etc)
People (nameID,firstname,middlename,lastname,custID)
Phones (phoneID,phonetype,areacode,number,?????)

My problem is this, Some of the phone nos belong to the individuals
and some belong to the company. If a person is replaced at a company I need to reasign the company phone nos to the new person whilst retaining the individuals and their personal phone nos. If a company is deleted I need to delete only the company phone nos. and if a person moves within the company I want the company nos to reasign to the new replacement but keep the personal nos of the individual. Now I see its going to be more complex than I thought.

Can anyone help me with the table layout and links. (nb this is only a simple database relating a person to a company without using departments etc.)
Its main use is to provide phone nos names and addresses quickly.
Many Thanks
Peter

View 4 Replies View Related

Updating Address Fields On A Contacts Form

Feb 8, 2005

I am bulding a contacts DB for work and am a bit of a newbie with Access.
I have a table for Individuals and a table for Organisations. Both have address fields.
On the individual's form there is a drop down for Organisation, which is linked to the organisations table (fk). The form has a sub-form which displays work address. I want the work address field to update to the Address field in the Organisations table when an organisation is selected on the drop down.
I am using Acess 2003.
Could somebody point me in the right direction please?

View 2 Replies View Related

General :: Creating A Database Full Of Contacts

Jan 2, 2014

I'm creating a database full of contacts. I have a contacts table with detailed info on each contact and I also have a company table with details on each company - all companies attached to a contact are in the company table plus a few others. I'd like to be able to pull up a company profile and see all the contacts we have associated with that company displayed in a list.

View 1 Replies View Related

Search Corporate Email Contacts But Do Not Import

Apr 8, 2013

I work for a large company, whose contact directory in outlook is enourmous (thousands of employees). Outlook currently manages its contact directory very efficiently. its very easy to search and email individuals. In my access database I would like to be able to have that same functionality. To pull contacts from outlook via a search, without actually importing outlook contacts.

I am designing a database for asset tracking of Lab equipment. Lab equipment gets borrowed or relocated frequently and I would like to assign a name/phone/email quickly and without error, when I need to input a record of equipment movement.

View 1 Replies View Related

COMBO Box Selection Filters Out A List Of Contacts?

Jun 30, 2015

I'm trying to set up my own form for my customer contacts.

I have TABLE A that lists general customer information.

I have TABLE B that lists customer branches (each customer has multiple branches).

I have a combo list set up so that if I select a customer name, the rest of the form populates with the customer general information.

Is there any way I can filter out a list depending on what customer is selected?

I only want to see the branches of the customer I've selected on the COMBO box.

View 2 Replies View Related

Pulling Contacts From Two Tables Into Third Contact Table

Apr 29, 2014

Ok, I have 3 tables. One lists a contact in conjunction with the branch of the company and the trips that contact takes. The second lists a contact in conjunction with the branch of the company and which team they work with (may work with many). The third should list their email address and their phone number. Is it possible to pull the contact name and branch of company from tables 1 and 2 into 3 automatically, such that all I have to input into table 3 is additional contact information? If that is possible, is it also possible to only pull each contact/branch of company pairing once (I don't want four entries for Joe Shmoe/Sales, even if he's taken 4 trips)?

Table 1
Branch of Company
Trip Dates
Trip Location
Contact

Sales
4/1/14-4/12/14
Chicago
Joe Shmoe

HR
6/2/13-6/4/13
New York
Jane Doe

Table 2
Branch of Company
Company Team
Contact

Sales
Blue Devils
John Deere

Sales
Jets
John Deere

Sales
Jets
Joe Shmoe

HR
Sharks
Jane Doe

Table 3Contact
Branch of Company
Email
Phone

Jane Doe
HR
jane.doe@company.com
800-555-1234

Joe Shmoe
Sales
joe.shmoe@company.com
800-555-1235

John Deere
Sales
john.deere@company.com
800-555-1236

View 4 Replies View Related

Problem In Combining 'Event Management' & 'Contacts' Templates

May 21, 2005

I'm using Access 97 and have merged the 'Event Managment' & 'Contact' templates. I thought that I would need to make 'Contacts' and 'Attendees' as the same table.

My knowledge is limited and attempts to change to 'AttendeeID' means I lose the ability to log 'Calls' to people.

Is there a simple way of combining the functionality of both databases given my limited ability in using access?

Any help would be greatly appreciated.

Many thanks
Adrian

View 2 Replies View Related

Run-time Error On Search DB/Email Results With DB Over 50 Contacts

Nov 15, 2004

I'm getting a Run-time error 2295: Unknown Message Recepients.

I've got a DB of about 2000 clients. In testing I did a test DB with 50 random
clients. Using any search criteria, it would grab those clients and open a new email
with their email addresses no problem.
However when I do this same thing with my complete DB of 2000 clients, I get this run
time error.
I'm pretty confused here, and anxious. It looks like the program is working, I just need it
to run with all my clients. This is the last thing I must conquer to be finished with this project.

View 3 Replies View Related

Tables :: Setting Up History Table For Contacts And Companies

May 15, 2013

I need setting up a history table for contacts and the companies that they are associated with. I am sure this will be obvious to some of you database veterans but I am fairly new to Access and I can't seem to figure out the best way to accomplish what I am trying to do.

Here is what I need to do:

When a contact's employment status changes, I need to change the contact's current company association but somehow maintain his or her association with the previous company so that s/he can still be associated with past projects.

So, in my contacts table (TBLContacts), I have a foreign key field "CompanyFK" that links to my companies table (TBLCompaniesPK). There is a one to many relationship between TBLCompanies and TBLContacts.

I want the CompanyFK field to be the current company but somehow link the person with past companies too so that the project directories and subforms will continue to show the contact's association with the parent company.

Maybe I don't need a history table but something else?

I have a similar problem with companies that change name, too. How to deal with takeovers, name changes, mergers, etc.

View 5 Replies View Related

Queries :: Get Contacts On Report That Match Parameters Inputted Into Box

Jun 19, 2013

I very new to Access. I am using the Contact Database template from MS and added a field of text. I am trying to get a query to search the field for partial text. I've typed the following parameter to narrow it down because I only need partial information:

Like "*" & [How are the contacts involved in Organization?] & "*"

I used the query builder off of a report that was already created. I just want to be able to get contacts on the report that match the parameters inputted into the box.

When I run the report it gives me the following error:"You either have an error in your expression or you have attempted to use an undeclared parameter. Check the expression for errors or enter the parameter '[How are the contacts involved in Organization?]' in the Query Parameters dialog."I hit OK and it pulls up the report without data filled in.

View 1 Replies View Related

Tables :: Setting Relationship Between Contacts And Locality Table

Sep 24, 2012

I have a contacts database and I am trying to set the relationship between the contacts table and the locality table. The contacts table has a LocalityID field that is a long integer and the Locality table has an autonumber as the PK. When I drag the LocalityID on one table to the other LocalityID I get the Can't create this relationship. When I look at the Edit Relationship dialog box the primary table is the Locality table not the Contacts table. I want set up a lookup on the contacts form that relates to locality.

View 4 Replies View Related

Forms :: Prevent Deletion Of Contacts Needed In Other Tables

May 17, 2013

In a simple Access 2003 database that has two table. A contacts table and a Report table.

I would like to be able to prevent the deletion of any contact that is still being used in the Reports table. The problem is that they are in a backend of a linked database. So the enforce referential integrity doesn't work. Plus I don't think I would like it anyway as it seems kind of dangerous to the reports table.

Is this possible to do what I need through the use of form coding?

View 14 Replies View Related

Outlook 2010 Contacts Linking - Notes Field

Apr 23, 2014

I know how to create new table in Access by linking to Outlook contacts. The problem is, the default NOTES field in the Outlook contact does not show up in the linked Access table. Every Outlook Contact field shows up with the exception of that one field.

View 3 Replies View Related

Minimise Access Main Window/Outlook Contacts Display

Oct 4, 2004

Two questions:
1.I have disabled all menus and assigned a custom form to load when the database is launched.
The form launches with the Main Access window in the background.
Is it possible to have this main window invisible; either minimised or absent?

2.I have created a linked outlook contacts table in my database. I have a feature in one of my forms which searches for contacts based on certain selections.
When a contact is found, it needs to be displayed. I will like to use the existing Outlook contact detail forms to pop up. I can make a custom form to display this info, but it seems a waste of time to code what outlook already has.
Can someone give any ideas? or, direct me to some reference material?
thanks!

View 1 Replies View Related

Tables :: Party Data Model For All Contacts - Companies And People

Jan 9, 2013

I have researched the 'party' data model but it is a bit too complex for what I'm seeking. For those familiar with it, I don't really need the intermediary relationship from-to tables.

I'm interested in ideas about setting up a data structure that will allow users to search contacts or select contacts in dropdowns regardless if the contact type is a person or an organization.

Obviously the fields needed for both are different and the biggest issue is the name field because the person contacts are

The way I am accomplishing it now is writing the company name, or "first name " & "last name" for a person, to kind of a bridge table when a new record is inserted into the person table or the organization table...kind of inefficient.

Is this a relationship thing or should I just write a function to create a temporary recordset when needed?

View 3 Replies View Related

General :: Error Using Access 2010 Contacts Database Template

Jun 13, 2014

I used the Contacts Database Template to import a comma delimited txt file of contacts data. The template included a number of tables, queries, forms & reports which I did not require. I deleted them leaving only a Table entitled 'Addressbk'. I added an Entry Form using the standard access tools and this works fine with the table. However, on running the access database I get the following error message; 'The form named "Main" is mis-spelled or refers to a form that doesn't exist. My only form is labelled 'Entry Form', so it would appear that one of the forms I deleted must have been named 'Main'. If one ignores the error message the database & entry form function perfectly.

View 3 Replies View Related

Forms :: Contacts Database - Error Entering New Record On A Subform

Jul 31, 2014

I am having a problem with my Contacts Database. I have attached it for your review.

My main form entitled "frmContact", is a form to enter a new contact. I have a Notes subform, and I want to be able to enter multiple notes for one person. I have a note for John Doe, and tried to enter a new note for him and got this error message:

"The LinkMasterFields property setting has produced this error: 'The object doesn't contain the Automation object 'tblcontact"."

Why is it doing this? I tihnk I have the relationships correct, and everything...

View 13 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved