Recent content by JohnLanc

I have a database form containing a treeview control. one of the textboxes on the form contains the node.key property of the last node to clicked on. I want to be able to change properties of the node by using the node.key in the text box but I don't know how to get the handle for the node...

Jim, Thanks for the help with the References - I am not familiar with the P&D wizard. I use the following code to clear the nodes: ActiveXCtl0.Nodes.Clear And I use the following to respond to nodeclicks: Private Sub Activexctl0_nodeclick(ByVal node As Object) Dim selnode As node...

I have put together a DB in Access on a machine running Windows XP. The DB is driven using a treeview control. When I try and run the DB on a Windows 2000 machine it gives an error as soon as it trys to populate the treeview control. I have copied across the MScomctl.ocx and the Comctl32.ocx...

I am trying to construct a report with several levels of detail. I have a calculated text box in the first (lowest) level of group headers which I then want to sum at the next highest level. I have tried using sum() which can't locate the textbox. I then tried making a hidden textbox in the...

Thanks Guys that was helpful. It is an easy trap to fall into!

I have a split database consisting of a front and back end both located in the same network directory. One button on a form in the database keeps generating the following message: "Error accessing file: Network connection may be lost" This buttons function is to load a form which is...

I have a table containing a list of documents, each of these documents has multiple records pertaining to it in another linked table. In order to display the information from the child table in one line with the document details, within a form, I am using a crosstab query, which forms part of...

I am generating line grpahs in a series of access reports. These graphs need to display the data tables as well. The problem I am having is that I cannot set the data table to display it's values as percentages. The values display as percentages in the underlying table. Any ideas?

Can anyone give me an indication of the practical limitations on the size of Access DBs. I am anticipating a DB I am currently working on becoming in the region of 100MB. The machines we run on are pretty good so I am only really concerned about the limits of Access itself. Any feedback would...

Thanks for your effort Ben

Got it working: Private Sub StepCredited_click() If StepCredited.Value = True Then CreditDate.Value = Now Else CreditDate.Value = Null End If Me.Requery End Sub

Thanks Ben, but it still won't update the field until I click on it!

I am trying to assign the current date to a field or clear the date from a field by clicking a checkbox. The problem I have is: When I check the box I cannot get the date field to display the date (or clear it) until I click on it and the control won't allow me to use the "Setfocus&quot...

MichaelRed, I found the createreport reference! I have managed to create a report programmatically now using your code, which worked great - thank you. But to complicate things further I now need to reference a second table in the report - any ideas? Thanks John

MichaelRed, Thanks for the advice. I would like to create the report programmatically but could not find any threads as you suggested. I don't suppose you have any sample code available? Thanks again John