Search results

I am using TransferSpreadsheet to export my table into a spreadsheet and this works fine, my problem is with opening the file from access. I figured this would work, i added a hyperlink on the button that also performs TransferSpreadsheet, but this does not work. Excel opens currupt. What is a...

could i get some input from people on what they think the best way to export an access table to an excel spreadsheet. thanks

I am perfroming a multiple criteria search that sometimes does not return the criteria searched for. For one of my criteria in my query, i am using IIf(IsNull([Forms]![Form3]![text1]),[Thesis_Title],IIf(InStr([Thesis_Title],[Forms]![Form3]![text1])>0,[Thesis_Title])) When i search for a set...

Does anyone have an idea how i could search for a keyword in a field. The field is a Thesis title and could be a sentence or two long. I just need to return any Thesis' containing the given keyword. thanks

bump

thanks for the help Rob. the query works good with the multiple selection, but everytime i run it with the chosen lookup values i write over an old record or add a new record to the table. ive tried messing with the settings but i can not get the query to stop writing over fields. if anyone...

Well, I would like to pull the parameters from fields on a form, I havent actually made this part of my db. But i need to be able to choose up to three different parameters every time the search is used and display the corresponding values for the same 9 fields found in some table. I really...

I am making a query for my database that could be used in many different ways. There are 9 fields being searched, but the search parameters are different everytime this query is used. I need some way to be able to choose what fields the search is based on, it could be based on the results of...