Search results

I fill out a treeview based on a series of tables that represents locations. For example tblLocation LocationID Location tblArea LocationID AreaID Area tblRow AreaID RowID Row tblPlot RowID PlotID Plot The Treeview uses the following code to populate itself in the form. Dim NodX As Node...

When you have multiple columns in a list box they get divided by a thin gray line..how can I get lines to divide the records?

Say I have a form with a List box that display last names. And there is a text box on the form where the user can enter in letters. How can I autselect the records according to whats in the text field automatically. Say the user enters in the letter H Then the list field automatically moves...

I am trying to build an ADODB recordset. Here is my code Set Recordset = New ADODB.Recordset With Recordset .ActiveConnection = CurrentProject.Connection .CursorLocation = adUseServer .CursorType = adOpenKeyset .LockType = adLockOptimistic .Open "Select *...

I have a wizard that has two pages to it. In the first page the user selects an option from a drop down combo box. The value selected fills a treeview in the second page with certain items related to the option chosen. However when the use click back and changes the item selected in the combo...

Here is my query .Open "SELECT tblLocation.*, tblArea.* FROM tblArea INNER JOIN tblLocation ON tblArea.LocationID = tblLocation.LocationID WHERE tblLocation.LocationID =’” & Me!cmbLocation & “’ & tblArea.AreaName =’” & Me!txtArea & “’;" I suspect that the problem is because the...

I have created a wizard using pagebreaks and the wizard works fine...I have however run into a problem where tabbing through controls is not relegated to a specific page break. What ends up occuring is that if I tab too far the window shifts up into the next page and I dont want it to do...

I need to check for IsNull on four of the five controls on a form. If there was only one control I would just write the code at the start of the procedure to If IsNull Then MsgBox "You must yadda yadda yadda", vbOKOnly + vbCritical, "Error" Else REST OF PROCEDURE However the...

Using the following code to build a recordset Dim rs As Adodb.Recordset Dim strEvent As String Set strEvent = 1 Set rs = New ADODB.Recordset With rs .ActiveConnection = CurrentProject.Connection .CursorLocation = adUseServer .CursorType = adOpenKeyset .LockType =...

Dealing with a MS Treeview 6.0 with the property set to use check boxes. Normally this process only check the node selected and ignores the parent child relationships I have managed to get some code that automaticaly checks parent nodes when a node is checked and unchecks child nodes if the...

Could someone double check my query expression below. Something is not right I know but I cant figure out what it is. I think it is a part of the And tblArea.Location = [Forms]![frmSelectLocationStartDefault]![cmbLocation] but I cant be certain....Just an fyi that cmbloacation data type is...

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

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

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

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