Am I starting at the right place?

[TeresePamela]

My company is switching from FoxPro/VFP to MS ACCESS 2000. I have ordered Access 2000 Desktop Developer's Handbook and the Access 2000 version of Visual Basic for Applications step by step.

I have to convert all my programs and forms. These are not terribly sofisticated, but are important to daily business. Two examples are using one form to have user select 1 or more items to seach by, find items and display data with scrolling functions, messages etc. (read only). I'm thinking my starting point here would be to use a sub-form. Another is manipulating multiple tables to either produce more tables and/or reports. I am assuming that Access VBA code behind a button on a form would be the way to go and therefor learning Access VBA code would be my starting point?
Am I on the right track with my starting points? I don't want to waste time going in the wrong direction if I can avoid it as I think I have a lot to learn here.

Thanks in advance for any and all guidance.

Pam

 

[dpimental]

A couple of years ago, I had to migrate a company from a FoxPro DB to Access.

Their FP db was older though. It was a DOS version. And the company wanted to maintain the "look & feel" of their DOS version of FoxPro, so, I had more challenges than you have; but your challenges are still significant.

But I was an Access Programmer, trying to work with FoxPro.

As far as a starting point goes, I am not clear on where you are in the process. How much analysis you've done, or whether you even need to do much (if you already know the FP db inside and out, you may not need much analysis).

I don't know if you've already migrated the tables, fields, and table relationships with the data over to access yet.

Can you clarify?

David Pimental
(US, Oh)
dpimental@checkfree.com

 

[TeresePamela]

Hi David,

I feel less alone now

Actually I have it rather easy in the sense that I was responsible for all aspects of the db development and maintenance so I totally understand the useage. Our files are very simple with just a couple of relationships and I have the process of migrating the data etc. tested, documented and waiting, which will leave me with related ACCESS data tables and no forms for updating or viewing and no reports created. I now have to figure out how to make the data useable in forms that look familiar to the users,(who are used to foxpro 2.5b screens) and how to re-code my foxpro programs to produce the reports etc. - I know absolutely nothing about vba code at this point :-(
My old programs used to read in data from multiple files, manipulate and either create more tables or generate reports, I'm assuming vba code behind buttons will be the way to go now?

Thanks for your time and help - it is appreciated.
Pam