Open form in another program

  • Thread starter Thread starter Mr-re man
  • Start date Start date
M

Mr-re man

Is it possible to open a form created in Access with all the functionality in
another program (eg. Excel, Internet etc)

I only ask as our company needs to pilot a scheme that records responses to
certain criteria and to purchase access for 50 pc's would cost a fortune as
we only have the standard office software.

Any suggestions would be appreciated
 
It would probably be easier to first make a report from the form and then
export it to Excel. Right click on any report and hit Export.
 
I have exported a report into excel before so am familiar with that process,
but how would you use that to convert it into a form?

The access form currently requires a user to click a button, this then opens
another form and asks whether if the enquiry was via an email, tel or
face-2-face enquiry, once selected, the following details are saved in a
table:

Description of button (application form request), enquiry type, date, time

At the end of the day, I can then create a report that indicates how many of
each category we have dealt with.

But instead of having access installed on every pc, I was hoping to have the
form work through another program but the results get imported to the access
table.

Hope that provides you with enough information on what I want it to do.
 
I misunderstood your question, I think. You are wanting to import Excel to
Access? If that is the case, you can link excel files directly to Access by
going to file/get external data. Or at the same location, you can just inport
the file and convert it into a table right on the spot. Access will do it for
you. So the users don't have to have Access, just Excel. You can also import
rtf (text files) if that would be better.
 
An Access form can only be used within an Access application; however, it is
not necessary to purchase a copy of Access for each computer. If you are
not already on 2007, the least expensive path would be to purchase Access
2007 only for the computers where the development will be done. Unlike
previous versions, the developers tools are a free download for 2007. With
that, you can deliver your application with the runtime version at no
additional cost.

With 50 users, it will be very important (an absolute must) that you split
your database and deploy a copy of the front end to each user. Also, be
sure your data structure is optimized and you are using good indexing and
that you take advantage of every performance benefit you can. For example,
put the back end accdb as close to the root directory as possible and keep
the file name length no more than 8 characters. Seems silly, but it does
help.
 
Back
Top