I have a form, set to "Continuous Forms" to kind of give that
spreadsheet feel, but I need it in a Form because my detail section
contains some buttons I need.
In my form header, I have an "Add New Record" button.
Here's my question. I want to get rid of that last empty line. The
one where when I start adding a new record, Access automatically drops
in a last blank to type in. The reason is that when someone clicks
"Add New Record", I populate some of the fields based on other open
forms. When they can just type in the next field, that populating
doesn't kick in... though I guess I could write the code to do that.
Was just wondering if there was a way to disable the showing of that
next blank record. 4 4461
Open your form in design view. open properties and go to the Data tab. Set
Allow Additions to No. This gets rid of the blank new record line. You won't
be able to add a new record at this point.
Where you click "Add New Record", add this code:
Me.AllowAdditio ns = True
You will now be able to add a new record.
Somewhere you will need to put this code:
Me.AllowAdditio ns = False
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1125 users have come to me from the newsgroups requesting help re******@pcdata sheet.com
"igendreau" <ia**********@h ermanmiller.com > wrote in message
news:11******** **************@ j33g2000cwa.goo glegroups.com.. . I have a form, set to "Continuous Forms" to kind of give that spreadsheet feel, but I need it in a Form because my detail section contains some buttons I need.
In my form header, I have an "Add New Record" button.
Here's my question. I want to get rid of that last empty line. The one where when I start adding a new record, Access automatically drops in a last blank to type in. The reason is that when someone clicks "Add New Record", I populate some of the fields based on other open forms. When they can just type in the next field, that populating doesn't kick in... though I guess I could write the code to do that. Was just wondering if there was a way to disable the showing of that next blank record.
It will vary a bit depending on Access version, but go into the form properties. In Access XP, you can set 'Allow Addtions' to no. VBA code can do it too.. igendreau<ia*** *******@hermanm iller.com> February 27, 2006 10:43:18 am >>>
I have a form, set to "Continuous Forms" to kind of give that
spreadsheet feel, but I need it in a Form because my detail section
contains some buttons I need.
In my form header, I have an "Add New Record" button.
Here's my question. I want to get rid of that last empty line. The
one where when I start adding a new record, Access automatically drops
in a last blank to type in. The reason is that when someone clicks
"Add New Record", I populate some of the fields based on other open
forms. When they can just type in the next field, that populating
doesn't kick in... though I guess I could write the code to do that.
Was just wondering if there was a way to disable the showing of that
next blank record.
Worked like a charm. Just changed my code to:
Me.AllowAdditio ns = True
DoCmd.GoToRecor d , , acNewRec
ScopeID.Value = xScopeID
Me.AllowAdditio ns = False
Thanks!!
igendreau wrote: Worked like a charm.
Um, Steve....
Time to change what you write for pseudonyms expressing appreciation... .
You may also want to vary the newsreader as well...
8)
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Armando |
last post by:
I recently saw the tail end of a "Continuous forms" discussion, but not
enough was available to see if this will be a PITA repeat question. Sorry
if it is.
On a form with its Default View set to Continuous Forms, I need to catch the
event when the repeating section iterates for each record in the underlying
table. I have buttons on the repeating section which will get their
captions from the current line in the table, or which will...
|
by: Richard Hollenbeck |
last post by:
I have the following query in my form's code:
Private Function Get_Data(fieldNum As Integer)
Dim strSQL As String
Dim db As DAO.Database
Dim rs As DAO.Recordset
strSQL = "SELECT & "", "" & AS Student,
activities.activityDescription, studentScores.score FROM groups INNER JOIN
(students INNER JOIN (activities INNER JOIN studentScores ON
|
by: Doug Bell |
last post by:
Hi,
I am trying to create form that displays data like an Access continuous
dataform rather than using a data grid.
I am thinking that I can achieve this by creating a row of text boxes, one
for each field I need to display. The creating a controls array for the
first n records I show and populate the text boxes. Then setting up a
vertical scroll bar for the number of records in the data table.
As the scroll bar is clicked or dragged,...
|
by: Edwinah63 |
last post by:
Hi everyone,
Please let there be someone out there who can help.
I have two BOUND combo boxes on a continuous form, the second being
dependent on the first. I have no problem getting the second combo to
change depending on what values the user selects in the first box, it's
just that every time the user changes the first combobox, the second
combobox FOR EVERY RECORD goes blank.
|
by: panwala_bhavesh |
last post by:
Thanks in advance... I have a form displaying the results of a query in
a continuous form style. I want to be able to double-click on the key
field of the form (a textbox, in this case a AssetID) and use this to
populate the AssetID textbox of another form. Any ideas on how to link
these?
Thanks!
Bhavesh
| |
by: Michael R |
last post by:
Searching the net I've found a simple technique to add row numbers and alternate colors (for the even and the uneven row) to a continuous form.
1st step: Create a textbox, send it to background and select the first color.
.ControlSouce =fRowNum(False)
.Name = RowNum
2nd step: Add the following function to the form module: (for row numbers)
Public Function fRowNum(Reset As Boolean) As Long
Static I As Integer
|
by: blueheelers |
last post by:
I have been researching for several hours on the best way to display
images in continous forms in Access 2003. For example, I want to
display employee name, email, phone, and picture for each record in
the recordset. I can have the pictures converted to any usable
format, use OLE or linking, whatever needs to be done.
So far, the 3 possible solutions I have found are:
1) OLE objects - if you don't have bitmaps associated just...
|
by: Lyn |
last post by:
I thought that in an earlier project I was able to click or double-click in
the detail section of a row in a continuous form and use the event to open
a detail form for that row.
However, now a click/double-click in a row's detail section doesn't
generate the relevant click event UNLESS that row is already the current
row (that is, the Record Selector symbol is showing at the left end of the
row). So I guess my thought was wrong.
Of...
|
by: rpboll |
last post by:
I am looking for the best way to accomplish the following continuous
forms concept.
There are Five Groups: A, B, C, D, E
Each group has eight Members: a, b, c, d, e, f, g, h
Each Member is seen as a row in a continuous form like:
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |