Cronk,
Thanks for your suggestions, I will try that out. But my project is being on hold now since the company is not making money due the COVID19 pandemic. Plus it is oil/gas industry where oil price is hurting them.
Cheers,
Andy
Cronk,
Thanks for your input. In the subform, I am displaying a datasheet with the rows of the days that they work. If I want to put the employee's name on the subform (Datasheet), I have to figure out a way to display the employee's name only once in the 'datasheet'
Cheers,
Andy
Hi DBguy,
Thanks for your quick response.
I've figured it out now. I assigned the TExtbox1 to the Employee_number when the form loads up (employee number is passed from main menu form). Then when I select the employee from the combobox , it will change the textbox1 value. this way, I get to...
Hi there,
I have a main form with one subform. they are linked together by Employee_Number fields on both forms(LinkMasterField and ChildMasterField). I would like to be able to change the subform's data for another employee number -while I am on that same main form . What is the best way to...
Hi,
Tjhis is my first post (nervous ).
I am Report in Access that runs total of employee's hours for a range of date. The below is a copy of the SQL statement from that report and it works fine with those dates. But when I tried to call the report from another Form (using VBA), it keeps...