hi,
in my work place i got an access database which contains several queries.
each time a user need to run a certain query he must open the database, select the proper query and insert a value(i.e. date) and press run to get the data.
the main problem is that most users dont know how to open and run queries.
i have a decent knowledge in excel vb but never tried it with access.
is there a way to make an excel file which will have an input cell for the users to type and then will open the query, insert the value and run it?
also each time i open a query it requires me to enter a password, can i make the macro to enter the password instead of doing it manually?
*i dont want do edit the existing queries, just need to insert a value to a specific cell in the query.
thank you very much.
in my work place i got an access database which contains several queries.
each time a user need to run a certain query he must open the database, select the proper query and insert a value(i.e. date) and press run to get the data.
the main problem is that most users dont know how to open and run queries.
i have a decent knowledge in excel vb but never tried it with access.
is there a way to make an excel file which will have an input cell for the users to type and then will open the query, insert the value and run it?
also each time i open a query it requires me to enter a password, can i make the macro to enter the password instead of doing it manually?
*i dont want do edit the existing queries, just need to insert a value to a specific cell in the query.
thank you very much.