Results 1 to 6 of 6

Thread: I need suggestions

  1. Jan 27th, 2004, 06:31 AM #1
    shersu
    shersu is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jul 2003
    Location
    India
    Posts
    318

    I need suggestions

    Hi all,

    I have a project in hand for which I am really confused as to how to start the project coz it contains a lot of tables and reports in Access. I would like to know from those experts out there that, is it advisable to do the coding in VB with Access as the Back End or should I do the coding in VBA for Access? Please suggest.

    Thanks
    Reply With Quote Reply With Quote
  2. Jan 31st, 2004, 06:29 PM #2
    Madboy
    Madboy is offline
    Supreme User Madboy's Avatar
    Join Date
    Oct 2003
    Location
    England
    Posts
    3,253
    You have double posted
    Reply With Quote Reply With Quote
  3. Feb 1st, 2004, 12:37 PM #3
    Shaggy Hiker
    Shaggy Hiker is offline
    Super Moderator Shaggy Hiker's Avatar
    Join Date
    Aug 2002
    Location
    Idaho
    Posts
    40,104
    Do the coding in VB. You might change the backend at some point in the future, and then where would you be?
    Reply With Quote Reply With Quote
  4. Feb 2nd, 2004, 11:44 PM #4
    shersu
    shersu is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jul 2003
    Location
    India
    Posts
    318
    You are absolutly right. Thanks for the info.
    BTW is there a way to use Excel as the backend on one of the forms?
    Thanks
    Reply With Quote Reply With Quote
  6. Feb 5th, 2004, 03:07 AM #5
    mebhas
    mebhas is offline
    Frenzied Member
    Join Date
    May 2003
    Location
    Sydney
    Posts
    1,123
    there should be. i remember seeing something like excel files as a source of a dsn in odbc.
    My codebank submissions :
    vb6-pop3 attachment processing, vb6-pop3 email

    My Rants:
    Customizing Combobox
    .Net and Office Outlook
    XML, CSV and DataSet
    Using SQL Server Compact in Windows Phone 7.1 apps – Part 4

    My Website : HERE

    Do rate my post if I have helped you.
    Reply With Quote Reply With Quote
  7. Feb 5th, 2004, 10:55 AM #6
    Shaggy Hiker
    Shaggy Hiker is offline
    Super Moderator Shaggy Hiker's Avatar
    Join Date
    Aug 2002
    Location
    Idaho
    Posts
    40,104
    You can use Excel with ease, you just need to include the proper references in the project. Once there, you can do anything you want with Excel.....slowly. I have found that using Excel seems a bit slow, but I haven't worked with it much, and it could be just the particular way I was doing things.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width