|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 3rd, 2006, 01:49 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Contacts DB change: help needed...
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. -- Howard 
|
|
#2
November 3rd, 2006, 02:09 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Contacts DB change: help needed...
Please post what you want to change...this place is full of volunteers...
-- 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" wrote in message ... 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. -- Howard
|
|
#3
November 3rd, 2006, 02:13 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Contacts DB change: help needed...
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 "Howard9" wrote in message ... 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. -- Howard
|
|
#4
November 3rd, 2006, 03:21 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Contacts DB change: help needed...
In article ,
says... 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 "Howard9" wrote in message ... 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. -- 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. -- Howard
|
|
#5
November 3rd, 2006, 04:21 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Contacts DB change: help needed...
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" wrote in message ... In article , says... 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 "Howard9" wrote in message ... 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. -- 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. -- Howard
|
|
#6
November 3rd, 2006, 04:45 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Contacts DB change: help needed...
In article , -
inc.com says... 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? 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 .... :-) -- Howard
|
|
#7
November 3rd, 2006, 04:53 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Contacts DB change: help needed...
Let me know what the recordsource is for the other one...probably reading
from a table or query... -- 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" wrote in message ... In article , - inc.com says... 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? 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 .... :-) -- Howard
|
|
#8
November 3rd, 2006, 05:50 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Contacts DB change: help needed...
In article , -
inc.com says... Let me know what the recordsource is for the other one...probably reading from a table or query... 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.... ? -- Howard
|
|
#9
November 3rd, 2006, 06:13 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Contacts DB change: help needed...
"Howard9" wrote in message
... In article , - inc.com says... Let me know what the recordsource is for the other one...probably reading from a table or query... 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.... 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. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!)
|
|
#10
November 3rd, 2006, 07:20 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Contacts DB change: help needed...
yes...thanks Mr. Steele...was doing that from (fading) memory...
-- Kevin Hill 3NF Consulting http://www.3nf-inc.com/NewsGroups.htm Real-world stuff I run across with SQL Server: http://kevin3nf.blogspot.com "Douglas J. Steele" wrote in message ... "Howard9" wrote in message ... In article , - inc.com says... Let me know what the recordsource is for the other one...probably reading from a table or query... 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.... 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. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!)
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
