Search results

Thanks again for the reply If I try that it still comes up with the same error, its seems to be getting stuck on the forms part.

Thanks for the reply, if I put in the code Me!FormsfrmSearch!frmSearchHousing![Type of housing] it comes up with the error I mentioned before, but it says it can't find 'forms' this is the actual if statement I'm using, (I have several other implementations of this code but for fields on the...

I've created two forms, my main form, and a search form which is a straight copy of the main form but called search form. The search form has a command button which runs the "Query by form" from Microsofts web page (KB210242), for the most part it works, but on the forms they have two sub...

Ok, I have figured it out, I had to delete the record source of each individual field on the form

I wasn't too sure where to post this, Queries or in Forms. Anyway, I have a database, with the main form (frmMain) to enter data, I have copied this form to turn into the search form(frmSearch), I have done the straight copy paste, to get the search form looking and feeling the same as the...

I've got a search form which uses the Query by Form code from MS web site http://support.microsoft.com/default.aspx?scid=kb;EN-US;210242 This all works, except for one of the fields is a drop down list, if I select a name and do the search no results are displayed, I can do a case statement for...

I'm in the process of creating a simple data access page address book, but I can't seem to figure out how to do a search on multiple fields, e.g. I want to be able to search by first name and surname. At the moment I have two command buttons one to search first name and one to search surname. I...

Thanks again for you help, I have been just looking at that, a fellow colleague has just pointed out the same mistake. I'm working on creating the query again. Thanks

I have just created a form based on a query of a number of tables, when I enter data into the form, the data goes to the tables, but when I close the form and re-open it, the records I have entered aren't displayed. I opened up the query and it didn't show any results, but again like the form I...

Brad, Seriously, thanks for everything. I actually had a message box, and it showed me # #, but I didn't know how to solve the issue. Thanks again Cheers

sorry to be a pain, but now when I try to search with out the date field been filled in I come up with Run-time error '3075'. If I put a date in it works fine.

You are an absolute God Send! Thank you soo much for that. Cheers

Thanks Brad, But I am still getting:"Run-time error '6': overflow message when I Debug it is on that line of code. where = where & " AND [Date of Application]= #" & Format([Date of Application], mm / dd / yyyy) & "#"

you know what, that was a top guess! Thanks heaps for that

but I keep geetin an overflow error message, so I'm not sure how to modify the code I have tried changing the code like this: where = where & "Select * from [1 Application Details] where [Date of Application] = #" & Format([Date of Application], mm / dd / yyyy) & "# ;" but I keep getting a...

Please, someone I need this code, or for someone to steer me in the right direction urgently Thanks

Please, someone I need this code, or for someone to steer me in the right direction urgently Thanks

This is the code I have: Private Sub cmdRunSearch_Click() Dim db As DAO.Database Dim QD As QueryDef Dim where As Variant Set db = CurrentDb() On Error Resume Next db.QueryDefs.Delete ("Dynamic_Query") On Error GoTo 0 where = Null If Left(Me![First Name], 1) = "*" Or Right(Me![First Name], 1)...

I have created a Search form using the code at this URl : http://support.microsoft.com/default.aspx?scid=kb;EN-US;210242 it works except I cant use it to search by date, which I need to do. It will only search in U.S. format, MM/DD/YYYY, as I am in Australia I need to search in the following...

Anyone??!! I have also added an Else to my code so now it looks like this: Private Sub ComboBox_AfterUpdate() If Me.textbox1= "Specific Value" Then Me.Textbox2= "Specific Text" Else Me.Textbox2= Me.Textbox2 End If this code is also in the Form_Current() but I still can't get changes to the...