Search results

Actually i open this scenario just open the big picture of possibilities on how to accomodate this concern. I observed topics concerning deletion and one experience here told that he is not agree about deleting data instead it must be stored in archive table. Now, for the seek of argument i open...

Ang lupit mo sobra sir. e try ko ngayon ito sir.

Thank you so much sir

Thank you so much sir.

That's great idea sir. Timestamp well help also to track the transaction and possible to recall.

Thank you sir.

The reason for this is you i share the single frontend into more than one user. I mean, you share the folder which you can access the frontend shortcut and once one user will open that frontend i will become locked to other users. However if you put a copy of the frontend to each user computer...

Since that's splitted database. Share your frontend copy to each user computer and relink to backend. Make sure to save as accde and disable shift after your relink the backend. Maybe you just share the frontend shortcut to the user not the frontend itself.

As long as that particular table record has a FK that bind them with Main transaction table PK like ogrenci-id then you can do same process but add another declaration.

You welcome brother. But you must also consider the opinion of sir @ Pat Hartman since he had a great experience and expertise concerning that issue.

what i mean sir is that. I have one table name: tblArchive. now i have other tables like - Purchase Order/Details - Inbound (ReceivedItems) and outbound(Issued Items) and so on. So If I delete records in any those tables for some reasons then that should be store in tblArchive.

Is it possible to dedicate one table (tblArchive) and all deleted records from any transaction will save there. Thank you for any possible way on how to achieve. I try append and delete query but i need to make to all transaction tables since fields are not identical.

Thank you sir so much for that sir @ Pat Hartman it's my pleasure to know that since im still in the level of learning process. I just share which working on my part for the sake that he maybe get some possible solution but not absolute.

Try this brother: Private Sub cmdDelete_Click() Dim lngID As Long Dim lngID1 As Long Dim lngID2 As Long Dim strSQL As String Dim strSQL1 As String Dim strSQL2 As String DoCmd.SetWarnings False lngID = ogrenci_id.Value lngID1 = ogrenci_id.Value lngID2 = ogrenci_id.Value DoCmd.runSQL "DELETE...