Search results

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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