Results 1 to 3 of 3
  1. #1
    jassie is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jan 2012
    Posts
    40

    Access 2013 table accesses

    I would like to know what you think the preferred method would be to replace vb code with the same processing in Access 2013 since I am new to working with Access. Basically in Access there are queries, forms, macros, reports, and modules. I basically would like to know what Access feature(s) you would use to replace the same function that is in visual basic.
    Here are the list of features I would like to replace:
    1. List all values in a table,
    2. find a particular value in a table,
    3. Insert, update,edit, or delete rows in a table.
    4. Import data files,
    5. Delete all rows in a specified table,


    6. Run the application to update all the applicable tables.
    7. Change a date in a certain table.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Are you talking about VB6 or VB.Net code?

    1. open table/query or bind form to table/query
    2. search/filter table/query or form/report
    3. action query objects or SQL actions in VBA
    4. Import/export wizard is one method
    5. action query objects or SQL actions in VBA
    6. update from where?
    7. action query objects or SQL actions in VBA
    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
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    You don't need code
    All can be done with queries and macros.

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

Similar Threads

  1. Export From Access 2013 To Excel 2013
    By Esmatullaharifi in forum Programming
    Replies: 8
    Last Post: 04-17-2015, 09:40 PM
  2. How to import a dBASE table in Access 2013
    By Jocoel in forum Import/Export Data
    Replies: 3
    Last Post: 11-05-2014, 07:08 PM
  3. Replies: 7
    Last Post: 03-27-2014, 11:47 AM
  4. Replies: 11
    Last Post: 12-17-2013, 03:07 PM
  5. Replies: 3
    Last Post: 11-04-2013, 07:40 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