Question Package solution missing the most important file: my .accdr file

[merika]

Hi all,

Finally my DB is done, used the package solution to be able to isntall a front end on the end-users PC´s and worked fine. There was however a small update I needed to do on one form after installing it on 2 PC´s (needs to be on 20 pc´s).

I updated the form and packaged everything again but no matter what I do... it doesn´t work anymore.

The 1st package I created contains the following:
- autorun info
- setup.exe
- folder Files with in it cruisedb.exe, cruisedb.accdr and folder Setup with just thr setup.ini

The next packages I created exactly the same but the cruisedb.accdr file is constantly missing. Any idea how to get the updated cruisedb.accdr back in the package?

 

[NigelShaw]

I can't see why its not being added. Maybe you could screen shot each step and post so we could see any errors. Usually if the file is included, it goes in the setup

N


Sent from my OMNIA7 using Board Express

 

[merika]

Hi Nige,

Seems like it works again. Have no idea why the package contains the addcr file now when it didn´t do so earlier (maybe taking screenshots was simply enough )

 

[merika]

So as mentioned... the accdr file is included in the msi now. It installs perfectly and opens correctly. The next problem comes when someone clicks on a link in the menu form. The following message pops up:

The expression "On Click" you specified as the value of the property from the failed event.
*expression does not result in the name of a macro, a user-defined function, or [Event Procedure]
*There was an error evaluating the function, event or macro

And it stops there. The users are not able to continue. The code behind the buttons is pretty simple:

Private Sub cmdBuscar_Click()
DoCmd.OpenForm "frmBuscar", , , , , acDialog
End Sub
Private Sub cmdNueva_Click()
DoCmd.OpenForm "frmDataentry", , , , , acDialog
End Sub
Private Sub cmdDataEntryBoats_Click()
DoCmd.OpenForm "frmBarcoInfo", , , , , acDialog
End Sub
Private Sub cmdClose_Click()
DoCmd.CloseDatabase
End Sub

Any suggestions out there on what it is that can go wrong here? Even to me, this is very simple straight forward VBA code to open up a form, nothing more.