back button on switchboard

[AWilderbeast]

is it possible to create a back button on your switchboard so from your main switchboard your subwitchboards or your sub sub switchboards you just click the back button to go the the previous switchboard?

 

[adam.greer]

Hi

I'm not sure if there is a 'back' button.

However I simply create a macro that opens a new form and closes the one your currently on. Then label this buttons as 'Back'

For the end user it's exactly the same, although it can be a bit long winded if you have lot's of buttons.


Anyone know of a 'back' button?

 

[AWilderbeast]

but im trying to use this button on a switchboard. so it wouldnt work on sub-sub switchboards if you know what i mean.

Im after a button that will go the the previous switchboard

 

[Rod D]

I use this all the time...

Hi

Open the Switchboard Manager as usual, then...
Create a new switchboard entry - Give it an appropriate name and set it to open a switchboard item - then select the switchboard you want to switch to.

I have attached a screedump to illustrate...

Regards
Rod

 

[AWilderbeast]

That is how i have it set up now, but the people im creating the db for want a button in the bottom right of the switchboard to go back instead. They say its confusing having it in the list as they may end up clicking it by accident. I know its finikey but its what there after

 

[Pat Hartman]

They may click it by accident regardless of where it is.

I like the go back to stand out so what I usually do is modify the switchboard form so that the last button is separated slightly from the 7 above it and I insert a sunken line to make the separation even more obvious. Then I assign the go to switchboard item to #8.

Warning - when you do this, you'll need to be very careful when using the switchboard wizard because if you add a new item to a page, it will give it the next available number which will be #9. Move it up in the list so that its number is changed to be less than 8 or open the [Switchboard Items] table and do it manually.

 

[AWilderbeast]

what if you dont have 8 items in every swtichboard?

 

[Kempes]

I have implemented a back button in my db,

Basically I created an unbound form that has an unbound text box. When firing up the db, it opens this form and hides it so users can't see it.

All you need to do then is for each button pressed, add some vb code to post the form name you are going from into this hidden forms text box.
In the back button on click code, refer to this value.

eg

If the hidden form is called backform and the text box is called back, on each button pressed the code to enter would be

Backform.back.value = "Formname"

Then the code for the back button would be

Docmd.close acform etc
Docmd.openform Backform.back.value

Hope this helps

 

[AWilderbeast]

my knowledge of vb is almost none existant, if you an could you give me an example db pleasse?

 

[Pat Hartman]

what if you dont have 8 items in every swtichboard?

I thought I explained that. Open the Switchboard Items table and make the last item in each switchboard has an ItemNumber of 8.

 

[AccessJunkie]

Interesting question and one in which I definitely have not seen before. I still think just using the built in functionality of the SBM to go to a Switchboard Page is much easier, but it's your call. I did some testing and have come up with something that seems to work Ok for you.

I will upload a sample file on my SBM page here this evening sometime:

http://home.bendbroadband.com/conradsystems/accessjunkie/switchboardfaq.html

One thing to note is that you should *not* put an option on the sub menus and sub-sub menus to go back to other pages because it will throw everything off in this sample. The code I put together uses a small table to build a "trail of breadcrumbs" so to speak. As you go down to sub menus and sub-sub menus, the table is keeping track of where you are going. Clicking the Back button in the bottom right corner takes you back up to the main menu one back step at a time. As far as I can tell you can go as "deep" as you want with the sub menus and it appears to work just fine.

The sample file has some entries in the Switchboard Items table for you to see the technique in action. Open the Switchboard form and try it out. You will need to import the Switchboard Form and the table called tblSBM from the sample file into your database in order for everything to work in your file.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

 

[AccessJunkie]

Okie Dokie, it's all here for the taking now:

http://home.bendbroadband.com/conradsystems/accessjunkie/switchboardfaq.html#back

Hope it helps.
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

 

[AWilderbeast]

thanks there just what i wanted, ive done wht it said to do but what do i put for this bit

A Reference must be set to the DAO Object Library as well. (from the site)

(from the form)

Private Sub FillOptions()
On Error GoTo ErrorPoint

' Fill in the options for this switchboard page
Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Dim strSQL As String
Dim intOption As Integer
Dim dbsCount As DAO.Database
Dim rstCount As DAO.Recordset
Dim intI As Integer

 

[AccessJunkie]

Hi,

Here is some past info on this subject I have posted in the NGs before:

>>>>>
It sounds like you need to set a reference to the DAO object library if you are using Access 2000 or 2002. Those versions do not by default set a reference to the DAO library.

To fix the References problem follow these steps:
- Open any module in Design view.
- On the Tools menu, click References.
- Scroll down till you get to Microsoft DAO 3.xx and check it.
- If you're using Access 97 that should be DAO 3.51 Object Library.
- If you're using Access 2000, 2002, or 2003 that should be DAO 3.6 Object Library.
- Close the References box again.
- Now re-compile again. Debug--Compile.
>>>>>

Hope that gets you going,
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html