Results 1 to 5 of 5
  1. #1
    kp123 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2011
    Posts
    33

    Unhappy Access without coding

    I was taught some of the basics of Access about 3 years ago.
    This was fairly top-level.

    I am now resuming my work with Access and am largely self-teaching myself, alongside a 'Dummies Guide' and regular trawling of the internet.

    What I wanted to ask was others' views on whether it is possible to be a regular Access user without the detailed knowledge of VBA and coding!


    Can I 'get by' without?

    That aspect scares me somewhat - not sure I'd know where to start!

    Interested to hear your views...

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Can you get by? Sure, but I don't think you'll be able to create anything really polished or that does anything particularly complex. Macros are an option, though not a great one in my opinion.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    boywonder is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    Dec 2010
    Location
    Memphis, TN
    Posts
    60
    Yeah, I wouldn't use macro either. I've known some instructors at school with a bachelor degree and teaching MS Access and other IT classes with no experience, but passed the MS certifications. FIGURES... To me, if you want to be an Access Developer, learn coding of Access.

  4. #4
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    Don't be put off by VBA.

    Access has a lot of flexibility and there are lots of problems that can be solved with plain vanilla Access. Macros can add a great deal to what you can do.
    I use VBA but 90% of the time I'm just using it to either hide or reveal a control, or transfer the value of a control to some other control. Those uses demand very little knowledge VBA. The knowledge part of the equation is knowing when to use the event properties of the forms and controls e.g.
    [mycontrol].visible = false
    or
    [mycontrol1] = [mycontrol2]
    In fact, a lot of the VBA that I code could be done with macros or the expression builder. It's just that I'm totally comfortable with VBA.
    Many users get into trouble using VBA instead of properly constructed queries and normalized tables.At least you wouldn't be challenged by that.

  5. #5
    boywonder is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    Dec 2010
    Location
    Memphis, TN
    Posts
    60
    I got hired to re-develop an Access app. The reason is that it keeps generating errors over and over again and would skip over macros without letting the user know a problem occurred. This app has over 1,000 of Access macros. The only thing I would use a macro for is the menu items. We learn this back in the middle of the 90's that macros generate errors and I started getting contracts to convert all macros to VBA. This company didn't hear the news.

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

Similar Threads

  1. Complex Coding --> Please Help
    By JFo in forum Programming
    Replies: 231
    Last Post: 11-03-2011, 01:20 AM
  2. Access to Excel (2003 version) VBA coding help
    By iamstupid in forum Programming
    Replies: 1
    Last Post: 05-26-2011, 09:53 AM
  3. VB coding to show current date n time in access form
    By cwwaicw311 in forum Programming
    Replies: 6
    Last Post: 02-10-2010, 09:53 PM
  4. Bar-Coding
    By texasprincess7 in forum Access
    Replies: 1
    Last Post: 02-12-2009, 10:29 AM
  5. parsing data in access (coding?)
    By banker247 in forum Programming
    Replies: 0
    Last Post: 01-13-2009, 12:05 PM

Tags for this 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
  •  
Other Forums: Microsoft Office Forums