I have done a couple of conversions of midsize databases. The data can be
imported into Access. For the forms and reports, I made screen shots of each
form and report then built Access forms and reports from scratch to give the
same functionality.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
- Show quoted text -
Steve, John and Douglas thanks for your responses I appreciate.
I was looking for a way to convert a foxpro database to an access
database because I've found it impossible to recreate a multiple
field
search box in access like the one in the vfp database. I have a
screen shot but i couldn't find a way to include it in this message.
I have been battling with this problem for weeks.
I'm trying to use ms access 2003 to create a search box that's similar
to
the one in foxpro. It searches all the fields in only one table so
each table has a search box for it. Here is a description for the
search
box for the community table which is one of the tables in the
database.
It has a drop down list that selects all the columns in the table
such
as area code for the community, community code, and community
description. Beside it is another dropdown list box for operator
which you can use to select operators such as plus, equals to (=),
greater than, less than, is null, between, in.
beside this is a box that display value.
Below all of these form fileds is an option box with options for and,
or.
and beneath this is another row just like the one before the options
box.
Below theses are three buttons for search, all, cancel. What's really
hard for me to figure out is the option box that uses AND, OR to
combine
the two diffrent search groups.
I'd be glad to send a screen shot to anyone who requires it to assist
me.
Thanks