Search results

  1. C

    Confused about VBA operation and looking for a solution

    Hi there - I have a datasheet and would like it so that when I select an option from that datasheet in that subform then the subform below is updated to reflect details for that line item. I have the following code: Private Sub Form_Current() Set form2 = Me.Form For Each ctrl In form2...
  2. C

    Referring to a subform from another subform in VBA

    This is driving me potty - a couple of times I have had it where can debug past a line so I think it's working then later throws up an error on same code. I have 3 forms currently When I Select something on the first one I want the bottom subform to update so I have code on on current and...
  3. C

    Run time error on code that was previously running fine

    I am getting When I try and update recordsource on a subform from VBA - it was working fine yesterday and now not working If I use the same SQL and set it manually it works fine on the subform also happens on lines like this Set frm = Me.FrmMonthDeptQuery.Form which worked fine before - the...
  4. C

    Consolidating like data together

    HI there - I have a query as follows: which returns Where the P&L Group is the same I'd like the total to be added together and just show 1 entry so for example C Technology Fees Aff. just show one line with a total of -8,339 + 8015 (-384) and 1 line for C Materials & Services Affiliate...
  5. C

    Calculated Value on Form Query

    Hi there - I understand the basics of doing calculated values on a form but a bit stuck on this more complex case This is an example of the underlying query Which generates I then have this on an underlying subform I want to have a field on here which is Profit which is Sales minus Cost of...
  6. C

    Can I update a query based on the tab that is selected

    Hi Access gurus, I have in my access database a Forecast table that has figures for forceasts for February through December. I have included the sums Feb through May below: I have a form with a tab for each month I would like it so that if the February tab is selected then it return the...
  7. C

    Updating a subform based on selection in another subform

    Hi there, I have a form with a couple of subforms which are based on queries. I would ilke to swap round the bottom two subforms and have it where I click on a PL group and the other section then just shows any data filtered by the Account Number. I can do it with adding a drop down but I...
  8. C

    Just joined

    Hello, Am involved in some Access Development with our Finance Team. I haven't done any access for a number of years (over 5 years). I do some VBA in Excel and have done a few databases at University and at previous companies. Hopefully can get some help where I get stuck - I make use of...
Top Bottom