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!

Recent content by Jonath

  1. Jonath

    textbox.selstart

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

    Remove Filter

    Me.filteron = false ?
  3. Jonath

    Form Width?

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

    Forms resizing in Access 2007

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

    Defaultvalue of unbound textbox

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

    Reference to Outlook in ACCESS2007 ??

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

    Reference to Outlook in ACCESS2007 ??

    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...)
  8. Jonath

    Reference to Outlook in ACCESS2007 ??

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

    Reference to Outlook in ACCESS2007 ??

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

    How to prevent Zeros auto-deletion ?!

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

    How to prevent Zeros auto-deletion ?!

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

    How to update a form related to a table ?!?

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

    How to update a form related to a table ?!?

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

    Using double quotes for a long path

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

    Using double quotes for a long path

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

Part and Inventory Search

Back
Top