Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    4
    Views
    738

    Hi John. Of course - a unique index is...

    Hi John.

    Of course - a unique index is required. Brain not in gear!! Thanks for this. Makes sense, else as you say, which field would access know to update in case of duplicates otherwise!
    ...
  2. Replies
    4
    Views
    738

    I know i must be missing something really simple....

    I know i must be missing something really simple. But can't think why when i run this query, i CANT enter data in the NEW SERIAL field.

    [attachment=87858:NoUpdate.gif]
  3. Replies
    0
    Views
    846

    I have an XP Client in my Domain which has SQL...

    I have an XP Client in my Domain which has SQL services running on it, and I want to add a Domain User account to have the permissions to start and stop this service through the GPO settings on the...
  4. Thread: Delete Query (XP)

    by Matz
    Replies
    2
    Views
    370

    Re: Delete Query (XP)

    Ah of course! Thanks http://windowssecrets.com/forums/images/smilies/ohmy.gif)

    This was the culprit:
  5. Thread: Delete Query (XP)

    by Matz
    Replies
    2
    Views
    370

    Delete Query (XP)

    Hi, I think I must be doing something really stupidly wrong, because I can't seem to delete a list of records using a simple query.

    Setup is:

    Table A. Fields: username, SSO
    Table B. Fields:...
  6. Replies
    6
    Views
    548

    Re: Display Comment (XP)

    Of Course... <img src=/S/doh.gif border=0 alt=doh width=15 height=15>

    Early monday morning comes to mind!!

    Thanks Hans
  7. Replies
    6
    Views
    548

    Re: Dicplay Comment (XP)

    Hi,

    where do i put the code for a custom function? it doesnt work if I put it in the ThisWorkbook module. Do i need to add to an .xla?
  8. Replies
    2
    Views
    924

    Re: Not authenticating?

    Hmm, perhaps theres some powerlines in the wall there, or just the leads from the PC as its all in a corner by the pipes - just so annoying that if i move the PC forward its fine, but if not then i...
  9. Replies
    2
    Views
    924

    Not authenticating?

    Hi, I am wondering if people out there would have any comments / thoughts on a situation I have come across at home recently.

    We have moved house, and now have the PC in a different room from the...
  10. Replies
    6
    Views
    548

    Dicplay Comment (XP)

    Just a quick one.

    Is there a way using a formula to capture the comment of one cell and display as the value of another cell?

    something like

    =COMMENT($A$5)

    to display the comment of A5...
  11. Replies
    19
    Views
    997

    Re: Email folders & subfolders? (2002)

    Ok, here is the code I have currently.

    It is to duplicate the folder structure of a .pst file. it copies the structure of a pst called 'Current', to a empty .pst called 'temp'

    this is helpful...
  12. Replies
    19
    Views
    997

    Re: Email folders & subfolders? (2002)

    Ahh.

    No probs, I am too trying to reconstruct the code. Thanks Hans.
  13. Replies
    19
    Views
    997

    Re: Email folders & subfolders? (2002)

    Hi, Hans - I need this code again, but the link does not work - any thoughts?
  14. Re: Protected Document, still access inserted Object (XP)

    Thanks Hans and Paul.

    I don't really want to have the 'enable macros' flag up, otherwise i might have gone for the on exit macro idea.

    Cheers
  15. Protected Document, still access inserted Object (XP)

    Hi, I have a Word Document that has about 10 objects embedded (as icons) - these are either other .doc or .pdf files.

    I want to protect the document so uses cant easily change the text, but still...
  16. Replies
    5
    Views
    625

    Re: VBA for Recordselector.Click (XP)

    Hi

    yes, was thinking of a list box, but the continous forms with that runcmd is fine.
  17. Replies
    5
    Views
    625

    Re: VBA for Recordselector.Click (XP)

    perhaps using a continous form will help - trying now...
  18. Replies
    5
    Views
    625

    Re: VBA for Recordselector.Click (XP)

    Hi

    works...ok-ish.. but not as good as when i click the record selector. The vba command sometimes selects the whole line, but sometimes opens up the cell within the selection . any other ideas?
  19. Replies
    5
    Views
    625

    VBA for Recordselector.Click (XP)

    Hi

    I have a datagrid view subform that you can click on to select records. i want the form to automatically select the whole row (as if you clicked on the record selector) whenever a cell is...
  20. Replies
    7
    Views
    1,570

    Re: font size of document map? (word 2002)

    Hi

    I cant change the size of the document map font via the zoom settings on outline view - they have no affect on the document map size.
    I can however change by making the document map style...
  21. Replies
    2
    Views
    1,219

    Re: Select all sheets vba (XP)

    i am dumb!!!

    cheers rory http://windowssecrets.com/forums/images/smilies/biggrin.gif
  22. Replies
    2
    Views
    1,219

    Select all sheets vba (XP)

    Hi

    I recorded a macro to select all sheets, but it used the Array(1,2,3,4,) method with the sheet names.

    I want to be able to select all sheets, but use the module in various workbooks, ie with...
  23. Replies
    16
    Views
    1,011

    Re: Range().Copy method freezing Excel (XP)

    well, thats quite a relief in a way! Thanks for taking the time Hans http://windowssecrets.com/forums/images/smilies/smile.gif

    I will find a way around it I'm sure, start again tomo though.

    I...
  24. Replies
    16
    Views
    1,011

    Re: Range().Copy method freezing Excel (XP)

    Thanks Hans - Im going to leave it now 4 a bit, i almost hope (!) you get the same issue on Excel 2002 <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>
  25. Replies
    16
    Views
    1,011

    Re: Range().Copy method freezing Excel (XP)

    In fact, the .copy method works fine to copy from any other sheet across sheets, just when copying from sheet 1 it doesnt.

    So i manually copied sheet 1 range (A1:m34) and pasted into a new...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4