setvalue
- Thread starter clean32
- Start date
ohh umm, now that makes me feel dum. yes and thanks
- Local time
- Today, 21:48
- Joined
- Feb 19, 2013
- Messages
- 17,763
regret I don't use macros, so can't help.
however the link you provided is not about setting a value from one form to another, so now doubly confused.
VBA may be 'a bit above you' but it is what most developers use - macros are for relatively straight forward tasks and are less flexible.
No idea if it is available in macros, but the openform command allows you to pass values via the openargs parameter, maybe you can investigate this as a way forward.
Otherwise explain what it is you are trying to do (include also the version of access you are using and what format - client web etc) and perhaps a vba solution will be provided
however the link you provided is not about setting a value from one form to another, so now doubly confused.
VBA may be 'a bit above you' but it is what most developers use - macros are for relatively straight forward tasks and are less flexible.
No idea if it is available in macros, but the openform command allows you to pass values via the openargs parameter, maybe you can investigate this as a way forward.
Otherwise explain what it is you are trying to do (include also the version of access you are using and what format - client web etc) and perhaps a vba solution will be provided
thanks, yes you are correct VBA is over my head, i am not a programmer, i am a Metallurgist or was.
i am struggling a bit with access 2007. every thing has moved or i can not locate it. i have wasted 1/2 of this afternoon with some thing called trust??
you showed me where setvale was. but it would not run until i did trusted location
i am struggling a bit with access 2007. every thing has moved or i can not locate it. i have wasted 1/2 of this afternoon with some thing called trust??
you showed me where setvale was. but it would not run until i did trusted location
- Local time
- Today, 21:48
- Joined
- Feb 19, 2013
- Messages
- 17,763
since 2007, all ms office apps that use macros or vba code have to be trusted - you can specify a trusted location such a mydocuments so putting files in that location will be automatically trusted.
Note that setting a trusted location in access is only for access, you would need to repeat for excel, word etc if required
Note that setting a trusted location in access is only for access, you would need to repeat for excel, word etc if required
Give it a go, I can assure you from personal experience that metallurgists can use VBA
