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.

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...

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

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

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)

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...

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...

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 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.

display some long text (commentaires) in forms. Within the text are to be hyperlinks to figures which opens in a new form. I have tried using text boxes & labels but the text is too long for these. Also I would like to group all commentaries for a site in one form and then jump to the location...

I have these word documents that I have to display. Within these documents are to be hyperlinks to some figures. I do not want to display them in Word as I do not want the Word bars etc. so I thought that I could do them all in a form and jump to the relevant area of the form as needed. Sort of...

I have added more into to the post. Any help?

I am using buttons to search for specific information. when the data is found it is displayed in a list box. I also need to display a total at the bottom of the box like total number of sites. Hown can i do that using code.

Is it possible to hyperlink to section in a form, like a bookmark? If so, how and if not what is the best way?

I am updating a counter on exit of a form. If the form is empty and the user clicks exit then a blank value will be written. How can I check if the form has data in it using code and not ONNODATA.

I am displaying some images which are stored outside of access in a form. The path to these images are stored in a field and swapped in when needed. Is there a way to specify a relative path so that it changes if I move the database to say a CD-ROM?

I have an unbound form with a combo box, a list box and a control for a picture with navigational buttons under the picture box. I select a category from the combo box and if there are sub categories for this category they are displayed in the tex box. I then select from the text box and the...