Search results

well... It seemed like a good idea at the time. But with a read-only front end you can't mess with a stored query - and you can't link to a query like you do to table in the back-end.... so I'm stuck again. If I can't figure out how to "link" to a query, I'll probably have to do a temp table...

Is there any possible way to link to a query in the same way that you link to table in your back-end? I ran into a scenario where I have to update the SQL statement of a stored query on the fly - basically a temporary stored query instead of a temporary table. (Had to do this because 6 other...

Your idea about a temporary table got me thinking about a Temporary Stored Query. I pointed all my update queries to the Temporary stored query instead of the original. Then in VBA i loaded the sql from the original query, inserted the form's filter into the sql's where statement, and then...

Wazz - thanks for the help. Will a temp table work in a MDE or read-only database Front end database? Thank you, Evan

This should do it. I left the 6 Phrases visible so you could see how they work, but of course, you can hide them. Evan

Yes, very possible - Working on something....

My update query uses the original query, pulls in data from a couple of other tables, compares it, and then performs an update. If I have to do this record by record in VBA i would need to create and close a 3rd query for each record in my filtered query - line by line... very slow, I imagine...

Actually, just reread your post and saw that you want the phrases in ANY order. And that you want to search across two different fields: Category and Description. 1st, you need to create a field in the query for your Combo box this is a combination of both text fields - you can name it...

If you set up the filter as I suggested, you could type in "el*end*15" and it would return the results as you want. To make it more user friendly you could use the afterupdate event to replace spaces with * so that your users could just type "el end 15". If you wanted to do this...

This is easy to do, and you don't need to use an array. Say for example that you want Text1 to filter results for Combo1. In the rowsource for Combo1, you probably have already built a query that supplies your data. In the criteria row for the column that contains your Description add the...

When I add a filter to my form, the underlying query, of course, does not include the additional criteria from the form. I need to use the underlying query to supply data to an update query. But the update query must only affect records shown on my form. Is there any way to feed the form's...

Open your parent form in edit mode and look at the subform's properties. Click the other tab. The name you see there is the name you should be using to refer to the subform. If you still can't get it to work try putting a breakpoint in some code on your SECOND subform, and type the following...

I never noticed the Form_Error event. Thanks missinglinq for pointing this out. Now, I can allow my users to type equations and fractions into numeric fields! Private Sub Form_Error(DataErr As Integer, Response As Integer) On Error GoTo ErrLog 'Allow Formulas to be entered into...

To requery SubForm2 from SubForm1: Parent!SubForm2.Requery

The code is good code. If you try to enter the control by tabbing into it you will see that it does select the text. The problem with clicking into the control is that the click event overwrites your selection. This may not be the cleanest work-a-round, but you could use the timer event to...

1st, you are confusing Dcount and Dlookup. Dlookup will return a value from a table, Dcount counts the # of records that match your criteria. Dcount will work for what you want to do, but don't include the comparison to 0 inside the Dcount statement. Complete the Dcount statement, then compare...

I recently ran across a web site for a software package that proclaimed: "While Access is great if you want to organize your baseball card collection, everybody knows that if you want to get anything done you have to look elsewhere." Do all the Access haters have a point? It seems to me that...

Hope I don't violate protocol by posting to an old thread, but I found you can change the order that subforms load in by using the 'Move to Front' or 'Move to Back' command in design mode. Hope this may help someone. Evan

Yes - i meant requery.

I appear to have accidentally discovered something that may useful if anybody else can recreate it. Requerying a subform by referring to the control on the parent form appears to requery without losing the current record or the selected control on the subform. myForm!mySubForm.Requery -...