Recent content by kenjones

The following works when I am searching a form on a value in a sub-form where the value is text ------------------------------- Private Sub find_boats_by_enq_no_Click() Dim stDocName As String Dim strSQL As String Dim trz As String trz = InputBox("Enquiry number??") stDocName =...

The double quotes work So "kenjones@somewhere.com" - OK kenjones@somewhere.com - OK "ken.jones@somewhere.com" - OK ken.jones@somewhere.com - Error message Why do you think the double quotes make a difference? And can I alter any of the properties of the field so I dont have to use the...

There is no special code or macro as far as I'm aware I'm just using the Access filter by form buttons that are on the toolbar. Click the first and you see the form with all fields blank. Enter the value you want to search/filter for in the appropriate field and then press the second button...

I'm using filter by form and have an issue with email addresses For example if I search on - "kenjones@somewhere.com" that's OK But if I search on - "ken.jones@somewhere.com" I get the following error message; "The expression you entered contains invalid syntax You may have entered an...

Hi Originally I posted this in "forms" last Friday so apols if you are seeing this again. Still unresolved I have a form displaying contact details. One of the fields being email address. Works fine until I enter an email address to search for with a "." before the "@". So It will search...

I'm using the filter by form buttons at the top of the page. When you press the first [left hand] one you are presented with the form cleared so you can enter what you want to search for in one or more of the boxes/fields on the form. When you press the second [RH] button it runs the filter and...

I have a form displaying contact details. One of the fields being email address. Works fine until I enter an email address to search for with a "." before the "@". So It will search for kenjones@ But ken.jones@ Will generate the following error "The expression you entered contains invalid...

'empty' is the value of the field company.main_name. I dont think there is a problem with the relationship. If you see my first post SELECT works exactly as I would expect it to. The problem arises when I try to delete the records I have tried your suggestion as follows; strSQL = "DELETE FROM...

OK I now have the following to try to delete the one field -------------------- Private Sub areas_delete_empty_records_Click() Dim stDocName As String Dim strSQL As String stDocName = "areas_delete_empty_records" strSQL = "DELETE areas.[country] FROM areas INNER JOIN company ON...

I have two related tables, company is the one table, areas the many I want to be able to delete records in the many table that match the criteria of a field in company I have no problems selecting the records with the following; ----------- Private Sub areas_find_empty_records_Click() Dim...

Great! Again thanks Taruz! This is so easy when you have somebody by your side who knows what they are doing! So the combo box. And I'm going to reach for the skies here. What if I want to search the table countries by both "country" and a second field "areas" And then another table with a...

Great! Thanks very much Taruz! More generally. If I want to search by different countries I can do it with numerous buttons or I can change the code. Neither seem that neat a solution. Before I waste a lot of time can you suggest a solution. I think I would like to click a button and have a...

Hi I have a form (Company) with a subform (Areas Inc Lay Company) The subform has a combo box (country) (record#) and (areas#) are the related fields in the underlying tables With a command button (company_find_bareboat_operators_spain), on the main form I would like to filter records of...

Hi Paul No I didn't. I'm no further on than my previous post where, after taking a look at the link you posted, I made some changes. If you could a look at the changes and point me in the right direction that would be appreciated Ken

Hi Paul Thanks for the reply I had a look at your link and made some changes. Obviously I'm not grasping this cos I get the same problem. I assume the problems are on the following 2 lines; strLinkCriteria = "[record#] = Forms![Areas Inc Lay Company]![areas#]" DoCmd.ApplyFilter ...