I am trying to save my front end db as an accde file so that can share it without end users being able to make structural changes. I get this message "Access was unable to create the .accde..." I looked around online and found a solution that said I should open the vba editor to debug and compile. This I did but when I do I get a compile error, Method or data member not found in a piece of code I don't recognize and can't find anywhere. I am not getting any error messages when I open and use any of my forms, so this really is confusing.
Help
Compiling help
-
- Administrator
- Posts: 78628
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 2StarLounger
- Posts: 198
- Joined: 21 Aug 2011, 02:32
Re: Compiling help
Private Sub ConId_AfterUpdate()HansV wrote:Can you tell us which line of code caused the error?
Me.RoleID = Me.ConID.Column(2)
End Sub
-
- Administrator
- Posts: 78628
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Compiling help
Possible causes:
- There is no control named RoleID
- The control ConID does not have columns, i.e. it is not a combo box or list box.
- There is no control named RoleID
- The control ConID does not have columns, i.e. it is not a combo box or list box.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 198
- Joined: 21 Aug 2011, 02:32
Re: Compiling help
That is what is so weird. I wouldn't have written a piece of code like this so I can't figure out where this is coming from!HansV wrote:Possible causes:
- There is no control named RoleID
- The control ConID does not have columns, i.e. it is not a combo box or list box.
Why would debugging find code I haven't written?
-
- Administrator
- Posts: 78628
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Compiling help
Someone must have created the code, either manually or by using one of the control wizards in Access...
Best wishes,
Hans
Hans