Contacts DB change: help needed...

H

Howard9

Hi everyone - I hope this is an appropriate request. If not I apologize.

I have a small "Contacts" database (the one that comes with
MSOffice2000)that is 90% what I need, but there are one or two small
things I need to change and it's outside my area of knowledge..

Appreciate any help if someone has a few minutes.
 
H

Howard9

Howard,
Just post the question/s, and if someone can help you, they will.
---
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
Click to expand...
Thanks guys... my problem is describing it :) But I'll give it a shot.

The Contacts DB which comes with MSAccess2000 is here (slightly altered
already, one tab removed, one or two field hidden):
http://www.brittainweb.com/ContactsDB.zip

It has a Contacts Form which has four "Tabs":
'Contact': Details of their name, phone, email etc.
'Calls': for logging calls and setting up reminders.
'Personal': for personal info, family, birthday etc.
'Company': for company name, address, phone, etc etc.

Problem 1)
Most of the DB is fine, but the 'Contact Tab' has a field called
"Company" which is a pull down menu with five items.
The idea seems to have been that the user of the DB only deals with five
clients... duh.
This field then auto-feeds into the 'Company Tab' and into a field
called "Company name".
So - I would be happy to maintain the link between the two fields if I
could change the first one from a pull down to a simple text entry
field. Then it could feed happily into the Company Tab.

Problem 2)
I know this is minor but it would enable me to make other changes if I
knew how to do it :) )
In the 'Personal Tab' there is a simple pulldown field offering five
choices of Married, single, separated etc etc.
I want to add 'attached' ... but when I look at the Main MSAccess page
view of this DB and look at tables, forms etc... there is no separate
table for this item. Where would this list be that I could add one item
?


[The reason I want to use this DB so much is the fact that it contains a
'calls' record and a reminder function. I am trying to build a small
consultancy business and am hoping to use this DB as the basis for
networking contacts and reminding me when to follow them up...]

Any help would be most appreciated.
 
K

Kevin3NF

I can't pull the sample down here, but I suspect both of these can be easily
changed.

What is the record source?

1. might be a table, in which case you can add to it..
2. Might be a list in the Properties of the combobox

Do you know how to find this info?

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com


Howard9 said:
Howard,
Just post the question/s, and if someone can help you, they will.
---
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
Click to expand...
Thanks guys... my problem is describing it :) But I'll give it a shot.

The Contacts DB which comes with MSAccess2000 is here (slightly altered
already, one tab removed, one or two field hidden):
http://www.brittainweb.com/ContactsDB.zip

It has a Contacts Form which has four "Tabs":
'Contact': Details of their name, phone, email etc.
'Calls': for logging calls and setting up reminders.
'Personal': for personal info, family, birthday etc.
'Company': for company name, address, phone, etc etc.

Problem 1)
Most of the DB is fine, but the 'Contact Tab' has a field called
"Company" which is a pull down menu with five items.
The idea seems to have been that the user of the DB only deals with five
clients... duh.
This field then auto-feeds into the 'Company Tab' and into a field
called "Company name".
So - I would be happy to maintain the link between the two fields if I
could change the first one from a pull down to a simple text entry
field. Then it could feed happily into the Company Tab.

Problem 2)
I know this is minor but it would enable me to make other changes if I
knew how to do it :) )
In the 'Personal Tab' there is a simple pulldown field offering five
choices of Married, single, separated etc etc.
I want to add 'attached' ... but when I look at the Main MSAccess page
view of this DB and look at tables, forms etc... there is no separate
table for this item. Where would this list be that I could add one item
?


[The reason I want to use this DB so much is the fact that it contains a
'calls' record and a reminder function. I am trying to build a small
consultancy business and am hoping to use this DB as the basis for
networking contacts and reminding me when to follow them up...]

Any help would be most appreciated.
Click to expand...
 
H

Howard9

[email protected] said:
I can't pull the sample down here, but I suspect both of these can be easily
changed.

What is the record source?

1. might be a table, in which case you can add to it..
2. Might be a list in the Properties of the combobox

Do you know how to find this info?
Click to expand...
Wo........... bingo .. I found the list of Married, attached etc in the
Properties Box of the field :) I reshuffled them and added one more
:)

Thanks Kevin !

Hope the other problem will be as easy .... :)
 
H

Howard9

[email protected] said:
Let me know what the recordsource is for the other one...probably reading
from a table or query...
Click to expand...
Sorry Kevin I don't know what that means...

I know the fields are connected....in that if I chose one of the
pulldown items in the first tab... it appears in the second tab..

In the properties of the field in the Company Tab
Name = 'txtCompanyName'
ControlSource = 'CompanyName

In the properties of the field in the Contact Tab
Name = cboCompany
ControlSource = CompanyID

If I chose one of the pulldown items in the Contact Tab... it appears in
the second tab.......... and strangely... if I write in a name by hand
in the field in the Company Tab....it then appears in the first tab as
if it were the first item in the pulldown list....

?
 
D

Douglas J. Steele

Howard9 said:
Sorry Kevin I don't know what that means...

I know the fields are connected....in that if I chose one of the
pulldown items in the first tab... it appears in the second tab..

In the properties of the field in the Company Tab
Name = 'txtCompanyName'
ControlSource = 'CompanyName

In the properties of the field in the Contact Tab
Name = cboCompany
ControlSource = CompanyID

If I chose one of the pulldown items in the Contact Tab... it appears in
the second tab.......... and strangely... if I write in a name by hand
in the field in the Company Tab....it then appears in the first tab as
if it were the first item in the pulldown list....
Click to expand...


What Kevin's talking about is the RowSource property of the combo box, not
its ControlSource.

RowSource controls from where the combobox gets its values, ControlSource
controls where the value is stored once you select it from the list.
 
H

Howard9

What Kevin's talking about is the RowSource property of the combo box, not
its ControlSource.

RowSource controls from where the combobox gets its values, ControlSource
controls where the value is stored once you select it from the list.
Click to expand...
For the Company pulldown field (Combobox?) in the first Contact Tab.

RowSource = SELECT Company.CompanyID, Company.CompanyName FROM Company
ORDER BY Company.CompanyName;
 
H

Howard9

[email protected] said:
So the combobox is populating based on the results of that ad-hoc query.

Add a new company to the Company table (presumably through a form..) and it
should show up in the drop down
Click to expand...
It won't let me save it - it says there must be a related record in the
tblCompanyTypes.

I would like to get to a stage where either of two possibilities works
without the need for a pulldown-combobox field:

a) I can simply type in the company name to the fields in both tabs
or
b) I type the name into one field and it auto appears in the other.
Again no pulldowns.

is this possible ?
 
J

John Vinson

So the combobox is populating based on the results of that ad-hoc query.

Add a new company to the Company table (presumably through a form..) and it
should show up in the drop down
Click to expand...

You may need to Requery the combo box in the AfterUpdate event of the
Company form.

John W. Vinson[MVP]
 
H

Howard9

You may need to Requery the combo box in the AfterUpdate event of the
Company form.
Click to expand...
This is all way beyond me guys. Thanks anyway...

Maybe I can find a way to make both of these fields invisible and just
add two new fields to the tabs... though when I try this the other tabs
show blank when I try to add a new record...
 
H

Howard9

[email protected] said:
Add a new company to the Company table (presumably through a form..) and it
should show up in the drop down

Sounds like it will already do what you want...take it one issue at a time
:)
Click to expand...
That means that I would have to go to the company table to add each new
contact company, as well as add the company ? and then end up with a
pulldown menu of hundreds of items ?
 
J

John Vinson

That means that I would have to go to the company table to add each new
contact company, as well as add the company ? and then end up with a
pulldown menu of hundreds of items ?
Click to expand...

huh?

If you are trying to track hundreds of companies, then... you're
trying to track hundreds of companies.

Do you want to see all of the companies in your list in the combo box?
Or don't you?

John W. Vinson[MVP]
 
H

Howard9

Do you want to see all of the companies in your list in the combo box?
Or don't you?
Click to expand...
NO way :) I want to enter the name in a basic text only field in the
Contacts Tab and the Company Tab :)
I just wish there were a way of doing this :-(
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modern equivalent of Autotext in Word? 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Access 2002 change report header text 0
Anything will help 0
Help required re Activation of Office 1
I need help please 0
Need Help Creating a Word 2010 Chistmas Letter Template 8
MS Outlook inbox to MS Accsess Database 0

Top