Search results

OK, I figured out part of it - I fooled around with the registration list thing and realized how dopey I've been. I can get the controls re-registered. I dug deeper into the MS KnowlegeBase and found a similar problem related to ODE Tools being installed after another application had already...

Thanks for the reply. Unfortunately, registering a control does not seem to correct my problem. I thought perhaps I should unregister, and then re-register a control. Once I unregistered it, it dissappeared from the registration list altogether, so I no longer can even try to register it...

Greetings, All I'd like to try jazzing up a few forms with Activex controls, but with certain controls, specifically microsoft controls with version 5.0. The moment I try to place one on a form, I get a message "You don't have the license required to use this Activex Control" and more blah...

You could try looking up Macro in the Help file. There should be an OVERVIEW subheading which explains a great deal.

By that do you mean that 1. Two different pop-up forms could each (individually) get criteria and open a particular form? or 2. You want to open a form using criteria derived from two separate pop-up forms? (both pop-ups required to get the criteria)?

OK, OK, I found it myself! An hour of digging in the helpfiles and here's a quote from helpfile that describes what I should have done: 1 Create a macro or event procedure that uses an OpenForm action to open the form. 2 Set the Window Mode argument of the OpenForm action to Dialog (acDIALOG...

I think I know what you're asking.... If opening the combo box displayed two columns: the ID and the name, would that do what you want? To do so, edit the row/source property of the combo box to: SELECT DISTINCTROW [YourQuery].[CustomerID], [YourQuery].[CustomerName]FROM [YourQuery]; Set the...

Thanks for the suggestion. HOWEVER, this does not work because execution continues looping through the While/Wend loop and focus never gets to the dialog box. I had to force-break out of it because there's no way to reset the MyWait variable to FALSE.

Greetings to all.. I'm trying to create a custom dialog box which can be called from a procedure. The procedure that calls the custom dialog box is runing through a for-next loop which is cycling through records looking for certain values. When a record with that value is found, I want to...

Works like a charm... Thanks very much. -Curt

Hello, all. Does anyone know a way, when opening a report in preview mode, to specify the zoom setting on opening? Right now I'm opening it with: DoCmd.OpenReport "reportname",AcViewPreview It always opens at 100% size, and would be better if it opened at 80%.

Sharda: I found that your solution worked only if I used a LABEL instead of a TEXTBOX, since the textbox has no caption attribute. I got this sort of thing to work for me using: me.[myLabel].caption = MyPublicVariable or me.[myLabel].caption = [Forms]![formname]![fieldname] Good luck.

I am having trouble using public variables in reports as well. My reports do not seem to see public variables. Is this something I'm doing wrong, or what?

Greetings, all. I'm searching for some big-picture suggestions about how I should go about the following: I have several combo-boxes on a form which pull their lists from other tables. If a user types an entry that is not in the list, I would like to give them the option of adding new items...

If you press <F4>, the combo-box opens up and arrows allow scrolling.

I'm assigning in the ON OPEN module of a form that is attached to the table in which is the field [BooleanField]

Greetings I have a db which includes a table that has several boolean fields. As part of another form, I want to change the value of some of these fields. That form is based on the table directly, and I have simple code that says: [BooleanField] = True I get a Run-Time error '2448' "You...

Thank you, thank you, thank you. -Curt

1. Is the text color the same as the bg? (I know, it sounds dumb, but we've all been caught). 2. Is it possible that that size of one of your new labels is somewhat larger than the text within? If so, even though the text does not overlap anything, the label area could overlap other labels...

I have a table which needs to be manually put into the order needed by the user. The order required can only be determined by the user. I am seeking a way to gracefully do this. I've made it work by adding a sequence field for the user to set and then running a sort based on that field, but...