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
2  1175 
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)
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) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jill Graham |
last post by:
Hi,
I'm using an access database and found following problem :
I have a table X with 2 records : record 1 & record 2. I execute following
procedure with 2 steps :
1. The procedure deletes...
|
by: Doohan W. |
last post by:
Hi,
I'm now working with DB2, and I can't find out how to execute the
contents of a string Statement, without using a Java/... procedure,
only using SQL statements.
I know that some SQBDs such...
|
by: Nabil |
last post by:
I am new to DB2 and here is my situation.
I have 2 temp tables where I am trying to insert data (from 2 select
statements)
DECLARE v_t1 VARCHAR(50);
DECLARE v_t1 VARCHAR(50);
DECLARE stmt1...
|
by: Andrew |
last post by:
Hi:
I run into the following problem where I would use CreateQuerydef to create
a new Table and then use "Execute" to execute the statement. However, I
keep getting an error message saying that...
|
by: nicholas |
last post by:
my insert works, but without the boolean value contentavailable.
When I try to insert this boolean I get a data mismatch error.
this "contentavailable" is an asp.net checkbox
I use a ms access...
|
by: rAinDeEr |
last post by:
Hi,
I have started using DB2 UDB ESE v8.2 in Linux recently. I have
seen a lot of articles on packages, prepare statement, bind and execute
statement.
I havent got a clear idea.
I have...
|
by: rn5a |
last post by:
In a ASP applicatiuon, the FOrm has a textbox & a select list where
the admin can select multiple options. Basically the admin has to
enter the name of a new coach in the textbox & select the...
|
by: HeislerKurt |
last post by:
I'm getting the infamous error, "Too few parameters. Expected 2", when
executing an update SQL statement in VBA. I assume it's a SQL syntax
issue, but I can't find the problem, and I used a VBA...
|
by: ChildProgrammer |
last post by:
I am trying to upload data into an Access db from vb.net. The data was parsed out from text files. Everything seems to be working fine up till the .execute point. The debugger insists there is a...
|
by: David |
last post by:
- Are there any peculiarities with using curs.executemany(...) vs. multiple
How many times are you calling execute vs a single executemany? The
python call overhead will add up for thousands of...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |
