473,883 Members | 2,233 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Adding new record in continuous form appears to produce records

I am developing an Access application where users insert bill records
for an electricity account by clicking on a new button. The required
workflow is
1) New button clicked
2) New record appears with some field populated per defaults for
account and some based on previous records - eg dates
3) Save button clicked
4) Record validated and saved if it passes validation.

I have three issues as follows

1) I am using a subform with a continuous form view. The problem is
that when a new record is added, as soon as default values for fields
are entered, a duplicate record appears which I don't want. I know that
it has something to do with allowadditions but I am confused how to
incorporate this.

2) I also want the new record to appear at the end of the record list
for that account with all the other records showing. I have used the
data entry property, but it sets the focus on the first record and the
user needs to scroll to the end.

3) What is the best way to keep the user on the editted/new record
until they save or cancel?

Thanks in advance.

Aug 30 '06 #1
1 5935
Catriona schreef:
I am developing an Access application where users insert bill records
for an electricity account by clicking on a new button. The required
workflow is
1) New button clicked
2) New record appears with some field populated per defaults for
account and some based on previous records - eg dates
3) Save button clicked
4) Record validated and saved if it passes validation.

I have three issues as follows

1) I am using a subform with a continuous form view. The problem is
that when a new record is added, as soon as default values for fields
are entered, a duplicate record appears which I don't want. I know that
it has something to do with allowadditions but I am confused how to
incorporate this.
Reading this as: as soon as you start entering data in the visible
record, Access displays the next new record below. Hmm... that is pretty
default behavior. Switched off by disallowing additions, but you do want
to enter data in the first place.
2) I also want the new record to appear at the end of the record list
for that account with all the other records showing. I have used the
data entry property, but it sets the focus on the first record and the
user needs to scroll to the end.
Answering these two questions in one. I advise you set AllowAdditions
for this form to False, and have the user enter a new record by means of
a button (which you must wire to insert the new record, and issue a
docmd.gotorecor d to it)
3) What is the best way to keep the user on the editted/new record
until they save or cancel?
Um... how about an extra field, presumably a boolean, that defaults to
false; and a table validation rule that states that this field must be
true? You can always cancel the entry by pressing Escape, if that's okay
with you; and if you want to save, use another button, that first puts a
True in our hidden field, and saves the record consequently.

I hope it makes sense! And if it doesn't, be sure to ask.
--
Bas Cost Budde
Holland
Sep 18 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
3185
by: Kathy | last post by:
What is the standard technique for handling the fields in the following scenario on a continuous form? Multiple Divisions. Each Division has multiple Buildings. Each Building has a Supervisor. Tables: (abbreviated) TblDivision DivisionID
2
4711
by: vulcaned | last post by:
Hi All, Hopefully I explain/ask my question correctly; In Access97 on a continuous form I display records direct from a table. Two displayed fields are policy nbr and a approved checkbox. In the displayed records I could have multiples of any given policy nbr. What I am hoping I can program is when a user clicks in the approval checkbox(makes it true) I then want to check off the rest of the approval boxes for that Same policy nbr that...
14
8272
by: Mark | last post by:
How can the instances of a textbox control on an continuous form be addressd? Can a specific instance be addressed? For example, a continuous form has ten records. How can the textbox for the eighth record be addressed? Thanks, Mark
6
15830
by: Prakash | last post by:
Hi !! In a Continuous Form with say 10 records, I'd like to have 1 button with an "UP" Arrow & another button with a "DOWN" arrow. By pressing either the Up or the Down Arrow, I'd like the user to be able to MOVE the records up or down the order. Something like in a WinAmp or MusicMatch Playlist. A little sample code would be much appreciated.
20
10851
by: Robert | last post by:
Need some help to stop me going around in circles on this one.... Have a nested subform (subform2) which simulates a continuous form for the record on the parent subform. Subform2 has rows of either an option button plus two text fields or a checkbox plus two text fields Am wanting to save the user entries into an underlying table. Tag property for each option button, check box or text field has the value of the key
3
3935
by: ApexData | last post by:
I am using a continuous form for display purposes. Above this form, a single record is displayed so that when the user presses my NewButton they can enter a NewRecord which gets added to the continuous form that displays below. Under the NewButton I have these lines of code: Me.AllowAdditions = True DoCmd.GoToRecord , , acNewRec
13
3469
by: eighthman11 | last post by:
using Access 2003 and sql server version 8.0 Hey everyone. Created a text box where the user types in an Inventory number and it takes them to that inventory number on the contimuous form. The form is based on a link table to sql server. Here is the code: Dim rst As DAO.Recordset Dim InventoryItem As String InventoryItem = "'" & "TextBoxValue" & "'"
1
1601
by: Steve | last post by:
This may be a dumb questions please forgive I have a form that shows a list box that links to a table with 7 employee names The form does not show employee key. When adding record to master table I only need to add employee key. So if I've entered a record for John Doe who has an employee key of 4. How do I insert the number 4 into my master table? The user selected John Doe in the box.
4
2282
by: Adam Tippelt | last post by:
Situation: I'm using a continuous form to display a lot of information stored in a datasheet. I'm using the form because it allows me to display multiple rows of information per 'record' which is needed as some of the records have a lot of text. However, I've needed to apply both a form of filtering system, and a way of re-ordering the form so that it is alphabetical/numerical order, depending on whiching heading is clicked. I have achieved...
0
9798
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,...
0
11160
Oralloy
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...
0
10766
jinu1996
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...
0
10422
tracyyun
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...
0
9588
agi2029
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...
1
7978
isladogs
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...
0
7136
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
6007
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4230
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.