Update data (1 Viewer)

M

Mina Garas Daniel

Registered User.

Local time

Today, 16:32

Joined

Jul 21, 2017

Messages

66

• Jul 21, 2017

• #1

Hi everyone
I'm new in this great forum
I need to update my data using form by write item code in search text box
then find the item then make update on data after that i need to save the item data with new code for example if the item code is 1 (coding by auto number field) , i want to save the item with code 2 ( by auto number field also) after update data or change data

How can i do that"
can any body help

I attached my database (2007) in post

Thanks
MG

 

Attachments

• Tial HOD Database.accdb

  1.4 MB · Views: 47

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 15:32

Joined

Jul 9, 2003

Messages

16,280

• Jul 21, 2017

• #2

Leave the auto number Field alone. Create separate field for your ID.

 

M

Mina Garas Daniel

Registered User.

Local time

Today, 16:32

Joined

Jul 21, 2017

Messages

66

• Jul 21, 2017

• #3

@Uncle Gizmo , thanks but after i separate the ID how i can update that Data by append query or update query

 

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 15:32

Joined

Jul 9, 2003

Messages

16,280

• Jul 21, 2017

• #4

Something like this:-

https://www.access-programmers.co.uk/forums/showthread.php?t=156665

 

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 15:32

Joined

Jul 9, 2003

Messages

16,280

• Jul 21, 2017

• #5

For more Ideas see the results of this Google Search on "ID" AND "DMAX"

Paste ALL the Following in the Search Bar
ID DMAX site:http://www.access-programmers.co.uk/forums/

 

Last edited: Jul 21, 2017

M

Mina Garas Daniel

Registered User.

Local time

Today, 16:32

Joined

Jul 21, 2017

Messages

66

• Jul 22, 2017

• #6

Dear uncle gizmo

Firstly thank u for the information
Secondly i try dmax but i need your help to adjust the item with new id because when i use dmax all column return to Max ID+1 as example all records become 9