Replies

that doesnt have the desired effect.

[indent]

---

‘—————-Footer Section ——————————————-

‘————–remove protection———————–
If ActiveDocument.ProtectionType wdNoProtection Then
ActiveDocument.Unprotect
End If

If foot_add = True Then

‘————————————–Add Footer text————-
If foot_page = True Then ‘———–show text on first page
ActiveDocument.PageSetup.DifferentFirstPageHeaderFooter = True
ActiveDocument.Sections(1).Footers(wdHeaderFooterFirstPage).Range.Text = txtourref.Text
ActiveDocument.Sections(1).Footers(wdHeaderFooterFirstPage).Range.ParagraphFormat.Alignment = wdAlignParagraphCenter
ActiveDocument.Sections(1).Footers(wdHeaderFooterPrimary).Range.Text = txtourref.Text
ActiveDocument.Sections(1).Footers(wdHeaderFooterPrimary).Range.ParagraphFormat.Alignment = wdAlignParagraphCenter
Else ‘———— dont show footer text on first page
ActiveDocument.PageSetup.DifferentFirstPageHeaderFooter = True
ActiveDocument.Sections(1).Footers(wdHeaderFooterPrimary).Range.Text = txtourref.Text
ActiveDocument.Sections(1).Footers(wdHeaderFooterPrimary).Range.ParagraphFormat.Alignment = wdAlignParagraphCenter
End If

‘————————————-Add Page Numbers————-

End If

If foot_num = True Then
If foot_first = True Then ‘———–show number on first page

ActiveDocument.Sections(1).Footers(wdHeaderFooterPrimary).PageNumbers.Add PageNumberAlignment:= _
wdAlignPageNumberRight, FirstPage:=True
Else ‘—————-don’t show number on first page
ActiveDocument.Sections(1).Footers(wdHeaderFooterPrimary).PageNumbers.Add PageNumberAlignment:= _
wdAlignPageNumberRight, FirstPage:=False
End If
End If

‘———–reprotect————
ActiveDocument.Protect Type:=wdAllowOnlyFormFields, _
noreset:=True
‘—————————-

---

[/indent]

This is where i am so far, this works exactly how i want except for the combination

Show Footer = true
Show page numbers = true
show page numbers on first page = true
show footer on first page = false

This code is called when the user creates a new document from one of their templates. There is a custom toolbar which they use to load these templates.

when they choose a template, a form pops up asking them if they want to include X/Y/Z in the document and also creates a reference. at the bottom of this form is the section I am working on.

With the option “show footer” This puts the reference generated by the form , into the footer of the document with the option whether to show this on the first page or not.

Hi wendell,

good advice, main reason i have been putting off the splitting of the database is due to their roll out policies at the place i work (who makes up these things ?) but hoping to do that soon.

I’ve been keeping a log of whoes logged in and when the system has been locking, have noticed a definate pattern there so going round to them today to give them a clip round the ear ole.

Hi wendell,

good advice, main reason i have been putting off the splitting of the database is due to their roll out policies at the place i work (who makes up these things ?) but hoping to do that soon.

I’ve been keeping a log of whoes logged in and when the system has been locking, have noticed a definate pattern there so going round to them today to give them a clip round the ear ole.

Modify is read/write/delete

Modify is read/write/delete

Trying to find where i read it now but apparently a frequently set screensaver can cause problems,

in answer to your questions,
The database is being opened by a shortcut on the user’s desktop
All users have modify permissions on the folder
Single database in a shared location (soon to be split)

The error is coming up about two or three times a day when users are loggin in. There are about 12 user’s using the database.

Trying to find where i read it now but apparently a frequently set screensaver can cause problems,

in answer to your questions,
The database is being opened by a shortcut on the user’s desktop
All users have modify permissions on the folder
Single database in a shared location (soon to be split)

The error is coming up about two or three times a day when users are loggin in. There are about 12 user’s using the database.

had a feeling that would be the reply,

had a feeling that would be the reply,

spot on tony

spot on tony

just a not too important note,

see small hint further up,

Land of og shares the same shores”!

also a variation on the game is that the subject of the land of og doesnt have to be the same each time , part of the fun is trying to work out what the land of og is for example i could start a game with the following

In the Land of og there is Abraham but no Franklin
In the land of og there are tigers but no lions
In the land of og there are scorpions but no beatles

also if your playing it with the drink while you think rule can get you quite merry

just a not too important note,

see small hint further up,

Land of og shares the same shores”!

also a variation on the game is that the subject of the land of og doesnt have to be the same each time , part of the fun is trying to work out what the land of og is for example i could start a game with the following

In the Land of og there is Abraham but no Franklin
In the land of og there are tigers but no lions
In the land of og there are scorpions but no beatles

also if your playing it with the drink while you think rule can get you quite merry