Replies

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!

Also, how do you get the attachment in line? I like that. It’s been a while since I visited Woodys, and hence have a lot of new changes to get used to – liking the site though.

Ah of course! Thanks )

This was the culprit:

Of Course…

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 get no communication / authentication, although the signal is strong.

Have changed the channel to 3, 5 and 13 – no joy as yet. I’m thinking an extendable cable (if i can find one) is the way forward!

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 as many managers want to copy their pst structure, and i can run this code to provide them with an empty structure.

Sub r1()
s1 Session.Folders(“Current”), Session.Folders(“temp”)
End Sub

Sub s1(fRoot As MAPIFolder, fCopy As MAPIFolder)
On Error GoTo 1
Dim f As MAPIFolder, i As Integer, fC As MAPIFolder
For Each f In fRoot.Folders
Set fC = fCopy.Folders.Add(f.Name)
If f.Folders.Count > 0 Then
s1 f, fC
End If
Next
Set f = Nothing
Exit Sub
1:
Debug.Print f.Name, f.FolderPath
Resume Next
End Sub

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

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 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 visible and changing it there./

i am dumb!!!

cheers rory

well, thats quite a relief in a way! Thanks for taking the time Hans

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

I really like the calibri font I have to admit, it has become my new ‘favourite’ replacing good old tahoma.

I have Visio 2007 installed here, rest of office is XP2002, apart from Outlook which is 2003 . Calibri came in with Visio, I would use it for email but no one else would appreciate it as yet as the Visio 2007 is trial specific to me!

Have a good evening