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
|
|||
|
|||
12:17AM VERY TIRED---nEED ADVISE/HELP
single table db.
table= track trains fields= date, inbound/outbound, Line, station, passengers, time, car #, destination the fields date,inboun/outbou, line and station need only entered one time and then the fields passengers, time, car#, destination, are entered many many times. In other words to enter data fast and not have to select the date, inboun/outboun, the line, the station for each train tracked in the other fields i.e. passengers and car # etc.. the fields date,inboun/outbou, line and station values will be the same for say 50 trains untill the spotters move to another line or station. I have a form with the fields date,inboun/outbou, line and station and a button that opens another form that contains the other fields to enter the non-repetetive data like # of passengers. My problem is when records are to be entered the user selects the date, then selects the listbox inbound or outbound, then cascading boxes selecting the train line and finaly the station the next information to be entered was gathered at. At this point the user clicks a button and another form opens with the fields passengers, time, car #, destination. I want the user to be able to stay in this form entering the fields passengers, time, car #, destination over and over quickly without having to referr back to the first form and select those fields each time. so when the user enters the last field data the complete data is saved to the table in other words the first form data needs saved on the same line in the table. I'm tired I hope this makes sense.... The way its working now the first form data is saved in the table as a different record. I need the first form dats to be saved with each set of dats from the second form. Ienter the first form data once I go to the second form and enter data and each time i finish I need my table to list example below. 10/11/2009 | INBOUND | WESTLINE | STATION1 | 32(Passengers) | 234C (Car #) | 13:44 (time). What I am getting is 10/11/2009 | INBOUND | WESTLINE | STATION1 | | | |32(Passengers) | 234C (Car #) Seprate records?????? How do I get the first form data to save with each completed entey of second form data? Thank you in advance just for reading this ......... |
#2
|
|||
|
|||
12:17AM VERY TIRED---nEED ADVISE/HELP
Keith,
It's 1:03 AM where I am and I am beyond tired... I digress.... Your problem is the ONE table, should have been two tables right off the bat. One train (one table), many passengers (another table). So this will not be a quick and dirty answer. Do you have the time to correct the tables? Then you could easily create a form/subform situation which would completely satisfy your Users. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Keith" wrote in message ... single table db. table= track trains fields= date, inbound/outbound, Line, station, passengers, time, car #, destination the fields date,inboun/outbou, line and station need only entered one time and then the fields passengers, time, car#, destination, are entered many many times. In other words to enter data fast and not have to select the date, inboun/outboun, the line, the station for each train tracked in the other fields i.e. passengers and car # etc.. the fields date,inboun/outbou, line and station values will be the same for say 50 trains untill the spotters move to another line or station. I have a form with the fields date,inboun/outbou, line and station and a button that opens another form that contains the other fields to enter the non-repetetive data like # of passengers. My problem is when records are to be entered the user selects the date, then selects the listbox inbound or outbound, then cascading boxes selecting the train line and finaly the station the next information to be entered was gathered at. At this point the user clicks a button and another form opens with the fields passengers, time, car #, destination. I want the user to be able to stay in this form entering the fields passengers, time, car #, destination over and over quickly without having to referr back to the first form and select those fields each time. so when the user enters the last field data the complete data is saved to the table in other words the first form data needs saved on the same line in the table. I'm tired I hope this makes sense.... The way its working now the first form data is saved in the table as a different record. I need the first form dats to be saved with each set of dats from the second form. Ienter the first form data once I go to the second form and enter data and each time i finish I need my table to list example below. 10/11/2009 | INBOUND | WESTLINE | STATION1 | 32(Passengers) | 234C (Car #) | 13:44 (time). What I am getting is 10/11/2009 | INBOUND | WESTLINE | STATION1 | | | |32(Passengers) | 234C (Car #) Seprate records?????? How do I get the first form data to save with each completed entey of second form data? Thank you in advance just for reading this ......... |
#3
|
|||
|
|||
12:17AM VERY TIRED---nEED ADVISE/HELP
I was afraid of that.......2:30am Thanks Gina
"Gina Whipp" wrote: Keith, It's 1:03 AM where I am and I am beyond tired... I digress.... Your problem is the ONE table, should have been two tables right off the bat. One train (one table), many passengers (another table). So this will not be a quick and dirty answer. Do you have the time to correct the tables? Then you could easily create a form/subform situation which would completely satisfy your Users. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Keith" wrote in message ... single table db. table= track trains fields= date, inbound/outbound, Line, station, passengers, time, car #, destination the fields date,inboun/outbou, line and station need only entered one time and then the fields passengers, time, car#, destination, are entered many many times. In other words to enter data fast and not have to select the date, inboun/outboun, the line, the station for each train tracked in the other fields i.e. passengers and car # etc.. the fields date,inboun/outbou, line and station values will be the same for say 50 trains untill the spotters move to another line or station. I have a form with the fields date,inboun/outbou, line and station and a button that opens another form that contains the other fields to enter the non-repetetive data like # of passengers. My problem is when records are to be entered the user selects the date, then selects the listbox inbound or outbound, then cascading boxes selecting the train line and finaly the station the next information to be entered was gathered at. At this point the user clicks a button and another form opens with the fields passengers, time, car #, destination. I want the user to be able to stay in this form entering the fields passengers, time, car #, destination over and over quickly without having to referr back to the first form and select those fields each time. so when the user enters the last field data the complete data is saved to the table in other words the first form data needs saved on the same line in the table. I'm tired I hope this makes sense.... The way its working now the first form data is saved in the table as a different record. I need the first form dats to be saved with each set of dats from the second form. Ienter the first form data once I go to the second form and enter data and each time i finish I need my table to list example below. 10/11/2009 | INBOUND | WESTLINE | STATION1 | 32(Passengers) | 234C (Car #) | 13:44 (time). What I am getting is 10/11/2009 | INBOUND | WESTLINE | STATION1 | | | |32(Passengers) | 234C (Car #) Seprate records?????? How do I get the first form data to save with each completed entey of second form data? Thank you in advance just for reading this ......... |
#4
|
|||
|
|||
12:17AM VERY TIRED---nEED ADVISE/HELP
Glad to help... sorry it wasn't the answer you wanted!
-- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Keith" wrote in message ... I was afraid of that.......2:30am Thanks Gina "Gina Whipp" wrote: Keith, It's 1:03 AM where I am and I am beyond tired... I digress.... Your problem is the ONE table, should have been two tables right off the bat. One train (one table), many passengers (another table). So this will not be a quick and dirty answer. Do you have the time to correct the tables? Then you could easily create a form/subform situation which would completely satisfy your Users. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Keith" wrote in message ... single table db. table= track trains fields= date, inbound/outbound, Line, station, passengers, time, car #, destination the fields date,inboun/outbou, line and station need only entered one time and then the fields passengers, time, car#, destination, are entered many many times. In other words to enter data fast and not have to select the date, inboun/outboun, the line, the station for each train tracked in the other fields i.e. passengers and car # etc.. the fields date,inboun/outbou, line and station values will be the same for say 50 trains untill the spotters move to another line or station. I have a form with the fields date,inboun/outbou, line and station and a button that opens another form that contains the other fields to enter the non-repetetive data like # of passengers. My problem is when records are to be entered the user selects the date, then selects the listbox inbound or outbound, then cascading boxes selecting the train line and finaly the station the next information to be entered was gathered at. At this point the user clicks a button and another form opens with the fields passengers, time, car #, destination. I want the user to be able to stay in this form entering the fields passengers, time, car #, destination over and over quickly without having to referr back to the first form and select those fields each time. so when the user enters the last field data the complete data is saved to the table in other words the first form data needs saved on the same line in the table. I'm tired I hope this makes sense.... The way its working now the first form data is saved in the table as a different record. I need the first form dats to be saved with each set of dats from the second form. Ienter the first form data once I go to the second form and enter data and each time i finish I need my table to list example below. 10/11/2009 | INBOUND | WESTLINE | STATION1 | 32(Passengers) | 234C (Car #) | 13:44 (time). What I am getting is 10/11/2009 | INBOUND | WESTLINE | STATION1 | | | |32(Passengers) | 234C (Car #) Seprate records?????? How do I get the first form data to save with each completed entey of second form data? Thank you in advance just for reading this ......... |
Thread Tools | |
Display Modes | |
|
|