Search results

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

Thank you, that worked out perfectly.

Sorry for the delay, been rather busy of late. The example is a very small sample of data, but I think it explains it well enough. In reality, we have about 30,000 entries over the last 10 years or so. So using the actual data there should be ~ 10 rows each county being ~200-400 job numbers...

Is it possible to do a count of items (in this case jobs) per month, over the course of several years. (Months going horizontally, years going vertically). So that looking down the column(s), lets you quickly see if there is a trend in one month typically being slow -- or overloaded compared...

I am trying to find any Applicator for a given Terminal in our database. Typically, this information is in the Item Master table, however I have come across a few entries that only have the correct information in the Die table. The original query listed: Item -- the item number Drawing --...

Thank you, I was mostly concerned since I have been using them for other fields -- like Employee ID (used for lookup / data entry). Which skipping a number here and there isn't an issue. Similarly, for department codes, operation codes, etc. -- none of which would have a real problem with...