Search results

The new table by week didn't quite do the trick. I've decided to build the form with 371 textboxes, populate the calendar based on the start date entered and then colour the calendar based on work, non-work and weekend/holidays. Reading tables from inside VBA is new to me, I found this code...

He's been saving them in both formats so both are available. Both files come in the same format. One header and one detail per line.

I already have a macro to flip the Excel spreadsheet so that it's 2 rows instead of 2 columns. I've added instructions to the macro to format all 121 header fields. This lets me use the Wizard and populate tblClaim with all of the saved claims. I would still appreciate a way around having to...

Situation: My client gets as receipt Excel files with data in 2 columns, 1 headers and 1 detail. I wish to load the detail into 1 Access table. I created a macro to flip the data so that I have 2 rows. The user can easily run this macro and save it before importing the spreadsheet. Problem...

What I have to work with: archives table SIN text - employee number jour date - day worked heure number - number of hours Contains the number of hours worked each day. One day could have multiple entries for an employee. monday table date date This table currently exist...

I have a table with daily entries for employees. I want to display a 12-month calendar and highlight each day that contains an entry in the table. I considered 365 textboxes which is just wrong. I considered 12 subforms. I'm not sure about child forms. I considered inserted an Excel object...

What did you end up with? I'm currently building a yearly calendar to show attendance at a glance. I am starting with 12 calendar controls on the form but would prefer having 2 6-month blocks.