hellow everyone !!!! (^__________^)
plzz help me to my problem i have my ms access and ms excel which is connected each other
=> now in my ms access have a table name (tblMonth) has columns (year,MonthNum,StartDate,EndDate)
HERE: sample in january(1) and feb(2)
Year MonthNum StartDate EndDate
2014 1 30/12/2013 05/01/2014
2014 1 06/01/2014 12/01/2014
2014 1 13/01/2014 19/01/2014
2014 1 20/01/2014 26/01/2014
2014 1 27/01/2014 02/02/2014
2014 2 03/02/2014 09/02/2014
2014 2 10/02/2014 16/02/2014
2014 2 17/02/2014 23/02/2014
2014 2 24/02/2014 02/03/2014
=> and for my ms excel has its columns (year,month,date) in this if i input the date that is base in the database range from StartDate TO its EndDate
will automatically put the month and year which base also in my database (year,MonthNum)
HERE:
A1 B1 C1
Year Month Date
A2=2014 B2=January C2=01/01/2014
(THIS PROJECT WILL USE VBA PROGRAMMING )
==> how can i do this ? plzzz i'm begging you guyz help me,... (^_______^)
THANKS IN ADVANCE (^_____^) I REALLY LOVE U ALL
Bookmarks