Access 2016 Runtime - Forms not opening

Question

I have developed an application in Access 2016 (32 bit)

When it starts it displays a splash screen for 3 seconds then proceeds to a login screen or a registration screen.

Under Access 2016 this works perfectly

When I convert the accdb to an accde and run it under Access 2016 runtime (on a different machine) the splash screen displays but nothing else happens.

If I run the accdb in the same manner the splash screen functions as it should but another of the forms in the application opens , displays nothing and hangs.

Has anyone any ideas on how I can resolve this?

Is there some sort of debug / log file that I can look at?

Thanks in advance..

Dave

Answer 1

You can export a form as text then reimport it. See https://stackoverflow.com/questions/2088814/exp...

This is a frequently used solution to a problem like you had. Another is to Decompile and recompile the database,

http://www.fmsinc.com/MicrosoftAccess/Performan...

It would appear your object was corrupted and that caused the problem.

Answer 2

Ok, so putting in the error trapping got you past the Registration/Login form to the main menu. So the problem now seems to be with this one form that will open but doesn't show any controls or anything just the form border and a blank within?

That usually indicates that there are no records in the Recordsource of that form in that instance. In the MsgBox, try using the following:

MsgBox "Opening Form with " & Dcount("*","recordsource") & " records."

Substitute the table or query name that is the recrodsource of that form.

I'm hoping that when it shows a blank form the message box will say 0 records.

Answer 3

Some progress ... I put some error checking in the code, recompiled and tried to run the accde

It worked fine on both of my machines running full access and the one running Access runtime ... Splash screen closed after 3 seconds as required - no errors reported.

I then go on to a main menu and there are options to open a few more forms.. all the forms open correctly apart from one - it shows a blank on the Access runtime machine and one of the full access machines.

I have added an on open event to show a msgbox  "Opening Form" message - which does appear on all three machines.

Running out of options here...

Answer 4

Hi Scott

Thanks for the reply

The splashscreen is set in options as the first form as you suspected.

That has an On Timer event and a Timer Interval set to 3000

And it has an On Close event

Code as follows:-

Private Sub Form_Close()

' Check if a registered user exists on tblUsers and if not open Registration Form

 If (IsNull(DLookup("UserLogin", "tblUser", "RegUser"))) Then

  DoCmd.OpenForm ("frmLicenseAgreement")

 Else

  DoCmd.OpenForm ("frmLoginForm")

 End If

End Sub

Private Sub Form_Timer()

  DoCmd.Close

End Sub

The idea is that if there is not a registered user on tblUsers then they are prompted to agree to the License and then enter details of a registered user.  If there is a registered user then proceed directly to the Login Form.

I have done some more checks and I found that the accde will not get past the splash screen if running under full access or runtime.

Thanks

Dave

Answer 5

We need to see the code you are using. I'm guessing the splash screen is set in Options as the default form, then you have other code in the splash screen to open up the next form.

So we need to see that code that opens up the next form. You also should be inserting error trapping in your code (if you are going to use an accde and/or Runtime) that will show error messages.

My suspicion here is a references issue. Its not clear whether you are running the app as accdb under the Runtime or as full license. If you are using a Runtime only machine, there is little need for compiling to accde.

So please provide more details so we can help.