Parameter Query through ASPMaker

  • Thread starter Thread starter ryguy7272
  • Start date Start date
R

ryguy7272

Has anyone used this tool?
http://www.hkvstore.com/aspmaker/

I am using version 6.0. It works great!! I just can't figure out how, or
if, I can pass a parameter to a query. Basically, I am trying to display
only certain records in a table, based on a UserName and Passowrd. For
instance, if the UserName is Jack, and the password in 1234, I want to show
only the records associated with Jack when he enters his Password. I don't
want to show all the values in the entire table. As it stands now, I have
created several tables, one for each employee, but I will have to create
dozens more if I move forward with this current format. I was hoping to just
have all records in one table, and only show those that should be displayed,
based on a certain UserName and Password. I am using Access 2003 with
ASPMaker version 6.0.

Thanks so much!!
Ryan--
 
ryguy7272 said:
Has anyone used this tool?
http://www.hkvstore.com/aspmaker/

I am using version 6.0. It works great!! I just can't figure out
how, or if, I can pass a parameter to a query. Basically, I am
trying to display only certain records in a table, based on a
UserName and Passowrd. For instance, if the UserName is Jack, and
the password in 1234, I want to show only the records associated with
Jack when he enters his Password. I don't want to show all the
values in the entire table. As it stands now, I have created several
tables, one for each employee, but I will have to create dozens more
if I move forward with this current format. I was hoping to just
have all records in one table, and only show those that should be
displayed, based on a certain UserName and Password. I am using
Access 2003 with ASPMaker version 6.0.
Click to expand...
They do have a forum there. Have you asked your question there? I would be
shocked if this product did not allow parameters to be passed to a query. I
would uninstall it in a heartbeat if it didn't.
 
Ha! Your bluntness made me laugh! Yes, it is a powerful tool, but if it
doesn't allow the user to do something like passing a parameter, it is not
going to help me much.

Thanks for the suggestion Bob. I'm headed to the ASPMaker forum right now!!


Regards,
Ryan----
 
Just in case anyone is interested, this is the solution:

You can use User ID security, see the tutorial "Tutorial - Advanced Security
- User ID Security" in the help file.

Thanks again for the tip Bob!!!
Ryan---
 
Back
Top