Search results for query: *

Hello, all. It's been a while since I darkened these corners, but I trust you've kept the place up in my absence. I am digging out some code from an old .mdb file and attempting to update it and purpose it in a new 365 ACCDB. This sort of a thing had worked in the mdb, but doesn't in the accdb...

Just wondering if there is some pre-built code to handle a querydef and parse out the SQL into [FieldName] and [Source]? For instance, given the SQL of: SELECT tblTable1.WidgetID, tblTable1.WidgetName, IIF(ISNULL(tblTable1.WidgetPrice),2.99, tblTable1.WidgetPrice) AS Price...

Just wondering if someone else has noticed this, or if there is something I'm missing. I have a multi-page form in Access (using the PageBreak control and navigation buttons to go to 'Next' and 'Previous' pages). I set the Form's Cycle property to be "Current Page". That works great to the...

Apologies if this has been asked elsewhere. My search turned up no direct results. I have a form with three subforms. The subforms are stacked vertically, but do not touch/overlap. They are the width of the main report, and they are 0" height. I want them to expand if there is data in that...

Hello, all... Problem Basics: I have an icon-heavy richtextboxex control on a secondary form, built from my main form. The first time I instantiate a new form2 and build the contents of the RTBex, the form displays no problem. The second time, it dumps out with an unhandled exception in...

Perhaps I am not seeing something here. I have gone through an Access tutorial (specifically Access 2000), but the security seems only as good as people deciding to go along with the parameters and behaving. I created a new system.mdw file. I defined users and groups, and setup permissions. I...

Hello all, I am trying to roll changes to a production database by creating a procedure that a user can run in the Rollout DB to update the Live DB. I've got the table entry changes taken care of, and I've got the query updates taken care of. There is also one form that I need to get from the...

I have an odd situation. I have three tables that matter WarrantyInformation Vehicles VehicleVolumes A Vehicle entry can be used multiple times in the Warranty table, and multiple times in the Volumes table. The VehicleVolumes table has a primary key of Plant, ModelCode, and VolumeMonth, so...

Hello, all, I am returning the top 5 product groups in a query. No problem. Now, for each of these 5 product groups, I would like to return the top 5 products contributing towards making the groups the top 5 of the groups. In the end, what I want is: Group1 - Product1/1 Group1 - Product1/2...

I had a database in Access 2K format that had an archive function that utilized the SHFileOperationA API call: Private Declare Function apiSHFileOperation Lib "shell32.dll" _ Alias "SHFileOperationA" _ (lpFileOp As SHFILEOPSTRUCT) _ As Long It works great...

I'd like to provide some flexibility to the query, to where the user could decide to pull the TOP 5, TOP 3, TOP 20, whatever. Using a parameter does not work: SELECT TOP [Enter Value]... I figure I can do this by manipulating the SQL of the querydef, but I'd like to just have some...

Hello again, all... I've been away from this forum for some time, but I am back with a question of my own. I don't know if I am out of practice, but I am just not seeing the best way to set this query up... function, sub-query, or inline computation. Here's the situation: Table...

For those of you who tried to help me before with my subform object filter problem (back story explanation here: thread705-1139800 "Undocumented Filter"), I thought I would share this update that I got from Frank Rice (MSDN Office Developer Center) at Microsoft: (I verified with Frank that it...

Is there some code template that will give me permutations of items of 'X' amount. Given five items I want to return: 12345 12354 12534 15234 12435 14235 13245 21345 etc. For this thread, the items can be phrased in terms of rows in a DAO.Recordset... any thoughts?

I wrote this code because I often found myself needing to return multiple items from a particular lookup, but the syntax was very often the same and I got tired of dimensioning DAO.Recordsets in every procedure. vDLookup returns a variant containing an array based on the sort of criteria and...

I use code to rewrite the Filter property of a Query, and then use acCmdSave to save that filter. When I step through the code however, the filter sometimes reverts back to the previous version after the save command. For instance: CurrentDb.QueryDefs(Me.cboReport).Properties("Filter") =...

Crosstab queries (perhaps among other sorts of queries), do not have a Filter property. But create a form with a subform control, and put in the SourceObject Property of the sf-control "Query.MyCTQuery" and you can do a filter-by-form or a filter-on-selection. But, when you have done that...

Hello all, I have been working with a particular issue from several different POVs over the last several weeks, and am still having difficulty with it. I have searched this board and not found an adequate answer. My basic question is: can I pass parameters to a query that I am opening as the...

In the case of a dynamic array, if it never gets filled with data, then the statements... Dim MyArray() as String, i as integer i = UBound(MyArray) ...will produce an error. How can I safely test for the ubound? I've thought about doing the following: Dim MyArray() as String Dim MyTest() as...

Hello all, I posted this over in the VBA forum as well, but this might be the better venue for this question... I have a query with a criteria parameter prompting the user to enter a value for the field. However, if a particular form is open, I want that field to pull from a particular field...