Recent content by Rowen

Ok I've copied and pasted the controls to a new form called subRepairs, but I'm still getting the error 2465, on this line of code: Forms!frmsearch.subRepairs.Form.Filter = "StairID = " & Me.cboStairs & _ " and inspectiondate between #" &...

Having the code as Me!subCaretakerSearch1.FilterOn = True gives me a run-time error '438', object doesn't support this property or method. Or have I not set the code quite right?

I've put in the debug.print on both lines of code relating to the subform, and I don't seem to be getting anything. I can't get it to give me the original error now, as it's giving me that variable not defiend error for the on click event on the command button. And now as I'm going between...

Ok I've added the Me! to all the filteron= true bits, and I'm now getting the following error: Run-time error '2465' Application-defined or object-defined error It's highlighting the following line Forms!frmsearch.tblRepairssubform.Form.Filter = "StairID = " & Me.cboStairs & _ " and...

Sorry I should have mentioned, I commented out the last bit to see if that was causing the issue. I get the same error if I uncomment it.

Hi, I'm hoping someone can help me, I have a form with 3 subforms, I'm using some combo boxes on the main form to filter the 3 subforms. The vba code I'm using works for 2 of the 3 subforms, and I can't figure out why it isn't working for the 3rd one...

Thanks DCrake, It turns out that the form wasn't corrupted, but re-doing the form did allow me to discover that one of the tables I was referencing for a combo box didn't have the right permissions on it. I've sorted that out and it's all working fine now. :) I just knew it would be something...

I think this is the right part of the forum to post this and I hope someone can help. I'm trying to create an access front end to an SQL Server backend, I've linked my tables and set forms to help view and edit the information, however on one form, and one form only I keep getting the...

I am also getting the error error: an invalid argument was passed in the function call. I have tried both variations of the line above and neither works. I get the same error, and the email appears in my email as a work in progress email and blank. The line the error seems to be raising the...

I'm hoping someone can help me, below is my code, to get some data from a table in SQL server and to insert it into different table into an access file. However what I need to add is something like the following line of code: dbo.tblEstateInspections.EstateInspectionID NOT IN (Select...

Ah-ha, Thanks for the link, it didn't quite fix the problem, as following the solution for the Group By didn't stop the field from being truncated, however I ended up removing the group by for the whole query and that did solve the problem. So thanks for the help. :)

The section of the report is also set to can grow = yes, I've had a look and it is a memo field, however there's another report that uses the same information but from a different query and the information isn't truncated in that. I've had a look at the two queries and I can't see any real...

I have a report with a text box where the can grow setting is set to yes, however when I preview the report the text is truncated. Does anyone know how I can fix this so that the whole text appears in the report?

Raising the topic from the dead a bit but this issue is pretty much related. I'm now trying to update an existing record with a date value that is based on when a check box is ticked. I need to insert the date as dd/mm/yyyy format. I've got the following code: DoCmd.RunSQL "Update...

It's ok, I figured out that it needed a 0, probably just as you were posting. I think it's still a bit too early in the morning. :) Thanks for the help.