A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

John Vinson is gone for two weeks can someone help me finish up this project?



 
 
Thread Tools Display Modes
  #11  
Old February 11th, 2005, 06:53 PM
Duane Hookom
external usenet poster
 
Posts: n/a
Default

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  
Old February 11th, 2005, 07:04 PM
external usenet poster
 
Posts: n/a
Default

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


  #14  
Old February 11th, 2005, 08:09 PM
external usenet poster
 
Posts: n/a
Default

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


  #15  
Old February 11th, 2005, 10:59 PM
Duane Hookom
external usenet poster
 
Posts: n/a
Default

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  
Old February 12th, 2005, 04:10 PM
external usenet poster
 
Posts: n/a
Default

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  
Old February 14th, 2005, 06:42 AM
Duane Hookom
external usenet poster
 
Posts: n/a
Default

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  
Old February 14th, 2005, 06:51 PM
external usenet poster
 
Posts: n/a
Default

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  
Old February 14th, 2005, 10:02 PM
external usenet poster
 
Posts: n/a
Default

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  
Old February 14th, 2005, 11:12 PM
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Project 2000 and Project server 2002 K.V General Discussions 1 January 21st, 2005 04:30 PM
Many to many reationship design? Dave Database Design 4 January 19th, 2005 12:11 AM
I am looking for a project planner, with start, finish dates and . dv fanatic General Discussion 1 November 27th, 2004 02: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


All times are GMT +1. The time now is 11:20 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.