473,769 Members | 7,923 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How I can start last edited record in my form?

Hello.

How I can start my M$ access form with last edited record? What I must put
in "on load" field?

Tnx. for advice.

Jan 6 '08 #1
4 1815
I have access 2003. Tnx.
Jan 6 '08 #2
See:
Return to the same record next time form is opened
at:
http://allenbrowne.com/ser-18.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"SoulSeeker " <gp*@bce.dewrot e in message
news:fl******** **@aioe.org...
>I have access 2003. Tnx.
Jan 6 '08 #3

"Allen Browne" <Al*********@Se eSig.Invalidwro te:

Msg ID: news:47******** *************** @per-qv1-newsreader-01.iinet.net.au ...
See:
Return to the same record next time form is opened
at:
http://allenbrowne.com/ser-18.html
Thank you very much Allen. Have a nice day. :)

Jan 6 '08 #4
On Jan 6, 4:40*am, "SoulSeeker " <g...@bce.dewro te:
"Allen Browne" <AllenBro...@Se eSig.Invalidwro te:

Msg ID:news:47***** *************** ***@per-qv1-newsreader-01.iinet.net.au ....
See:
* *Return to the same record next time form is opened
at:
* *http://allenbrowne.com/ser-18.html

Thank you very much Allen. Have a nice day. :)
This can be modified to save the last edited record on a per user
basis by adding the appropriate user identifier to the tblSys table.
Can be handy in a multi-user environment.
Jan 8 '08 #5

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

Similar topics

1
680
by: sixsoccer | last post by:
I have built a database with a <Mainform> and a <Subform>. My problem is twofold. 1. My subform is set as a continuos form with AllowAddiotions set to NO (ie. a list of Issues to the client on the mainform) 2. To add new issues, a button is used and a pop-up form is used to add an issue with more detail than what's available on the subform. 3. On accepting the new Issue from the pop-up the pop-up closes and you are returned to the...
3
23936
by: BLUE WATER | last post by:
Hi, I have managed to simplify my problem but can't seem to get this to work. I want to open up a form from a click event of another form, but not only open the form when the button is pressed but also move to the last record. DoCmd.OpenForm "My-Form-Name", acNormal Opens the form with no problem.....
0
1939
by: ethanj /personal/ | last post by:
We are using Access 2000 database, with the following settings. Tool > Options > Advance > Default Record Locking = Edited Record Open databases using record level locking = True Form property > RecordLock = Edited Record. However, the record is still NOT locked. Multiple users can still open
2
2506
by: Patrick Fisher | last post by:
Hi To display a message when a user attempts to edit a record in a multi-user environment where a forms Record Locking is set to Edited Record and another user is editing a record, is difficult because Access does not trigger an error, I have overcome this problem by trapping the Delete and Backspace key in the KeyDown event of the form and displaying a label on the form saying "If Record cannot be Edited it may be that Another User is...
10
3736
by: Lyn | last post by:
I have a form set to Single Form mode with which I can cycle through the records in a table via Next and Previous buttons. To avoid users pressing the Previous button on the first record and the Next button on the last record, I would like to disable one or both buttons when the first and/or last record is displayed. I am not sure how to do this when the RecordSource is simply the table. I know that if the record source were a...
2
2183
by: cbremar | last post by:
Is there a way to do this. Currently, you can have multiple users editing the same record and not until they try to save it does it tell you that the record is being edited by another person. I want to make the record 'non-viewable' is it's already being edited by another user. Can anyone help?
12
10949
by: daniel | last post by:
Hi All, I have a form and VB code in Access. The code is like With rs .Edit !Field = 10 .Update End With
1
1497
by: Chris | last post by:
I have a query which I use to edit a table and a column that I type the date that I edited the perticular record in the table. Is it possable for the date to change automatically when I edit the record?
7
1650
by: USBZ0r | last post by:
Hi there guys! Im struggling to find a way to select all rows from a MySQL table that were edited within the last 2 minuites. When the user edits their profile, it time stamps it. So all i need to do is fetch all rows that were time stamped within the last 2 minuites of the current time. anyone have any ideas how it would be done in PHP/SQL? Thanks
0
9589
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10216
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...
1
9997
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,...
0
9865
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
8873
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
7413
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
5310
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3965
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2815
bsmnconsultancy
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...

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.