Search results

There is nothing in orderby

I did change the name of a field but I can't find the OrderBy property to check if the old field names are in there. Where should I look?

Hi, I have a problem when I try to open a form called frmCrisisSupportWorkers from a database I am making. When I do, a message box keeps appearing that says "Enter Parameter Value: tblTCLocation.tclcation" but I don't know where this is coming from or why it is appearing. I have been trying...

With binding the query to the form, I can't as it has the table bound to it that has all the data. Is a good solution to copy the form and bind the second to the query and when you press on the search button, it just opens the new form that is bound to the query?

How do I bind it as I thought you just put the query in the record source for the form but I tried that and that doesn't work?

Sorry, my message made sense to me at the time but looking at it now, I can see it wouldn't make sense to others. I meant that when I type it txtSearch and run the query, it returns the records that are similar to the search box. So that is the bit I got working, although, to search for...

But how do I search for a letter or word and have every record returned that contains that letter or word in a field somewhere in the record, but in form view, so that you can see all of the related information?

Great, thanks. Now that I have that bit working, I wanted to have a button that when I press it on the form, it will search through the fields but then when it finds results, it will post the records that have the results in the form fields. How would I do this?

I have tried putting a text box called txtSearch at the top of the form . I then have a query that I run that looks at what is in the text box and tries to match any fields to it. In the criteria for one of the fields, I have Like "*&[forms]![frmCrisisSupportWorkers]![txtSearch]&*" where...

Hi, I need help making a search function for a form. I have a form with details about telephone counselors and want to be able to place a text box at the top that allows me to search through all the fields in the tables that the form relates to or displays. Could someone help me please...

What is all that code you have got in the macro down under the GoToControl in the macro? _AXL:<?xml version="1.0" encoding="UTF-16" standalone="no"?> _AXL:/2009/11/forms"><Statements><Action Name="OnError"/><Action...

That's great Gina, thanks for that. How did you do it?

I think I might know how to do it, I just don't know the vba code to select the next record. I have renamed the text field to txtTCID so I could just use the code txtTCID.setfocus I think.

Here is the database

I put it on frmCrisisSupportWorkers. I wanted to select it to go to the next or a new record then the focus to go up to the TC number so you don't need to take your hands of the keyboard. I can use the features of the button to make it go to a new record but I don't know how to set the focus...

I have made a button on my form to go to the next tab or make a new tab but how do I get the focus to switch to the TC number field once I select that button?

Guess it is a bit hard to test it if you don't know how to test it or how it should work. Maybe I will continue testing and let you know if I have problem ;)

Does my search form appear to work alright? Just thought someone else should look at it through a fresh of set eyes, in other words, not me. Something may be spotted that I missed.

Thanks for bringing that to my attention. I asked my manager and she does want it drawing from separate tables, so I will use that. I will just need to make another table.

I meant, location appears to work fine. In the table, I noticed a WorkLocationID field and I wasn't sure if it was needed as I wasn't really using it but I wondered if I should be using it somewhere. Only thing is that I can't make a relationship from it to the location table as there is...