Re: Convert foxpro to access

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



On Jul 9, 8:22 pm, "Steve" <s...@xxxxxxxxxxxxxxxxxxxx> wrote:
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
resou...@xxxxxxxxxxxxxxx

"pointer" <smut...@xxxxxxxxx> wrote in message

news:1184002011.528781.263990@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



Does anyone know how to convert a foxpro database to an access
database complete with the forms and other objects in the foxpro
database?- Hide quoted text -

- 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


.



Relevant Pages

  • Re: SYSTEMS ENGINEER/ VAX-VMS/ CAREER POSITION
    ... System Administration and database admin from NIIT, ... salary details and generate reports and enclosures,and calculates ... Responsibilities: ... Write New programs from user requirements, Programming Changes ...
    (comp.os.vms)
  • Re: Selling the boss on a "publish to the web" Access app?
    ... provide a link to the database to users and they could come in to the site, run reports, etc. ... Can you find me an example of a database online and don't have to login that was written in asp.net for example? ... You REALLY need to adopt some overall secure model for your web systems, regardless of what your goal is here. ... So the idea of a one click to publish to some system, certainly means that you're going to have to adopt a web server with a FIXED set of standards. ...
    (comp.databases.ms-access)
  • Re: Advice needed for a growing Access 2000 project
    ... However, it turned out that quite a few of those were "leftovers" from previous releases, no longer accessible from anywhere but the database window, and, thus, no longer used. ... But that certainly isn't the _norm_ -- without any 'heroic' measures, there are routine reports of split Access DBs ... Finally, in my opinion, for "Windows apps", that is, individual-user applications, modest-sized multiuser applications, and client-server applications of any size, Dot Net does NOT "help along" any of these issues. ... The post I reference was in reference its self to the MS Access Help file under "Microsoft Access database general specifications" ...
    (comp.databases.ms-access)
  • Re: running report cause fatal error- on Win98, not XP
    ... another query. ... only the more complex reports cause the crash- the others do ... Then compact the database: ... Still in the code window, choose Compile from the Debug menu. ...
    (microsoft.public.access.reports)
  • Re: running report cause fatal error- on Win98, not XP
    ... It is actually not that difficult to crash JET with complex queries, ... another query. ... only the more complex reports cause the crash- the others do ... Then compact the database: ...
    (microsoft.public.access.reports)