Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
HELP! Add record to table through VBA
You might try the following: Public NewProcedure(frm as form) Dim ty As Integer Dim tp As Integer Dim ny As Integer Dim np As Integer Dim rs As Recordset Set rs = frm.RecordsetClone rs.MoveLast ty = rs("Year") tp = rs("Period") Call...- JennyS
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
How to 'gather' the records up
I'm not sure why you need to renumber your records, but a suggestion would be create a new table containing your fields with the "Counter" field being an autonumber. Next create an append query sorts your "Item" field decending; and append to the newly created table.- JennyS
- Post #2
- Forum: Microsoft: Access Other topics
