Search results

Yes i have tried it - but unsucsessfully. Here is what i have. On form one a command button with the following procedure: Dim DocName As String DocName = "find" DoCmd.OpenForm DocName Which opens for number two called "Find". Form number two has a command button called "ID...

we use the docmd.findrecord "bla bla" command. What we need to do is before the command is somehow record the position (current field) of the focus, then after the findrecord command re-set the focus back to the same field. I hope you understand what i mean.

Thank you raskew, there was an underscore that needed removing and a space too. All is working. Thanks for you help and the code!!

I have a form with 49 small text boxes taht i populate with numbers in a 7 X 7 grid format (similar to excel) At the moment i am on record "1" and the focus is in field "text10". When i do a find record search and i move to a different record, say to record 30. The focus moves does not stay in...

How do you get the focus to remain in the same place (same field) after a new record has been found. At the monent it just gose back to ID field (perhaps because it is tab stop 1)

raskew You code has the wrong number of arguments error. perhaps n=Right(mynum), 3) i don't know but it does not work.

thank you. I may stick with what i have - because well here is the code from the text boxes control source: ="You Are Currently In " & [rank] & [suffix] & " Place With £" & [total1] & " In The Bank" and i don't know how to call the public procedure to work in this way. BTW. Do you know how to...

What i have done is create another table with two fields. Id and suffix Id has 200 records from 1 to 200. And siffix carries the correct th, rd, etc for the number in the record. And then made simply a select query with a join between Id field of the original table and the suffix field of the...

I have a ranked list of numbers which when displayed in a text box via it's control source i would like to add the "th" or "nd" after 1 or 2, etc. How is this done?