Problem after database split

[drobinson]

'ello all,

The moment of truth finally came and I split my database FE/BE for testing only the truth was a bit sour.

Background:
I have several forms in my database that have a common series of buttons at the top which open their corresponding form. Before the split, everything was fine - you can click on the button and the desired form would open. After the split, I'm getting the error message:

"Microsoft Office Access couldn't find the toolbar 'EVM Database Menu'."

This is referencing a toolbar that I used during development to help jump to forms.

I tried removing the toolbar from each form (Tools > Customize > Toolbars > unchecked the custom toolbar), and re-split the database FE/BE ends, but to no avail..

So, I checked the event codes to be sure I didn't program something wrong. There are 9 buttons total to open forms, 7 of them give this problem, the remaining 2 do not. The code for the problematic and non-problematic ones are identical!

Example - Non-Working (error message re: Custom Toolbar):
-----------------------------------------------------------
Private Sub cmdActuals_Click()
On Error GoTo Err_cmdActuals_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmDataActuals"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_cmdActuals_Click:
Exit Sub

Err_cmdActuals_Click:
MsgBox err.Description
Resume Exit_cmdActuals_Click

End Sub


Example - Working (no error message):
-----------------------------------------------------------
Private Sub cmdPerfProj_Click()
On Error GoTo Err_cmdPerfProj_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmPerfProj"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_cmdPerfProj_Click:
Exit Sub

Err_cmdPerfProj_Click:
MsgBox err.Description
Resume Exit_cmdPerfProj_Click

End Sub

Questions:
So..this has nothing to do with code, it must be a problem in the linking somehow, right? A bug possibly? What else could be causing this? More importantly, is there a solution to my predicament that anyone could help out with? Searches so far have returned no help either from forums (including here), MS site (no Q-articles), and VBA Help. I'll continue searching though.

Any help would be appreciated. Thanks!

 

[ScottGem]

This is just a guess, but I suspect the toolbar is based on a table (kinda like a switchboard). It was split out but the form references to it were not changed to the BE.

 

[drobinson]

I discovered a jury-rig solution. On the import, I simply did not check the option to import Toolbars. Although I don't want the custom one there, this at least alleviates the command button problem. I can modify the Toolbar at least, maybe it'll add some value to the project.