This is a two part question regarding a splash screen and subsequent form that opens in my database.
Part One :
I have an initial splash screen that opens with only a tagline displaying, and after a brief interval the tagline becomes hidden and the logo displays. I am currently using the "OnTimer" event to hide the tag line and display the logo. The problem is I need another timer that will allow me to display the logo for a brief interval and then open the search form. So without multiple splash forms I need something that will have the following functionality:
Spash screen opens (when user opens database) and displays the tag line for a brief interval. When that interval expires the tagline becomes hidden and then displays the logo. After another brief interval the splash screen closes and the search form opens.
Part Two :
I have a search form with multiple search fields on it. One of the fields uses the primary key in the event the user knows what they are looking for (which will be often) they simply enter it and go straight to that record. The default behavior in access seems to be that when a text box gets the focus the cursor displays in the leftmost position which is exactly what I want. However it only seems to work programatically because when a user clicks on the text box the cursor displays where they clicked even when the text box is blank.
I want the cursor to default to the left position only when the field is blank regardless of how the user got there be it by clicking, tabbing, or programatically. If that field isn't blank then the entire value should be highlighted when they tab into the field, or are sent there programatcially, but if they click in the text box the cursor should go to the point they clicked.