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
|
|||
|
|||
DataSheet view problem
I have several forms that I open from a switch board button. I can not get the forms to open in datasheet view.The default etc are set to datasheet but they open in single form view,when i open the form by double clicking directly on it it opens ok in datasheet.
If after opening the form I change to design view then back it opens in datasheet. |
#2
|
|||
|
|||
DataSheet view problem
-----Original Message----- I have several forms that I open from a switch board button. I can not get the forms to open in datasheet view.The default etc are set to datasheet but they open in single form view,when i open the form by double clicking directly on it it opens ok in datasheet. If after opening the form I change to design view then back it opens in datasheet. . Set the forms Default view to Datasheet and the Views allowed to Datasheet |
#3
|
|||
|
|||
DataSheet view problem
I have done that Ken but the forms all still open in single view. note this only happens when the form is opened from a button.
This is the code generated for the on click Private Sub All_Forward_Click() On Error GoTo Err_All_Forward_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Crane form All" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_All_Forward_Click: Exit Sub Err_All_Forward_Click: MsgBox Err.Description Resume Exit_All_Forward_Click End Sub "Ken" wrote: -----Original Message----- I have several forms that I open from a switch board button. I can not get the forms to open in datasheet view.The default etc are set to datasheet but they open in single form view,when i open the form by double clicking directly on it it opens ok in datasheet. If after opening the form I change to design view then back it opens in datasheet. . Set the forms Default view to Datasheet and the Views allowed to Datasheet |
#4
|
|||
|
|||
DataSheet view problem
Nordave wrote:
I have done that Ken but the forms all still open in single view. note this only happens when the form is opened from a button. This is the code generated for the on click DoCmd.OpenForm stDocName, , , stLinkCriteria Change that to DoCmd.OpenForm stDocName, acformDS, , stLinkCriteria -- Joan Wild Microsoft Access MVP |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sort (organize) columns in Datasheet view | maugdc | New Users | 1 | June 17th, 2004 12:13 AM |
Forms in datasheet view and tables | Ian AFFS | General Discussion | 2 | June 10th, 2004 03:38 PM |
Hang on opening datasheet view | Ezius | General Discussion | 0 | June 8th, 2004 03:29 PM |
how to start a form in datasheet view from the switchboard | William Wenjie Wang | New Users | 3 | June 1st, 2004 04:30 AM |
Forcing PowerPoint to open in Slide View, not Normal View | Steve Rindsberg | Powerpoint | 0 | May 19th, 2004 12:51 AM |