Search results for query: *

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

I'm sure the problem comes from the long path. I can save the file in a simple folder such as c:\documents and settings\jonath\my documents\file.doc I read that Access can't deal with paths including lots of spaces :-/ I'm looking at http://www.thescripts.com/forum/thread575414.html now...

Hi TheAceman1, I tried your syntax, but it still lead me to the same error. How is "Debug.print" supposed to work ?! Access Help tells me it displays text in the execution window, but I didn't get anything there. Thanks anyway, I'm still open to any suggestion

Hi djayam, thanks for your reply, but using underscores didn't make it. I still have error 5152 "invalid file name", even if I use underscores for every folder name (c:\documents_and_settings\....), which would be very unlikely by the way :-p Jonath.

Hi jrbarnett, I tried your suggestion with strpath: - the msgbox displays the correct folder/file name!! - BUT it won't save the file ("invalid file name") :-/ Thanks anyway, I'm gonna try djayam's idea. Jonath.

Hi, I have a form with a button that allows editing and saving a Word document. However the folder where I want to save the document is quite long and I'm having an error at this line: [code] fichier.activedocument.saveas ("c:\Documents and settings\eric\mes documents\Objectif...