Recent content by TechGuy

  1. T

    load new set of data into subform dynamically?

    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
  2. T

    load new set of data into subform dynamically?

    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
  3. T

    load new set of data into subform dynamically?

    Thanks Doc. That works like a charm. Cheers, Andy
  4. T

    load new set of data into subform dynamically?

    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...
  5. T

    load new set of data into subform dynamically?

    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...
  6. T

    Can you use VBA to pass parameter as criteria for Report with Grouping/Aggregation in MS Access?

    yes. good catch. I am testing out a small timesheet database. I will definitely work on normalization when I get to build it. Cheers.
  7. T

    Can you use VBA to pass parameter as criteria for Report with Grouping/Aggregation in MS Access?

    oh sorry. it is prompting for Date_Worked field. see attachment
  8. T

    Can you use VBA to pass parameter as criteria for Report with Grouping/Aggregation in MS Access?

    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...
Top Bottom