Search:

Type: Posts; User: pieter; Keyword(s):

Page 1 of 7 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Query to show only duplicate records (2003)

    assuming your tabel is called table1 and the field is called field1, the following SQL statement should do it:

    SELECT DISTINCT table1.field1 FROM table1 INNER JOIN (SELECT field1 FROM table1 GROUP...
  2. Replies
    4
    Views
    373

    Re: subsubform within tabcontrol (2002)

    you're a great help as always Hans!

    i've got it working now, but only if the name property and source object property of the subfrom control are the same.
    so if i set both name property and...
  3. Replies
    4
    Views
    373

    Re: subsubform within tabcontrol (2002)

    thanks Hans!

    that should do the trick. however, i am more versed in VBA than in form design unfortunately and i'm having difficulty applying the "=[SubFormName]![IDName]"-suggestion to the actual...
  4. Replies
    4
    Views
    373

    subsubform within tabcontrol (2002)

    i've got the following table model:
    table1 <-one to many-> table 2 <-one to many-> table 3

    for space saving features i don't want to create a subform within a subform, the last subform should go...
  5. Replies
    3
    Views
    1,018

    Re: Word has insufficient memory (Word 2002 XP)

    does application.DisplayAlerts=wdAlertsNone help?
  6. Replies
    4
    Views
    353

    Re: For Each Field in a Form (Office 2003)

    Edited by HansV to change <!t>[script] tags to <!t>[code] tags. Please don't use Script - it makes code unreadable <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> Hans, i just was a...
  7. Replies
    2
    Views
    391

    Re: Excel row insert (Excel 2002)

    the appropriate constant to use in this case is called xlShiftDown (member of the XlInsertShiftDirection constants), with a value of -4121. the xlDown constant will also work, because it has the...
  8. Re: VBA code no longer works :o) (Word 2002 /XP SP

    do you have a before close event running?
  9. Re: Word version dependent VBA code (Word 2000 / W

    the .Borders(wdBorderDiagonalDown) is actually not a good example of your problem, because then the compile error could easily be avoided by replacing the constant name with its value. the compile...
  10. Replies
    11
    Views
    6,921

    Re: Detecting file/folder permissions (VB6)

    no, you have to write it with the standard open, print, close what have you staments or the file system object. then you can test silently for access denied. then write the actual file using the api.
  11. Replies
    12
    Views
    3,172

    Re: Using Office Automation from Java

    reverse engineer java JNI?
    or
    http://j-integra.intrinsyc.com/com/download/

    (you have to contact them though for licencing fees, evaluation period is free.)
  12. Replies
    11
    Views
    6,921

    Re: Detecting file/folder permissions (VB6)

    just try to write a small dummy text file to test for proper access rights. then depending on the result, abort or continue with the actual file you want to write.
  13. Re: inputbox that shows formula & edit formula pur

    you can go into edit mode by pressing F2. if you want this to be the standard behavior of the inputbox, you could try sending the f2 key with the vba.sendkeys method before you call the inputbox, but...
  14. Re: test if Word document is already open in VB (Word 2000)

    whether the template is on a server or not should not matter. if you start a document from a (server)template with set mydoc=documents.add("myserverdocsmytemplate.dot"), you should not receive the...
  15. Re: Word mail merge failure (Word 2000 / Access 2000)

    tough problem. it looks like something is corrupting the registry.
    you might want to try the following (make sure no instances of word are running - if you're not sure, reboot the computer)
    now...
  16. Replies
    4
    Views
    1,513

    Re: OleServerBusyTimeout (VB6)

    "When opening an office document that expects user interaction my app is hanging."

    in general, you could avoid user interaction by setting various properties before/at opening of an office...
  17. Re: Generic comments about a Word template (All VBA versions)

    these are all sane arguments of course. a template should be as selfcontaining as possible, whilst still allowing user customization. setting the normal template to read only does limit user...
  18. Re: Setting Event Listeners in Word Add In (Word 2

    if the template is not in the startupfolder of word (options.DefaultFilePath(wdStartupPath)) it won't load automatically.
    either put it in the startup folder or use the add method of the addins...
  19. Re: PasteFace on CommandBars not quite right (2000

    just a quick idea to explore:how about copying the entire commandbar and keep track of custom controls. you could set various properties of the copied commandbar to provide some basic form of...
  20. Replies
    10
    Views
    1,431

    Re: Blocking spyware with a HOSTS file

    great tip. i combine mvps's host file with hpguru's one. i look for updates on security sofware (including several hosts list definitions) at the calendar of security updates
  21. Replies
    19
    Views
    1,550

    Re: Sleazy phishing code du jour

    nice! NOT! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    here's the most recent phishing scam which in essence exploits bad html design on the server, which allows cross site script...
  22. Replies
    4
    Views
    419

    Re: macro points to username (Word XP Sp2)

    nice out-of-the-box thinking! <img src=/S/groovin.gif border=0 alt=groovin width=21 height=21>
  23. Replies
    27
    Views
    1,568

    Re: Norton AV and Zone Alarm...can they co-exist?

    hi Dave,

    a browser should not normally need server acces. i use firefox now, but when i used internet explorer it didn't need server access either. have to admit though that i never used the...
  24. Replies
    4
    Views
    419

    Re: macro points to username (Word XP Sp2)

    Templates("C:Documents and Settings" & environ("username") & "Application DataMicrosoftWordStartupSWFirm.DOT").AutoTextEntries(...

    both this solution and the api solution are at get username
  25. Thread: False positive?

    by pieter
    Replies
    10
    Views
    926

    Re: False positive?

    hi Alan,

    highly probable it's a piece of malware. try using this free online malware scanservice to find out more
    as for avoiding these types of mishaps, using a restricted user account will...
Results 1 to 25 of 159
Page 1 of 7 1 2 3 4