[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Access 2010 does not open form

Posted on 2011-10-20
Medium Priority
Last Modified: 2012-05-12
I have an Access report that opens OK in 2007 but I get a blank screen in Access 2010. Can anyone help? (I don't have 2010 on my PC so it's hard to test)

Here's the Load/Open VBA: -

Private Sub Form_Load()
' Set form size
    Me.InsideWidth = 1440 / 2.545 * 11
    Me.InsideHeight = 1440 / 2.545 * 8
End Sub

Private Sub Form_Open(Cancel As Integer)
' Set defaults
    Me.txtStart = Date - 1
    Me.txtFinish = Date - 1
    Me.txtSalesOrderFile = "SalesOrd_" & Format(Me.txtStart, "yymmdd") & "_to_" & Format(Me.txtFinish, "yymmdd") & "_.xls"
    Me.txtInvoiceFile = "SalesInv_" & Format(Me.txtStart, "yymmdd") & "_to_" & Format(Me.txtFinish, "yymmdd") & "_.xls"
    Me.txtFileLocation = "X:\RLC\"
End Sub
Question by:HKFuey
LVL 85
ID: 36998726
Is this the ONLY form that is having troubles?

References could be an issue on the 2010 machine - can you list out the references you've got set on your database (VBA Editor - Tools - References)?
LVL 61

Expert Comment

ID: 36998766
<I have an Access report that opens OK in 2007 >

Also, just as a sanity check...

Did you post the correct code?  You are describing an issue with a report, but the code you posted is for form events.

Author Comment

ID: 36999232
Sorry it's a form that runs 2 reports based on dates entered.

I'm going to set up Access 2010 on my PC to try figure it out.
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37000912
Also, clearly define what you mean by a "Blank Screen".
The entire computer screen?
The Access window?
just the report/form is blank?
The report/form has headers and footers, but no data?
(Post a screenshot)

Author Comment

ID: 37000999
OK, the Access screen was blank when opening in Access 2010 (even though a form was specified in startup).
I installed the Access 2010 runtime and replicated the error. I tried a previous version of the Access App  and it worked OK so I must have corrupted it somehow (even though it works OK in 2007)

I used an older version of the app, imported the (changed) queries and reports and it works!
(I don't know why it works now but do I need to???) Blank Form
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37001502

The only time I have seen something like that is when the user does not have access to modify the data.

Perhaps another Expert can assist further...
LVL 74

Accepted Solution

Jeffrey Coachman earned 2000 total points
ID: 37010841
If you still have a copy of access 2007, try this:
(Make sure you have all updates and service packs installed for Windows, Office 2007 and Office 2010)
1. Open the BD in Access 2007 and
a. Run the compact/repair utility
b. compile the code (in the vba editor, click Debug-->Compile)
c. Run the compact/repair utility again
2. Open Access 2010 and create a blank new database
3. Import all of the objects

Author Closing Comment

ID: 37016293
Thanks for the help
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37018898

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question