RE: Help

From: JeffCT (computercardio_at_verizon.net)
Date: 09/01/04

  • Next message: Paul Clement: "Re: Migrate Access app to VB.NET" 
    Date: Wed, 1 Sep 2004 01:05:12 -0700

    Hi Chris, My email address is computercardio@verizon.net.
    What would even be better would be the following scenario.
    I have a client in a remote location.
    On our server we have a text file(The file is a Flat Cobol File)
    It has 98 fields, record length is 1024.
    I would like them to be able to do lookups on the file by either a sort
    name or a zip code. I only need to display the follwing fields from the
    record: Name, Title, Company, Address, City, State and Zip code. What I have
    done so far is taken the Flat File and converted it to an Mdb file(Access
    File). I have fooled around with the DED and gotten close to the results I
    need, but not there yet. This requires the clients to have Access installed
    on their local machine though so that they can connect to the database. Not
    all clients want that though. Would you have maybe a better solution to this.
    Thanks,

    Jeff.............

    "ChrisP" wrote:

    > Jeff,
    >
    > I don't clearly understand what you are asking for. There are many different
    > ways to achieve what you want. Do you want to display the table like you were
    > viewing it in the database? Ifso, you can use a MSFlexGrid.
    >
    > Or Are you looking to display information in textboxes or other controls on
    > a form from the database tables?
    >
    > To connect to a database you need to opena connection and then run whatever
    > query you want to display the right info. You can use an ADO control and then
    > set all your textboxes to the right data source property, the ADO control,
    > and the datamember property, the field from the databse or query directly.
    >
    > I need more info to help you. Leave me your email in a reply and I will send
    > you a few demos on how to connect and use a database a few different ways.
    > You can take it and mold it to fit your needs.
    >
    > hope this helps,
    > Chris
    >
    > "JeffCT" wrote:
    >
    > > I am new to this language. I have been given a small project.
    > > I have a MS Access DB with one table, 98 fields.
    > > I have to create a user interface that will allow the user to enter either a
    > > 7 position Sort Name or a five position Zip Code.
    > > The program needs to display the following fields of the row for that
    > > record,Name, Title, Company, Address, city state and zip code. In addition I
    > > need to have buttons to scroll up or down through the table. Can anyone help
    > > to get me started on this project. Thanks in advance for your help.
    > > --
    > > Jeff
    > > --
    > > Jeff

  • Next message: Paul Clement: "Re: Migrate Access app to VB.NET"