Access Switchboards

[rbutler6]

could anyone please tell me if is at all possible how to put a button on the switchboard so that it will open up my Excel worksheets that are attached to my Access database. The Excel worksheets have my schedule of appointments they are linked to my access database and update when they are changed, but I want to be able to put a button on the switchboard that will allow a user to click the button and open up to the schedule so if need be they can schedule and appointment and at the same time it will update the data base with the new information. all I need is to put button on switchboard to open up the excel spreadsheets.

 

[HiTechCoach]

could anyone please tell me if is at all possible how to put a button on the switchboard so that it will open up my Excel worksheets that are attached to my Access database. The Excel worksheets have my schedule of appointments they are linked to my access database and update when they are changed, but I want to be able to put a button on the switchboard that will allow a user to click the button and open up to the schedule so if need be they can schedule and appointment and at the same time it will update the data base with the new information. all I need is to put button on switchboard to open up the excel spreadsheets.

Welcome to AWF!

Let me turn down my screen .... your post is really load (bold) ...

I would strart by create a function to that uses the Application.Followhyperlink ... to open the excel file

This function should be able to be called from your switchboard.

 

[rbutler6]

Welcome to AWF!

Let me turn down my screen .... your post is really load (bold) ...

I would strart by create a function to that uses the Application.Followhyperlink ... to open the excel file

This function should be able to be called from your switchboard.

This might sound dumb but I don't understand what you mean, I am not very good with access, could you please explain this to me, or show me what you mean.

 

[ajetrumpet]

could anyone please tell me if is at all possible how to put a button on the switchboard so that it will open up my Excel worksheets that are attached to my Access database.

you can't open a linked spreadsheet, can you?

 

[rbutler6]

you can't open a linked spreadsheet, can you?

I don't know, but I am trying to find out. I was told that you need to use VB but I am not a programmer and really don't understand VB this is part of what I was told:

Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True

just don't have the rest and don't know where to put it or how to put it there.