Recent content by sjd

I am curious if there is any major different between using the the two methods. DoCmd.GoToRecord , , acNewRec ... set form control values DoCmd.RunCommand acCmdSaveRecord OR Me.Recordset.AddNew ... set recordset values here (not sure of the syntax) Me.Recordset.Update In particular, I am...

Thank you for the information. In my specific case, I am going to parse the hyperlink from a control on the form itself. See code below. Private Sub button_name_Click() Dim oldFileName, newFileName, newLoc As String Dim msgNoHyperLink, msgNoFile, msgCopy As String Dim LResponse As...

Is it possible in access, to create a button that will copy a file to a new directory? Specifically, the data field in question is an access hyperlink that we can click on to open a PDF drawing of a part. I just want to copy the file the hyperlink points to, into a new directory. EX...

Do you have a sample database? (Or some schema data, what relationships are present) Do you have some sample output? Mostly the last bit is confusing to me, "QVCENT_TASK_HEADER.MODIFIED_DATETIME INTO [1 TASKS COUNT]". I remember when I was trying something complex, an assembly price per...

I've run into that before. According to MS, the join can have different outcomes based on the order in which they are joined. Or, the ON clause is insufficient and should have/be in a where clause instead. Reference: http://office.microsoft.com/en-us/access-help/HV080760616.aspx I'm not sure...

I think you will need to change the first JOIN clause to a LEFT OUTER JOIN. I would copy the query, then try it with the new join and see how it works. It should, show all [a USER ID and Name].[Sterling User ID], and null entries for missing [QVCENT_TASK_HEADER.USER_ID]. You might have to...

I think you need to specify a LEFT OUTER JOIN, instead of an INNER JOIN. A good guide for the joins: http://blog.codinghorror.com/a-visual-explanation-of-sql-joins/ I use that all the time =)

I ended up using the mid function since the date was not always MM/DD/YY -- EX: 1/24/14 was not 01/24/14. There were also some garbled entries, no spaces or malformed dates 01/08/08/14 type entries. I ended up with something like this: UPDATE items SET revision_date = IIF(...

I am trying to split a field that typically contains a revision level and a revision date in a single entry as follows: (Rev Level) {Space} (Date: MM/DD/YY) REL 10-30-14 A 11-20-14 C 11/13/14 Note: dates use either - or / as separators. 99% of the time, there is a space between revision level...

I am not sure how to go about this. I'd like to filter a drop down by Yes/No field in the table. Table: Employee Yes/No Field: IsActive What I am trying to do is allow old jobs to show inactive employees, but only have the drop down list active employees for new entries. Is that possible...

Just wanted to thank you. I had used the page linked above, but was using the incorrect VB reference. The format that finally worked was: Forms!Mainform!Subform1.Form!ControlName

I have form for entering jobs, which has several sub forms within tab controls. One of the sub forms, is an item entry form. This item entry form, has an obsolete check box, and a revision pending check box. What I am trying to do, is change the color of input fields based on which check box...

That makes sense, given the E in the Design, Grouping and Totals, ribbon bar does not show SUM as options for that field, but does for the non-calculated fields. I suppose my question now is, can this sort of report be done? Perhaps with sub-reports or something. (I am not really familiar...

OperationHoursPP does the same thing - asks me to enter the value of the variable; instead of seeing the data in the footer of the group 'below' it. Meaning Group On order is 1)Part # -> 2) Deparment -> 3) Operation.

I am trying to create a fairly complex report that will show a full cost breakdown of making a part. I have it mostly working similar to the text below. Where I get stuck is Department and Part Cost. The Part #, Department, and Operation are "Group By". The Operation group Footer includes...