473,322 Members | 1,755 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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 1797
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.dewrote in message
news:fl**********@aioe.org...
>I have access 2003. Tnx.
Jan 6 '08 #3

"Allen Browne" <Al*********@SeeSig.Invalidwrote:

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.dewrote:
"Allen Browne" <AllenBro...@SeeSig.Invalidwrote:

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
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...
3
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...
0
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...
2
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...
10
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...
2
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...
12
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
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...
7
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.