Empty table records in a form

[olorin_117]

Hello. I have a complicated question to make so I ll try to make it as detailed as possilble. I am currently using a bunch of different excel files, each one for a different product. Each product has it's own excel that I take daily measurements. Each product may have 30 or 40 rows of data any day that I am "using it". For example today i am working with product A and taking 40 measurements, tomorrow on a different product etc etc. As of now I have managed to make a pseudo-form in excel and at the end of each day, the data is sent to a single table in access that works as a data collection file. In this table there are all the products, all the measurements I ve taken..
I want to know if there is a way to make a form in access that each day "projects" empty rows of previously said table, that I can store data there. I ve searched the internet but I think I am not using the correct terms. Semi-experienced with access (basic knowledge)..

I don't want the method, only if it is do-able and worth the time and effort. I was thinking to a) make a table with autonumbering each day the database is used to store records, that then connects (one to many) with the table I mentioned so b) each day in the form I could show the table but i don't know how to so only empty records (? - don't know if I am at the right path).

 

[Micron]

Not sure what you're asking. By the sounds of that, your table setup resembles spreadsheets and that would be no good for relational database tables. You have 1 table for products which is good, but probably should have a table for all measurements and then a junction table for the measurements/products mix. You might want to research 'ms access junction tables' or similar. Maybe db normalization too.

 

[welshgasman]

I think by "project" you mean create empty records, ready for populating?
Not a good idea IMO.

 

[jackd]

Since readers are guessing what your set up and requirement means in context, I recommend you create a graphic showing your "process(es)" to clarify communications.
The more detail and clarity the quicker you'll get focused responses.

Are you trying to create a database?
Is your primary working environment Excel

 

[olorin_117]

I think by "project" you mean create empty records, ready for populating?
Not a good idea IMO.

Shouldn't have used the work "projects" because i meant "shows"

 

[olorin_117]

Since readers are guessing what your set up and requirement means in context, I recommend you create a graphic showing your "process(es)" to clarify communications.
The more detail and clarity the quicker you'll get focused responses.

Are you trying to create a database?
Is your primary working environment Excel

Measurement Count	Time	Measurement
1st	10:11	5
2nd	10:45	6
3rd	11:01	4
4th	11:30	5

My excel data table has this format with 2 more cells that have the date and the product name that aren't repeated. I have managed to send all the data to a separete sheet (that copys the table and then loops each empty cell on a "date" and "product" column and puts the respected data on them, in order to have the same format as the access table and then append them there via a macro. I wanted to know if the excel data can be made into an access form (maybe) in order to eliminate the use of an excel file

 

[Micron]

Hard for me to visualize all of that, but if a sheet has be created to resemble a db table, then why not link to that sheet in Access? It will automatically update and you can create whatever form or report that you need, same as if it were any local db table.