Search results

When I try to use NextRecord, it stops after finding its first "hit" and does not go to the next successful match upon clicking the butting again. Thanks for the responses so far.

Any thoughts? My co-worker "harassment" is elevating a little higher today... (at least it is friendly harassment)

I am trying to create a button to quickly go to the next record with the same entry in a given field [Case Name]. It is working, but the search stops at the last record in the database and does not "loop around" and continue searching from the first record. I cannot figure out why acSearchAll...

Thank you!

I have cascading combo boxes in a subform. When I click the second box, which is dependent on the first, I get the following error: "Object does not support this property or method" This is what I have for the On Enter Event: Me!LeadIn.Updated Form!LeadIn.Requery I originally had ...

Thought I would bump this up to get any new opinions or some advice on the problem. (12 people viewing the Queries area right now)

Hate to ask this as it will show my true lack of Access skills, but where do I put the function?

That got rid of the dollar sign, but there is still text after the final number. There is a : after the last digit, if that helps to specify the info I want to extract.

I probably have an easy question for one of you out there, but I just cannot get it myself. I need to extract the data between two characters in a string. The data will be similar to this: T4454: Text Text-Text: $296.07: Text Text I need to get the dollar amount between the dollar sign and...

Thank you for the response. I actually did kind of what you said, but made a copy and worked from that until I got it right (which was pretty much on the first try, which surprised me).

Excuse my lack of access skills on this one, but where is the code? I cannot find it in the example database. All I see is the macro to open the form and the form itself.

I like the ability to do this, but I only need a portion of the functionality. I only need to store the path to the picture, I do not necessarily need a field to show the picture in the form. What can I delete from the code so it does not require the picture field? Thank you!

Still looking for assistance!! I added a sample database, so if anyone has any ideas, I would appreciate the help.

db example attached. Looking for help!! I have attached a sample db that is laid out similarly to the one I have. In the attached example, go to the form and search "Blue" as the only criteria in the Vehicle Color box. Run the query. After that enter Toyota in Vehicle Make (Blue remains...

Thought I might ask again to see if I can get some additional ideas or help. Thanks!!

Just wondering if anyone has any ideas on this. Another thought was to show the query results at the bottom of the form in a box (subform?), but how to get it to show the datasheet view from the query that way actually in the form?

I appreciate your help, but I am not sure I am explaining this correctly based on your response. I click a button and it runs query. The query results (looks like a spreadsheet) then comes up behind the form. I want to adjust some parameters on the form and press the button on the form...

Just use the AfterUpdate event for the last of your parameter fields and just do a --> Me.Requery The last drop down box gets its choices from a table. Will the Me.Requery just change that or will it actually requery the query and get new results based on the changed parameters in any of the...

Refresh query results** Updated with db example This is probably a simple one for somebody: I have a query based off of parameters on a form. A command button on the form then runs the query. I would like to be able to change the parameters on the form and re-run the query without having...

Thanks! Thanks Jon K! It worked great. I found I had to tweak it a little to get the results I needed becuase of other fields I did not include impacting it, but what you put together worked great.