Search results

Hi. I am trying to pass the openargs to a report On Open (or on load event, I don't know which would be preferred). I have the code figured out (with prior help of Access World Forums) for the on click event of the form for openargs. Now, I've been trying to figure out the On Open/On Load code...

Hi. I would like to select a specific form or report, based on a combo box and then have that form or report opened on a click event. I have a FormName table that lists forms and reports for that a user can do data entry or view the form/report. I have a FormMain that has cboFormName combo...

Hi. I have a form which opens in edit mode. The form has a textbox fkDetails. I want to add a new record, and copy the fkDetails value (number) to the new record via macro or vba tied to a button. The prior record from which I am copying may or may not be the last record in the table. Any...

My ultimate goal is to reach a point where I can do an append query based on the results of the query. Tables invovled FileNameTbl: IDFileName, FileName 1 BackgroundTextureRoughBlack 2 YellowSmoothTextureAbstract FileNameSnipetsTbl: IDSnipet, Snipet 1 Black 2 Rough 3 Smooth 4 Yellow 5 Texture...

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