Search results

Ok I actually figured out how to force parent nodes to check but I cant figure out how to force child nodes to uncheck if the parent node is unchecked. Could a modification of this code resolve the problem...may an else statement Private Sub TreeView0_NodeCheck(ByVal Node As Object) On Error...

The following is my code on a on open evnt of a form containing a treeview. IN the properties of the treeview I have selected to use check marks. Currently you can select any node in the treeview and it will check individually with no effect on the parent node. I need to find a way to force...

Hey thanks...That worked well.

I actually figured it out..I just wasnt stopping the function to check the data in the recordset

I am trying to figure out how to use a tree view to browse through related records in three seperate tables. the table are related in the following manner tblArea AreaID AreaName tblRow RowID AreaID RowName tblPlot plotID RowID PlotName There is other associated information in the...

I have a form with 2 list boxes The first list box has a query as its record source and so displays the values retrieved from that query. There is a command button whose purpose it is to take a selected record from that first list box and write that value into the second list box as a record...

I am a little shaky on what I need to add to the code for this Here is the code I have Private Sub cmd1_Click() Dim ctrl As Control Me.cmd4.SetFocus For Each ctrl In Me.Controls If (ctlr.Tag) = "Loc1" Then ctrl.Visible = False End...

Assume I have a form called FRM The form has a list Box from which the user can select a record. There is a Next button. For a number of reasons I want the Next button to change the visibility of the controls so that the first list box is "hidden" with its selected value and a second control...

I have the following code in my module Dim rsVineyard As ADODB.Recordset Dim mySQLVineyard As String mySQLVineyard = "SELECT tblVineyard.VineyardName FROM tblVineyard WHERE (((tblVineyard.VineyardName)<>'na'));" Set rsVineyard = New ADODB.Recordset With...

How would one go about an AddNew in an ADODB recordset for a field whose value is a date IF you want the date to be automatic. So that if the code looks like this Dim rst As New ADODB.Recordset rst.Open"tblEvent", CurrentProject.Connection, adOpenKeyset, adLockPessimistic rst.AddNew...

Never Mind I figured it out.. I needed to put two double quotes inside the double quotes and I was only putting one. Thanks for the help I appreciate it. :)

I am still having problems... Here is the scoop. frmEditTrainingSystem has a pop up window frmEditTrainingPopUp the on clikc code has a wherecondition that determines the filter for the frmEditTrainingPopUp. The code looks like this Private Sub cmdEditTrainSystems_Click() On Error GoTo...

Hello.... I seem to be missing an 'operator' in my expression and I am slightly confiused as to what that might be. The query statement is: SELECT qListTrainingSystems.[Training System] FROM qListTrainingSystems WHERE (((qListTrainingSystems.[Training System])<>"na")) ORDER BY...

This question is focused on the relationships between 5 maybe 6 tables. Consider the following list of tables tblLocation tblArea tblRow tblPlot tblEvent The tables have the following fields: tblLocation LocationID LocationName tblArea AreaID LocationID AreaName tblRow RowID AreaID...

I am having a problem with my delete button deleting the wrong record. Consider that I have a form called frmEditProducts In this form is a list box that displays a list of the Products from the tblProducts. There are 4 buttons... Add Delete Edit Cancel My Add button and Edit button both...

Thank that solved my question perfectly!

This is kinda difficult to explain...but here goes. Lets say I have two forms. One is a list of product categories....the other is a list of Products the tbls would be organized in this manner tblProducts ProductID Autonumber ProductCategoryID Number Product...

I have a form that has as its source a tblTrainingSystems The form name is frmTrainingSystems On the form is a listbox "ListTrainingSource" and a button "cmdEditTrainingSystem the form has an efter update event that selects records in the tblTrainingSystems dependant on what record is...

You probably think I am an idiot but I am fairly new to access...could you give an example of how that statement might look...

MOre information Maybe I should be more specific... Here is a more detailed explanation... I have a form named frmEditTrainingSystems There are four buttons on this form Add, Edit, Delete, Close. There is also a list box that has as its source the a query on the tblTrainingSystems that...