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!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Jonath
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. Jonath

    Using double quotes for a long path

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

    Can't save Word Document - Error 5152

    Greetings, I'm working with Access/word 2007; I have a button on a form which allows users to fill a .doc and save it to C: I used the method described in FAQ702-2379 All works fine, in particular: file.activedocument.saveas ("C:\documents and settings\eric\mes...
  7. Jonath

    Error adding a New Record

    Hi, i have a form "recherche" where a user can enter a search criteria (in a field 'Name' for instance) For this field, on Lostfocus event, I have: ---------- docmd.openform "enqueteur",,"byname" 'byname is a requery...the research works fine if Forms![enqueteur].Newrecord then...
  8. Jonath

    Setfocus error !

    Hi, i'm working on a form with various unbound controls to deal with conversions; for instance the user chooses "M" or "F" but the record source in the table becomes "1" or "2". When a user navigates through the records, i want the right information to be displayed on the form (M/F, not 1/2)...

Part and Inventory Search

Back
Top