Search results

When I open a form with a text box that displays a memo field the form opens with the text highlighted and when I click in in it comes off. How can I prevent this from happening when opened. Is is possible to access the scroll bar properties of a text box. Thanks all.

Gee, Never thought of that. Thanks.

I have two popup forms. I want a modal effect in that the one on top must be closed before accessing the bottom one. I need to do this without setting the property of the forms to be modal as at somepoint I need to make them invisible and when they are modal and visible is false MSAccess hangs...

Thanks. Would IsLoaded return true if the form is hidden?

How do I use VB to check if a form is open? Thanks

I am not using any code. The field is a memo field with lots of text. I have to use the vertical scroll bar to see all the text. What I want is that when I have scrolled down into the box to read what is there that after clicking outside of the box that I do not have to scroll to where I was...

I am scrolling in a text box and I am in the middle of the box. I then click on a hyperlink outside of the box to view a picture. When I go back to the text box, I have to start from the top again. I there a way to keep the scroll location of the text box once it has lost focus? Thanks much

Thanks much. The thing is, I know that the code should go in the onopen event but it is the code that I do not know how to build. My form will consist of data on Areas, Distance, Elevation, Site Code and Parish Name. These are not all present at the same time as it depends on the criter selectd...

How can I print the results of a form search which changes based on criteria selected by user and the result is displayed in a list box on another form. (The latter is what I want to print)

Bound Column is 1

Why does a selection from a combo box displays the first option in the box instead of the selected option. Correct calculations are however performed on the selected option. Here is the code. If cboSite.Value <> "(ALL)" Then With Me!cboCategory .RowSource = "SELECT...

Thanks a lot. Inno Setup looks like the what I want.

I have an access database that i want to distribute on CD. The database access files (.jpgs etc.) in different folders on drive C. I want to be able to have something like a setup program that would install the files in their respective location so the they will be found by the database. Does...

If I add "where" won't this filter out the other items? You see, I want all the other items in the combolist to be there but I want to jump to this particular item in the list. Its like making it the default value only you don't what it is.

I have a form with a list box with items in it. I want when I double click on a row a form opens and displays the corresponding record. The problem I have is automatically selecting the corresponding item in a combobox on the form being opened which would then display the rest of data. Thanks...

I have a subform with Tab controls on it. A combo box which is used to select a site is on the master form. There are times when a site is selected and there are no relevant data on an associated tab. How can I check if the tab is empty and perhaps display a message or make a message label...

I am not sure I understand. One of the SQL statement for the Recordsource is below. I tried using the DLookup with rstRecSource as the domain but it gave me an error. Any more advice. Thanks strSQL = "SELECT Sites.Name, Parish.[Parish Name], [Picture Gallery].SiteCode, " & _ "[Picture...

I have set the recordsource of a form based on selections from combo boxes. How do I check if records were returned?

I have a tab page with different pages. How can i check to see if page is empty so that i can display an appropriate message instead f the user seeing a blank page. Thanks

How can I display text with hyperlinks within it. The text is too much for labels and text boxes.