Datasheet View

[sladetroityer]

Will a datasheet view From allow command buttons? When I add a command button and then go to Form view only the datasheet is displyed. What happened to my command button?

 

[RuralGuy]

The simple answer is NO. you will need to use a Continuous form set up to look like a Datasheet in order to get the Command buttons for each record.

 

[sladetroityer]

What about a split form? In access 2010 there are split forms? I tried to view the split form on a navigation from and the datasheet portion of the split form doesn't show up. Any idea why it doesn't show up?

 

[RuralGuy]

Sorry but never tried a split form yet.

 

[missinglinq]

What are you trying to do with this Command Button? I've used the Double-Click event of a Textbox in place of a Command Button on Datasheet View Forms before.

Linq ;0)>

 

[sladetroityer]

I am all set on this one, Thanks. I changed form to continous form. Can you help me out with my export to excel VBA code. No-one seems to know how to write the code.

Private Sub cmdExportExcel_Click()
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qselEmployeeInformation", "c:\EmployeeInfo.xls", True
End Sub

This works but I want it to export only the filtered data...... me.filter maybe

 

[lution]

For split forms, expand the size of the form header so you have enough room to include your controls. If there isn't already a form header, add one and put your controls there.

 

[Simon_MT]

A Continuous Form can do the same. Parent equivalent in the Header + Command Buttons. SubForm data in the Detail.

Simon