As of now A_ID used to come from a combobox which had A_ID in its select query.
Code:
forms![frmMain]![cboID]
9 results in 0.0023 seconds.
-
HiGu started a topic Taking a parameter from recordsource of form to open a new form in ms access vba.in AccessTaking a parameter from recordsource of form to open a new form in ms access vba.
I have a procedure that opens a form based on a particular "A_ID".This A_ID is present in the recordsource of a subform but it's not displayed on the same.How do I refer to this A_ID so as to open the form?
As of now A_ID used to come from a combobox which had A_ID in its select query.
Now, I do not know how do I take A_ID from the subform as it is not displayed in any of the contro... -
How can I do a "Grouped TOP 1"?
I dont know how to do this, given this table:
What I need to do...Code:----------------------------------- CaseId | User | Timestamp ----------------------------------- 1 | 1 | 01/26/2011 2 | 3 | 03/12/2011 3 | 2 | 03/20/2011 4 | 1 | 04/16/2011 5 | 3 | 05/17/2011 6 | 1 | 05/06/2011 7 | 1 | 08/18/2011
-
Charles Ndethi started a topic How to set a session id to a value after using a case-when statement?in MySQLHow to set a session id to a value after using a case-when statement?
Hi I want to set the session id to a value after evaluating the request_time using a case when statement.
here 's the table
when the keyword is entered request_time...Code:userinput_id session_id request_time keyword 1 2011-03-04 08:23:45 free 2 2011-03-04 08:25:50 free -
How to use case-when statements in stored mysql procedure?
Hi, I want to set the session_id automatically using the request_time parameter so i opted for a mysql stored procedure that contains a case statement.Here goes.
...Code:create procedure upd_userinput(in request_time timestamp, out user_session_id int) begin update user_input; case request_time when time(request_time) < '9:15:00' && time(request_time) > '8:15:00'
-
error linking c++ and asm
i want to call a procedure from asm but when i want to link my program it show some error
like de _cout procedure doesn't exist and _printf and others =/.....
i think that maybe the obj of my program in c++ its not right but how i make it!! i use borland c++ 4.5 -
Excel: Calling Foreign Procedure
I am setting up a public procedure which I plan to have available to all open workbooks. Technically, it sets the column formatting for any column in other workbooks, which matches any of the field names listed in my library workbook (which also contains the procedure). This comes about because copying data from SQL Management Studio and pasting into Excel doesn't maintain any info about the data. Access works more intuitively. If I copy in data... -
store procedure call
Hi:
I´m calling a store procedure inside another store procedure and I have two problems
create sp1(in variable int)
begin
call sp2(variable)
call sp3(variable)
call sp4(variable)
end
the first thing is :
If I call each sp alone it works fine but if I call the sp1 it does´t work and no error messages are reported.
The second... -
Recursive stored procedure
Hi all,
I need your help.
I'm creating a program to display the circuit of Bus by city and stop.
This is my example and i don't know how to do it:
I have 3 differents circuits of bus and each circuit can have one or multiple transfer to another circuit.
So let's say i'm looking for a trajet from City1/Stop1 (source) To City3/Stop11(destinat ion)
Here's the scenario:... -
Where do I place a stored procedure?
Hello all. Sorry if the question is an obvious one, but I have a stored procedure as follows:
[CODE]
CREATE PROCEDURE USPAddToyRecord
@strToyName varchar(50) ,
@strToyCode varchar(6) ,
@intToyId int out
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO tblToy (strToyNameTO,s trToyCodeTO,) VALUES
(@strToyName,@s trToyCode)
SELECT @intToyId = @@IDENTITY
END
...
