Search results

Good afternoon, I wonder if someone out there could help please? I am trying to copy one record from my table to a new record. I found an example on this forum in relation to another question which appeared to meet my requirements. I want to copy a previously entered record and assign it with...

oh no! Thanks Dag! Sorry @arnelgp, as Dag has said, it works perfectly, if you use it as intended! i need to change a few things on my forms to prevent others from making the same stupid mistake as me, but other than that, a big shout out to @arnelgp for all of his help. Thanks also Manic for...

Hi @arnelgp, thanks for you message. sorry, perhaps I haven’t explained myself (my wife always complains about that!) In the Reporting form, if I use the record arrows to select record 1, with the following data in the 6 fields: accident 1, Dave, Date, aaa, bbb and a revision number of 1. I...

I am afraid that there still seem to be an Issue, in that each time revision is posted, it overwrites the previous info as well as copying itself as intended. I have replaced the data in the op’s table to more easily understand what is happening, I made 6 entries, Accident 1 through Accident 6...

Hey @arnelgp, thank you so much for your answer and for taking the time to look at this for me. I really appreciate your efforts. I will do some testing later. once again, thank you

@arnelgp Thank you very much for you answer, I have tried to modify your code into my project. The serial number and report number work correctly, so thank you!, but there seems to be a problem with the info in the boxes named Text 1, Text 2 and Text 3. I entered the info using the new record...

Sorry, code referenced is in post #2 of this thread Quackers

Hello, please excuse me if jumping into someone’s post is not allowed.... I would like to do something similar to what the OP has asked, I have already looked at the Audit trail and this is not what I want. @arnelgp has suggested some code which would suit my project, however, from my limited...

Hello everyone, I am from the UK. I am very new to Access, did some work with Excel Macros many years ago, trying to work on a project in Access, now, really struggling with what is probably some very easy stuff! will try not to make too much of a nuisance of myself Quackers