IMPLEMENTING MICROSOFT ACCESS SECURITY
- MICROSOFT ACCESS SECURITY OVERVIEW
- Creating a User Account
- Creating a Group Account
- Add Users to Security Groups
- Remove Users from Security Groups
- Deleting a User-Account
- Deleting a User-Group-Account
- Create or Change Security Password
- Clear Security Password
- Assign or Remove Permissions
- Assign Default Permissions
- View/Transfer Ownership of Objects
- Transfer Ownership of Database
- Set Permissions to Run/View Query
- Default Permissions for new Query
- RunPermissions Property
- Converting Database Old-Versions
- Converting Old-Version Workgroup File
- Sharing Previous Version Database
TIPS & TRICKS
Creating 3D Text on Forms/Reports
Creating 2D Text with Borders on Forms/Reports
Creating 3D Text with Borders on Forms/Reports
Creating 3D Text with customizable Shadow setting
Using Office-Assistant with MessageBox
How to use Common Dialogue Control (File Browser) in MS-Access
How to create a Reminder Ticker on Form
How to Import/Export Microsoft Access Objects using VB Code.
How to Create an Excel File from Microsoft Access and write data into it.
How to create a Word File from Microsoft Access and write text into it.
How to create a Text File using FileSystemObject.
How to Rename File using FileSystemObject.
How to display Drive, Folder and File information using FileSystemObject.
Sir,
How to use Goto Record Next function that it will access or display all records that having the same primary key?
Example: i have a button name Goto next, when I click the button it will make to display a record in a textbox, then all of the record to be displayed have the same primary key it is the EOF it will loop again.This is like a generate button of a keygen. Hope you will help me.
This is my two table:
DB 1
SoftID
Software
Name
DB 2
KeyID
SoftID
Key
I have created a relationship.In one Software many Keys.
It is easier to display all records matching a particular key-value (like displaying all items pertains to a particular Purchase Order Number) by designing a Main-Form and Sub-Form combination. Link both Forms in Link Child fields & Link Master Fields Properties on OrderID.
You can see an example Form in C:\Program Files\Microsoft Office\Office11\samples\Northwind.mdb Database. Open this database and open the Form with the name Orders. This form has a Sub-Form inserted as datasheet form that is designed on Order Details Table. When the Order Number of the Orders form changes all records belongs to the new Order will appear in Order Details form.
You can learn a different method involving VBA by visiting the page:http://www.msaccesstips.com/2009/12/filter-with-buildcriteria-function/
Luved it :)