Search results

Hello Bob, Thank you very much for your response! It is an encouraging thing to come back to after my vacation. Currently, the main form has: Record Source: Lbr_TS_Tbl The Subform has: Source Object: Table.Lbr_TS_Dtl Link Master Fields: [Forms]![Lbr_Ts_Tbl_Form]![Lbr_TS_ID_FormLink] Link Child...

After dealing with this issue for a number of weeks I have narrowed it down a little bit. -This error generally only occurs when you sort the subform table. -When the error occurs it only affects the file that you are currently using. -If you delete the linked tables and re-link them, the...

Hello Paul0, You are correct, the field that is not populating is the field that links the subform datasheet records to the parent table's records. Therefore, you can click through the Parent records on the main form (which are the different days that the crews worked) and it automatically...

Hello All, DB Background: I have created a cost tracking database that uses timesheet entries to track hours and costs for different tasks. I have a Lbr_ts_tbl that has a field for the date the work was completed. the Lbr_ts_tbl has an autonumber primary key named Lbr_ts_id. I also...

Thanks jdraw! I will try those out! canuck_1

Hello, I need to find a way to use normal symmetric rounding (always rounds .5 up) instead of the Bankers Rounding that access defaults to when using the round() function. My end goal is to have a query/report with 3 columns; one column for Reg_Hrs*Reg_Rate, one for OT_Hrs*OT_Rate, and a grand...

Hello Everyone, I was born and raised in Alberta, Canada and I enjoy hiking, fishing, cycling, and numerous other sports. Basically anything that takes advantage of the beautiful mountains and foothills that comprise the western border of the province. I am fairly new to Access (approx 4...