Results 1 to 6 of 6
  1. #1
    wasim_sono is offline Advanced Beginner
    Windows XP Access 2013 64bit
    Join Date
    May 2005
    Location
    Pakistan
    Posts
    73

    Hide the Database window

    How can I hide the databse window. I created an application which is driven by switchboard. Now I want that the user could not open the table , form , macro etc. For this I want to hide databse window and Menu bar. If I customize the menu bar then it will apply on all MS-Access software or only on this particular databse?



    Please help me!!!


    Thanx.

    Wasim

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    In the menu, under tools, select startup options. One of the options is to hide the database window.

    BTW, if the db window is hidden, to unhide it hit F11.

    Patrick

  3. #3
    wasim_sono is offline Advanced Beginner
    Windows XP Access 2013 64bit
    Join Date
    May 2005
    Location
    Pakistan
    Posts
    73
    Thanks

    Is it possible to hide it permanently? I also want to inquire something new. I posted it before but not found any answer. I don't know the right forum to place it. Please accept my appology in advance.

    I have a master table having employees basic data. Now employees done some courses. I design a form based on a new table. For time saving I want that as the user enter the emp no, the system fetch basic record of that employee from master table i.e. Designation, Grade, Deptt etc. and then the cursor jump to next field of course.
    How it will works? Pl. help I'll be verry thankful to u.

    Wasim

  4. #4
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    Quote Originally Posted by wasim_sono
    Is it possible to hide it permanently?
    Perhaps, but I am not sure how to do it. Even if I did know, I would still caution you against it.

    Quote Originally Posted by wasim_sono
    I have a master table having employees basic data. Now employees done some courses. I design a form based on a new table. For time saving I want that as the user enter the emp no, the system fetch basic record of that employee from master table i.e. Designation, Grade, Deptt etc. and then the cursor jump to next field of course.
    Presumably you have at least three tables:

    tblEmployees <basic employee data>
    tblCourses <data on courses available>
    tblEmployeeCourses <data on the courses each employee took>

    Based on a design like that, I would set up a form based on tblEmployees using a subform based on tblEmployeeCourses, with the form and subform joined on the EmployeeID. That would allow you to see the basic employee info as well as the list of courses that employee has taken.

  5. #5
    wasim_sono is offline Advanced Beginner
    Windows XP Access 2013 64bit
    Join Date
    May 2005
    Location
    Pakistan
    Posts
    73
    Thanks Patrick

    Its a very good idea but how can make a record of tbltrans that contains basic information from tblEmpl + tblcourses+tbltrans?

  6. #6
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    I'm not entirely sure what you mean. In any event, I would probably need you to provide a sample of your database.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Hide zero value in report and date syntax
    By Alex Motilal in forum Access
    Replies: 0
    Last Post: 11-16-2008, 09:11 AM
  2. Replies: 0
    Last Post: 12-31-2007, 11:12 AM
  3. Replies: 1
    Last Post: 12-06-2006, 05:32 PM
  4. Set IE window size using followhyperlink
    By AndrewAfresh in forum Access
    Replies: 0
    Last Post: 11-23-2006, 12:22 PM
  5. Use fixed height and width for the Access window
    By AndrewAfresh in forum Access
    Replies: 3
    Last Post: 07-05-2006, 09:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums