JithuAccess
Member
- Local time
- Today, 03:57
- Joined
- Mar 3, 2020
- Messages
- 325
Hello guys,
Is there any method to hide the Records in a Table on a Button click Event?
When a user click on a command button a Table will open and user would be copying data from an Excel spreadsheet to Access Table. This is my Code:
In this Table there are more than 11,000 Records. I want to hide all these Records from this table when a user click on the command button. So that users won't overwrite in an Existing Record (By mistake). Can we do this?
Thanks
Is there any method to hide the Records in a Table on a Button click Event?
When a user click on a command button a Table will open and user would be copying data from an Excel spreadsheet to Access Table. This is my Code:
Code:
DoCmd.OpenTable "tblTest", acViewNormal, acEdit
DoCmd.GoToRecord acDataTable, "tblTest", acNewRec
In this Table there are more than 11,000 Records. I want to hide all these Records from this table when a user click on the command button. So that users won't overwrite in an Existing Record (By mistake). Can we do this?
Thanks