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
Earlier this year, Dennis wrote "To remove the last row, change the form
property Allow Additions from Yes to No". It worked for User "an", but not for several others. Now I have the same problem. What could be missing? Here's the dump of my properties: AllowAdditions: False AllowDatasheetView: False AllowDeletions: False AllowDesignChanges: False AllowEditing: True AllowEdits: True AllowFilters: True AllowFormView: True AllowPivotChartView: False AllowPivotTableView: False AllowUpdating: No AutoCenter: False AutoResize: False BorderStyle: Dialog Caption: #Suchmaske Antragsdaten f CloseButton: True Eingabe Storno Container: Forms ControlBox: True Count: 70 CurrentView: 0 Cycle: All Records DataEntry: False DatasheetBackColor: 16777215 DatasheetBorderLineStyle: 1 DatasheetCellsEffect: Flat DatasheetColumnHeaderUn 1 DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderline: False DatasheetFontWeight: Normal DatasheetForeColor: 0 DatasheetGridlinesBehavior: Both DatasheetGridlinesColor: 12632256 DateCreated: 07.12.2005 16:15:24 DefaultEditing: 4 DefaultView: Continuous Forms DividingLines: True FastLaserPrinting: True FetchDefaults: True Filter: (Stand=Pervor()) FilterOn: False FrozenColumns: 1 GridX: 10 GridY: 10 HasModule: True HelpContextId: 0 HorizontalDatasheetGridline 1 Hwnd: 7800612 InsideHeight: 12615 InsideWidth: 7035 KeyPreview: False LastUpdated: 07.12.2005 16:15:24 LayoutForPrint: False LogicalPageWidth: 9340 MaxButton: True MinButton: True MinMaxButtons: Both Enabled Modal: False Moveable: True NavigationButtons: False OnClose: [Event Procedure] OnLoad: [Event Procedure] OrderByOn: False Orientation: Left-to-Right Owner: admin Painting: True PaletteSource: (Default) Pictu (none) PictureAlignment: Center PictureSizeMode: Clip PictureTiling: False PictureType: 0 PopUp: False PrtDevMode: Long binary data PrtDevNames: Long binary data PrtMip: Long binary data RecordLocks: No Locks RecordSelectors: False RecordsetType: Dynaset RecordSource: Abrechnung Antragsdaten RowHeight: Default ScrollBars: Neither ShortcutMenu: True ShowGrid: True SubdatasheetExpanded: False SubdatasheetHeight: 0 TimerInterval: 0 UserName: admin VerticalDatasheetGridlineSty 1 ViewsAllowed: Form Visible: False WhatsThisButton: False Width: 6803 WindowHeight: 13440 WindowLeft: 3075 WindowTop: 510 WindowWidth: 7470 |
#2
|
|||
|
|||
Omit last blank row
forgot to add: I'm using Access 2003, but the DB is in 2000 format.
Also, the thread from earlier this year had the same subject line. |
#3
|
|||
|
|||
Omit last blank row
It depends on what is causing the "last blank row". In a form in Continuous
Form View, this is usually the place holder for a new record. It allows you to simply click into this row to move to the new record. Setting AllowAdditions to False/No will remove this place holder. Since you have multiple users, does each user have their own copy of the front-end file with the forms, reports, etc? If so, did you make this change for each user? -- Wayne Morgan MS Access MVP "Sebastian Helm" wrote in message ... forgot to add: I'm using Access 2003, but the DB is in 2000 format. Also, the thread from earlier this year had the same subject line. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Blank Page Report | Diane Walker | Setting Up & Running Reports | 2 | November 10th, 2005 04:21 PM |
omit blank mail merge fields | gapkid | Mailmerge | 2 | October 20th, 2005 07:19 AM |
How do I omit blank space in a document created with a template? | anjajane | General Discussion | 5 | October 6th, 2005 10:19 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 |