Search results

Hi All. I'm stuck on how to find gaps in records. (I know there have been other threads on this topic, but I am just not getting it, sorry.) I really don't want to have to manually go line by line to find any gaps. In my table I have a BegNumb and EndNumb. I have done a query to calculate the...

One of by DB's is doing the following: in a form or table, sometimes when I am adding records in a short text field, the cursor is not acting normal. If I change part of the text in the field, the cursor jumps around, and letters that I am not trying to delete get deleted or moved to a new place...

Hi. I need to pass the IDOrder from the frmOrder to a new form frmOrderDetails, connected with foreign key fkOrder. Typically, frmOrderDetails will be used for adding new records. So I am confused as to what the code should be for both the command button on frmOrder and the On Loan event code...

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