Two Access Questions - Please help!

[Guest]

Question 1:
I have nested switchboards within switchboards for the database I've
created. I just had Access create the default switchboard for me. How can I
change the settings to get the main switchboard to open again if I have
opened a switchboard?

Question 2:
Is there a way to put ONLY the MONTH (i.e., July and not July 2005) on my
report. I would like for it to run off of a variable unbound text box that's
in my switchboard, but if that's not possible then is there something else?

 

[Pat Hartman]

1. on the second switchboard, add an entry that goes to the first
switchboard.
2. If your tables contain more than one year's worth of data, you will need
to include year in the criteria or July from ALL years will be returned. If
you are talking about showing only the month part of a data field, just set
the format to mm, mmm, or mmmm depending on if you want to see 04, Apr, or
April

Question 1:
I have nested switchboards within switchboards for the database I've
created. I just had Access create the default switchboard for me. How can I
change the settings to get the main switchboard to open again if I have
opened a switchboard?

Question 2:
Is there a way to put ONLY the MONTH (i.e., July and not July 2005) on my
report. I would like for it to run off of a variable unbound text box that's
in my switchboard, but if that's not possible then is there something

else?