Open a Form in Invisible mode on opening the db.

[recyan]

Currently, I have set the Access Options -> Current Database -> Display Form: -> myForm.



Is it possible to open a Form on opening a db in VBA ?

The reason being, I would like to open this form in Invisible mode on opening the db application, with the user not being able to see it.

Would like to avoid use of Macro.

Thanks

[June7]

Options I am aware of:

1. autoexec macro

2. VBA in event procedure of another form
DoCmd.OpenForm "form name", , , , , acHidden

3. custom ribbon code can call VBA procedure in general module - example:

following is VBA procedure

Sub OnRibbonLoad(ribbon As IRibbonUI)
    ' procedure called by custom ribbon code in QATRibbon record of USysRibbons table
    ' QATRibbon is set as the default ribbon when database opens
    DoCmd.OpenForm "Login"
End Sub

following is code in USysRibbons table

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="OnRibbonLoad" >
  <commands>
    <command idMso="Help" enabled="false"/>
  </commands>
  <ribbon startFromScratch="true">
    <officeMenu>
      <button idMso="FileOpenDatabase" visible="false"/>
      <button idMso="FileNewDatabase" visible="false"/>
      <button idMso="FileCloseDatabase" visible="false"/>
    </officeMenu>
    <qat>
      <documentControls>
        <button idMso="DataRefreshAll"/>
      </documentControls>
    </qat>
  </ribbon>
</customUI>

[recyan]

Thanks for the various options.
1) Would like to avoid. Reason : Way back, after reading the opinions of many of my gurus in forums ( including you ), I came to the conclusion that I should avoid macros unless unavoidable. Today, I only have the conclusion with me & have forgotten the justifications. One of them could be that you cannot import macros in to another database. Please correct me if I am wrong.

2) Not possible. Reason : As this is the first form that opens when the db is opened.

3) This is a bit over my head at this time. Will try to analyse & see if I can incorporate. But at first glance, it appears to have opened new areas for me to explore & use.

Thanks

[June7]

Macros can be imported, at least they are listed as an item in the import wizard. These are probably general macros that can be selected for import. I don't know if embedded or data macros will import with the objects they are associated with.

Sources to learn about customizing ribbon.
http://www.accessribbon.de/en/
http://office.microsoft.com/en-us/ac...010211415.aspx

[recyan]

Sorry for the delayed response.
Thanks for the links. Will take a look asap.

Thanks