Search results

hahaha...yeah i'm sure it's very jerryrigged, but the fact that it works makes me very pleased. Thanks for your assistance, I really couldn't have done it without you.

Me.SearchResults_Qnote_subform.SetFocus DoCmd.GoToRecord , , acFirst strSQL = "SELECT * FROM [QIT_Z3_QNOTE_tbl] WHERE [Q-note #]=" & Me.SearchResults_Qnote_subform.Form.[Q-note #].Value Me.SearchResults_Qnote_subform.SetFocus DoCmd.GoToRecord , , acNext Do Until...

Alright. I have figured out my problem. After I do the procedure the query's criteria stays in the query and then after a while the criteria for the field will fill up, so I just have to figure out how to have the criteria auto clear after I get the query exported. It works perfect aside from...

Sorry, I cut out the part of my code in between. I bring it back up the first record. I'm looping to set the sql code to all the filtered records. I will look into RecordsetClone. The only reason i was looping was because I didn't know any other way to get all the filtered results to show up.

I had also tried the code below and it still didn't work. Is there a better way of going through until the last record? Me.SearchResults_Warranty_subform.SetFocus DoCmd.GoToRecord , , acLast strClaimNum = Me.SearchResults_Warranty_subform.Form.Claim_Number.Value Do Until...

Do Until IsNull(Me.SearchResults_Warranty_subform.Form.Claim_Number.Value) strSQL = strSQL & " OR (LHW_All_Claims_IMP_tbl.[Claim Number]) = '" & Me.SearchResults_Warranty_subform.Form.Claim_Number.Value & "'" DoCmd.GoToRecord , , acNext Loop I have been changing stuff all...

yes. that's how I'm getting all the ID's.

i still got the error. Any other ideas?

...alright. It was working great and then all of a sudden after i clicked the button i got the message, "System Resource Exceeded". Since it's the same amount of data as before I can't imagine that's the problem. Would you have any idea how to fix this?

IT WORKS! I ended up having to do something a little different, but you certainly got me on the right track with the SQL stuff. THANKS

I'll try to explain this better. I have a search form. A user will input whatever they want to search into textboxes and click a button. When the button is clicked it will open into the form with four subforms and filter based on what was entered on the search form. Then if the export to...

Textbox.value = text End If and then put it in the after update event or change. Sorry it wasn't all together.

I believe you could put: If listbox.value = 1 Then Textbox.value = assignment ElseIf listbox.value = 2 Then Textbox.value = decision ElseIf listbox.value = 3 Then

It works...but it's still the same problem I had originally. If I have 'ID' as my field linked to the query I can only get the first record from the filtered subform. Is there something I can put in criteria to make it go through all the filtered records?

i've been playing with it a little bit. It won't let me use a subform as an object, it has to be a table or query. Is that right? If so, do I need to use SQL in the table or stick with the query method. If I'm sticking with the query, then I'm still not sure how to get more than just the...

Alright, I have to go do something, but I'll have a crack at it later today or early tomorrow. THANKS

I was looking at that a while ago, but now I can't remember why I didn't use it. I thought that you couldn't have filters with DoCmd.TransferSpreadsheet. Is that true?

I should have said to a single excel workbook with each subform being on a different sheet. I'm doing DoCmd.OutputTo acOutputQuery, "Search_qry", acFormatXLS, strPath. Once I get this working then I'm going to work on the getting them into the same workbook.

I want to have the qry doing this so that I can easily output all the filtered subforms to a single excel spreadsheet. I haven't found an easy way to do this yet, so I'm trying this way. If I just do DoCmd.OutputTo etc., from the form it doesn't keep the filter with it. Is there a better way...

Yeah. I'll just try and give an example. Say I have the query filter off the subforms ID and in the filtered subform there are records with ID's 2, 5, 10, 55, 110. How would I go about getting all of those into the query? Currently it will only show the record where ID = 2.