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...
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...
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 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...
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.