.net – How to suppress a prompt window to continue further

ms-accessvb.net

As per my application requirement I need to open each form in Access DB to count Activex controls using vb.net. My problem is, one form in the DB is prompting for user input and because of that my application stops until user intervention.

Is there any way to ignore such forms and proceed with scanning DB without user intervention?

Please help me out….

Best Answer

Can't you open your forms in design mode:

docmd.openForm "myFormName", acDesign

You'll then be able to freely browse the objects in the form and identify your activeX controls.

Related Solutions

.net – How to find out Activex Controls from MS Access DB forms using vb.net

Can you access the controltype property? If so, I cannot help with vb.net, but here is some VBA that may help.

ActiveXCount = 0
For Each ctl In Screen.ActiveForm
    If ctl.ControlType = 119 Then 'Custom control'
        'Debug.Print ctl.Class'
        ActiveXCount = ActiveXCount + 1
    End If
Next

.net – How to prevent to open a MS Access Database while reading data from forms

Sounds like an unsplit application (tables and forms/etc. in a single MDB file), and that it's being shared by multiple users. This is a disastrous scenario. See Splitting your Microsoft Access MDB into a front end and back end for all the details.

Once it's split, you'd work on an individual copy and then distribute updates to users. The point is that since version 2000 the design of an Access MDB (as opposed to the data) cannot be edited while it's open by any users.

Best Answer

Related Solutions

.net – How to find out Activex Controls from MS Access DB forms using vb.net

.net – How to prevent to open a MS Access Database while reading data from forms

Related Topic