Solved

Microsoft Access 2007 (2010 Development Environment) pop-up form problem

Posted on 2013-02-07
10
400 Views
Last Modified: 2013-02-14
I have had this happen a few times in the last week and I don't know why it's happening or what to do to prevent it.

I use pop-up and modal forms a lot for report filtering, etc. and lately whenever I make a change to one of the forms it no longer opens up (or if it does it's hidden somewhere). If I take the pop-up and modal attribute off, the form opens fine.

Any suggestions/ideas?

I am developing in a 2010 environment and saving the app as a 2007 for use by my clients at their end. Could this have something to do with it?

Thanks for any help...
0
Comment
Question by:Ei0914
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 2
  • +1
10 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 38864907
"I am developing in a 2010 environment and saving the app as a 2007 "

I'm quite impressed that anything works, then.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 38864947
<I am developing in a 2010 environment and saving the app as a 2007 for use by my clients at their end. >
Always develop in the same environment as the end user/client.

There is no way you can assure full compatibility with different versions...

For this reason most developers will have available all of the popular versions of Access.

JeffCoachman
0
 

Author Comment

by:Ei0914
ID: 38864961
Eeeks! Really? My 2007 machine crashed and I am now stuck with my Windows 7, 64-bit, 2010 environment... I haven't had too many issues -- expect with API calls, etc.
0
Technology Partners: 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!

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38865112
I mean you can use 2010 and "Pray" that nothing goes wrong...

It may be OK, but you have issues already...
;-)

Perhaps there is another solution here, ...
We are just suggesting that you eliminate as many variables as possible.

<My 2007 machine crashed and I am now stuck with my Windows 7, 64-bit, 2010 environment>
Then you should still have the software for 2007, correct?
...just load it on a junky machine...
0
 

Author Comment

by:Ei0914
ID: 38865166
Hey Jeff -- had an XP Box with 2003 (mother-board died a few months ago), a Vista laptop running 2007 and my new laptop with 64-bit 7 and 2010 -- had most covered till the Vista  laptop blew up... Ugh...

I don't have the install CD's for 2007 anymore -- not sure if it came preloaded -- which I think it did... I guess I can remote in to my client's to do the work ---

So -- do you think that has something to do with my pop-up forms hiding?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38865312
cant be sure...

Post a sample and I can take a look...


Sample database notes:
1. Back up your database(s).
2. Combine the front and back ends into one database file.
3. Remove any startup options, unless they are relevant to the issue.
4. Remove any records unless they are relevant to the issue.
5. Delete any objects that do not relate directly to the issue.
6. Remove any references to any "linked" files (files outside of the database, Images, OLE Files, ...etc)
7. Remove any references to any third party Active-x Controls (unless they are relevant to the issue)
8. Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
9. Unhide any hidden database objects
10. Compile the code. (From the VBA code window, click: Debug-->Compile)
11. Run the compact/Repair utility.
12. Remove any Passwords and/or security.
13. If a form is involved in the issue, set the Modal and Popup properties to: No
    (Again, unless these properties are associated with the issue)
14. Post the explicit steps to replicate the issue.
15. Test the database before posting.

In other words, ...post a database that we can easily open and immediately see and/or troubleshoot the issue.
And if applicable, also include a clear graphical representation of the *Exact* results you are expecting, based on the sample data.
0
 
LVL 48

Expert Comment

by:Dale Fye (Access MVP)
ID: 38865517
I would agree with all previous comments about developing in 2007 vice 2010, especially with the 64 bit Office.  I have 2007 installed on the XP virtual machine on my Windows 7 laptop.  That way I can work develop in 2007 and test in 2010.

MS used to have a program that allowed you to purchase a previous version of Office really cheap, if you bought the newest version.  Don't know whether that program is still around, but you might want to check the Office website and contact tech support.  If you registered the 2007 program, they may have a record of that as well.
0
 

Author Comment

by:Ei0914
ID: 38865561
I have 64-bit OS and 32-bit Office 2010.
0
 
LVL 48

Expert Comment

by:Dale Fye (Access MVP)
ID: 38865621
OK, so this is not an Office 2010, x64 issue.

I would still recommend that you try to develop in the same environment (operating system and Office version) that your client is using.

So, you are having this difficulty on your computer, not your clients?  I use Office 2007 on my Windows 7 (x64) desktop, and cannot say that I have encountered this problem.

Are you certain that you are saving the forms with the popup and modal = Yes?  I generally find that making them popup (with modal set to No) usually works fine for me.  If I want the form to open as modal, I use the acDialog value in the WindowMode argument of the OpenForm method.
0
 

Author Comment

by:Ei0914
ID: 38865823
fyed - I can try that -- just can't understand why this is happening... it's such an odd behavior. I just tried this while logged into my client's machine (via Logmein) and the problem isn't happening... She's running Office 2007 - Windows 7 Pro (32-bit)
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

726 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