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'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...

Is there a way to code a function to search through the various modules in my dbs to look for a query name? -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...

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...

I currently have a listview with multiple columns of data. This includes text, date, and value columns. The sort option on the ListView sorts the selected column Alpha-Numerically. Therefore, dates and values are sorted wrong. I've searched Tek-Tips and the web to find a solution to this...

I have a frontend database which has been distributed to several users. It uses a ListView control 6.0 to display data from a queried recordset. After the ListView is populated, some users see an empty ListView. There are only blank rows. Through some testing, I've determined that the data...

I'm trying to limit the results of a query by setting the criteria of three fields to the values of a ComboBox's columns. I'm using similar syntax for each field... [forms].[myForm].[ComboBox1]![column(2)] The problem is that the criteria returns a null (or blank) value. I've tried setting...

I have an unsecured frontend which I would like to associate with an existing security file (mdw). How would I go about reseting the frontend to be dependent upon the mdw file? I would like it to be set up so that it requires a link to be used and a username and password. It's not enough...

Has anyone actually used the mousedown event with a ListView Control? When ever I try the following code, I get an error message: The expression MouseDown you entered as the event property setting produced the following error: Proceedure declaration does not match description of event or...

I have found many examples of how to view the dbs properties on an open dbs. However, I cannot find any code showing how to view the properties of a dbs that is closed. I would like to be able to view the properties without having to open the database. Does anyone have any ideas? Thanks. -agfon

Just out of curiosity, has anyone tried integrating a PowerPoint slide as an Access SplashScreen? PowerPoint provides a lot of neat transistions and effects that aren't available within Access. -agfon

I have an error number: -2147467259. Is there a way to obtain the respective error description? Something like... MsgBox Err.Number = -2147467259 Results in... "Not a valid file name." Thanks in advance.