Is there a way that, when using a single or continuous form which
allows additions and edits, I can detect when I am entering a new
record (eg moved on to *) rather than editing an existing one?
In general, while wanting edits to be allowed, I want to be able to
warn if certain fields are being edited unexpectedly, but not do this
while a new record is being entered.
It's to avoid the sort of situation where someone thinks they are doing
a filter by form but accidentally types all over an existing record (is
it only me that people do this to?).
2  3894 
On 2 Nov 2005 03:00:30 -0800, "MIG" <go********@doreenbird.co.uk> wrote: Is there a way that, when using a single or continuous form which
allows additions and edits, I can detect when I am entering a new
record (eg moved on to *) rather than editing an existing one?
In general, while wanting edits to be allowed, I want to be able to
warn if certain fields are being edited unexpectedly, but not do this
while a new record is being entered.
It's to avoid the sort of situation where someone thinks they are doing
a filter by form but accidentally types all over an existing record (is
it only me that people do this to?).
IF Not Me.New Record Then (existing record)
IF Me.NewRecord Then (new record)
Wayne Gillespie wrote: On 2 Nov 2005 03:00:30 -0800, "MIG" <go********@doreenbird.co.uk> wrote:
Is there a way that, when using a single or continuous form which
allows additions and edits, I can detect when I am entering a new
record (eg moved on to *) rather than editing an existing one?
In general, while wanting edits to be allowed, I want to be able to
warn if certain fields are being edited unexpectedly, but not do this
while a new record is being entered.
It's to avoid the sort of situation where someone thinks they are doing
a filter by form but accidentally types all over an existing record (is
it only me that people do this to?).
IF Not Me.New Record Then (existing record)
IF Me.NewRecord Then (new record)
Aha; thanks.
(As a last resort, try the bleedin obvious, but I never spotted that.) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Stephane Belzile |
last post by:
Is there a way I can detect in vb.Net the power has switched to a UPS
unit in case of power failure?
Thanks
|
by: Victor |
last post by:
I've been to a few websites where it displays the town, state (if USA),
country I'm browsing from. Now, I know that detecting country is easy, but
how do you determine the town?
What ASP...
|
by: Bogdan Zamfir |
last post by:
Hi,
When users TAB to a field, I want it not to select all field content, but
instead go to either begin or end of the field. This because sometimes user
TAB to a field then type something by...
|
by: Chris |
last post by:
Can anybody tell me how to detect is the user has closed the browser
Thank you
|
by: Aaron Smith |
last post by:
I have a parent table that has one child table. The parent has a single
field (ID, AutoIncrement, Seed 0, Step -1 in the DataSet, Seed 1, step
1, in DataSource). The child is linked to this ID...
|
by: Rich |
last post by:
Hello,
I need to trap/detect when a textbox is entered via the tabkey. If the
textbox is not empty when entered via the tabkey then set focus to next
textbox. To enter that textbox would then...
|
by: Ron |
last post by:
Hi All,
Using Access2000, winXP.
Table 1 = tblClients displayed on frmClients via qryClients. 2nd table =
tblInvoices shown on frmInvoices via qryInvoices. 2nd table = tblDetails
shown on...
|
by: Dst |
last post by:
This is what i'm trying to do:
I'm porting a windows app to a web app.
I have a webform which will edit some data stored in a database.
The data needs to be locked in the database, while editing....
|
by: rsmccli |
last post by:
Access 2002
Hi, I have a number of comboboxes/textboxes in the header of a form that the user selects values from. These comboboxes/textboxes correspond to controls in a datasheet view subform....
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
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,...
|
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...
|
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...
|
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...
| |
