Results 1 to 13 of 13
  1. #1
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    grid? list? (VB 6, MS Access 98)

    I am new to VB and I am trying to build a grid? list? something that will display (on the monitor) three fields of a record if the status is not Finished. Then in 5 seconds or 10 seconds it redisplays the screen and will stay online all day. I was able to get this done using MS Access but we are trying to stay way from that and just use vb if we can.

    Rec. status Job
    123 submit PC Conversion
    1234 submit PC Conversion
    1343 working Tape Copy

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: grid? list? (VB 6, MS Access 98)

    <hr> Then in 5 seconds or 10 seconds it redisplays the screen and will stay online all day. <hr>
    I have no idea why you mean by this. Why does it need to "redisplay" the screen, and what is entailed in staying online all day? There is no particular advantage in doing this in VB or Access if you're working with a database backend. In fact, you're using the Jet engine regardless if you use VB's "database" capabilities. IT people who don't know any better often think that VB is *better* than Access without realizing they use the same database engine.
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: grid? list? (VB 6, MS Access 98)

    The "application" I am working on does the following: 1. A client will pull up the form they need to have work done with (Tape copy, File conversition, File Transfer, File to CD). 2. On average we have about between 200 - 250 request each day. 3. Within the application the clients fill in the request - Conversion - convert a binery file that is about 35 mb in size. 4. I would like to have a small window that will display the records that have a status of "submit" meaning it is a new job request. 5. My Data Control operators will then go into the application and pull up the record and view all the details about this request. Do the converstion from x format to a ascii fixed flat file. This request can take from 2 min to upto 1 hour in some cases.

    Now why does it have to "display" all day? - I have 5 operators per shift - doing these conversions from 6:00 am until 11:00pm and they all view the overhead monitor to see if there is any work waiting. Right now the display is in MS Access 98 and it works fine. But, with about 300 clients accessing the current MS Access "forms" the database tends to get slower, then with clients and inhouse users using MS Access 98, 2000, 2002 and now 2003 they are asked to convert the db.. someday someone will say yes to the conversion.

    By using the VB as a frontend to the database, my clients and inhouse users are not being asked to convert the database, they are not overburdening the system, thus slowing it down. I do know that I am using the same database engine that is why this will only be a temporary fix. The main drive in 2 years will be to convert all our Access databases to DB2 database using ColdFusion as a frontend.

    As for IT people not knowing any better... will we have a small programming dept (11 programs) that recommended this process while they start working on the main conversion project.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: grid? list? (VB 6, MS Access 98)

    Look at the Timer control; it is non-visible in runtime and can be used in code much like the On Timer event of an Access form.

    Important properties:
    - Interval (in milliseconds)
    - Enabled (True/False)

    Important (and only) event:
    - On Timer (code to execute every Interval milliseconds if Enabled = True)

    Write code in the On Timer event (double click the control to create the event procedure) to refresh the text boxes.

  5. #5
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: grid? list? (VB 6, MS Access 98)

    I realize this would be a diversion from the plan to go to DB2, but you could consider converting the database to SQL Server. MSDN includes a developer version that probably would let you split the data store from the application pieces. You then could deploy it on the "free" MSDE version of SQL Server, which has a performance governer for more than five simultaneous queries. With only five operators, it should work fine for you.

    There is a book I bought a few years ago with a title similar to SQL Server for Access Developers or something like that. Very useful for evaluating this sort of migration.

  6. #6
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: grid? list? (VB 6, MS Access 98)

    Where would we get the money to get servers? We would need to hire people that are famililar with Servers and SQL. As for having just 5 operators,yes that is true, but we have about 30 inhouse Accounts Reps and about 200 outside clients.
    We are a mainframe shop running an IBM mainframe with a DB2 database that is close to 4 terra bytes in data for other applications we have. We have the programers and DB2 developers and administrators. Why go to something we don't support or have the resources for?

  7. #7
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: grid? list? (VB 6, MS Access 98)

    > Where would we get the money to get servers?
    You can buy a great COMPAQ server on eBay with lunch money. Not sure if you have lunch money available.

    > We would need to hire people that are famililar with Servers and SQL.
    While you hardly need to know anything about SQL Server to do this, but it is true that you would need to run a Windows 2000/2003 server. If you don't currently run Windows servers, then it wouldn't make sense to start now as the licensing costs would kill you.

    > As for having just 5 operators,yes that is true, but we have about 30 inhouse Accounts Reps and
    > about 200 outside clients.
    No wonder your Access database is all tied up.

    > Why go to something we don't support or have the resources for?
    Well... it seems you are going down that road already with VB... <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  8. #8
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: grid? list? (VB 6, MS Access 98)

    > Why go to something we don't support or have the resources for?
    Well... it seems you are going down that road already with VB...

    Now you hit it on the nose..... A while back I wrote of few VB tid bits... basic stuff... create a form, write the data to a database. I wanted to see how VB worked so I took the Introduction class. BIGGEST mistake of my life. Now they think with its possible to convert an applications that was created by several people in about 6 months, within a few weeks. Most of the work is possible to do... its just create a form, enter data to form and update database. Its the little things like this that have me going nuts. I would say that 97% of the work is done. The only thing remaing is the status monitor and the reports.

    I think that using the FlexGrid with the timer might do the job. I just need to figure how how to load and configure the grid and get started.

  9. #9
    New Lounger
    Join Date
    Oct 2003
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: grid? list? (VB 6, MS Access 98)

    MAKE CLONES OF YOUR DATABASE, THEN UPDATEBATCH PERIODICALLY. MAY BE THE ANSWER TO THE CLOG.

    TONY

  10. #10
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: grid? list? (VB 6, MS Access 98)

    We tried Clones, Replicates all the stuff MS talks about. We just have to much traffice all around. Best thing all around is to convert this to somthing else. This application has been around now for about 5 years and its time to let it go and start fresh with something more powerful.

  11. #11
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: grid? list? (VB 6, MS Access 98)

    Another thing you *might* want to do is convert the forms to an Intranet ASP page and from there you are constructing SQL strings that can be fitted to the SQL Server MSDN (can't remember the whole acronym, but it's the free SQL Server kernel) -- this will give you access to the backend 'transparently' as people will log into a webpage and interact via forms and you will be able to transfer to another db backend much more easily as ASP just issues SQL strings from a connection. Just a thought... I happen to work a lot with ASP and am happy with it's ability to work with dbs remotely.

  12. #12
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: grid? list? (VB 6, MS Access 98)

    Have you looked at moving the back-end tables to DB2 now and using an Access front-end on each workstation? ODBC connections can be created to DB2 as I understand it, and then you have the power of a mainframe database with a nice small user interface running on each PC. In theory you could do the same with VB6, but the development would take 3 times a long.
    Wendell

  13. #13
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: grid? list? (VB 6, MS Access 98)

    Right now i am not sure what we are going to do. Our parent company is looking into converting everthing we have on the IBM Mainframe/DB2 to a Server(s) some type. Using X software as the database. So for the next 6 months at least we are at a complete stop on any changes/updates.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •