Search results

Thank You! I Wanted This Done For A Long Time And I Couldnt Figure It Out! Thanks Sooooooo Much!

This is in Access 2000. Open AllRecordsSearch. Go to the right and click the contacts tab. Type in "Blass" for the last name and click search. As you can see, "Blass" comes up, BUT "Buchanan" is selected (first in the list).

Here, I will just send you an example of my DB. THanks for your help.

Weird, I think it worked the first time, then I did another search and it didnt work and wont work again.

No, sorry for not telling you this earlier. When I perform a search, it works, but in addition to bringing up the matched record, it brings up the rest of the clients according to the Company. So when I search Last Name: Johnson. It will bring up the records with the Last Name that is...

The message box appeared: found a record. searched on: [Last Name] Like '" & Me.txtSearchLast but still, the record was not on the searched last name. The point of this is because I have highlighted rows. So when the record is selected, the record is highlighted. But when I do the search...

Yeah, I know I should base it on a query. I couldnt for some reason. Thanks for your help.

Again, I do appreciate you helping me out here. Thanks a lot.

Yeah, that didnt work again. Weird. Hmm.

Yeah, that is still not working. I dont know. I used the DoCmd.GoToRecord, , acLast and it worked and went to the last record in the list. Do you have any suggestions on doing a GoToRecord function?

I couldnt base my form on a query form some reason. I tried before and it wouldnt work because it is a form with two subforms. Main form has Company information. Subform1 has Client information per Company. Then Subform2 has Lead information per Client. And this form was created for the...

I feel really dumb asking this question because I feel stupid right now. I have Accounts that are Active and Inactive. In a form, however, I want to only show Active accounts. A invisible combo box in the form called cmbActiveInactive shows whether or not the Account is Active or Inactive...

That still goes to the first record in the list. In advance, thank you for your help.

? Can anyone help ?

Hi, in my main form I have company information (Name, Address, City, State, etc). I am searching a subform. My subform contains Contact information (First Name, Last Name, Title, etc). I searched for several weeks on this issue and I have had no success. This is my code: Dim strSQL As...

Does anyone have any other ideas? Thanks.

Just tried downloading it, but it doesnt work. Please view your PM. Thanks.

Because, what I have done, employees dont even have to submit their employee I.D., Time In, and Time Out information. This all can be done automatically without wasting time inputing that information

Hi, I just did this. PM me if you want help. Or send the database to me and maybe I can do it for you!

I just tried that and it didnt work. My string variable is: l_strAnd And this is what I put: Me.ClientInformation_Subform1.SetFocus DoCmd.GoToRecord , , "[First Name] = '" & l_strAnd & "'" Any other ideas?