By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,391 Members | 1,429 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,391 IT Pros & Developers. It's quick & easy.

How to Execute a statement from a Text..

P: n/a
ng
I have a table that contains security information. User name, Password,
etc. I also have an optional field, that I would label, for antiquity sake,
"autoexec" So, if Joe Blow needs an extra menubar, or whatever, I can just
execute a single statement that is contained in a variable. I would
envision something like:

(assuming I'm at the correct record in rst...)

docmd.rst!autoexec

But that doesn't seem to work. I think I ran into this years ago, and there
is a simple function to convert, I can't remember it for the life of me, and
I tried to search the web, so, TIA!

-BrianDP
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
ng wrote:
I have a table that contains security information. User name, Password,
etc. I also have an optional field, that I would label, for antiquity sake,
"autoexec" So, if Joe Blow needs an extra menubar, or whatever, I can just
execute a single statement that is contained in a variable. I would
envision something like:

(assuming I'm at the correct record in rst...)

docmd.rst!autoexec

But that doesn't seem to work. I think I ran into this years ago, and there
is a simple function to convert, I can't remember it for the life of me, and
I tried to search the web, so, TIA!


The Eval() function.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Nov 13 '05 #2

P: n/a
DOH! Thanks.
-BrianDP

"MGFoster" <me@privacy.com> wrote in message
news:sf*****************@newsread2.news.pas.earthl ink.net...
ng wrote:
I have a table that contains security information. User name, Password,
etc. I also have an optional field, that I would label, for antiquity
sake, "autoexec" So, if Joe Blow needs an extra menubar, or whatever, I
can just execute a single statement that is contained in a variable. I
would envision something like:

(assuming I'm at the correct record in rst...)

docmd.rst!autoexec

But that doesn't seem to work. I think I ran into this years ago, and
there is a simple function to convert, I can't remember it for the life
of me, and I tried to search the web, so, TIA!


The Eval() function.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.