Search results for query: *

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

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

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

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

I have an error which appears when i run my code, i have had a look at it and i dont know whats wrong, so any help would be gladly appreciated Many Thanks Vicky strSQL = "SELECT Count([Complaints Table].Counter) AS CountOfCounter, [Complaints Table].[Type of Complaint]...

I have a VBA query which errors saying "Missing operator in query expression 'Format([Date],""mm"") AS Month'. Any ideas what is missing as I keep trying different things and im not getting anywhere? Thanks in advance Vicky strSQL = "SELECT Count([Complaints...

I have a nested query and it comes up with an error saying "Run-Time error 3131, Syntax error in FROM Clause" and i keep looking at my code and I just dont know whats wrong. So any help would be much appreciated. strSql = "SELECT Count(Counter) AS CountOfCounter, [Type of...

I have this piece of code than runs on a form with 3 drop down boxes which the user can select from either of them and then the other form will open at the record which is specified in one of the dropdown boxes. When i run the code it doesnt error for the first If statement but it errors for the...

I have a report which is exported to RTF format. But when I do this my memo field gets split up, as the report is 2 pages long, but instead of the rest of the memo field appearing at the top of the page it starts half way down. I would use a Snapshot but i need the file to be editable. Any ideas...

I have a report which is exported to RTF format. But when I do this my memo field gets split up, as the report is 2 pages long, but instead of the rest of the memo field appearing at the top of the page it starts half way down. I would use a Snapshot but i need the file to be editable. Any ideas...

I have the code shown below which looks up 2 values in another table and inserts those two values into my form. But these is a problem with the sql statement. I can get it to work if i just use "select * from tbl_yearly_figures", but when I put in the "where" part then it...

I have this code below which locks the controls on a form if either of 2 check boxes are ticked. When it locks the controls i also want their background colour to go grey. The code below kind of works, it locks all the controls if the check box is ticked on that form, but it makes all the form...

I have this code below which locks the controls on a form if either of 2 check boxes are ticked. When it locks the controls i also want their background colour to go grey. The code below kind of works, it locks all the controls if the check box is ticked on that form, but it makes all the form...

Private Sub Form_Current() On Error Resume Next Dim ctls As Controls Dim ctlCur As Control Dim fEnabled As Boolean Dim i As Integer If Me![Date] >= Date - 10 Then fEnabled = Not (Me![Verify Release] Or Me![Op Verify Release] Or Me![RS Verify Release])...

I have this code and when i run it it comes up with a message "end if without block if", i'm new to if statements and not sure whats wrong. Also the txt_box holds the value so when the form is opened, the password is still displayed which of course for a password isnt very appropriate...

I am using Access 97 and I have this piece of code and i cannot get it to work, im pretty new to the VBA side of access so any help would be appreciated. I want the user to select their department, then enter the password and then check this against what is stored in the tblPasswords and then...

I have a combo box which has two columns, the second of which holds an integer value to replace what the user selects from column one, as the user would not understand the relevance of the integer value. I have set this up and as there are two columns it puts a scroll bar along the bottom so...