Buttons

[scottmvinovrski]

Hi everyone,
I am trying to create a button on a form that will export only that record. On the command options I do not see there being an option to do such. Can anyone help? Thanks. I would like to export to excel or anything that will capture what I am looking at. I have noticed that Yes/no boxes do not export to excel?

 

[scottmvinovrski]

nevermind i was able to create a macro and then add a command that emailed the information via snapshot view

 

[Fifty2One]

ooops i was looking at home for a piece of code from your same question yesterday but i guess it is solved... my code sample was to make a macro...

 

[The_Doc_Man]

scottmvinovrski

I have noticed that Yes/no boxes do not export to excel?

Ah, but they do! The problem is that you don't realize what they are. The classic Access Yes/No field is a "derived" rather than a "native" data element. Yes/No is a "cast" (alternative format) of a BYTE integer, which will export as 0/1 to Excel. This is because the export routines are DUMB. Way too dumb to check which format you are using.