Search:

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

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]

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

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

This was the culprit:

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

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

Early monday morning comes to mind!!

Thanks Hans

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?

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

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

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

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

Ahh.

No probs, I am too trying to reconstruct the code. Thanks Hans.

Hi, Hans - I need this code again, but the link does not work - any thoughts?

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

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

Hi

yes, was thinking of a list box, but the continous forms with that runcmd is fine.

perhaps using a continous form will help - trying now...

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?

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

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

i am dumb!!!

cheers rory http://windowssecrets.com/forums/images/smilies/biggrin.gif

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

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

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>

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