Forum Home
Press F1
Thread ID: 13607	2001-12-09 10:11:00	MS Access Macro	Guest (0)	Press F1

Post ID	Timestamp	Content	User
27130	2001-12-09 10:11:00	I have a lot of info to enter into an Access dbase and several entries are duplicates. I would like to use a macro or similar to enter these duplicates from a Function key or similar quick method. I once prog'd in ASCII but age has caught up. I use both 95 & 2K Versions of Access. Any help will be appreciated. Thanks.	Guest (0)
27131	2001-12-09 10:40:00	Complex but.... Dump the data in Excel, sort by appropriate column, run an IF function eg =IF(A1=B1,'yes',0. Scan the column and delete the extras. Import into Access.	Guest (0)
27132	2001-12-09 10:48:00	Drat. Have reread your post and see you want to enter them, not delete them <Disappears in direction of Access> Complete one record, highlight row, copy then paste.	Guest (0)
1