Search results for query: *

Hi Paul, My info is set up as follows: the report has a group header and footer. In the group footer there's a subform. What would be realy nice to do is let this report print only 8 detail records, and only 8 related records in the footer. I had already tried placing the pagebreak in the...

Hi Paul, Thank you very much, this works perfect. And for now I can get away with this report's layout. But, (there's always a but..) for the convenience of explaining the problem I didn't mention I want the page 'to be broken' after printing the Footer of the first group. How would you do...

Hi, Can anyone please help me on the following: I'd like to force a pagebreak on a report after for instance 10 records haven been displayed. How would I do that? Thanx in advance, Reinier

Hi TidyTrax, I'm not sure if I understood the question, because the way you put it the answer is to obvious. nevertheless: Syntax UBound(arrayname[, dimension]) example Upper = UBound(MyArray, 1)

Hm, found it myself, it was just a typo

Hi, I found part of the solution at Microsoft Knowledge Base Article - 191754, but I get the message:"the workgroup file is missing or opened exclusively by another user." Currently absolutely no one is in it, so how can this be? Gr, Reinier

Hi all, Can anyone help with setting op an ado-connection from an excel spreadsheet to a secured access db? The db is secured so the user needs to be joined with the security workgroupfile, but how is this done through ado? Greetz, Reinier

Hi RickSpr, Uhh, was meant as a joke. Mean't to say: use vba to force Microsoft to publish its API's as a reaction to Billpower. Sorry, if my humor is a bit dull.

Hi Billpower and RickSpr, Thank you both for your response. Decided I won't use this because the db is split and secured. I will just let it bounce on a general err.description, or otherwise do have to force Microsoft myself. Since this is a forum: can anyone tell me how this can be done in...

Hi, I'd like to know how to check if a table is in use by another user or process. I've searched the forums but couldn't really find what I needed. Anyone with a suggestion or references to 'how to' articles please help. Gr, Reinier

Ok, leave it, already found it

Hi all, I'm trying to append rows to a table, but can't get it right. After confirming to update, I get the message access cannot append due to key violations. How is this possible if there are no key fields in the table to append to? (I removed the keys to test this) Any help would be...

Well, sorry I don't have a complete solution, just a suggestion. Maybe you could use the CreateControl method in a loop. This way you can easily set the properties of the controls, especially their names and the on_lost_focus event, which you set to your 'Stock Value SubTotals'-function. Think...

Hi, As far as I know there is no control collection in vba. You can try something like: dim c as control dim i as long dim strName as string strName="myName" for i = 0 to 100 strName=strname & cstr(i) set c=me.controls(strName) etc...

Hi, code seems fine to me. What else is named Month? Perhaps a field in the table the form is bound to? Just gessing here.

Thanks. Nothing wrong with the code indeed. Used the right handles, but forgot to pass them though, my mistake. How to reward you?

Yep. r.tienkamp@sfl.nl I haven't got Visual Studio or VB installed, not even in the Office Developer Edition. But I've found the SDK and the function. Till now this is what i'm playiong around with: Option Compare Database Option Explicit Declare Function GetWindowRect Lib "user32&quot...

Aha, thanx for that. I'm not that familiar with using the Windows API, but I'll give it a go. I'll have some reading to do first, I suppose :)

Hi, a very simple question I assume, but can't find the answer. In access forms don't have a property left or top. Is there another way to get the forms position? Gr, Reinier

The thing is I wasn't sure witch event I wanted to fire the append query and if I wanted to use a temorary table. I do now use just a bound form and an append query fired by the afterupdate-event of the form. works fine till now. Thanx for the remark anyway.