Search results for query: *

I understand you had a similar situation. Great that you figured it out (and kept your sanity ;-). Yes, with programms like Access you simply never stop learning. That is fun, but sometimes also a bit frustrating. Regards, Manuel.

I've had this problem for years now. It was never a major issue, so I let it be. But now that is is finally resolved it is sort of 'the cream on the pie'. Though it's more important that all the programming works correctly, it is very satisfying to have these details resolved. So thanks again...

RuralGuy, Excellent!! I can even put in exceptions so that the AutoCorrect option does not need to be turned off. I realised that it hat to be a bug, or something simple. But it somehow never came to mind to look at other setting options in Access. Thank you very much! Manuel.

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

Hi PH and AceMan, It works! It works! It works! I have been testing, trying and looking for months (not constantly off course) for this solution. Somehow never been able to find it anywhere on the internet, forum, etc. This is really a great help! Thanks very much! Manuel.

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

Hi PH, Thanks for your reply. I am not sure if I understand you correctly. I only have several comboboxes on the main form to select items. These comboboxes use the ORDER BY clause to order the items. But I cannot see the connection to my problem ... yet. Regards, Manuel.

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

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

Hi Tom, Like you say in other posts that you have answered: you cannot sum controls, but you can (sometimes) sum the expressions. In my case we have: Name textbox: Amount2 Control Source: FieldnameX When I simply sum the expression of the subReport as in =sum([FieldnameX])...

Hi Tom, Your tip does work. With your suggestion I can put the total for a subreport in the footer. But I cannot sum the totals of the subreport. The report nicely sums up the totals of Delivaries and subsequently of the Orders. But is does not sum the totals of subreport (belonging to the...

Thanks for this tip Tom, I still am figuring it out though, 'cause at the moment I still get a syntax error. Regards, Manuel.

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

Sorry, The title of this mail should have been: "Can't make SumProduct to work in VBA". Manuel.

Sorry, The title of this mail should have been: "Can't make SumProduct 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...

Hello Skip and PH, The problem is resolved. Kips, thanks for your offer to help. PH, your suggestion was the solution to the problems. A very logical suggestion. Thanks a lot! Manuel.

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