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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
=?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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |