I don't have your answer, but since your question is more Access related, you might get a good answer from (in my experience) the best Access resource around, http://www.utteraccess.com/. If there is an answer to your question, it should be there.
Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY
"The Leader in Back-lit Mirrors & Mirror TV Technology"
T 425 776-4946
F 425 491-8200
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>
Note: The information contained in the e-mail, including any attachments, is legally privileged and confidential. If you are not the intended recipient you are hereby notified that any reading, use or dissemination of this message is strictly prohibited. If you have received this message in error, please immediately notify us by telephone at 425-776-4946 and delete this message from your system. Even though this e-mail and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free, and no responsibility is accepted by Electric Mirror LLC for any loss or damage arising in any way from its use
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Tuesday, October 28, 2008 6:31 AM
To: vantage@yahoogroups.com
Subject: {Disarmed} RE: [Vantage] OT: MS Access Data Access Pages
Thank you for your input.
I'm somewhat familiar with the fundamentals of Access Forms. On a
normal Form, this is easy.
However, this is what my problem is: I cannot duplicate this on a
"Page" or a "Data Access Page". There's not as much flexibility and
functionality on DAPs. I'm almost certain this can be done on a DAP,
but it will require a little VBScript code or something.
I'm completely clueless.
Even if I create the Form in Access and do a Save As... to a Data Access
Page, it won't wave due to my "cascading" or conditional dropdowns. In
fact, in Forms, as you very well know, they are Comboboxes whereas in
Pages they are "dropdown lists".
Microsoft..... consistently inconsistent.
Any other ideas would be much welcomed. :-)
Vic Drecchio
ERP Administrator
TIMCO Aviation Services
Greensboro, NC
Email: vic.drecchio@...<mailto:vic.drecchio%40timco.aero>
Office: 336.668.4410 x3091
Mobile: 704.530.3092
-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Toby Boogerd
Sent: Monday, October 27, 2008 9:53 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] OT: MS Access Data Access Pages
You would set your second dropdown to use a query that accepts a
parameter from the first drop down. So if they pick Job # SK101345 and
then click the op drop down the code onClick would do something like
Select * from TableName where JobNum = @parameterJobNum (in our case the
param would be SK101345 from the dropdown)
________________________________
From: Vic Drecchio [mailto:vic.drecchio@...<mailto:vic.drecchio%40timco.aero>]
Sent: Thursday, October 23, 2008 5:20 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] OT: MS Access Data Access Pages
By any chance are there any MS Access guru's out there very familiar
with Data Access Pages?
I am logging some things to a Vantage SQL UD table via our intranet
using MS Access' Data Access Pages.
I have 2 drop down controls on the form. One for Job#. One for Op#.
I want the user to select the appropriate Job#. That's easy.
Based upon that Job# selected, I need to "filter" the results available
in Dropdown #2 so it only displays the valid Ops for that Job#.
Hopefully it's easy. Thanks in advance.
Vic Drecchio
ERP Administrator
TIMCO Aviation Services
Greensboro, NC
Email: vic.drecchio@...<mailto:vic.drecchio%40timco.aero> <mailto:vic.drecchio%40timco.aero>
Office: 336.668.4410 x3091
Mobile: 704.530.3092
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
[Non-text portions of this message have been removed]
Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY
"The Leader in Back-lit Mirrors & Mirror TV Technology"
T 425 776-4946
F 425 491-8200
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>
Note: The information contained in the e-mail, including any attachments, is legally privileged and confidential. If you are not the intended recipient you are hereby notified that any reading, use or dissemination of this message is strictly prohibited. If you have received this message in error, please immediately notify us by telephone at 425-776-4946 and delete this message from your system. Even though this e-mail and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free, and no responsibility is accepted by Electric Mirror LLC for any loss or damage arising in any way from its use
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Tuesday, October 28, 2008 6:31 AM
To: vantage@yahoogroups.com
Subject: {Disarmed} RE: [Vantage] OT: MS Access Data Access Pages
Thank you for your input.
I'm somewhat familiar with the fundamentals of Access Forms. On a
normal Form, this is easy.
However, this is what my problem is: I cannot duplicate this on a
"Page" or a "Data Access Page". There's not as much flexibility and
functionality on DAPs. I'm almost certain this can be done on a DAP,
but it will require a little VBScript code or something.
I'm completely clueless.
Even if I create the Form in Access and do a Save As... to a Data Access
Page, it won't wave due to my "cascading" or conditional dropdowns. In
fact, in Forms, as you very well know, they are Comboboxes whereas in
Pages they are "dropdown lists".
Microsoft..... consistently inconsistent.
Any other ideas would be much welcomed. :-)
Vic Drecchio
ERP Administrator
TIMCO Aviation Services
Greensboro, NC
Email: vic.drecchio@...<mailto:vic.drecchio%40timco.aero>
Office: 336.668.4410 x3091
Mobile: 704.530.3092
-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Toby Boogerd
Sent: Monday, October 27, 2008 9:53 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] OT: MS Access Data Access Pages
You would set your second dropdown to use a query that accepts a
parameter from the first drop down. So if they pick Job # SK101345 and
then click the op drop down the code onClick would do something like
Select * from TableName where JobNum = @parameterJobNum (in our case the
param would be SK101345 from the dropdown)
________________________________
From: Vic Drecchio [mailto:vic.drecchio@...<mailto:vic.drecchio%40timco.aero>]
Sent: Thursday, October 23, 2008 5:20 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] OT: MS Access Data Access Pages
By any chance are there any MS Access guru's out there very familiar
with Data Access Pages?
I am logging some things to a Vantage SQL UD table via our intranet
using MS Access' Data Access Pages.
I have 2 drop down controls on the form. One for Job#. One for Op#.
I want the user to select the appropriate Job#. That's easy.
Based upon that Job# selected, I need to "filter" the results available
in Dropdown #2 so it only displays the valid Ops for that Job#.
Hopefully it's easy. Thanks in advance.
Vic Drecchio
ERP Administrator
TIMCO Aviation Services
Greensboro, NC
Email: vic.drecchio@...<mailto:vic.drecchio%40timco.aero> <mailto:vic.drecchio%40timco.aero>
Office: 336.668.4410 x3091
Mobile: 704.530.3092
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
[Non-text portions of this message have been removed]