Recent content by nick.tait

Hi guys, Ive beeing trying to figure out a drag drop code in my treeview and i keep getting this error 'the expression mousedown you entered as the event property setting produced the follwoing error: Procedure declaration does not match description of event or procedure having the same name.' i...

Hi, Is there anyway to fill a Treeview with information from one access column in a table and then have a branch off that which displays data from another column in a separate table? I can display data in my treeview but only if the data is from two columns in the same table. Please Help!! This...

Hi Everyone, Haven’t posted here for a while but I but every time I have before I’ve always got the answer I was looking for. The problem I’m having at the moment is with a treeview drag and drop code. What i simply want is to be able to drag nodes/sections/data which is in the treeview and move...

Hi everyone, Is there anyway to replace the nodes in a treeview instead of adding them to the treeview so that i dont get a 'Key is not unique in collection' error every time i try to run the code? My code is below. Thank you all in advance Option Compare Database Option Explicit Private Sub...

Hi everyone, i have been working on a code for a few weeks and am completely lost. I have a Tree which contains the code below. instead of the tree displaying the information in the table i would like there to be a 'branch' before this step which says "custodian History". i would ideally click...

I attached a photo of the database (New Compressed (zipped) Folder.zip), hope it helps. so the table that you can see is produced in the tree diagram (see attachment 2 (Tree)) however i would like the data to go in a branch called "custodian history" first which you would click on to produce...

i didnt. there are different problems or the older one has been fixed

Hi everyone I have written this code which produces a tree (see attachment). Basically i want all of the information put into a previous branch called assetnumber. When u click on assetnumber i would like the attached view to come up. so really i just want another branch containing the info i...

This is the most recent code. ive totally reworded it and gone with a different approach. The line in red is where it crashes. i really cant figure it out. ive been able to fix everything else but im totally stuck on this. Thanks in advance Dim db As DAO.Database Dim rs As DAO.Recordset Dim...

Thank you SOOOO much Paul i ran it and found a few more errors which i fixed however go stuck on a line which i have had troubles with for a while. i cant seem to get it right. Its in red below. Dim db As DAO.Database Dim rs As DAO.Recordset Dim rs2 As DAO.Recordset Dim strQuery1 As String Dim...

Hi all Can anyone help with this error message that keeps occuring. 'Run-Time error 3464 Data Type Mismatch In Criteria Expression.' It happens in my code below in the line highlighted in red. Thanks in advance Option Compare Database Option Explicit Private Sub...

ok so it will run until the line in red. Then the line in red produces an error stating that 'element not found'. Thank you for your help so far.. Can you help me with this problem? Private Sub Custodian_History_Form_Enter() Me.[Custodian History form].Nodes.Add Text:="Custodian History"...

yeh i did but it still wont work. ok here is the current code im trying to run at this moment. keep in mind i have changed the name asset # to assetnumber. The error '424' object requires keeps popping up for the line in red. Private Sub Custodian_History_Form_Enter() Me.[Custodian History...

Thank you very much pbaldy, this lets that line of code run. However it produces the same error on the line below ([Asset #].AddItem strcombo). When i try to change the '[asset #]' to ("[Asset #]") it wont let the line run because of a 'compile error'. I then took your advice and changed the...

Thanks for the quick reply Guus2005 The error occures on 'strcombo = Record_Set1([Asset #])' line and the error states that 'microsoft office access can't find the field '|' referred to in your expression' Nick