Hello,
I have a form A in my ADP project. The record source of A has input
parameters.
I need to open form A from three different forms X, Y and Z.
When I open A from form X, I want it to take input parameters from form
X.
When I open A from form Y, I want it to take input parameters from form
Y.
When I open A from form Z, I want it to take input parameters from form
Z.
How do I accomplish this?
Thanks,
Isaac 5 3745
Probably the easiest way it to pass the calling form name to form A via
OpenArgs, then have A generate a SQL string for its RecordSource property by
reading values from controls on the source form.
I usually don't like embedding parameter values in SQL when it can reasonably
be avoided, but I've used ADPs enough to know that any other way you might
attempt to do this is bound to be quirky and cause you massive headaches.
On 9 Dec 2004 00:56:42 -0800, is********@yaho o.com wrote: Hello,
I have a form A in my ADP project. The record source of A has input parameters.
I need to open form A from three different forms X, Y and Z.
When I open A from form X, I want it to take input parameters from form X. When I open A from form Y, I want it to take input parameters from form Y. When I open A from form Z, I want it to take input parameters from form Z.
How do I accomplish this?
Thanks,
Isaac
Thank you Steve! I now plan to use OpenArgs and use it in the On Open
event of the form to generate an appropirate SQL statement that
executes a stored procedure with the required parameters. As you
suggested then I plan to assign the generated SQL string as the
RecordSource of the form.
Thanks,
Isaac
Steve Jorgensen wrote: Probably the easiest way it to pass the calling form name to form A
via OpenArgs, then have A generate a SQL string for its RecordSource
property by reading values from controls on the source form.
I usually don't like embedding parameter values in SQL when it can
reasonably be avoided, but I've used ADPs enough to know that any other way you
might attempt to do this is bound to be quirky and cause you massive
headaches. On 9 Dec 2004 00:56:42 -0800, is********@yaho o.com wrote:
Hello,
I have a form A in my ADP project. The record source of A has input parameters.
I need to open form A from three different forms X, Y and Z.
When I open A from form X, I want it to take input parameters from
formX. When I open A from form Y, I want it to take input parameters from
formY. When I open A from form Z, I want it to take input parameters from
formZ.
How do I accomplish this?
Thanks,
Isaac
Let us know how it goes.
On 9 Dec 2004 20:01:58 -0800, is********@yaho o.com wrote: Thank you Steve! I now plan to use OpenArgs and use it in the On Open event of the form to generate an appropirate SQL statement that executes a stored procedure with the required parameters. As you suggested then I plan to assign the generated SQL string as the RecordSource of the form.
Thanks,
Isaac
Steve Jorgensen wrote: Probably the easiest way it to pass the calling form name to form A via OpenArgs, then have A generate a SQL string for its RecordSource property by reading values from controls on the source form.
I usually don't like embedding parameter values in SQL when it can reasonably be avoided, but I've used ADPs enough to know that any other way you might attempt to do this is bound to be quirky and cause you massive headaches. On 9 Dec 2004 00:56:42 -0800, is********@yaho o.com wrote:
>Hello, > >I have a form A in my ADP project. The record source of A has input >parameters. > >I need to open form A from three different forms X, Y and Z. > >When I open A from form X, I want it to take input parameters fromform >X. >When I open A from form Y, I want it to take input parameters fromform >Y. >When I open A from form Z, I want it to take input parameters fromform >Z. > >How do I accomplish this? > >Thanks, > >Isaac
Sure :-)
Steve Jorgensen wrote: Let us know how it goes.
On 9 Dec 2004 20:01:58 -0800, is********@yaho o.com wrote:
Thank you Steve! I now plan to use OpenArgs and use it in the On
Openevent of the form to generate an appropirate SQL statement that executes a stored procedure with the required parameters. As you suggested then I plan to assign the generated SQL string as the RecordSource of the form.
Thanks,
Isaac
Steve Jorgensen wrote: Probably the easiest way it to pass the calling form name to form
Avia OpenArgs, then have A generate a SQL string for its RecordSource property by reading values from controls on the source form.
I usually don't like embedding parameter values in SQL when it can reasonably be avoided, but I've used ADPs enough to know that any other way
youmight attempt to do this is bound to be quirky and cause you massive headaches. On 9 Dec 2004 00:56:42 -0800, is********@yaho o.com wrote:
>Hello, > >I have a form A in my ADP project. The record source of A has
input >parameters. > >I need to open form A from three different forms X, Y and Z. > >When I open A from form X, I want it to take input parameters
fromform >X. >When I open A from form Y, I want it to take input parameters
fromform >Y. >When I open A from form Z, I want it to take input parameters
fromform >Z. > >How do I accomplish this? > >Thanks, > >Isaac
Hello,
I tried passing a string through OpenArgs and tried to change the
record source of the form based on the argument passed. I get an error
message saying the Open form action was cancelled. Does this have
something to do with the (Cancel as integer) in brackets in the sub
routine? I tried removing this and setting the value of Cancel to
false, inspite of this the error continues to appear. Any solutions?
Thanks
Isaac
Steve Jorgensen wrote: Let us know how it goes.
On 9 Dec 2004 20:01:58 -0800, is********@yaho o.com wrote:
Thank you Steve! I now plan to use OpenArgs and use it in the On
Openevent of the form to generate an appropirate SQL statement that executes a stored procedure with the required parameters. As you suggested then I plan to assign the generated SQL string as the RecordSource of the form.
Thanks,
Isaac
Steve Jorgensen wrote: Probably the easiest way it to pass the calling form name to form
Avia OpenArgs, then have A generate a SQL string for its RecordSource property by reading values from controls on the source form.
I usually don't like embedding parameter values in SQL when it can reasonably be avoided, but I've used ADPs enough to know that any other way
youmight attempt to do this is bound to be quirky and cause you massive headaches. On 9 Dec 2004 00:56:42 -0800, is********@yaho o.com wrote:
>Hello, > >I have a form A in my ADP project. The record source of A has
input >parameters. > >I need to open form A from three different forms X, Y and Z. > >When I open A from form X, I want it to take input parameters
fromform >X. >When I open A from form Y, I want it to take input parameters
fromform >Y. >When I open A from form Z, I want it to take input parameters
fromform >Z. > >How do I accomplish this? > >Thanks, > >Isaac This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Jim |
last post by:
im using asp.net, C# to enter data into a table in sql
server...however im getting this error:
Input string was not in a correct format.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details: System.FormatException: Input string was not in a
correct format.
|
by: ST |
last post by:
Hello, I will be posting 2 errors that I just can't seem to figure out (I'll
put them in different posts). I have looked all over the internet, and I
still can't figure these out! This webapp was working fine, and then all of
a sudden it just "broke"! Thanks in advance for your help!
Input string was not in a correct format.
Description: An unhandled exception occurred during the execution of the
current web request. Please review...
|
by: SophistiCat |
last post by:
Hi,
I am working on a computational program that has to read a number of
parameters (~50) from an input file. The program contains a single class
hierarchy with about a dozen member-classes or inherited classes, each of
which needs some subset of those input parameters. The classes may
individually perform some input validation, and even determine which
parameters are to be read next. Currently, each class performs its own
file...
|
by: Andrew Chanter |
last post by:
I am developing my first ADP client for a SQL db, after having used mdb's as
clients in numerous applications previously. I have found that
theoretically the Input Parameters property of a form in an adp and its
method of therefore enabling a form to be connected to a procedure that
requires parameters is really nifty. However in practice I am finding a
number of annoying issues with this, most particularly that the adp seems to
have...
|
by: fumanchu |
last post by:
I've got to let end users (really just one person) load billing batch
files into a third party app table. They need to specify the billing
cycle name, the batch name, and the input file name and then I can use
these values to execute a SQL Server stored procedure to load them
into the batch table from the input file (the stored procedure uses
Dynamic SQL to Bulk Insert the file to a temp table then processes it
into the final table.)
My...
| |
by: FS Liu |
last post by:
Hi,
I am writing ATL Service application (XML Web service) in
VS.NET C++.
Are there any sample programs that accept XML as input and
XML as output
in the web service?
Thank you very much.
|
by: Chad Micheal Lawson via .NET 247 |
last post by:
I'm stumped at this point and I'm tired of trying things so I'mposting in hopes of some guru with a sharp eye. I have anasp.net app running on a local Win XP Pro box. Within the app,I call a SPROC and pass the info to the SQL box and it hiccups. I'll drop VS.NET into debug mode and step through the SPROCcreation and copy those values into Query Analyzer to get alittle more info. When I run the Query Analyer that data worksjust fine. What?! ...
|
by: joesin |
last post by:
I recently found a vulnerability on my website that allowed sql
injection. I have been trying to write some code that would clean user
data but have been running into problems. The validation still works,
however so does the injection methods I have used....
These are the examples of code I have tried to use to fix the problem.
1. FrmUserName=replace (FrmUserName, " ' ", "")
2. function stripQuotes(FrmUserName)
stripQuotes =...
|
by: yawnmoth |
last post by:
I'm trying to get a list of all the input elements of a form tag and
am having some difficulty doing so. First, here's my XHTML:
<div>
<form action="">
<input type="text" name="a" />
</div>
<div>
<input type="text" name="b" />
</div>
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |