Recent content by vix666

Thanks for your help. In the end i just changed my code to rebuild the tree from the table thus eliminating the need for the line of code that errored. But i will look into this problem as no doubt it may cause other problems in the future from the way it has been built. Thanks Again Vicky

I have just picked up this project and have never used treeviews in vba before and have done some research but still cannot understand why I am getting an error. My code is posted below and it error occurs on the "oTree.Nodes.Add oTree.DropHighlight, tvwChild, "c" & iNodeCount + 1...

Firstly i apologise if this is a really easy question to answer or if i am going about this in completely the wrong way as I have only just started using ASP.net and SQL server and have been thrown right in the deep end. I am trying to get the value from a field within the details view which...

Great! :) Thankyou very much Vicky

I want to be able to refresh a form from my module using a variable. At the moment I am using Forms!strFormName_JD.Refresh but it just errors, i have tried different things, e.g putting quotes and ampersands around the variable but nothing works. Any help would be greatly appreciated Thanks...

I presume you mean that when you open the query you want it to ask the user for a user ID. If so then build your query using query builder and select all of the fields you want. Then in the 'criteria' part of the query builder under the User ID field enter your message which you want the user...

I want to be able to change the default value in a subform by using code. This subform is used as a template and when the user a clicks on a button its recordsource changes, therefore i cannot just set one default on the subform control, i need to dynamically do it depending on which the user...

Thanks very much, i had completely forgot about that, thats what happens when you do so many different kinds of work - you forget stuff! Thanks again Vicky

I currently have this code below which errors on the sql statement saying 'too few parameters expected 1', this should work as its only a simple query - im confused! Any help would be much appreciated Thanks in Advance Vicky Dim intRecordID As Integer Dim db As Database Dim rst As Recordset...

Thanks alot for all your help. I finally figured out what it was. it was concerning the dates and the format which they were held in. in the table they were held as long date and the form which i referenced to get the dates to query by was holding the date as a short date and it caused a...

I have kind of set it up from scratch, it still uses the same strSQL as the string but i entered it all from scratch. Thanks for the help. Any other suggestions? Vicky

nope i know that they are group, they are grouped to give me a total of complaints per complaint type per month over the date period specified. It should return 42 rows which is grouped from 156 rows. Im completely baffled by this one Thanks Anyway Vicky

I agree i must've overlooked something really simple but can't think what. what did you mean by remaining criteria? Thanks Vicky

Thanks for the help. I have changed the dates and it was already storing it as a british date so this did not get rid of my problems. So i have tried writing a simple query eg select [fieldname],[fieldname] from [tablename]; and it only has 1 row for its recordset when it should have over 900...

I have this sql statement below which has recently stopped working and is only returning 14 rows instead of 42 rows. Im completely baffled by it. So any ideas would be greatly appeciated? Thanks in advance Vicky strSQL = "SELECT COUNT([Complaints Table].Counter) AS CountOfCounter...