July 25, 2008 12:52pm pdt

1. capricorn1 2,111,351
2. DatabaseMX 1,314,921
3. boag2000 590,019
4. LSMCons... 558,404
5. peter57r 446,668
6. harfang 412,103
7. GRayL 388,331
8. jimhorn 257,552
9. matthews... 250,724
10. cactus_d... 242,502
11. TextReport 236,057
12. hnasr 202,250
13. ee_rlee 173,155
14. angelIII 140,704
15. jefftwilley 140,435

1. capricorn1 9,768,389
2. nico5038 5,699,981
3. rockiroads 5,409,687
4. peter57r 3,891,163
5. LPurvis 3,394,721
6. LSMCons... 3,294,994
7. shanesue... 3,288,317
8. DatabaseMX 3,198,382
9. harfang 3,028,936
10. stevbe 2,857,111
11. jimhorn 2,677,144
12. GRayL 2,548,175
13. flavo 2,109,583
14. mbizup 2,021,084
15. jadedata 1,964,977

08.24.2007 at 12:26PM PDT, ID: 22785819

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.0

docmd quit giving odd error

Zone: Microsoft Access Database

Tags: entered, expression, load

I have an access 2002 database that gives the users a login form call frmlogin. After logging in they get another form with the main menus, the login form stays open in the background. When I click on a button to exit the database by docmd.quit i get the following error.

"The expression On Load you entered as the event property setting produced the following error:
DGSalesCRM_XP can't find the form 'frmlogin' referred to in a macro expression or visual Baic code.
*The experssion may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]
*There may have been an error evaluating the function, event, or macro"

I only get this error when using the MDE file. the MDB file works fine

here is the code in the on load:
Private Sub Form_Load()
If Forms!frmlogin!txtAccess = "Admin" Then
Me.cmdAdminMenu.Visible = True
Else
Me.cmdAdminMenu.Visible = False
End If
End Sub

and here is the exit button
Private Sub cmdClose_Click()
On Error GoTo Err_cmdClose_Click

DoCmd.Quit

Exit_cmdClose_Click:
Exit Sub

Err_cmdClose_Click:
MsgBox Err.DESCRIPTION
Resume Exit_cmdClose_Click
End Sub

There is no error when the form is initally loaded and I'm not sure why i'm getting an on load error when exiting the database. Any help would be appreciated.

Start your free trial to view this solution

Question Stats

Zone: Microsoft

Question Asked By: willhebert

Solution Provided By: spambler

Participating Experts: 1

Solution Grade: A

Translate:

Loading Advertisement...

20080236-EE-VQP-29 / EE_QW_1_20070628