I created a form and put in my controls (variables). I then put in code including option explicit, declared variables, and put in a couple of docmd statements. Now, I'm getting error messages with my docmd statements. What am I doing wrong?
Option Explicit
- Thread starter Mechele
- Start date
simongallop
Registered User.
- Local time
- Today, 22:56
- Joined
- Oct 17, 2000
- Messages
- 611
what is the error message and what is the line of code that is creating it?
Robert Dunstan
Mr Data
- Local time
- Today, 22:56
- Joined
- Jun 22, 2000
- Messages
- 291
Can you be more specific. What DoCmd statements are you doing and what error messages do you get?
Docmd.maximize (on load form event)
Error message:
The expression on open you entered as the event property setting produced the follow error: Member already exists in an object module from which the object module derives:
*The expression 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.
Error message:
The expression on open you entered as the event property setting produced the follow error: Member already exists in an object module from which the object module derives:
*The expression 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.
Docmd.maximize (on load form event)
Error message:
The expression on open you entered as the event property setting produced the follow error: Member already exists in an object module from which the object module derives:
*The expression 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.
Error message:
The expression on open you entered as the event property setting produced the follow error: Member already exists in an object module from which the object module derives:
*The expression 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.
boblarson
Smeghead
- Local time
- Today, 14:56
- Joined
- Jan 12, 2001
- Messages
- 32,059
It would help if you can put more of the code here as sometimes the VBE may highlight one line of code, but something else may ACTUALLY be causing the problem.
I have some possible ideas, but without the code to narrow it down, it would take to long to type the possible scenarios.
BL
[This message has been edited by boblarson (edited 03-15-2002).]
I have some possible ideas, but without the code to narrow it down, it would take to long to type the possible scenarios.
BL
[This message has been edited by boblarson (edited 03-15-2002).]
The following code is what I added and then I got the error message: (Everything was working fine except I was running out of memory. So, I decided to declare variables.)
Option Explicit
Dim CommunityHealthImprovementNetworkQ As String
Dim AmericasPromiseQ As String
Dim InternetSolutionsHealthContentQ As String
Dim MemberBrandSolutionQ As String
Dim IntegratedSolutionQ As String
Dim LaurusHealthProfessionQ As String
Dim CommunityCareServicesQ As String
Dim CareVisionQ As String
Dim CommunityVisonQ As String
Dim EnterpriseVisionQ As String
Dim MemidQ As String
Dim TempQ As String
Option Explicit
Dim CommunityHealthImprovementNetworkQ As String
Dim AmericasPromiseQ As String
Dim InternetSolutionsHealthContentQ As String
Dim MemberBrandSolutionQ As String
Dim IntegratedSolutionQ As String
Dim LaurusHealthProfessionQ As String
Dim CommunityCareServicesQ As String
Dim CareVisionQ As String
Dim CommunityVisonQ As String
Dim EnterpriseVisionQ As String
Dim MemidQ As String
Dim TempQ As String
DBL
Registered User.
- Local time
- Today, 22:56
- Joined
- Feb 20, 2002
- Messages
- 659
Look through all the code for the form and make sure that there aren't any other OnLoad events lurking about. If there isn't, try creating a blank database and importing all the objects from the existing database into the new one. Remember recompile the code and add any reference libraries you might need.
