Solved

Running a procedure from anothe unrelated form

Posted on 2016-10-09
5
45 Views
Last Modified: 2016-10-09
I am using this. It does not work. Tried all manor of combinations

Call Me.Forms.[ProjectForm].[Details].Form.DuplicateRecordQueryWithSets

DuplicateRecordQueryWithSets     is the procedure
0
Comment
Question by:DatabaseDek
  • 2
  • 2
5 Comments
 
LVL 28

Expert Comment

by:Pawan Kumar
ID: 41835871
What error is coming? DuplicateRecordQueryWithSets is a procedure written in which database ?
0
 

Author Comment

by:DatabaseDek
ID: 41835874
Method or Data not found with "Forms." Highlighted

Same database
0
 
LVL 19

Accepted Solution

by:
crystal (strive4peace) - Microsoft MVP, Access earned 500 total points
ID: 41835878
if you are using an absolute reference to the procedure, don't start with Me
   Call Forms.f_Master.f_Child.Form.ProcedureName

Open in new window


make sure the procedure is PUBLIC that you are calling. For instance:
Public Sub ProcedureName()
   'code goes here
End Sub

Open in new window

if you are calling this from code behind the master form, you can do this:
      Call Me.f_Child.Form.ProcedureName

Open in new window

0
 

Author Closing Comment

by:DatabaseDek
ID: 41836014
I had brackets around form names.

Thank you
0
 
LVL 19
ID: 41836019
you're welcome ~ happy to help
actually the problem with the example was that it was "Me.Forms..." instead of "Forms..."
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

813 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now