Search results

You havent helped me with my problem at all.... I want my label name to change in relation to another field.

This is probably an easy to do, but somehow I am stuck. There is a field in my form that lists if the company is a hospital or clinic (OP or IP). And then there is a field in my form that shows the size of the company. The label is "Size". I dont want that label to be "Size". IF the...

I tried it and it didnt work. I am probably not doing it right. I am still confused. . . .

Awesome. One more question...sorry. I have multiple fields that I search from. In the example code I supplied, I only listed one field. I have 4, I believe. How do you DCount all of them at the same time?

I am totally lost...still. Sorry.

I just looked at some DCount() information and I dont seem to quite get it. Could you help me out a little more...

I made a search form. I want to add a message box when there are no results. What would the code be to add a message when the search returned no results? I know you have to put: MsgBox "Your search returned no results. Please check the spelling and try again.", vbInformation, "Invalid...

Ok send me a PM if you have anymore questions. Good luck!

Ok. That is ok. Open up your form in design view. Go to View > Properties. And go to the Event tab in the Properties menu and find On Open. Click on the white space and a ... box should be visible. Click on the ... and it will bring up another menu and choose "Code Builder". And that will...

Try this: Me.OrderBy = "[Forms]![Issues]![ID]" Me.OrderByOn = True If that doesnt work just put in the field you wish to order by instead of [Forms]![Issues]![ID] so it would look like: Me.OrderBy = "[fieldNameHERE]" Me.OrderByOn = True And put this in the OnOpen Event.

Send an example of your database, maybe I could get you on the right path.

I just did this to maximize my startup form. On the OnOpen Event put: DoCmd.Maximize Worked for me.

But I think you might just need to go to the table that the form is based off of and sort the ID field as you want and then save the table and then open the form again....

I would need to see an example because I dont really understand what you want to the extent to help you.

Dont know if this is right, but it will point you in the right direction I believe: If Me.ARW.Value Or Me.ARW2.Value > 5 Then Me.Check1 = True End If Like I said, that might not be entirely correct, but at least it is the right direction.

Thanks. I am at home, but I will try it first thing tomorrow and I will send you a message of how it went. Thanks again.

Ok there is the example. It is from Access 2000. A little background: there are three tables. Accounts is information about certain hospitals. ClientInformation is client information pertaining to the hospitals linked by Account ID. Then there is LeadInformation. This database is intended to...

I dont know how to PM you...but it will be up soon. I havent downloaded Win Zip yet so I am downloading it and then I will zip the database. It will be up in a few minutes.

All of the information is confidential, but I will create a new database with generic information. I will have it up in a short amount of time.

Yeah, I read everything. And pasted the code into my form. And changed the field names and form names, but I still have had zero luck.