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  

Omit last blank row



 
 
Thread Tools Display Modes
  #1  
Old June 20th, 2005, 12:38 PM
an
external usenet poster
 
Posts: n/a
Default Omit last blank row

Hello!

I have a continous form.
When I open it, in last row to appear a blank record.
How is possible to avoid it, please.
Thanks in advance.
an
  #2  
Old June 20th, 2005, 01:18 PM
Dennis
external usenet poster
 
Posts: n/a
Default

The last row is there so you can add new records. If you wish to omit it, you
will not be able to add new records unless you create a button or some other
routine to add them. To remove the last row, change the form property Allow
Additions from Yes to No

"an" wrote:

Hello!

I have a continous form.
When I open it, in last row to appear a blank record.
How is possible to avoid it, please.
Thanks in advance.
an

  #3  
Old June 20th, 2005, 01:23 PM
an
external usenet poster
 
Posts: n/a
Default

Ok, Dennis.

Thank you for your reply.
an

"Dennis" wrote:

The last row is there so you can add new records. If you wish to omit it, you
will not be able to add new records unless you create a button or some other
routine to add them. To remove the last row, change the form property Allow
Additions from Yes to No

"an" wrote:

Hello!

I have a continous form.
When I open it, in last row to appear a blank record.
How is possible to avoid it, please.
Thanks in advance.
an

  #4  
Old June 20th, 2005, 04:39 PM
Steven Greenberg
external usenet poster
 
Posts: n/a
Default

=?Utf-8?B?RGVubmlz?= wrote in
:

The last row is there so you can add new records. If you wish to omit
it, you will not be able to add new records unless you create a button
or some other routine to add them. To remove the last row, change the
form property Allow Additions from Yes to No

"an" wrote:

Hello!

I have a continous form.
When I open it, in last row to appear a blank record.
How is possible to avoid it, please.
Thanks in advance.
an


I too would like my subform to not show the blank row, I also have a button
to add a new record who's coding is simply goto newrecord. When I set allow
additions to no. the button gives me a debug error saying can't go to
record. Does the coding need to be fancier (like turn back on allow then
add then shut it back off)? or am I barking up the wrong tree?
Thanks
Steve
  #5  
Old June 20th, 2005, 07:04 PM
John Vinson
external usenet poster
 
Posts: n/a
Default

On Mon, 20 Jun 2005 15:39:27 GMT, Steven Greenberg
wrote:

I too would like my subform to not show the blank row, I also have a button
to add a new record who's coding is simply goto newrecord. When I set allow
additions to no. the button gives me a debug error saying can't go to
record. Does the coding need to be fancier (like turn back on allow then
add then shut it back off)?


Exactly: Allow Additions = No means that no additions are allowed
using the form; if you want to allow additions, then you need to
change that setting.

John W. Vinson[MVP]
  #6  
Old August 25th, 2005, 03:51 PM
paulpenta
external usenet poster
 
Posts: n/a
Default

Hi Dennis,

I had the same problem, and got that fix from this forum and it worked. But
now it doesn't. What could I have done to mess that up?

Paul

"Dennis" wrote:

The last row is there so you can add new records. If you wish to omit it, you
will not be able to add new records unless you create a button or some other
routine to add them. To remove the last row, change the form property Allow
Additions from Yes to No

"an" wrote:

Hello!

I have a continous form.
When I open it, in last row to appear a blank record.
How is possible to avoid it, please.
Thanks in advance.
an

 




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
"Blank page" is not blank. It contains text written weeks ago. Kingfish General Discussion 3 January 7th, 2005 09:52 PM
Plain blank new slide Marcela Powerpoint 8 January 5th, 2005 03:59 PM
How to omit blank lines in mail merge SandieBch General Discussion 2 December 16th, 2004 08:05 AM
Creating an "unmovable" blank page Dan Page Layout 1 October 11th, 2004 11:12 PM
0 if blank Theo Worksheet Functions 7 January 7th, 2004 08:20 PM


All times are GMT +1. The time now is 05:25 PM.


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