If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Is there a VBA method for copying a single record in form view?
I want to copy the last record of a table (while in form view). How?
|
#2
|
|||
|
|||
Is there a VBA method for copying a single record in form view?
Access doesn't really have a concept of "last record of a table". Tables are
unsorted sacks of data: Access will stick records wherever it wants. The only way to ensure order is to use a query with an appropriate ORDER BY clause. Assuming you've got an appropriate ORDER BY clause, you can use the TOP 1 predicate. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Mac Hardy" wrote in message ... I want to copy the last record of a table (while in form view). How? |
Thread Tools | |
Display Modes | |
|
|