Recent content by Jonath

Hi andzejek, try on the Click event: Me.text45.selstart=0

Me.filteron = false ?

I don't think so, cf. here: http://office.microsoft.com/en-us/access/HA100307391033.aspx they say maximum form width is 55,87 cm. Maybe there's some possible work around, but I'm no expert :-p Jonath.

Hi addy, I'm not sure if this is relevant, but you may have a look at Height and Width (and/or Insideheight) properties of your forms. In access2007 help they give this procedure to resize a form; you could use it on dblclick event for instance; I put it here for info: Sub...

Hi, I have a form with an unbound textbox, and would like to change its defaultvalue when its text is modified. I tried, on lostfocus and afterupdate events: -textbox.defaultvalue = textbox.text -textbox.defaultvalue = """" & textbox.text & """" but when I close and re-open the form...

Yes, I tried that code, and got an error too. I am not very interested in re-installin Outlook, do you think it would work if I just copy MSOUTL.OLB on my C: ? Thanks.

Additional info: There is no MSOUTL.OLB file in c:\program files\microsoft office\office12 .. (I have MSWORD.OLB, MSPPT.OLB, and XL5FR.OLB though...)

Hi Remou, yes I DID look for that reference!! It's not there :-/ Starting with "Microsoft O..." I only have: Microsoft Office ... Microsoft OLAP Microsoft OLE Starting with "O..", I only have: OLE DB Errors OLEPRN optshold ...

Hi, I'm working with ACCESS2007 on Windows XP and made a form to let the user send an email via OUTLOOK, thanks to FAQ702-2921. However, I can't find the reference specified in the Emailing posts, which is a reference to Microsoft Outlook. I tried with references to Microsoft Office, some...

Ye I tried that already, but it didn't work. Anyway, thanks for your answer, I make it work like this: dim number dim zeros dim breaker dim k zeros="" breaker=0 for k=1 to 9 if mid(mid(Dmax("[NUMBER]","ENQUETEURS","[NUMBER] between 'A000000000' and 'A999999999'"),2,9),k,1)=0 and breaker = 0...

Greetings, I have a Table "ENQUETEURS" with a field "NUMBER"(primary key) Format of this field is ?######### where ? is A for french people B for the rest of europe C for the rest of the world and # is the number (000000001, 00000002....etc) I have a form with a control...

Thanks for answering, but I solved the problem The form was actually bound to 2 tables with a common field, and I didn't update the second table :-p

Hi, I have a table named 'ENQUETEURS' and a form 'ENQUETE' with bound controls to edit/add records in the table. Initially I had 1224 records on the table, and the form showed...1224 records BUT I copied/pasted an updated version of the table with 1297 records, and the form still shows 1224...

Oh my...! The folder where I want to save the files must be CREATED MANUALLY before using ACCESS !!!! I can't believe I didn't try that sooner :) Thanks all for your help

Examples of the fields: Name1: Name2: STINGRE WILLIAM PROHET NATHALIE MARQUET ESTELLE I don't think there is any problem with the fields; they are just names with capital letters and no "forbidden" characters. I can...