Recent content by Skippymouse

Does anyone know if I can wrap to 2 columns within a single concatenated text box? I have a long skinny list that could be displayed in 2 columns if it can be done.

If you add this phrase to the criteria of the date field in the query behind the report/form it will prompt for dates. Be sure to keep date format in mind (usually short date works best- mm/dd/yyyy). If you are not drawing from a query, simple create a query that matches your table and then...

Finally got it. I appreciate the suggestions in this and other topics. Your help was invaluable!

And the (painful) saga continues. In review, I have a query based combo box on a form which selects a ProviderName. In a subsequent combo box I have SiteNames. The idea is to get only the SiteNames directly associated with the ProviderName selected to appear in the second combo box. I have...

I had a similar problem myself, fortunately it is pretty easy to fix. Here's what I did. In the property box for that control on the form I went to the data tab. In the tab is the RowSource. By clicking to the right of that line you will get a "..." box. Click it. It will give you a SQL...

Have you tried setting the Tab Stop property for the auto filled controls to No? It will keep the cursor from going to that field while tabbing through the form. You need only go into the design view of the form and select each object and set the Tab Stop property to NO in the Other tab...

I tried the code you sent but got a message stating that I had not defined a variable. What did I do wrong?

I know I should not be having a problem with this, but...... I have a combo box on a form wherein the user selects a Provider (based on a Provider table). I also have a Location combo box (based on a related Location table). Each Provider may have several locations. The client would like me...