Recent content by TB11

  1. T

    Combo box on new (next) form not updating

    Sorry. Page =1 Record 1, New Page = Add new record
  2. T

    Combo box on new (next) form not updating

    I have two combo boxes on a form. The first combo box sets the parameter for the second combo box selection. It works perfect on page 1 of the form. The problem: when I go to a new form the second combo box does not update and does not show the values it should - it is stuck on the values from...
  3. T

    Using Totals Query for next query to show further values that were not included in totals query (like note field)

    @Pat Hartman and @arnelgp Thank you, I have been tying to figure this out for awhile. You both got me thinking on a different approach, and I solved it. The answer, should anyone else have the same issue: the first query is the aggregate query. The second, sub-query, is based on the totals...
  4. T

    Using Totals Query for next query to show further values that were not included in totals query (like note field)

    @Pat Hartman I want both the aggregate query to get the last date for a project task, then a details query to show the details, like the note field, of that last project task. @arnelgp That's where I am stuck. I have tried several different sub-queries, but each has given me more entries than...
  5. T

    Using Totals Query for next query to show further values that were not included in totals query (like note field)

    Hi. I'm stuck. My table: IDProjectTask fkProject fkTask This involves just 6 different tasks. DateTask TimeTask fkTaskStatus TaskNote My totals query, to give me the latest DateTimeTask for each fkTask. fkTask - grouped by DateTimeTask - Max. Formula is [as I added DateTask + TimeTask]...
  6. T

    SQL Where clause based on combo box on form

    @theDBguy I would like the WHERE to be on the outer query.
  7. T

    SQL Where clause based on combo box on form

    Hi. I keep getting errors on the Where clause for a SQL query, to get the max date of the InvDate and grouped on Status field. The form name is fTest, the combo box on the form is named cboCompany. The where from a (different) select query is WHERE...
  8. T

    Rename (and move) files based on MS Access table with VBA

    Further note: While the debugger stopped at OldPathName As NewPathName, it did rename and move 1 of the 27 files before I got the error Run-time error 53, file not found.
  9. T

    Rename (and move) files based on MS Access table with VBA

    @LarryE I'm trying to use the Name function to rename those files in a file folder on my computer, and move them to a new folder on my computer using the fields from MS Access table. I tried your suggestion, and it did not work.
  10. T

    Rename (and move) files based on MS Access table with VBA

    Hi. I have a table with a field for the temporary file name, which includes the original (temporary) folder path, the name of the document and the file extension (TempPicturePathName) and another field with the new folder path and new name (FinalPicturePathName; the final folder path is...
  11. T

    Query to get value of number of occurrence

    @bob fitz THANK YOU! Exactly what I needed.
  12. T

    Query to get value of number of occurrence

    @theDBguy there should not be duplicate dates
  13. T

    Query to get value of number of occurrence

    Is there a way to create an expression that will assign a sequential value based on the sorted date? So, if it is the first date, the value =1, and if it is the fifth date, the value =5. the twentieth date =20, and so on. Query, sorted in ascendign order on date field: IDProject, ProjectDate...
  14. T

    VBA based on DLookup query, and use DLookup result to open form

    Hi. I'm trying to open a form based on a DLookup value from a query. The results from the DLlookup will be either a 1 or 0. I would like to open the form only if the DLookup = 1 I'm struck on the where condition. Private Sub OpenUnbilled_Click() Dim tmp As String tmp = DLookUp("IsUnbilled"...
  15. T

    Date range parameter, force results if no dates match

    @plog @Pat Hartman Thanks. I will try the count approach and see if I cant do a work around in query #2. Thanks.
Top Bottom