Forms and tables

[caphillips]

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.

[caphillips]

John I hope you track this because you seem to know what I am trying to do.

[June7]

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.

[caphillips]

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.

[June7]

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.