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
|
|||
|
|||
Form to organize records by todays date
I am trying to create a form that will organize my records by today’s date
and perform these functions below. I need the most help setting up the tables, can you guide me. Field1 : Drop down list with 6 different activities to choose from. Field2: Default today’s date Field3: enter Quality of experience (ranges from 1 to 10) Field4: Drop down list with different times to choose from 5 min, 10 min, 15 min, 20 min, 25 min, 30 min Field5: labeled completed, has a check box/ Yes or No This is how I have my table is currently set up, but I am not able to get the results I am looking for when I create the form tblActivity -- ActivityID - Autonumber - primary key field ActivityType - ActionDate - DateTime datatype - default =Date() Quality - Duration - Consistency - |
#2
|
|||
|
|||
Form to organize records by todays date
What ain't you getting that you want?
What are you getting you do not want? Post example and sample. -- Build a little, test a little. "Teddy" wrote: I am trying to create a form that will organize my records by today’s date and perform these functions below. I need the most help setting up the tables, can you guide me. Field1 : Drop down list with 6 different activities to choose from. Field2: Default today’s date Field3: enter Quality of experience (ranges from 1 to 10) Field4: Drop down list with different times to choose from 5 min, 10 min, 15 min, 20 min, 25 min, 30 min Field5: labeled completed, has a check box/ Yes or No This is how I have my table is currently set up, but I am not able to get the results I am looking for when I create the form tblActivity -- ActivityID - Autonumber - primary key field ActivityType - ActionDate - DateTime datatype - default =Date() Quality - Duration - Consistency - |
#3
|
|||
|
|||
Form to organize records by todays date
What ain't you getting that you want?
A drop down box with a list of activities to choose from. I was able to install the drop down box on the form but I can’t get the list to display the six different activities to choose from. (I am always using the same six activities, should that effect the table design or is that okay? ) To get the form to display the six different activities I entered tblActivity in design view and went to the ActivityType field. I clicked the lookup tab and selected combo box. In the row source I entered "Activity1";"Activity2";"Activity3";"Activity4";"A ctivity5";"Activitiy6" But I still was unsuccessful which leads me to what I am getting that I don't want. What are you getting you do not want? When I try to use the combo box on the new form I created from the updated table a message box that says “The record source "Activity1";"Activity2";"Activity3";"Activity4";"A ctivity5";"Activitiy6" specified on this form does not exist. You misspelled the name, or it was deleted or renamed in the current database, or it exists in a different database. In the Form or Report’s Design View, display the property sheet by clicking the properties button, and then set the RecordSource property to an existing table or query." The spelling is correct as are the activities so I don’t understand why I am getting this message. Please help if you can. Thank you! "KARL DEWEY" wrote: What ain't you getting that you want? What are you getting you do not want? Post example and sample. -- Build a little, test a little. "Teddy" wrote: I am trying to create a form that will organize my records by today’s date and perform these functions below. I need the most help setting up the tables, can you guide me. Field1 : Drop down list with 6 different activities to choose from. Field2: Default today’s date Field3: enter Quality of experience (ranges from 1 to 10) Field4: Drop down list with different times to choose from 5 min, 10 min, 15 min, 20 min, 25 min, 30 min Field5: labeled completed, has a check box/ Yes or No This is how I have my table is currently set up, but I am not able to get the results I am looking for when I create the form tblActivity -- ActivityID - Autonumber - primary key field ActivityType - ActionDate - DateTime datatype - default =Date() Quality - Duration - Consistency - |
#4
|
|||
|
|||
Form to organize records by todays date
Update: I got The combo box to display a drop down list now, but instead of
displaying the activity type a number is being displayed. "Teddy" wrote: What ain't you getting that you want? A drop down box with a list of activities to choose from. I was able to install the drop down box on the form but I can’t get the list to display the six different activities to choose from. (I am always using the same six activities, should that effect the table design or is that okay? ) To get the form to display the six different activities I entered tblActivity in design view and went to the ActivityType field. I clicked the lookup tab and selected combo box. In the row source I entered "Activity1";"Activity2";"Activity3";"Activity4";"A ctivity5";"Activitiy6" But I still was unsuccessful which leads me to what I am getting that I don't want. What are you getting you do not want? When I try to use the combo box on the new form I created from the updated table a message box that says “The record source "Activity1";"Activity2";"Activity3";"Activity4";"A ctivity5";"Activitiy6" specified on this form does not exist. You misspelled the name, or it was deleted or renamed in the current database, or it exists in a different database. In the Form or Report’s Design View, display the property sheet by clicking the properties button, and then set the RecordSource property to an existing table or query." The spelling is correct as are the activities so I don’t understand why I am getting this message. Please help if you can. Thank you! "KARL DEWEY" wrote: What ain't you getting that you want? What are you getting you do not want? Post example and sample. -- Build a little, test a little. "Teddy" wrote: I am trying to create a form that will organize my records by today’s date and perform these functions below. I need the most help setting up the tables, can you guide me. Field1 : Drop down list with 6 different activities to choose from. Field2: Default today’s date Field3: enter Quality of experience (ranges from 1 to 10) Field4: Drop down list with different times to choose from 5 min, 10 min, 15 min, 20 min, 25 min, 30 min Field5: labeled completed, has a check box/ Yes or No This is how I have my table is currently set up, but I am not able to get the results I am looking for when I create the form tblActivity -- ActivityID - Autonumber - primary key field ActivityType - ActionDate - DateTime datatype - default =Date() Quality - Duration - Consistency - |
#5
|
|||
|
|||
Form to organize records by todays date
Never mind, back to the same problem again.
"Teddy" wrote: Update: I got The combo box to display a drop down list now, but instead of displaying the activity type a number is being displayed. "Teddy" wrote: What ain't you getting that you want? A drop down box with a list of activities to choose from. I was able to install the drop down box on the form but I can’t get the list to display the six different activities to choose from. (I am always using the same six activities, should that effect the table design or is that okay? ) To get the form to display the six different activities I entered tblActivity in design view and went to the ActivityType field. I clicked the lookup tab and selected combo box. In the row source I entered "Activity1";"Activity2";"Activity3";"Activity4";"A ctivity5";"Activitiy6" But I still was unsuccessful which leads me to what I am getting that I don't want. What are you getting you do not want? When I try to use the combo box on the new form I created from the updated table a message box that says “The record source "Activity1";"Activity2";"Activity3";"Activity4";"A ctivity5";"Activitiy6" specified on this form does not exist. You misspelled the name, or it was deleted or renamed in the current database, or it exists in a different database. In the Form or Report’s Design View, display the property sheet by clicking the properties button, and then set the RecordSource property to an existing table or query." The spelling is correct as are the activities so I don’t understand why I am getting this message. Please help if you can. Thank you! "KARL DEWEY" wrote: What ain't you getting that you want? What are you getting you do not want? Post example and sample. -- Build a little, test a little. "Teddy" wrote: I am trying to create a form that will organize my records by today’s date and perform these functions below. I need the most help setting up the tables, can you guide me. Field1 : Drop down list with 6 different activities to choose from. Field2: Default today’s date Field3: enter Quality of experience (ranges from 1 to 10) Field4: Drop down list with different times to choose from 5 min, 10 min, 15 min, 20 min, 25 min, 30 min Field5: labeled completed, has a check box/ Yes or No This is how I have my table is currently set up, but I am not able to get the results I am looking for when I create the form tblActivity -- ActivityID - Autonumber - primary key field ActivityType - ActionDate - DateTime datatype - default =Date() Quality - Duration - Consistency - |
Thread Tools | |
Display Modes | |
|
|