how i send to a globel model a string and how i get it back in access 2010
hi
i have in a form this formula
how can i send it to a globel model function and how i get it back from the globel model
i have in a form this formula
how can i send it to a globel model function and how i get it back from the globel model
Dim strFormName as String
Set strFormName = {Current Form Name}
Who is Participating?
Technically you don't "Get" or "Send" values to/from a Module.
You typically can retrieve a Public Variable using a Public Function.
...And store values in public variables.
Something like this in a Public Module:
Public lngpubCustomerID as long
Public Function GetCustomerID () as long
GetCustomerID =lngpubCustomerID
End function
Now you can set the public variable from anywhere in your project, something like this:
lngpubCustomerID =me.cboCustomerID
...Then retrieve it with this:
SomeThing=GetCustomerID()
Note that you may also have to implement a system to "reset" the variable.
The danger here is that you must tightly control where, when and how you set the Variable, or things could get confusing.
JeffCoachman
You typically can retrieve a Public Variable using a Public Function.
...And store values in public variables.
Something like this in a Public Module:
Public lngpubCustomerID as long
Public Function GetCustomerID () as long
GetCustomerID =lngpubCustomerID
End function
Now you can set the public variable from anywhere in your project, something like this:
lngpubCustomerID =me.cboCustomerID
...Then retrieve it with this:
SomeThing=GetCustomerID()
Note that you may also have to implement a system to "reset" the variable.
The danger here is that you must tightly control where, when and how you set the Variable, or things could get confusing.
JeffCoachman
Thanks for Your Answer sorry for the delay i was outside the town...
iry the code that you give but its not working
this is my code in the form that i store the variable
Public Sub Command21_Click()
Dim strFormName As String
strFormName = Me.Name
GetFormNameSt = strFormName
End Sub
and this is my public module
Option Compare Database
Public GetFormNameSt As String
Public Function GetFormName() As String
GetFormName = GetFormNameSt
End Function
and in the other form where i want to retrive the variable i wrote this code in a command buttan
Private Sub Command0_Click()
Dim b
b = GetFormNameSt
MsgBox b
End Sub
but the problem that i get a blank msgbox without the form name
iry the code that you give but its not working
this is my code in the form that i store the variable
Public Sub Command21_Click()
Dim strFormName As String
strFormName = Me.Name
GetFormNameSt = strFormName
End Sub
and this is my public module
Option Compare Database
Public GetFormNameSt As String
Public Function GetFormName() As String
GetFormName = GetFormNameSt
End Function
and in the other form where i want to retrive the variable i wrote this code in a command buttan
Private Sub Command0_Click()
Dim b
b = GetFormNameSt
MsgBox b
End Sub
but the problem that i get a blank msgbox without the form name
thanks thousand times for your excellent and detailed answer i'm grateful for you, I'm more than supplied from your professional answer and it is a pity that i don't can to give your more then 500 points...
Bill
Bill
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
It seems like this line:
GetFormNameSt = strFormName
You are trying to assign the value of the variable named strFormName to a variable named GetFormNameSt
But the prefix "Get" is typically used to refer to a *function*, not a variable.
You cannot assign a variable to a function.
A function will "return" a value.
I also don't see the need for the "Intermediate" variables (unless you are using them somewhere else...)
If your ultimate goal is to store the name of a form and retrieve it in another form, then you really only need to reference the public variable:
Msgbox YourPublicVarialbe
But in the interest of completeness (and because you cant use a Public variable as criteria for a query), I will show you both methods in the attached sample
;-)
JeffCoachman
Database47.mdb