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 |
#11
|
|||
|
|||
Go back to my reply that begins "As Ken mentioned..." You will find your
solution there. Make sure you have a table as Ken suggested and then build the form etc as I suggested. Any other attempt to use a form bound to your student table will just result in failure and cause me to get upset and possibly not respond. -- Duane Hookom MS Access MVP -- wrote in message news I want to do both but right now I have a form that if I put an ID number in the ID Scan textbox it just moves the information in all the other textboxes to the next student in the table? I thought we could fix that first then work on saving the information or does it involve doing both to get the results I am looking for in the form? On Fri, 11 Feb 2005 08:45:40 -0600, "Duane Hookom" wrote: Do you want to store the information about which students were at which lunch? Or, do you simply want to scan the card and display the student information on the screen? When the next student gets scanned, the previous student information is not viewable and not saved anywhere. -- Duane Hookom MS Access MVP |
#12
|
|||
|
|||
So the first I have to is add another textbox to the original form
with the date and that will be bound to the new table tblStudentsLunchAttend.LunchDate field correct? On Fri, 11 Feb 2005 11:53:35 -0600, "Duane Hookom" wrote: Go back to my reply that begins "As Ken mentioned..." You will find your solution there. Make sure you have a table as Ken suggested and then build the form etc as I suggested. Any other attempt to use a form bound to your student table will just result in failure and cause me to get upset and possibly not respond. -- Duane Hookom MS Access MVP |
#13
|
|||
|
|||
|
#15
|
|||
|
|||
John is out of town so I would only follow my advice ;-) Ken is also good
but he handed this off to me. What are the table and field names of your students table and your lunch attendance table? All you should have to do is create a continuous form based on your table tblStudentsLunchAttend. You should have a combo box based on your students table to allow the scanning of the student ID to capture a value to store in tblStudentsLunchAttend. You can include other controls on the form depending on what you want to see on the form when you scan. The form should be set up as "Data Entry: Yes". This will hide all the old records when it opens. -- Duane Hookom MS Access MVP -- wrote in message ... Do you know of a sample of this anywhere that I could look at? It seems like I am changing everything that was done originally with John Vinson. Should I follow all the directions in this thread both yours and Ken Snells advice or just yours? I have been working on this for over a week and seem to be going in circles at this point. I now have built another table. What can I post to show you what I have so far. On Fri, 11 Feb 2005 18:44:28 GMT, wrote: On Fri, 11 Feb 2005 18:04:22 GMT, wrote: So the first thing I have to do is add another textbox to the original form with the date and that will be bound to the new table tblStudentsLunchAttend.LunchDate field correct? On Fri, 11 Feb 2005 11:53:35 -0600, "Duane Hookom" wrote: Go back to my reply that begins "As Ken mentioned..." You will find your solution there. Make sure you have a table as Ken suggested and then build the form etc as I suggested. Any other attempt to use a form bound to your student table will just result in failure and cause me to get upset and possibly not respond. -- Duane Hookom MS Access MVP |
#16
|
|||
|
|||
On Fri, 11 Feb 2005 15:59:07 -0600, "Duane Hookom"
wrote: John is out of town so I would only follow my advice ;-) Ken is also good but he handed this off to me. Thank You again for your time! What are the table and field names of your students table and your lunch attendance table? Student Table - Student List 2-5 - #, Student ID, Last Name, First Name, Grade, HR, Lunch Lunch Attendance Table - tblStudentsLunchAttend - StudentID, LunchDate All you should have to do is create a continuous form based on your table tblStudentsLunchAttend. You should have a combo box (What should this Combo Box consist of? I'm haven't used one before) based on your students table to allow the scanning of the student ID to capture a value to store in tblStudentsLunchAttend. You can include other controls on the form depending on what you want to see on the form when you scan. The form should be set up as "Data Entry: Yes". This will hide all the old records when it opens. I have a form which consists of ID Scan, Student ID, Lunch, First Name, Last Name, Grade, Class and now Date. This way I can see who I am scanning and if they belong in that lunch. Until I started changing things when I entered the Scan ID the student list would just move up one name from the student table. -- Duane Hookom MS Access MVP |
#17
|
|||
|
|||
Read my most recent reply and set up your form based on
tblStudnetsLunchAttend. The StudentID field must be bound to Combo Box that has a row source like Name: cboStudentID Row Source: SELECT StudentID, [First Name] & " " & [Last Name] as FullName, Grade, Lunch, HR FROM Student; Columns Count: 5 Bound Column: 1 Column Widths: 0,1.5,0.5, 0.5, 0.5 Add more text boxes to the form with control sources like: to display the Grade =cboStudentID.Column(2) to display the Lunch =cboStudentID.Column(3) -- Duane Hookom MS Access MVP wrote in message ... On Fri, 11 Feb 2005 15:59:07 -0600, "Duane Hookom" wrote: John is out of town so I would only follow my advice ;-) Ken is also good but he handed this off to me. Thank You again for your time! What are the table and field names of your students table and your lunch attendance table? Student Table - Student List 2-5 - #, Student ID, Last Name, First Name, Grade, HR, Lunch Lunch Attendance Table - tblStudentsLunchAttend - StudentID, LunchDate All you should have to do is create a continuous form based on your table tblStudentsLunchAttend. You should have a combo box (What should this Combo Box consist of? I'm haven't used one before) based on your students table to allow the scanning of the student ID to capture a value to store in tblStudentsLunchAttend. You can include other controls on the form depending on what you want to see on the form when you scan. The form should be set up as "Data Entry: Yes". This will hide all the old records when it opens. I have a form which consists of ID Scan, Student ID, Lunch, First Name, Last Name, Grade, Class and now Date. This way I can see who I am scanning and if they belong in that lunch. Until I started changing things when I entered the Scan ID the student list would just move up one name from the student table. -- Duane Hookom MS Access MVP |
#18
|
|||
|
|||
Now when I go to Form View I get a box asking
Enter Parameter Value StudentID? Do you know of a Access project that is similiar to what I and trying to do like the Northwind Project that comes with Access so I can see what to do. The students have already changed lunches for a week and I have been working on this for at least three? I have searched the internet for a template or for something similiar to this project but have had no luck. Even if I can just get a form to scan in the students ID Number and get his name, lunch, grade, and class would work for now. I can try to work out the saved list later. On Sun, 13 Feb 2005 23:42:49 -0600, "Duane Hookom" duanehoot wrote: Read my most recent reply and set up your form based on tblStudnetsLunchAttend. The StudentID field must be bound to Combo Box that has a row source like Name: cboStudentID Row Source: SELECT StudentID, [First Name] & " " & [Last Name] as FullName, Grade, Lunch, HR FROM Student; Columns Count: 5 Bound Column: 1 Column Widths: 0,1.5,0.5, 0.5, 0.5 Add more text boxes to the form with control sources like: to display the Grade =cboStudentID.Column(2) to display the Lunch =cboStudentID.Column(3) |
#19
|
|||
|
|||
You really get around!
I saw you on TEK-TIPS FORUMS trying to find out about "Enter Parameter Value". And how's that grandson? |
#20
|
|||
|
|||
This is making me crazy!!!!
Now I have a all the FirstName Last Name(It is not the actual names but FirstName LastName) in the student ID Combo Box The Lunch textbox has #Name? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Project 2000 and Project server 2002 | K.V | General Discussions | 1 | January 21st, 2005 03:30 PM |
Many to many reationship design? | Dave | Database Design | 4 | January 18th, 2005 11:11 PM |
I am looking for a project planner, with start, finish dates and . | dv fanatic | General Discussion | 1 | November 27th, 2004 01:48 PM |
Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
Signing a VBA mde/mdb Access 2003 | John Buckett | General Discussion | 3 | July 3rd, 2004 09:14 PM |