Some days I swear I forget how to read! To answer your question, "can I just do all this in Access?" Maybe you can, but it would be infinitely easier...
How many record in the append query? If you want to use your existing function you will need to loop at some point, either append the records one by...
hi, the table name changed this week for the first time, they are usually Table006 and table007 when they are two (rarely but can happen), now i got...
Normal way is to store the last used and add 1 to that.
However as you are using @@identity, you may as well use the autonumber, providing you never...
Not sure if it will work but you could try translation on the fly through google translate. I dont have arabic and it didnt work for me in arabic but...