Thank you Arnelgp, it work now. My mistake, I missed your first line of edited code where you declared Dim ID As Long. After including that, it runs perfectly, thank you again!!
Thank you Arnelgp, it work now. My mistake, I missed your first line of edited code where you declared Dim ID As Long. After including that, it runs perfectly, thank you again!!
Thank you Gasman, I understood I was calling up the record set to see the last record that was used by that p, then copy all the data from that set. So I need to do a call on the whole record set.
I'm not sure what TOP1 is but will do the research on that now.
Many thanks!!
Many thanks...
Hi all, I have a database that I have been using for years that is entirely based on macros and core functionality. I am now trying to improve its functionality and efficiency with VBA . The database records all transactions such as expenditure and deposits, loans across cash, direct debits...
I have been using Access Data bases for 2 decades and feel very comfortable developing solutions that use basic functionality and macros. But recently, I have decided to add that extra level to some databases that I have used for ages; I'm trying to learn VBA. So I'm a newbie VBA in an old...