Search results for query: *

I have some VBA which identifies all of my dbs QueryDefs - including the temporary "~sq_" type queries. Knowing the form and control that a ~sq_c is associated with, is there a way of opening the control's row source via vba? -agfon

I understand that criteria limits the results. Your original response suggested that I use a pass-through query. I removed my criteria to determine if the response time was any worse -- it wasn't. The sub-queries do join tables on the ORACLE backend. Then, the various sub-queries are joined...

cmmrfrds, Actually, I've tried testing for that. I removed all of the criteria and it's still taking 5 minutes + to run a query that takes 8 seconds with the Access backend. It seems that when I open each subquery individually, everything runs quickly. However, when I link them together, the...

I'm in the process on converting my access backend over to ORACLE. We're continuing to use access as a frontend interface. The conversion went well and opening the ORACLE tables is immensely more quick. However, when we attempt to create queries in access using the linked tables, the response...

I have several pdf forms with fields (i.e. name, location, phone, etc...) which need to be filled. Currently, this must be done manually. I have a database with the data and I'm looking to see if any VBA exists which will allow me to automatically open the pdf, fill in the blanks, and save the...

Duane, This is a ListView - not a ListBox. The ListView has functionality that the ListBox doesn't. -agfon

By-the-way, I tried dropping this reference into VBA and it did produce the desired results. -agfon -agfon

I'm experiencing a problem with a query that references the selected item within a ListView. The query criteria is as follows: WHERE (((Table1.Rec_ID)=[Forms]![frm_main]![ListView1].[SelectedItem])) Prior to receiving Windows XP, this query fired without any issue. Now, it prompts the user...

Thanks, MajP. I spent the better part of the morning looking for anything to give me guidance. I appreciate the links. -agfon

Is there a way to code a function to search through the various modules in my dbs to look for a query name? -agfon

stix4t2, Thank you very much for the code. It was exactly what I was looking for. -Fred

These users are used to hitting 'Enter' to exit the field and move the focus to the Cmd_button that fires the query. I've expanded their selection of fields; however, I would still like the set-up to be similar. -agfon

I have a series of textboxes designed to allow the user to input in query criteria. I would like to set them up to utilize on "On Key Down" function to start the query when the Enter key is pressed. This would be instead of setting the "On Key Down" sub for each field. Has anyone ever done...

PHV, The query is in the process of being adjusted to account for additional requirements. -agfon

PHV, My SQL view pane is similar to your example. My guess is that I have too many fields that I'm trying to limit with this method. -agfon

PHV, The only drawback is that it really increases the size of the SQL code when you have multiple columns utilizing this method. My query has around ten columns. When I use this method, the query fires fine. However, I cannot enter the query in design view afterwards. Access basically...

Thanks PHV. That seems to work. I'm trying it out now to see if there is any performance improvements. -agfon

I have a form with several text and combo boxes. It it set up to allow the user to input criteria and then run a query. In the criteria area of the query, the criteria of each column is set in the following fashion: [forms]![my_frm]![my_textbox] The problem I'm experiencing is when the...

Thanks, Skip. I've seen this solution. I'm trying to avoid having a series of leading zeros. -agfon

What value do I change from text to numeric? The field in the table is already numeric. Is there something on the Listview itself that can be changed? -agfon