Solved

Running a procedure from anothe unrelated form

Posted on 2016-10-09
5
51 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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.

820 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