plying with ADP

[Guest]

I'm working on porting an Access DB to SQL. I'm trying to decide whether to
keep my original front end mdb/mde and accessing SQL via ODBC linked tables
or use an ADP.

Anybody has any pro/cons?

One thing I have noticed is the following:
On many comboboxes, I have a row source that look like this:
SELECT Sites.* FROM Sites WHERE Sites.Active=True Or SiteId=cmbSiteName;
where cmbSiteName is the name of the control that this query was used for
rowsource; hence returning the value for the current record for this control.

This was setup in order to be able to inactivate individual values in the
source table without affecting records that might have used that value. So
any given combobox would only display the list of active items and if the
current value was de-activated, then it would still be available for
selection.

I know I could accomplish the same by promatically setting the rowsource
during the Current event to include the value of the current record, but I
like to limit how much code runs on my current event to keep things fast and
simple.

Any suggestion on how to dynamically include a value from a control on a
form into a rowsource query for another control when using ADPs?

Thanks

Peter-d

 

[Aaron Kempf]

use ADP I mean DUH

MDB is a total pain in the butt-- with no value

anyone using MDB should be FIRED and then spit upon

 

[Aaron Kempf]

Any suggestion on how to dynamically include a value from a control on a
form into a rowsource query for another control when using ADPs?


I'd reccomend setting the SQL Statement of the value that you WANT to the
value that you NEED.


[Forms][MyForm][MyControl] is not ANSI compliant


So-- instead of doing this:

strSql = "Select * from employees Where EmployeeID =
[Forms][MyForm][MyControl]"


merely do this:
strSql = "Select * from employees Where EmployeeID = " &
[Forms][MyForm][MyControl


do you notice the difference in the double-quotes?

 

[Albert D. Kallal]

do you notice the difference in the double-quotes?

Well, did notice that you left out the ! (bang)

So-- instead of doing this:

strSql = "Select * from employees Where EmployeeID =
[Forms][MyForm][MyControl]"

No, the above never worked, you need to use:

strSql = "Select * from employees Where EmployeeID =
[Forms]![MyForm]![MyControl]"

merely do this:
strSql = "Select * from employees Where EmployeeID = " &
[Forms][MyForm][MyControl

As usually, even when you try to help, you get it wrong, go off on huge
tangents about using a ADP, and at the end of they day, fail to help, and
fail to respect the people here....good job...

Really, at the end of the day, it not about being right vs wrong, it about
how you try and help the community here. If you don't like the community, or
the tools you are using, you are free to move on.

you can choose to be bitter, or better...the call is yours...

 

[Aaron Kempf]

stfu kid

air code

ADP kicks MDB's butt any day of the week

do you notice the difference in the double-quotes?

Well, did notice that you left out the ! (bang)

So-- instead of doing this:

strSql = "Select * from employees Where EmployeeID =
[Forms][MyForm][MyControl]"

No, the above never worked, you need to use:

strSql = "Select * from employees Where EmployeeID =
[Forms]![MyForm]![MyControl]"

merely do this:
strSql = "Select * from employees Where EmployeeID = " &
[Forms][MyForm][MyControl

As usually, even when you try to help, you get it wrong, go off on huge
tangents about using a ADP, and at the end of they day, fail to help, and
fail to respect the people here....good job...

Really, at the end of the day, it not about being right vs wrong, it about
how you try and help the community here. If you don't like the community, or
the tools you are using, you are free to move on.

you can choose to be bitter, or better...the call is yours...

 

[Aaron Kempf]

if I DO NOT LIKE THE COMMUNITY?

THIS IS _MY_ COMMUNITY NOT YOURS

ACCESS DATA PROJECT IS THE RIGHTFUL HEIR TO THE MS ACCESS NAME

GO AND PLAY IN A MDB NEWSGROUP, KID

do you notice the difference in the double-quotes?

Well, did notice that you left out the ! (bang)

So-- instead of doing this:

strSql = "Select * from employees Where EmployeeID =
[Forms][MyForm][MyControl]"

No, the above never worked, you need to use:

strSql = "Select * from employees Where EmployeeID =
[Forms]![MyForm]![MyControl]"

merely do this:
strSql = "Select * from employees Where EmployeeID = " &
[Forms][MyForm][MyControl

As usually, even when you try to help, you get it wrong, go off on huge
tangents about using a ADP, and at the end of they day, fail to help, and
fail to respect the people here....good job...

Really, at the end of the day, it not about being right vs wrong, it about
how you try and help the community here. If you don't like the community, or
the tools you are using, you are free to move on.

you can choose to be bitter, or better...the call is yours...

 

[Aaron Kempf]

I can choose to be bitter or better?

I don't need to CHOOSE to be better

I am better than all your MDB newbie dorks

I'm a SQL Server 2005 Certified DBA

stfu and go and play with your newbie databases in a MDB-specific newsgroup

do you notice the difference in the double-quotes?

Well, did notice that you left out the ! (bang)

So-- instead of doing this:

strSql = "Select * from employees Where EmployeeID =
[Forms][MyForm][MyControl]"

No, the above never worked, you need to use:

strSql = "Select * from employees Where EmployeeID =
[Forms]![MyForm]![MyControl]"

merely do this:
strSql = "Select * from employees Where EmployeeID = " &
[Forms][MyForm][MyControl

As usually, even when you try to help, you get it wrong, go off on huge
tangents about using a ADP, and at the end of they day, fail to help, and
fail to respect the people here....good job...

Really, at the end of the day, it not about being right vs wrong, it about
how you try and help the community here. If you don't like the community, or
the tools you are using, you are free to move on.

you can choose to be bitter, or better...the call is yours...