Share via

modifying an access template

Anonymous
2019-03-12T18:18:34+00:00

Hi all

I have not done any serious access programming since 2006!  Anyway I have been asked to modify a task management app that appears to be made using the template.   the app is layed out using 3 database files, db.fe.accdb - contains forms, reports, queries, macros and linked tables.  db.be.accdb  which contains tables both data and lookup.

 My problem is this; when I open the application I get an error when the application attempts to return a splash screen before it opens the actual main dashboard.  Where should I be looking to get rid of the splash screen and just open application?  the splash screen is a form called welcome.  I've been going through object dependancies, macros, and ran the database tools >>Documenter on both Db's

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ScottGem 68,830 Reputation points Volunteer Moderator
    2019-03-13T17:06:14+00:00

    If there is no code behind the splash form that was causing the problem you can disable it. But since the problem was an old location there shouldn't be any reason to do that.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2019-03-13T11:06:34+00:00

    Thanks scott, 

    the third file was backup_db.be.accdb.

    I can't find any thing in the onload or On Open function.

    the actual root cause was with the linked tables; they were trying to connect to an old location.

    Was this answer helpful?

    0 comments
  3. ScottGem 68,830 Reputation points Volunteer Moderator
    2019-03-12T18:42:46+00:00

    You say it three files, but only list 2. it sounds more like a normal split database between Front end and back end.

    You may NOT want to disable the splash form. You have to check and see what that form does. It may do some configuration that allows the app to work.

    So you want to try using the Shift Bypass key to bypass the start up. then open the Welcome form in Design mode and check the On Open and On Load events to see what the form does. Then track where the error occurs.

    Was this answer helpful?

    0 comments
  4. DaveM121 891K Reputation points Independent Advisor
    2019-03-12T18:30:06+00:00

    Hi jbird4k

    Generally a splash screen is just a form that has a timer on it and it is set as the initial form in the database, so you need to set the Dashboard Form as the initial form shown on that database, to bypass the splash screen

    In Access open that database, go to File - Options

    Click Current Database

    Under Application Options, in the Display Form list, select the Dashboad form that you want to display when the database starts

    Click OK, and then close and reopen the database to display the startup form.

    Was this answer helpful?

    0 comments