Recent content by Ramzi

  1. R

    Save the names of tables, forms, and reports in a Microsoft Access database to a table named "ObjectNames.

    Thanks Pat Hartman i done the same and got my issue resolved.
  2. R

    Save the names of tables, forms, and reports in a Microsoft Access database to a table named "ObjectNames.

    Guys! Basically i have a table ID ObjectType ObjectName HasAccess I want to get the names of all Forms and Reports in this table instead typing one by one. Anyone who can help me to get ride on it.
  3. R

    Save the names of tables, forms, and reports in a Microsoft Access database to a table named "ObjectNames.

    Actually i want to save the names in my own table to give the permission for users where authorized users can access the forms reports.
  4. R

    Save the names of tables, forms, and reports in a Microsoft Access database to a table named "ObjectNames.

    Public Sub SaveObjectNames() On Error GoTo ErrorHandler Dim db As DAO.Database Dim obj As AccessObject Dim strSQL As String Dim rs As DAO.Recordset Dim objectName As String ' Open the current database Set db = CurrentDb ' Loop through each...
  5. R

    Save the names of tables, forms, and reports in a Microsoft Access database to a table named "ObjectNames.

    Please look into my code and correct where i'm worng?
  6. R

    Save the names of tables, forms, and reports in a Microsoft Access database to a table named "ObjectNames.

    Public Sub SaveObjectNames() On Error GoTo ErrorHandler Dim db As DAO.Database Dim obj As AccessObject Dim strSQL As String Dim rs As DAO.Recordset Dim objectName As String ' Open the current database Set db = CurrentDb ' Loop through each...
  7. R

    Introduction

    Hello everyone, This is Muhammad Rameez from Pakistan. New to access.
Top Bottom