Search results

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.

I've tried putting the NZ() function in two ways, the first like " & NZ(rs1("FlatNo")) & " which gives me the same error I was getting, the second NZ(" & rs1("FlatNo") & ") I get the error that 'NZ' is not a recognised built in function name. Am I putting the NZ in the right place?

I'm not quite sure if this is the right section of the forum but I'm having some trouble inserting data into SQLServer from Access. I keep getting an 80040e14 error, Incorrect Syntax near ','. My code is the following rs1.Open "Select * from tblCaretakerComments", cnFrom, adOpenStatic...

Sorry for the double post, I was having issues with the connection when I posted, and my questions seems to have posted (at least I can see it), but the topic hasn't been updated.

I've tried to find the original data source, but I've had no luck, so it's looking like I'm going to need to set up my own ODBC. But then I think I'm going to have an issue with passwords as at the moment the users just open the programme and can start using it, obviously I don't want to change...

I have found this piece of code and am attempting to make it work at the moment, but really I'd like the date to stay in English format, I've seen things that say Set DateFormat DMY, but I'm not sure how to get this code to work in VBA. Edit: I changed it from 101 to 103 and it's working...