Export to Excel button, hide access windows

[Ammarhm]

Hi Guys
Thank you so much for this wonderful site
I need som help modifying a database search that was posted in this site for free use
The database is attached with this thread.
I need help with a couple of things:
1- In the search forum (frmSearch), i need to add another buttom that simply exports the search result from the subform to an excel file, and that the user would be promoted to choose where to save the new excel file, could anyone please help me with that??
2- I need a way to make all the background MS Access windows dissapear, ie only the search form is displayed, as if it is a stand alone application, can it be done??
3- I need another button to be able to print the result of the search, any ideas??
I appreciate your kind help, and i hope i am not asking stupid questions here, I am a "very" beginner myself in Access.
Thanks again

 

[Ammarhm]

Hi All again
I found the solution to problems 1 and three, took some time with VBA
Could anyone please give me a solution to problem 2 ie a way to make all the background MS Access windows dissapear, ie only the search form is displayed, as if it is a stand alone application, can it be done??

 

[georgedwilkinson]

I am by no means an expert on this topic.

But I saw this neat sample in the samples forum that "over-rides" Access' normal look and feel. Don't know if it'll help:
ACC2000: Custom InterFace - Transparent Floating Panes