|
Passs a parameter to a query via a Data Access Page - Help
So I have spent the last two days (straight) trying to pass a
parameter to a data access page that is based on a query. My plan is
to tack on the parameter to the URL for a database that will sit on a
share folder.
From what I could find, I have attempted the below script.
Regardless of what I do I always end up with the same window that asks
for the parameter in order to see the ...
|
1 |
12.06.2006 04:04:39 |
|
|
filtering a combo box based on user's selection in another combo
i have 2 combo boxes in a data access page and i need the content on
the second combo to be filtered based on the selection of the first
one.
ex. first combo lists all authors and the second lists books. i need
the books combo to list books authored by the selected author in the
authors combo box.
Any help??
...
|
2 |
09.06.2006 14:20:49 |
|
|
IE7 and Drop Down box
I am unable to navigate using the drop down box since installing IE7b2
is there any way of changing the behavior other than going back to IE6?...
|
1 |
09.06.2006 03:27:01 |
|
|
access97-function left()
Hi
Why, on workstation, I get error messages 'Function isn't avaible in
expressions in query expression Left(......)' ?
On another workstation my aplication run without problems.
...
|
2 |
07.06.2006 15:22:32 |
|
|
News de prueba
...
|
1 |
02.06.2006 23:55:58 |
|
|
Adding records to a table using data pages
I need to create a simple form to allow people to add data to a table without
them seeing any other data in the table. All I want is the textboxes from the
table and a submit button that adds the data from the textboxes to the table.
Anyone have a simple explanation on how to do this.
Thanks....
|
2 |
02.06.2006 00:00:59 |
|
|
Data page doesn't look the same within Access vs "outside"
When I look at my data access page within Access, all the formats and
defaults I have set up work the way I expect them to. But when I open
the page as a web page, none of the defaults are there. For example, I
want a field to display as currency (no decimal places) when it has a
value, or as blank when it is zero or null. In the Format property I
have put $#,###;($#,###);"";"".
When I sta...
|
1 |
30.05.2006 23:16:56 |
|
|
Relative path
Hi all,
How can I create relative path between my db and my dap`s, so I will not
have to update the path every time I change folders?
Thanks,
Tom
...
|
1 |
30.05.2006 06:20:56 |
|
|
problem with data page size
Hi
a Question
Can i controtll the data page size at the runtime?
example:
wehn the results more than 5 then
data page size = 10
in vba
'if msodsc.DataPages(0).Recordset.RecordCount >5
then ' msodsc.GroupLevels(0).DataPageSize = "10"
but this givs an error
...
|
1 |
29.05.2006 06:30:56 |
|
|
Access: Data Access Page Navagation Question
Hello,
Does anyone know how to write the vbscript syntax to make a command button
close a data access pages and open up a main menu form in access.
Goal: When the end-user clicks on a cmdButton that opens a data access page
from an access main menu form and the end-users wants to go back to the menu,
they can just click the command button.
Additionally, please list reference books a...
|
3 |
29.05.2006 06:08:06 |
|
|
Sharing a Data Access Page
Hi,
I have created a data access page and want to share it with colleagues.
The database is on a network drive. My network drive is connected to drive
R:\.
When I come to share the Data Access page with a user who's network drive is
something other than R:\ an error message comes up saying it can't find the
database? Is there a way round this so everyone's network drive does no...
|
4 |
28.05.2006 19:06:41 |
|
|
Subform
at times my data may be redundent so if an item (address) aready excists in
my subform I want to have that item appear when typing. Can someone help.
note several fields (address fields)...
|
2 |
28.05.2006 19:06:34 |
|
|
Text-Field Multiline Problem
Hi
My text-field is multiline and wehn i give a ENTER the text goes up and
isn't visibble.
I wish that wehn i give a ENTER an event starts and not that the cursor jump
to the next line
Have anybody an idee?
regards Matthias
...
|
3 |
28.05.2006 19:06:25 |
|
|
Losing the path
Hi,
I have few dap in my DB.
the path for the data is :\myprject\myproject.mdb
when I copy the files to a different machine I lose the connection to the
data, even if I keep all the files in the same path.
Any suggestions?
Thanks,
Tom
...
|
2 |
28.05.2006 19:06:18 |
|
|
Parameter Window
Hi all,
I created a DAP based on a query (with access 2003).
When I open that page with IE, the parameter window in not elegant as nuch
as I want to.
Is there any way to control it`s looks?
Thanks,
Tom
...
|
2 |
28.05.2006 19:06:12 |
|
|
specific results have a different BG color
Hi,
Not sure if this is possible or not, but is there a way to make certain
results that are queried from the DAP have a different background
color?
We have a time-off calendar, and some have suggested it would be nice
if each payday (Every other Friday) was a differernt color?
could this be done?
Chris.
...
|
2 |
28.05.2006 19:06:06 |
|
|
Lock records
Hi,
I have DAP that shows data from DB.
How do I lock the records so user will not remper them?
Thanks,
Tom
...
|
4 |
28.05.2006 19:06:00 |
|
|
NEW PORTAL
===========================================================================
FULL LEGAL SOFTWARE !!!
Games, video, program, image, chat, questbook, catalog site, arts, news,
and...
This site it is full register and legal software !!!
Please download and you must register software !!!
PLEASE REGISTER SOFTWARE:
http://www.webteam.gsi.pl/rejestracja.htm
DOWNLOAD LEGAL SOFTWARE:
http://www.w...
|
1 |
28.05.2006 19:05:43 |
|
|
NEW PORTAL
===========================================================================
FULL LEGAL SOFTWARE !!!
Games, video, program, image, chat, questbook, catalog site, arts, news,
and...
This site it is full register and legal software !!!
Please download and you must register software !!!
PLEASE REGISTER SOFTWARE:
http://www.webteam.gsi.pl/rejestracja.htm
DOWNLOAD LEGAL SOFTWARE:
http://www.w...
|
1 |
28.05.2006 19:05:35 |
|
|
this is test
OK,
I Wold like to help each other.
...
|
2 |
27.05.2006 10:46:30 |
|
|
Creating Data Access Page
When I try to create a data access page in either design view or with the
wizard, I can get a field list. All that is displayed is where the file is
with a red "x" next to it. I tried refreshing it and I was given an error
"Microsoft Office Access is unable to connect to the data source specified
in the connection string of this page. The server may not exist on the
network, or there may...
|
7 |
22.05.2006 07:45:02 |
|
|
defined type
Hi,
In my first function in Access97 , I get the errors:
"User - defined type not defined"
for cod line: "Dim cat As New ADOX.Catalog"
(function loads the LinkedTables array)
What can I do?
Thanks
...
|
4 |
19.05.2006 22:50:31 |
|
|
subscript out of range
Hi,
What problems generate the message "Subscript out of range"
and which is the solution for this ?
Thanks
...
|
1 |
19.05.2006 07:49:10 |
|
|
Re: Parameter Query for PASSWORD doesn't maintain Input Mask
"martijn" <m.leerentveld1@chello.nl> schreef in bericht news:...
>
> "Kevin McDonald" <KevinMcDonald@discussions.microsoft.com> schreef in
> bericht news:F2E52661-7015-4CF1-AB82-A495419A1436@microsoft.com...
> > I've created a Query asking for "Your Password?". I've tried setting
the
> > input mask to PASSWORD, but the Data Access Page doesn't show *******...
|
1 |
19.05.2006 03:03:32 |
|
|
Parameter Query for PASSWORD doesn't maintain Input Mask
I've created a Query asking for "Your Password?". I've tried setting the
input mask to PASSWORD, but the Data Access Page doesn't show *******. It
still shows the password as I'm typing it.
I also can't figure out how to change the format of the "Enter Paramters"
box on the DAP.
Thanks,
Kevin
Access 2000, FrontPage 2000, Local Web on XP Pro....
|
2 |
19.05.2006 03:03:21 |