Search results

Worked the solution out myself. Here it is for those who are interested. Private Sub xTree_NodeCheck(ByVal Node As Object) Dim nChild As MSComctlLib.Node, intI As Integer Dim objTree As TreeView Set nChild = Node.Child For intI = 1 To Node.Children If Node.Checked = True Then...

I have a tree view that depicts Test Case Area (Parent Node) and the associated Test Cases (Children). I have checkboxes property set to TRUE. In the NodeCheck method, I want to say "If the parent Node is checked, then check all of its children". 2 Questions 1-How do I iterate through the...

I figured it out so I thought I would post the code for others. Here is how to get the column names from a table in your database tabledef collection. Dim Counter as long Counter=0 For Each tdf In Application.CurrentDb.TableDefs If tdf.Name = "tblMappings" Then While Counter <...

I would like to get a list of a tables columns using VBA. How can I do this in VBA? I understand how to get a list of tables in the table collection but is there a way to access a particular tables definition to produce a list of columns? My goal is to select a table, generate its column...

I have successfully automated the refresh of my linked tables using VBA (thanks to a post on this forum -- Cool). Anyway, what I would like to know now is this: If my table collection does not have any linked tables, using VBA, how can I get that list of available tables to show? Assume that I...

I am fairly new to Access and VBA. How do I reference a Reports RecordSouce? I have a form which contains a few combo boxes/check boxes on it. I want to use the form to allow me to filter the output of a report. On the form, I also want to be able to create the report without selections...

Searched the internet, these forums and no luck. Can anyone tell me why Access (2003) generates seemingly random queries? This query shows up now and then in my database: TmprryQryFrLnkFldsCrtn0123456789 If I look at it in SQL View or in design view it is always blank. What is it? and how...

Yeah I used the search but didnt find what I needed (and its slow). Never used Shaped RecordSets. Is there a benefit to using a shaped set versus JOIN?

I have 2 tables, Test Cases, Test Case Details. I have a tabbed form to display the data. How do I open the form and retreive the data from both tables? Tables are related by ID.

Birdy Thanks for the examples. In the CascadeCombo box example, after selection from the RowField combo box, the subform is filtered. I want to extend this example such that a user can highlight a row in the subform and then click a command button that would open a detail window that displays...

Hello all. Using Access 2003 (SP1) First off, I am new to Acess programming (but not new to programming). I have a small database that I have created that currently contains 2 forms. The first contains 2 combo boxes (Schema Name, and Associated Tables) and a subform. Upon selection of a schema...