Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20
  1. #16
    caphillips is offline Novice
    Windows 8 Access 2013
    Join Date
    Aug 2014
    Posts
    13

    That's exactly what I want john but as you said my arrangement isn't right and I am not experienced with vba yet. I am currently in the process of self-teaching myself. I need a little help/guidance. I need the data base to keep all data for every record and every field. I work for the government in transportation and this is what we are attempting to do so we can get away from excel.. The only thing that need new data every month is fuel, days, trips, mileage, month, and if you want to get technical year which only changes every 365 days but for this database I want it to be entered every time data is entered. originally wanted the year to stay the same with every new update but I am new at this and it was taking to much time to try and fix it and I had no one to get guidance/help from. Luckily I found this site and am praying you guys can help. If this site helps me fix this database it as well as me will get all the credit. Maybe someday I will be in a position to help some new.

  2. #17
    caphillips is offline Novice
    Windows 8 Access 2013
    Join Date
    Aug 2014
    Posts
    13
    John I hope you track this because you seem to know what I am trying to do.

  3. #18
    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
    If you want to keep historical data, that means creating new records each month. You say you don't want to manually select every tag number but want a set of blank records each month with all the tag numbers and then just enter other data. That can be done but requires code. Something like:

    CurrentDb.Execute "INSERT INTO MonthlyTable(TagNum, DateEnter) SELECT TagNum, Date() AS DateEnter FROM VehiclesTable;"

    You are a long way from understanding how to program automation into your db. First step is to get data structure correct. Maybe this site will help http://www.rogersaccesslibrary.com/. There are many other sources such as books and classes. You need to understand relational database principles, Access functionality, programming concepts, VBA and/or macro coding.
    Last edited by June7; 08-12-2014 at 02:25 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.

  4. #19
    caphillips is offline Novice
    Windows 8 Access 2013
    Join Date
    Aug 2014
    Posts
    13
    You are right june7 I am but to certify you don't have to I am in the process of learning but have not yet that Is my winter project to learn basic programing with VBS. Was trying to get around it with this database but knew it probably wouldn't happen. Since you didn't have to know to be certified I assumed that a database(all) could be built with or without programming.

    I understand some of the code but don't. That means for all four of my tables I would have to enter a specific string of code which is fine but don't know were to begin. do I go to the SQL or do I go under each specific table and enter it in under the VBA.

  5. #20
    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
    A database can be built without a speck of code (VBA or macro), I have one. But you asked for automation that needs code. The more user-friendly, the more code.

    Tables can't have VBA code.

    I don't know your db so can't address the question of whether or not you need code that does something with all four tables.
    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.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Using Tables and Forms
    By Menglish in forum Database Design
    Replies: 2
    Last Post: 06-05-2013, 04:09 PM
  2. Forms and Tables
    By Tiffy in forum Database Design
    Replies: 3
    Last Post: 02-10-2012, 05:27 PM
  3. Replies: 10
    Last Post: 07-12-2011, 11:09 PM
  4. forms and tables
    By Roberta in forum Access
    Replies: 2
    Last Post: 09-02-2010, 02:48 AM
  5. Forms and tables
    By phoenix in forum Access
    Replies: 1
    Last Post: 03-03-2010, 04:52 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