how to build this???

[engmsosman]

everyday there's 10 items and thier scores .. so it should be like this ((12 jan===> item1=50% item2=66% item3=80% .. etc)) .. i need somehow to open the days table to find that item column is already filled with the 10 items (or whatever written in the items table) and wait me to enter thier score .. it that possible???

 

[Insane_ai]

Write a macro in the database to open a form filtered to the date you want. Use a batch file to run the macro through a scheduled task. The syntax for the batch file command is: "[Drive]:\[Path]\[database]" /x [MacroName]
Example: "C:\Scripts\DailyInfo.accdb" /x Run_Daily_Reports"

 

[engmsosman]

Write a macro in the database to open a form filtered to the date you want. Use a batch file to run the macro through a scheduled task. The syntax for the batch file command is: "[Drive]:\[Path]\[database]" /x [MacroName]
Example: "C:\Scripts\DailyInfo.accdb" /x Run_Daily_Reports"

thanks for reply .. i made something based on you idea .. it's a code fill the data after selecting the current date .. look at this..

Private Sub frm_date_AfterUpdate()

Set db = CurrentDb
Set rs = db.OpenRecordset("SELECT * FROM item_details ;")
rs.AddNew
rs.Fields("daydate") = frm_date.Value
rs.Fields("item") = "item1"
rs.Update
rs.AddNew
rs.Fields("item") = "item2"
rs.Update
rs.AddNew
... etc to item10!! ..

that works! .. but is there a way to make a dynamic loop for each item in the item table? instead of copy/paste those 3 lines 10 times! .. what if the items grow to 1000000 or somehow?!