Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Manuel10
  • Content: Threads
  • Order by date
  1. Manuel10

    IJ is converted into Ij

    Hello, I have table column for normal textfields. For some unknown reason to me Access changes words that starts with the capitals IJ into Ij. For example: the dutch word IJsbergla becomes Ijsbersla. Other capitalcombinations like RObot or BEker are not converted. Why does this only happen to...
  2. Manuel10

    Restricted application of Setfocus method?

    Hi, I notice that the SetFocus method only works when referring to a subform. Referring to a control in a subform, or to a subsubform (which is seen as a control in a subform), or to a control in a subsubform, etc. just isn't working. So, Me![Subform].SetFocus - Works! But...
  3. Manuel10

    First record has become last record?

    Hi, I have a form with a subform and a subsubform. In both subforms I encounter the strange behaviour that the form starts with showing the second record in the list. When going to the last (key)record, the subform ends up showing the first record. The keyrecords are counted as 1,2,3 etc. There...
  4. Manuel10

    Keeping footer together with last section line?

    Hello, I have a section that does not need to (and sometimes even cannot) be kept together on the same page. In the footer of this section there is a total. Sometimes (when printing) this total is shown as the first line of the next page. This ain't nice. So I would like to keep this footer...
  5. Manuel10

    Adding totals of subreport to a group sum

    Hello, - I have a report based on a query. - The report contains two grouplevels based on [Order_Id] and [Delivary_Id]. - The Delivary_Id group contains a.o. the field [Amount] - In the footer of grouplevel Order_Id a total is given of all records of [Amount] that belong to a specific order...
  6. Manuel10

    Can't make Dsum to work in VBA

    Hello, I found very helpsome tips by searching in this forum and came across the use of Excel functions like Dsum and SumProduct for applying multiple conditions. However I can't get these functions to work (properly) in VBA. In the example code the syntax of the code between the brackets after...
  7. Manuel10

    Worksheetfunction does not function with object

    Hello, It seems to me that Worksheetsfunctions don't function at all when applied to an other excel object. For example, while Excel_Object.Workbooks(Bestandsnaam).Worksheets("Blad1").Range("J2:J10").Address works properly, the next code...

Part and Inventory Search

Back
Top