(Msg. 1) Posted: Fri Sep 26, 2008 11:19 pm
Post subject: Table Archived from groups: microsoft>public>access>tablesdbdesign (more info?)
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.
(Msg. 2) Posted: Mon Sep 29, 2008 3:03 pm
Post subject: RE: Table [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
(Msg. 3) Posted: Fri Oct 03, 2008 8:41 am
Post subject: RE: Table [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"Denver" wrote:
> 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
> the report in this format i will just send it directly.
>
>
> thanks
>
> denver
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other