Table

[Denver]

I have a table which has all the records i have in my database..
i want to open this table without clicking from the database window...
i would like to use a command button to open this table and prompt a
password to avoid any user to manipulate it, is this possible?
what would be my code looks like?

there are instances that my boss like to export this table to excel and PDF.
what if i updated the table or add a records from this table would access
update also the excel and PDF that i exported? so that when they asking me
the report in this format i will just send it directly.


thanks

denver

 

[Fred]

I noticed that nobody answered. If I may be direct in an attempt to be
helpful.

Your question sounds a little vage, but things like that can generally be
done with Access. Your question is also very broad, and it sounds like you
are newer to Access. And so a respondent would have to put months of
teaching into one answer.

If you are newer to Access, this one is probably too tough of a place to
start. I'd start with something easier/more typical. If this project needs
to get done right away, you may need to get someone to do it for you.

 

[RayNDM83]

I have a table which has all the records i have in my database..
i want to open this table without clicking from the database window...

First, you need to create a form. Then under Tools, Startup, Display
Form/Page you can choose to open specific form you want to open.

i would like to use a command button to open this table and prompt a
password to avoid any user to manipulate it, is this possible?

There is a general password for all the users and there is a security
password that you can also use. Which type of you prefer?

what would be my code looks like?

there are instances that my boss like to export this table to excel and PDF.

In the form, you add a button and create a macro that will transpose your
form to an excel sheet.

what if i updated the table or add a records from this table would access
update also the excel and PDF that i exported?

Everytime you hit this macro button to transfer to excel, all files being
transfered are the most current one.

so that when they asking me