Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2008
    Location
    Los Angeles
    Posts
    5

    Have database open automatically

    I would like my database to open automatically when I double click on the shortcut icon on my desktop.



    Can anyone tell me how to do this?

  2. #2
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Location
    Chicagoland
    Posts
    109
    Are you trying to create a shortcut on your desktop? Are you using Windows? If so, go to your database in Windows Explorer or My Computer, right click on it, select 'Sent To' and then click on Desktop (create shortcut).

  3. #3
    Join Date
    Jan 2008
    Location
    Los Angeles
    Posts
    5

    Access opening automatically

    No, I already have a shortcut on my desktop. When I double click on it, I would like the information to appear automatically.

  4. #4
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Location
    Chicagoland
    Posts
    109
    What do you want to see when it opens? What do you now to get to where you want to go?

  5. #5
    Join Date
    Jan 2008
    Location
    Los Angeles
    Posts
    5

    Access opening automatically

    I have my address and telephone directory set up in an Access table. I would like to double click on the shortcut and have the entire table (showing the data) show up on my screen.

    Right now when I double click on the shortcut, Access opens with this rectangular image in the center of the screen entitled, "Norman's Address and Telephone Numbers: Database". Underneath that are several tabs in the following order: "Tables", "Queries", "Forms", "Reports", "Macros", "modules". To the right of these are the options to click, "Open", "Design", "New".

    To open my directory to get the phone number I want, I have to make sure that "Tables" is selected and then I have to click "Open".

    I would like to have the database open automatically, without having to make sure that "Tables" is selected and to click "Open". I would like to be able to double click on the shortcut and -- whallah -- it's open.

  6. #6
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Location
    Chicagoland
    Posts
    109
    I don't believe you can have a table open automatically.

    However, you can have a form open on startup. You could create a form with your table data. For instance, you could create a AutoForm: Columnar and choose the table you want to be able to view. Under the 'Tools' menu go to Startup. Under Display Form/Page, you can select the form you just created. The next time you open the database, this form will automatically open.

    Hope this helps.

  7. #7
    Join Date
    Jan 2008
    Location
    Los Angeles
    Posts
    5

    Table opens automatically

    I have just tried what you suggested and quite liked the Form format because it allows me to see more information for that particular entry. Thank you.

    However, let me tell you that it is possible to have a Table open automatically. Years ago I achieved this and continued to experience its benefit since then.

    But recently my computer crashed. And when I retrieved my data from the CD, I found that this Table did not open automatically anymore. I tried, but couldn't remember, for the life of me, how I did it.

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

Similar Threads

  1. Replies: 0
    Last Post: 11-10-2008, 12:32 PM
  2. Form will not open
    By dserbanescu in forum Forms
    Replies: 0
    Last Post: 01-09-2008, 09:48 AM
  3. Open form in another database
    By Karyn-2000 in forum Forms
    Replies: 0
    Last Post: 04-19-2006, 10:17 AM
  4. automatically create queries
    By GEORGIA in forum Programming
    Replies: 8
    Last Post: 01-23-2006, 02:35 PM
  5. 'On Open' Property
    By emilylu3 in forum Forms
    Replies: 1
    Last Post: 12-08-2005, 02:28 PM

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