Search results

Thanks Rich. But I did a search before I wrote the post and found nothing that dealt with the form's title bar. I did another search and mine was the only post that appeared. Is there possibly another place to find this? Mike

Does anyone know how I can change the color of the form's title bar using Access VBA?

A static variable in a sub or function remains as calculated when the function closes. The first time the function is run the static variable = 0; when the function opens it increments the static variable by 1 and then closes. The next time the function opens the static variable = 1 and the...

You then can set up a parameter in the criterion: Like "*" & [Who is the advertiser?] & "*"

Try using a page count in the report. You may also use a text box on the report that is fed by a function that increments. This function will need a static variable and a parameter telling it if it needs to initialize the static variable (counter) - that is set to zero. Before you run the...

How about using a Like "Panasonic" criterion for the target field in a query that is fed by the table containing the words of the articles?

It looks like you need to use a weighted average; this will handle the zeroes. What you do is multiply the efficiencies by 1, add up the results and then divide by the number of instances. You may have to do the multiplication in one query and then feed the result to an aggregate query which...

Hi, I decided to give up on a rich text box for Access reports. But all is not lost. Using VBA I created a Word document for each song's lyrics with a filename that is based on the song ID. I will just use automation to get Word to print what lyrics are needed. It appears that this will...

Hi, I think I'm getting the hang of the rich text box. I have a form - the one from Spacepro's suggested download. I found that if I past the data into the rich text box on that form, the data's formatting specs are changed to the type apparently preferred by the rich text box. This is shown...

Thanks spacepro, I downloaded and looked at the example but the data still looked cryptic as if it had template specifications in it. The data I want to display has formatting data for things like linefeeds and carriage returns. When I copy and paste it into a Word document – RTF formatted –...

Hi, Does anyone have a sample app for using the Rich Text Box control? Even though it has a control source, the control seems to ignore it. I don't have a clue where to start with it. I downloaded the RTF2 ActiveX control from Lebans Holdings but I don't understand their their sample app at...

Hi, I have noticed that the DoCmd.Hourglass method works under certain circumstances but doesn't work under others. A situation in which it did not work is when I was resorting a tabular form after clicking on the label above a field. Because it was taking longer than I wanted to resort the...

Thanks Spacepro, I'LL give that a try. I was thinking that I would have to copy the field contents to a file and then read it with the web browser control but I didn't want to. I guess that is what I will have to do. Thanks again, Mike

Try a main form that contains a combobox fed by the possible teams. Add the other form to this form as a subform. Use the combobox as the criterion for the query that feeds the subform. You can do this using the build functionality. Then on the afterupdate event of the combobox requery the...

Hi, I am creating an email app in Access 2002. Everything seems to work fine except that when I try to display the body of the of the message. If happens to be in HTML, all of the HTML code is displayed as well. I would like to display the message as a web browser does. What control would I...

Terminal Services is a feature that is included with Windows 2000 Server - probably 2003 also. When you run an Access application using TS both the front end and the back end are on the server. The user effectively has a desktop on the server and a window to it from his/her client desktop...

One other possibility to handle the network issue is to use Terminal Servces. This will set it up so that only screen changes, mouse clicks, and key strokes traverse the network. We did that is it helped a great deal.

You can use a field. Say the table is tblProperties and the field is CtrlBox. You can use the following code: me.ControlBox = DLookup("CtrlBox", "tblProperties") This way it would be more flexible.

Hi, I just thought of something else. You can create a SQL statement that will show the name of all forms in the MSysObjects table. Look at the table to figure out what the ID code is for forms in the last field of the table; its -32768. SELECT Name FROM MSysObjects WHERE Type = -32768...

Hi, You don't need this code. When you create forms, disable the control box at that time and add a button that will function as an alternate way to close the form. If you don't want users to close the forms at all, you might consider something like the following: Dim frm as Form For Each...