Results 1 to 5 of 5
  1. #1
    charaia is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Posts
    2

    Where to begin?

    I am a VB6 programmer who haven't coded for many many years and kindo rusted. I would like to begin using VBA 2010 for simple utility programs like reading a text file, writing out to a text file (the stuff we can also do in text editors). Where can I find good code examples? Can you recommend some book/tutorials that helps me build coding in VBA and recall VB6 syntax etc.


    thank you,

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I don't know any books but I am sure they are available. This one looks interesting: Access™ 2007 Programming by Example with VBA, XML, and ASP by Julitta Korol, Wordware Publishing, Inc.

    Most of what I have learned has come from a mentor, Help files, or off the web. Like http://www.databasedev.co.uk/text_files.html
    Last edited by June7; 11-16-2012 at 01:39 PM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  4. #4
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    The databasedev and functionx sites were particularly helpful when I was making the move from VB6 to Access/VBA, and Crystal Long's MVP site continues to be useful, after 12 years of working in Access!

    But you need to be aware of a couple of things:

    • While VB6 and Access VBA are both derived from a common ancestor (QuickBasic4.5), they are not the same language! Functions and Properties in one language are absent from the other language! And even more confusing, Functions and Properties present in both languages do not necessarily do the same thing and do not necessarily utilize the same syntax!
    • And more importantly, to me, you're proposing to use a Database development program to develop apps that are not Databases! One of the most important factors in accomplishing a task, successfully, is to select the appropriate tool for the job! And from your original post, and well as my own prior experience, VB6 sounds like a much better fit for this project than MS Access does!


    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    charaia is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Posts
    2
    Thank you All! In my current job, all I am using is SQL server MS 2008, I coded 6 years ago & now don't have any projects at hand that need programming applications. I feel like I have forgotten all. Current employer used the VBA, so it will be nice to begin playing little bit at a time & recall stuff. I will look into the suggested links/resources. Thank you again.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Where do I begin...
    By ETCallHome in forum Access
    Replies: 1
    Last Post: 04-15-2011, 08:07 AM
  2. Begin:/Endit:
    By jgelpi16 in forum Programming
    Replies: 2
    Last Post: 11-15-2010, 02:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums