Prefill based on day of the week.

C

cesar.zapata

Hi, I'm recreating a excel workbook to an access Db to track delivery
times...

so, I have this simple db that has date as the primary key and a- table
for line items.

we track trucks coming in these trucks have to make an appoinment
before they come. so we have some companies that deliver to us on
weekly basis say truck NY comes on Mon Wed and Fri and Truck CT comes
Tue and Fri.

what i want to do is when they create a new master record(date), with
vba prefill records in the line itmes with the truck company prefilled.


thanks for all your help.

thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

modify code to just insert Mon-Sat date and day for Given Week End 0
Help to Highlight Excel Row based on Weekly Date Range 2
Automatically update a cell with a date based on anther cells date 2
Automatically Insert Dates For Week Off One Day Entry 7
Day/Date/Week 3
Return Value based on Day of Week 1
Count working days by week 7
Grouping large amount of data by day-of-week 3

Top