Search results

I have attached the zip file of the database. When you open the database, the switchboard should appear. See to exactly what I'm trying to do, just click the "reports" button, then click the "more" button, and then click the "search in excel" button. You will then be prompted to save the file...

I did do that and it took it down from 5mb to 4. I only have 7 records in the data so far and for some reason I cannot open the link you sent me. I'll have to look in to why it won't open. If you have an external email account, I can send it to you.

I have an append query that dumps data into a table. The table is called search "Search_Excel_1" and the query is called "Search_Excel". I set up a macro to first run the query, then I want to run the module code that you gave me take the data in table "Search_Excel_1" and just open excel with...

I'm not sure what you mean by Call. Where do I call the function? When the switchboard manager asks me for the function name, I put Send2Excel("Search_Excel_1"). I'm still getting the error. If I want to run the module in a Macro, what action do I use? I'm sorry this is my last try. I won't...

I name the module "Excel" "Search_Excel_1" is my table "Excel_1" is the name of the sheet (not sure what this actually means though) Then I went to switchboard manager and selected command: Run Code and Function Name: SendTQ2Excel. This is what is in my module and table "Search_Excel_1" has...

To create the module, I have been clicking on the modules tap and selecting NEW. Or is not incorrect. It compiles fine, but now when I try to run the code I get "there was an error executing the command.

I'm getting a compile error : Invalid outside procedure when I run the module. Am I doing something wrong? Does something need to be open, as well?

Thank you for your help.

Is there code available? I'm not the greatest VB programmer at the moment.

I'm using the "Output To" command in the macro design. Is there any way to have the command output to Excel without having to save it somewhere on your computer first? I just want to click the button to run the macro and to have it just open up the report in Excel. Thanks in advance.

Thank you for your help.

Yeah, I guess I'm pretty much a noob. I was definately unaware that I would need to type in exactly what was in the title field. I am just trying to allow part of the memo field to be searched on. Still pretty clueless on how to get his accomplished with lack of vba or access knowledge.

If this has already been asked, please point me in the right direction. Couldn't find anything related to this when using the search. I have simple form with a text box and a button labeled "search". Text box is called Search_Box and the form is called frmSearch. I want to have the ability to...

Thanks for your help, Nigel. This is the module code that my form code is running off of. Option Compare Database Option Explicit Private Type BROWSEINFO hwndOwner As Long pidlRoot As Long sDisplayName As String sTitle As String ulFlags As Long lpfn As Long lParam As Long...

Happy New Year to all. I have a form that contains a button that opens a folder browsing window which allows the user to select a specific folder on a server and it stores the folder path on the form which can be clicked on and opened for later use. I have it set so that the path when you...

It works!! I placed it in the "on click" event. Thank you very much for your help!

Bob, thanks for your reply. I inserted this code in a new vba module and I was going to have the module run in a macro after the append query. I'm getting an error with the "Set" in the above code. The error states "compile error, invalid outside procedure". I'm pretty new to access and vba, so...

I fixed the problem. I had the wrong form name in my criteria command :mad:. Thanks for your help, Curtis.

I'm having the same type of problem here except I have no idea what to put in "criteria" in order for my query to read in the number in the textbox. the number in the text box is the primary key for each specific form. I want my query only to return 1 result by only reading the RecordID number...

Thanks, Curtis. Is there anyway to have it automatically fill in for the RecordID number? As of right now, when I run the code in the "criteria", it still prompts me to enter in the recordID number, even when I have the button on the open form.