Search results for query: *

Worked like a dream - thank you very much.

Sorry I'm a novice. Where do I put this update query and how do I run it? I assume I replace 'yourTable' with the name of the table i.e. 'Clients'

I have 36000 email addresses in a table but could not search on them to find records when they were in 'hyperlink' format. I changed the format to 'text' and I can now search BUT the problem is that many of the email adddresses now show as client@junglematsse.com#http://client@junglematsse.c...

I have been storing email addresses as a hyperlink in a table, but Access will not sort this into order. So as I do not need the hyperlink I changed the data type back to text but now all the email addresses appear like this format... abc@drabc.freeserve.co.uk#http://abc@drabc Is there any...

Thank you both v much! Kieran

Sorry it does work with Child250 as the name BUT it is slow searching through 30000 records - is there any way of doing it via a module to speed it up. regards Kieran

I tried using expression builder as you suggest - I think the subform is referred to as 'Child250' or 'New Sales Subform' but neither these seem to work or display field names under expression builder- the db pops up a box for me to manually enter the number instead. I tried.. [Sale ID] Like...

This doesn't work - I guess I need to substitute [SUBFORM] with the actual name of the subform but it doesn't have one! Any ideas?

I have a form showing a clients record which has a subform showing brief details of the clients past orders. I would like to make the subform clickable so that if a 'Sale ID' is clicked on the list another form called 'Sales Record' opens and shows full details of that sale. Ideally my where...

Thank you - I've already done that one as well on all the FEs. It is a very good tip though.

Thank you - I have checked network speed and deleted temp files and the network speed is the same as other machines. Must be some other cause?

We have an 8 PC network using an FE/BE database. Our newest PC (with the highest spec) is actually the slowest at completing tasks on the DB. For example, a form contains buttons which open up another form and the a word document and then inserts fields from the new DB form into 'bookmarks'...

Thank you I'll give this a go.

I have a split FE/BE database which 8 PCs in the office connect to. Since splitting the database a few error messages pop up relating to the database not being available. When I check windows explorer the mapped network drive containing the BE will have a red cross on it. When I click this...

Thank you for a speedy and successful post - have a star. Kieran

Works fine for SURNAME1 but does not like the syntax for SURNAME2 - it is showing in red - can you use OR in this statement? regards Kieran

Hi, hope someone can help. I am trying to open a form to display certain records i.e. users type in a surname or part of a surname into a field 'goto' - I want the form to display all records where either 'surname1' OR 'surname2' (these are Mr & Mrs records which could have couples with...