Search:

Type: Posts; User: James Pilcher; Keyword(s):

Search: Search took 0.01 seconds.

  1. Another VBA solution

    The only other solution I can think of at this point is to dump the entire contents of the report's RecordSource into a temporary table. Open a properly-sorted Recordset against the table. Run code...
  2. Replies
    9
    Views
    406

    A permanent "temporary table"

    Hi AccessNovice,

    Do not delete the temporary table at the end of the session. Reason? Any indexes you've created go away along with the table. You will have to recreate the indexes each time you...
  3. Solve it with VBA

    I might be able to help with a bit of VBA. If you are printing or doing a PrintPreview, here are the steps I see:

    Define a module-level variable in the report. Put this line at the top of the...
  4. Replies
    2
    Views
    266

    Check the property sheet

    Make sure you have defined 11 columns on the combo box property sheet. If you have defined fewer than 11, Access and the combo box will not see all of the query columns and you cannot address them....
  5. Replies
    5
    Views
    904

    It is doing what you ask

    Forgive me for pointing it out, but in your example you have asked it to Count, not Add. Use DSum(). I hope this solves your problem. :)
  6. Lots of formatting

    I'm not sure what you are up to, but try these things:

    -----------------
    Make sure all text boxes fit right next to each other in the detail section; no empty space anywhere across the width.
    ...
  7. Replies
    5
    Views
    904

    A clean solution

    Here is a clean solution for your DCount:

    =DCount("*","tblValuations","([CreateValuation] Between [reportdate] and [reportdate2]) AND [SalesID] = " & [Reports]![tblSalesman2]![SalesID].Value)

    I...
  8. Some thoughts using limited information

    First off, you do not need to call a function to establish sTopic as a public string variable. Just put this line at the top of any Access VBA module:

    Public sTopic as String

    That takes care of...
  9. Replies
    4
    Views
    860

    linked table/query limitations

    If you are trying to establish a relation between two tables in the back end database, yes, that should always be done in the back end file. I can think of no reason to do it in the frontend. If you...
  10. Replies
    2
    Views
    537

    Two more variations

    Or how about this: DCount("*","tblValuations","[SalesID]=" & Me.SalesID.Value & " AND DateValue([CreateValuation])=Date()")

    I'm assuming SalesID is a numeric value. I use DateValue() to strip away...
  11. Replies
    2
    Views
    555

    The last what?

    Becareful with DLast() and DFirst().

    You want the last record based on what kind of a sort? Sort the domain one way and "last" might be different than when you sort the domain another way. I...
  12. You need to put the control with the SUM in the...

    You need to put the control with the SUM in the subform, possibly hidden (or visible) in a section footer. Then, in the main form, you just refer to the control as Wendell mentioned. You cannot SUM...
  13. You are undoubtedly opening your report in a...

    You are undoubtedly opening your report in a screen-oriented Report View or Layout View, rather than the long-time standard Print Preview. Format events fire only when Access is preparing send output...
  14. Replies
    5
    Views
    539

    Hi Browni, Your SQL statement will return a...

    Hi Browni,

    Your SQL statement will return a list of contacts that have contributed over $999 at least once. It does not return a list of contacts that always contribute over $999. Forgive me if I...
  15. Replies
    5
    Views
    539

    Contributors

    Seeing how you want to know how many contributors ALWAYS contribute at least $1000, try this:

    SELECT [ContactID], Min([Contribution]) AS MinC FROM [Contributions]
    GROUP BY [ContactID] HAVING...
Results 1 to 15 of 15