Search results

  1. 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...
  2. 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]...
  3. 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...
  4. 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...
  5. 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...
  6. 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"...
  7. T

    Date range parameter, force results if no dates match

    Hi. I have a query based on 2 tables. Table 1: IDProject; Table2: IDProjectInfo, fkProject, fkTask, TaskDate. Left join on table 1 IDProject. I want to use a date range parameter based on a form with user providing the start and end dates: Between [Forms]![f_Basic]![StartDate] And...
  8. T

    Passing subreport text box value to main report

    Hi. I keep getting errors when I try to pass the value of a text box on a subreport to the main report. (I'll need this value on another subreport.) Main report is: r_Main Control source of subreport is: Report.r_Main_subA Text box on subreport is: TotalCosts Can anyone help? Thanks.
  9. T

    Apply italic to concatenated text string in query

    Hi. I have a concatenated text string that I would like to have part of it in italics, that I can then use that string in a report. String: "First part: " & [FieldA] & ", " & "second part " & [FieldB] Wish: "First part: " & IN ITALICS [FieldA] & ", " & "second part " & [FieldB] END ITALICS I...
  10. T

    Format date+time into m/d/yyyy h:nn AM/PM

    Hi. I need for format a date+time query field into m/d/yyyy h:nn AM/PM. The format of the property sheet does not hold, so I need to code in the format within the query field. I just can't figure out the syntax. Right now, the seconds are included, which I do not want. The present results, with...
  11. T

    Query for single column based on ID and fkID

    Hi. I have 2 tables. Table1 IDProject, ProjectDate (this table has only 1 date per IDProject) Table 2 IDProjectGroup, fkProject, GroupDate (this table has 1 or multiple dates, all relating to the IDProject from table 1, but the date in table 2 is not a duplicate of date from table 1) Wish list...
  12. T

    Automatically change field on main form based on information from subform

    Hi. I have a continuous subform that includes IDNote, DateNote, TimeNote. There may be just 1 note, or there may be many notes. Is there a way to automatically change the IsGroup field on main form when there are 2 or more notes added to the subform? Or is this a separate update query? And...
  13. T

    Criteria in query not working

    Hi. I have a query that I am using to doublecheck and then correct data entry ID IsActual --from table, 0 for no and 1 for yes ActualA --from table ActualB --from table ActualC --from table exp_Actual: IIf([ActualA]>0 Or [ActualB]>0 Or [ActualC]>0,"yes","no") --this is used as part 1 of the...
  14. T

    Dual Criteria for DLookup

    Hi. I'm trying to do a dual criteria, but I either get errors or the wrong person for the DLookup. This part works fine: Expr1: DLookUp("[PersonFullName]","Person","[IDPerson]=" & [fkPerson]) When I try to add in the second criteria, that the fkRole =2 is where I'm stuck. (The fkRole is...
  15. T

    Query results horizontally for single line export to Excel

    Hi. I need to have the query render the results vertically, into a single row for exporting to Excel for mail merge. I've read that I need multiple crosstab queries to do this, but I am not really sure where/how to start. Table: ID, Team, Color, Sport Wish list results: TeamA, TeamAColor...
  16. T

    Link to same field in same table

    How to link to the same field in same table? People table ID, FirstName, LastName 1, Jane, Doe 2, John, Doe 3, Scott, Doe 4, Sue, Doe Family Tie table ID, Family Tie Mother, Father, Wife, Husband, Sister, Brother Jane = Wife of John, Mother of Scott, Mother of Sue John = Husband of Jane...
  17. T

    Subreport totals to main form

    I am trying to have a text box on the main form reference a totals text box from subreport for payments. At times the payments subreport may have no data, but it still shows the subreport and displays a total of $0.00 in those instances (which is what is needed). I am stuck and keep getting...
  18. T

    Make subform visible based on combo box selection; avoid nested IIF with Switch or Select Case

    Hi. #1: I have been trying to figure out how to make a subform visible based on combo box selection on main form. I've tried doing this with both after update event and the on click event with a command button, but I just got error after error. Main form "frmPlants", has combo box...
  19. T

    Don't want combo box to change

    I have a form with a combo box. I don't want the value of the combo box to change as I go to the next form tecord. Is there a way to stop the change? Why: I have a form that I use for data entry for projects. The same project is involved for record after record. When I close the form, then when...
  20. T

    Null on DSum

    Hi. I'm relatively new to Access , I have zero experience with VBA and I am stuck (and have been for days). Summary: I have multiple queries based on a form with the parameters between [StartDate} and [EndDate}, and also [CustomerID]. I have my Payments Query [q_Payments], which is entirely...
Top Bottom