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 » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Last field in last record not in report...



 
 
Thread Tools Display Modes
  #1  
Old May 27th, 2004, 06:59 PM
Dr. Roberto VALENTE
external usenet poster
 
Posts: n/a
Default 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  
Old May 27th, 2004, 07:13 PM
fredg
external usenet poster
 
Posts: n/a
Default 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  
Old May 28th, 2004, 02:27 PM
Dr. Roberto VALENTE
external usenet poster
 
Posts: n/a
Default 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

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


All times are GMT +1. The time now is 07:17 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.