NEWBIE needs a little help...

  • Thread starter Thread starter Ray W.
  • Start date Start date
R

Ray W.

I've created my database and form for new employee management

I want to place an icon on each of the manger's desktop so all they need to
do is click no the icon and the form will pop-up. How do I make this happen?

Once they have poplulated the form, I want them to be able to go to FILE the
SENT TO and email me the form exactly as they see it on their screen (it is
printable, but trying to do things electronically). When I try this I get
promted for an HTML template, not sure what access is looking for here. How
do I make this happen?

Thanks,
-Ray
 
Ray W. said:
I've created my database and form for new employee management

I want to place an icon on each of the manger's desktop so all they
need to do is click no the icon and the form will pop-up. How do I
make this happen?
Click to expand...

You can create a shortcut to the form itself and put it on the manager's
desktop, by right-clicking on the form and choosing Create Shortcut...
However, that won't open the form and only the form -- the Access
application will open and the application window will be visible behind
the form, and the database window will also be visible unless you've set
the startup option to hide it.

It is possible, by virtue of some API coding, to make a form appear
without the Access application window. See this link:

http://www.mvps.org/access/api/api0019.htm

I believe that, although the article doesn't say so, your form must be
both PopUp and Modal.
Once they have poplulated the form, I want them to be able to go to
FILE the SENT TO and email me the form exactly as they see it on
their screen (it is printable, but trying to do things
electronically). When I try this I get promted for an HTML template,
not sure what access is looking for here. How do I make this happen?
Click to expand...

This you can't do, at least not the way you descibe it. A form is not a
container for data that you can e-mail from place to place; it's just a
user-interface object that allows the user to interact wth data that is
stored in tables. What do you plan to do with the form when you get it?
If it's the data you want, File -> Send To... works fine, but you have
to pick one of the supported formats. In no case will it send something
that actually looks like the form.

You *can* create a report that looks like the form -- with the form open
in design file, click File -> Save As... -> Report. You can e-mail this
report as an attachment in snapshot format, in which case anyone with
the snapshot viewer can look at it or print it. However, that's just an
image of the data, and you can't then get at the data to work with it.
 
Back
Top