Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need some help on creating an addin using UsysRegInfo

Status
Not open for further replies.

FancyPrairie

Programmer
Oct 16, 2001
2,917
US
I have created several different wizards using UsysRegInfo. And they all work fine. The problem they all have in common is that when I exit my Access Db, the wizard database (one that contains the table UsysRegInfo) continues to run. I have to use the task manager to kill the wizard database after one of the wizards run. I can see the database but can not exit out or do anything in it until I kill it. I've been dealing with this for quite some time, because the wizard had so many components I figured I was leaving something open some place. But it is too large to try to dig in to it. However, I have created another wizard that only opens a dialog form, then opens another form (hidden) that is specified by the user. The wizard than scans through all of the properties of the hidden form, saves the info and the hidden form is then closed. I then close the Wizard dialog form. I can exit the database that called the wizard but the wizard database continues to run. What am I missing?

Here is my UsysRegInfo table:

HKEY_CURRENT_ACCESS_PROFILE\Menu Add-Ins\my wizard 0
HKEY_CURRENT_ACCESS_PROFILE\Menu Add-Ins\my wizard 1 expression =myfunction()
HKEY_CURRENT_ACCESS_PROFILE\Menu Add-Ins\my wizard 1 Library |ACCDIR\MyWizardDb.accda

"myfunction" looks like this

Function myfunction(Optional var1 As Variant, Optional var2 As Variant, Optional var3 As Variant)

On Error Resume Next

DoCmd.OpenForm "frmMMCPCWz_AccessToWebConversion", , , , , acDialog

If (Err.Number <> 0) Then MsgBox Err.Number & vbCrLf & Err.Description

End Function
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top