Search results

That's even better for non-existent god sakes! Oh man, you're making my day, my week, my year. I gotta implement this next week after my SQL project is done. I will have specific questions, so be prepared....that's it...I gotta putcha on payroll...Donald T, look I got a new British guy for...

Actually, Dave the catalog number is all that is ever used in these queries. No text. So,the character strings with text don't count. That's why I thought it could be iterative. the catalog numbers like something ac-20b-30c-50exd-01. Of course that's a completely fictitious number.

Ortho-Dave, the sql option you gave may be just what I need to make the requery process work. I'm going to test it soon. Yes, there will be tweaks. But the spectacular thing is it will interrogate the saved query, just what I wanted. And of course this process could be made reiterative. So, if...

Actually, you've provided 98% of what I want to do already. With that simple line of code, you virtually solved my problem. But for some background. I have a built this form to allow PM (product managers) to query a database of electrical parts with their technical description. It is divided...

You know Dave answering a question ultimate brings yet another....so..... what if I wanna start the process over with the saved query? Just ...umm...I don't know. I can't jump back to the start of the routine. I most likely have to add a new button that query the saved results with the same...

I thought this option wasn't available in intellisense. But I guess it is! Thanks ...uhh lemme see who are you. Dave of the Orthodoxy (smile). With regard to OKonly, I want that to stay as is for another reason. In my case I need to keep users limited. But being able to save the query as new...

Here is a copy of the VBA module (with some details have been changed to protect proprietary information from my job) Private Sub FindXXX_Click() Dim Command0 As String DoCmd.OpenQuery "DescriptionsQry" If MsgBox("To accept these query results click OK", vbOKOnly) = vbOKOnly Then OK = True End...

Hi, my name Robleh and I'm a database specialist working in the engineering industry in the U.S. I've been working with Access 2013 VBA, and have had some limited success with rather simplistic module creations. Recently, I've wanted to improve one with 'save as' functionality to a query...