Recent content by TB11

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

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

@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...

@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...

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]...

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

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

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.

@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.

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

@bob fitz THANK YOU! Exactly what I needed.

@theDBguy there should not be duplicate dates

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

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"...

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