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
|
|||
|
|||
Last field in last record not in report...
Hi all,
I am building a simple test program in Access 2000. It will take 10 questions out of a database of hunfdreds and present them to users... Everything works, except this: If you answer the last question (which could be any question in the continuos form) and press "Print Test Results", the last answer will not be considered, it will stay blank... If I move to Prev/Next record, before printing, everything works fine... What I am looking for is some code in the print button do to it for me... tried move next, move prev... they don't work :-( Thanks for any help you may provide... Ciao, Lupo |
#2
|
|||
|
|||
Last field in last record not in report...
On 27 May 2004 10:59:34 -0700, Dr. Roberto VALENTE wrote:
Hi all, I am building a simple test program in Access 2000. It will take 10 questions out of a database of hunfdreds and present them to users... Everything works, except this: If you answer the last question (which could be any question in the continuos form) and press "Print Test Results", the last answer will not be considered, it will stay blank... If I move to Prev/Next record, before printing, everything works fine... What I am looking for is some code in the print button do to it for me... tried move next, move prev... they don't work :-( Thanks for any help you may provide... Ciao, Lupo Access does not save the record until you close the form, move to the next record, close the database, or you expressly tell it to. Code the command button click event used to open the report: DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenReport "ReportName", etc -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
#3
|
|||
|
|||
Last field in last record not in report...
Dear Fred,
that works, almost... in the sense that it does update my answer count, but the form takes a second (less, actually) to do it and when I check if the number of answers corresponds to the number of questions, it's still one behind... Basically, I only need a code between your two lines to "waste time" before executing the second one and I'll be all set... Does such a command exist? Thanks again, Lupo fredg wrote in message .. . On 27 May 2004 10:59:34 -0700, Dr. Roberto VALENTE wrote: Hi all, I am building a simple test program in Access 2000. It will take 10 questions out of a database of hunfdreds and present them to users... Everything works, except this: If you answer the last question (which could be any question in the continuos form) and press "Print Test Results", the last answer will not be considered, it will stay blank... If I move to Prev/Next record, before printing, everything works fine... What I am looking for is some code in the print button do to it for me... tried move next, move prev... they don't work :-( Thanks for any help you may provide... Ciao, Lupo Access does not save the record until you close the form, move to the next record, close the database, or you expressly tell it to. Code the command button click event used to open the report: DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenReport "ReportName", etc |
Thread Tools | |
Display Modes | |
|
|