|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
March 21st, 2005, 07:40 PM
|
|||
|
|||
|
VBA: Trying to use procedure parameter in expression, error within this message :)
hey folks!
thought i'd try and be clever and cut down on static code, lets get some of those dynamic juices flowing! right, well, what i would like to do is have a sub procedure that i can use to clear the values of a form object. ideally the name of the object should be sent to the procedure through a parameter (if possible) this is some code that i thought could work  Code:
Public Sub DelFormObj(obj As String) Me.[obj].Value = Null End Sub the error i get is: Access can't find the field '|' referred to in your expression I'm new to VB/VBA so any help will be greatly appreciated!
|
|
#2
March 22nd, 2005, 10:45 AM
|
|||
|
|||
|
answer found. (in this forum actually, aint search brilliant!)
turns out that if i want to use a variable in an expression i just have to use parenthesis instead. Me(variablename).Value instead of Me.[variablename].Value
|
|
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > VBA: Trying to use procedure parameter in expression, error within this message :) |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
