Search results

  1. K

    Coding to automate 2016 outlook

    Hi, I had a command shown below which was working fine but upgraded to 2016 outlook and Access and now outlook opens but doesn't open a new email and does not send. I was wondering if anyone has any suggestions what the issue is? Private Sub Command108_Click() Dim myDefPrt As String 'get...
  2. K

    Stop a subform unbound textbox adding value to whole column

    Hi, I`m quite new to access. I am using access 2003. I have a subform normally set to datasheet view based on a table and a query and I would like to be able to manually enter values into one of the fields (different values for each record). Leaving the subform the way it is I cannot enter...
  3. K

    Expand / Collapse a subform record

    Hi, I am relatively new to Access. I am using Access 2003. My problem is that I have a form (form1) with a subform (sub1) and located in that subform is another subform (sub2). When I open a record in form1 the fields in sub2 which rely on info from sub1 displays #Error. The #Error...
  4. K

    Sum a calculated field in a subform

    Hi, I am relatively new to access. I am using Access 2003. My problem is that I have a customer invoice form (which works fine). It calculates the invoice total from a subform (based on a query) which has individual calculated job prices on it (multiple job prices on any invoice). What I now...
  5. K

    Subform Issues

    Hi, I am using Access 2003. I have a main form with a subform1 on it. The subform1 has a subform2 on it. My first issue is that when I open the main form in subform1 the calculated fields show #Error. When I maximise and then minimise subform2 the calculations take place and totals are...
Top Bottom