If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to start a form in datasheet view from the switchboard
Greetings,
I'm using access 2000 and using switch board for my menu control. I don't want to spent too much time to design a form layout so decided to using datasheet view instead. I've set default view as datasheet in design view, but it always start the form in single form view. Is there a way to force it start in datasheet view? Thanks, W Wang |
#2
|
|||
|
|||
how to start a form in datasheet view from the switchboard
William Wenjie Wang wrote:
Greetings, I'm using access 2000 and using switch board for my menu control. I don't want to spent too much time to design a form layout so decided to using datasheet view instead. I've set default view as datasheet in design view, but it always start the form in single form view. Is there a way to force it start in datasheet view? Thanks, W Wang Sounds strange. Are you sure you've saved the changes to your default view? I've just tried to replicate the problem and can't. Otherwise, why not use the Form Wizard to create your form? Steve |
#3
|
|||
|
|||
how to start a form in datasheet view from the switchboard
Hi Stephen,
You have three options (at least) available to you. 1. You could make your form into a Continuous Form and design it so it *looks* just like a datasheet. Then open it in Edit mode from the Switchboard. 2. You could design your own "Switchboard-type" form and launch all your procedures from there. 3. You can change the Switchboard code a little bit to achieve your desired result. The Switchboard automatically will open a form in Single view. If you change the code to datasheet view then ALL forms will open in Datasheet view which is probably not a good thing. If you would like to have the best of both worlds, follow these instructions on a BACK-UP COPY. Open the Switchboard code. Find the area that has this: ' Constants for the commands that can be executed. Const conCmdGotoSwitchboard = 1 Const conCmdOpenFormAdd = 2 Const conCmdOpenFormBrowse = 3 Const conCmdOpenReport = 4 Const conCmdCustomizeSwitchboard = 5 Const conCmdExitApplication = 6 Const conCmdRunMacro = 7 Const conCmdRunCode = 8 Add one more line to the list like this: Const conCmdOpenFormDatasheet = 9 Now go a little further down the code until you come to this area: ' Run code. Case conCmdRunCode Application.Run rst![Argument] ' Any other command is unrecognized. Case Else MsgBox "Unknown option." In between these two areas we want to add another one for datasheet view. Add in this new code in the middle so it looks like this: ' Run code. Case conCmdRunCode Application.Run rst![Argument] ' Open a form in Datasheet Mode. Case conCmdOpenFormDatasheet DoCmd.OpenForm rst![Argument], acFormDS ' Any other command is unrecognized. Case Else MsgBox "Unknown option." Compile and save the form. Now you will NOT be able to use the Switchboard Wizard to use this option. The Wizard will only use the 8 pre- defined options. To open a form in Datasheet View you will need to go directly to the Switchboard Items TABLE and add it yourself. If you study the records you will figure out what is going on. Just use the number 9 in the Command field to open a form in datasheet view and showing all records. -- Jeff Conrad Access Junkie Bend, Oregon Happy Birthday George Lucas 1 Year till Episode 3 (not that anyone is counting) "Stephen Glynn" wrote in message ... William Wenjie Wang wrote: Greetings, I'm using access 2000 and using switch board for my menu control. I don't want to spent too much time to design a form layout so decided to using datasheet view instead. I've set default view as datasheet in design view, but it always start the form in single form view. Is there a way to force it start in datasheet view? Thanks, W Wang Sounds strange. Are you sure you've saved the changes to your default view? I've just tried to replicate the problem and can't. Otherwise, why not use the Form Wizard to create your form? Steve |
#4
|
|||
|
|||
how to start a form in datasheet view from the switchboard
"Jeff Conrad" wrote in message ... Hi Stephen, You have three options (at least) available to you. I'm using your option 3 to solve the problem. Thanks for the help. Regards, WWang |
Thread Tools | |
Display Modes | |
|
|