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!

Search results for query: *

  • Users: Jofx
  • Order by date
  1. Jofx

    Rename Bookmarks in Word doc

    Is it possible to rename a set of bookmarks with vba script ? ex: my doc contains several bookmarks like: [BMK_1] [BMK_2] [BMK_3] I'd like to rename them to: [NEW_BMK_1] [NEW_BMK_2] [NEW_BMK_3] without deleting and inserting new bookmarks Thanks
  2. Jofx

    Runtime procedure

    Mike, I used your code and encounter a bug when closing and re-open XL. I run the following sample, save the sheet, close XL, re-open it, re-run the test, and a error message happens (#9) When I just close the sheet without closing XL, no error happens. Any idea ? Thanks in advance Jofx...
  3. Jofx

    Runtime procedure

    Thanks a lot Mike, it looks like simple. Jofx
  4. Jofx

    Runtime procedure

    May VBA code creates a new sheet at runtime inside an XL workbook. I 'd like to assign a event procedure to that sheet (ex: Sub Worksheet_Activate) dynamically. Is it possible ? Thanks Jofx
  5. Jofx

    Delete identical rows in excel

    Thanks Geoff and Loomah I've have to try it now.
  6. Jofx

    Delete identical rows in excel

    Hi, I'm looking for a Excel VBA code to delete all identical rows in a range (keeping unique rows). ex: Col A A B B C D D D should give: Col A A C Any idea ? Thanks
  7. Jofx

    Textbox validation inside a multipage

    You are right. It works fine to me now I just wanted to replace specific name "Textbox1" by a generic in the beforeupdate proc: "Userform1.MultiPage1.Pages(Userform1.MultiPage1.Value).ActiveControl.name" it didn't work because the (userform1.multipage.value)represents the current active page...
  8. Jofx

    Textbox validation inside a multipage

    Microsoft Support: MultiPage control Use a MultiPage control to work with a lot of information that can be sorted into several categories. A MultiPage control is made up of one or more Page objects that each contain a different set of controls. You can set the active page programmatically by...
  9. Jofx

    Textbox validation inside a multipage

    I come back to my first post: My textbox is inside a multipage. When I put a wrong value in the textbox1 and JUST AFTER click on a other page of the multipages container, the beforeupdate event is not started. in that case, your first tip : .............. Private Sub TextBox1_BeforeUpdate(ByVal...
  10. Jofx

    Textbox validation inside a multipage

    Thanks bclt, it's working fine in addition, I'd like now 2 things:- - add a message when textbox value is wrong - user can leave the textbox with an empty value (and not necessary a numeric value, i.e 0) Thanks a lot Jofx
  11. Jofx

    Textbox validation inside a multipage

    HI, I would like to validate a textbox value (numeric). The textbox is inside the first page of a 2 pages multipage in a userform. I did use a standard validation process in this case: "beforeupdate" event on textbox which is calling a procedure But, the point is: when you write a wrong value...
  12. Jofx

    Get the textbox name

    I just tried : Sub textboxName_AfterUpdate() msgbox Me.activecontrol.name end --> MultiPage1
  13. Jofx

    Get the textbox name

    Thanks Ken I've tried your tip but it doesn't work. The activecontrol gives the name of a multipage containing textboxes. Any other idea ?
  14. Jofx

    Get the textbox name

    I would like to get the name of a texbox after this textbox has been updated. something like: Sub textboxName_AfterUpdate() msgbox "The name of the updated textbox" end Thanks
  15. Jofx

    Get "Table B" records from selecting a "Table A" row

    I'm testing Filemaker pro 7 and I'm beginner. Is it possible to do the following : All records of a first table (Table A) are displayed in a layout as a list of rows. By clicking on a icon displayed at the beginning of all rows, I'd like to launch a other layout to display all recors of a second...
  16. Jofx

    Database options

    Hi What exactly means the options (File/Options) in database section: "perform grouping on server" and "perform query asynchronously" I just guess it is database connection related ...

Part and Inventory Search

Back
Top