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
|
|||
|
|||
Viewing forms in datasheet mode from a switchboard
I am creating a database with lots of forms based in queries that are
datasheet, and non-editable for the end user. I want the user to be able to access these forms, in their datasheet view, from the switchboard. I only seem to be able to open the form in tabular view. How can I do this? |
#2
|
|||
|
|||
On Fri, 19 Aug 2005 07:17:02 -0700, Alison wrote:
I am creating a database with lots of forms based in queries that are datasheet, and non-editable for the end user. I want the user to be able to access these forms, in their datasheet view, from the switchboard. I only seem to be able to open the form in tabular view. How can I do this? Regardless of how you have set up your form to open, if you are opening it from an event on another form you must specify Datasheet view: DoCmd.OpenForm "FormName", acFormDS I gather you are using the Microsoft Add-In switchboard. Life would be simpler for you if you didn't, and made use of an unbound form with command buttons. Much more versatile, and easier to maintain.... and Access will write most of the code if you use the command button wizard. That being said, if you are using that Microsoft Add-in Switchboard and wish to open a form in datasheet view, you need to make a change in it's code. Open the Switchboard Code window. Find the Private Function HandleButtonClick(intBtn As Integer) code line. A few lines down you'll find the Constants listed. Add Const conCmdOpenFormDS = 9 at the end of the list (I believe there are originally just 8 constants). Then go down further into the Select Case statements. Add Case conCmdOpenFormDS DoCmd.OpenForm rst!Argument, acFormDS just before the Case Else statement. Close the code window. Open the Switchboard Items table. Change the Command value for the form you wish to open from it's current number (either 2 or 3) to 9. That should do it. Best advice I can give you is to make your own switchboard form. -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Switchboard add mode | Dave M | Using Forms | 0 | March 28th, 2005 11:57 PM |
Access Datasheet Forms | Clint Liezert | New Users | 1 | January 27th, 2005 12:32 AM |
opening forms in add mode, one control's data automatically entere | erinu | General Discussion | 1 | July 3rd, 2004 12:09 AM |
Forms in datasheet view and tables | Ian AFFS | General Discussion | 2 | June 10th, 2004 03:38 PM |
how to start a form in datasheet view from the switchboard | William Wenjie Wang | New Users | 3 | June 1st, 2004 04:30 AM |