Hi All
Program:
Microsoft Word 2003
Back ground
I am trying to write a macro to insert a landscape page into a portrait document.
Firstly the code must find out if there is a following page after the current cursor point. If there is a following page, the code need to enter extra section breaks to ensure the footers remain correct, other wise the code will just add an extra page making...
AllusiveKitten
Last Activity: Nov 25 '10, 01:00 AM
Joined: Feb 27 '07
Location: Australia
-
Word Macro to detect a following page
-
Thank you Tequila, that works a treat.
AK... -
Hi Vinci,
I have had no luck in working it out, your help would be greatly appreciated.
Thank you
AK...Leave a comment:
-
Hi Vinci
No the sheets are not visible, I have the sheets hidden when excel opens, I have commands the user presses to enter their password before the sheet will become visible.
Yes I am trying to say I want the Unhide function diabled when the sheet is hidden, I want the Unhide function disabled when this paticular spreadsheet is opened full stop..
Hope this helps
Cheers
...Leave a comment:
-
Disabling the Sheets Unhide feature in Excel
Hi All
I dont know if it is possible or not, but I am wondering if anyone knows if you can Disable the Unhide feature in Excel. The feature I am talking about is found under Format > Sheet > Unhide.
If this is possible I would love to be able to code this in..... it will keep little fingers from not touching what they shouldnt be.
Thank you for your assistance.
AK -
Thank you Rabbit,
You are an absolute treasure, I just may have some hair left after this little exercise now.
Cheers
AK...Leave a comment:
-
User-defined type not defined
Hi
I am having an issue with the following coding throwing back an error after I have converted a database to 2002-2003 File Format so that I can MBE the database.
...Code:Private Sub Btn_Hyperlink_Click() Dim dlgPickFiles As FileDialog Dim strFilePath As String Set dlgPickFiles = Application.FileDialog(msoFileDialogFilePicker) With dlgPickFiles .AllowMultiSelect = False -
Hi All
I am still having trouble with this coding error, I have recreated the database and all is fine until I convert the database to 2003-2003 File Format so as that I can MBE the database. It is after I convert the database that I am getting the User-defined error.
Has anyone come across the same problem that could give me a solution to my problems??
Thank you kindly
AK...Leave a comment:
-
...Code:Private Sub cmdRun_Click() Dim dlg As CommonDialog Dim strRootFolder As String Dim strFile As String 'check that data has been entered If DCount("Name", "Data") = 0 Then MsgBox "Please populate data table" DoCmd.OpenTable "Data" Exit Sub End If DoCmd.SetWarnings FalseLeave a comment:
-
Where I have been saying CommonControl, I mean CommonDialog... .. no wonder I am confusing my self..!!Leave a comment:
-
Hi ADezzi
Now I feel like a real fool... the CommonControl has been created and it all works in the old database, here is the full coding that uses the control.
...Code:Dim dlg As CommonDialog Dim strRootFolder As String Dim strFile As String 'check that data has been entered If DCount("Name", "Data") = 0 Then MsgBox "Please populate data table"Leave a comment:
-
User-defined type not defined
Hi All
I am hoping someone can assist.... I have imported all of the table, queries, forms & modules from one database into a new database I have created. I am now getting a 'User-defined type not defined' error on the following coding:
I have checked that all of the references are the same and the only one that I can see where there maybe a problem is Command Controls... In...Code:Dim dlg As CommonDialog
-
Hi Nico,
I have just tried the coding that they provide, I think this is just to show how to send an email.... this coding give 2 security pop ups and 1 coded Msgbox.
Below is the code I have for my emails to send, in my full version I have a loop that goes until all emails are sent.
...Code:Sub ReminderEmails() Dim Email As String Dim EmailName As String Dim strNote As String
Leave a comment:
-
Hi ADezzi
I will firstly say "Your are definately worth you weight in gold".
OK from the start, you are correct in assuming I am trying to Update a specific Field in a Table, yes it is a Hyperlink Data Type, and when I click on this field I want the "document" to open not navigate to a Web Page.
I am getting the address of the document from a msoFileDialogFi lePicker which is being...Leave a comment:
-
Hi Nico,
I have had a read of the document and I am sorry to say that it has gone completely over my head. Can you please give me just a little hint on how to go about removing the warning?
Thank you for you help
AKLeave a comment:
-
Hi ADezii
I am really not getting this one at all, I think I must be confusing myself, how do I incorporated all of the data of the hyperlink into a update code?
Thank you for you help
AK...Leave a comment:
-
Coding for closing down an automatic email
Hi all,
I really hope I can explain myself properly, I have set up coding to send multiple automatic emails which is working super! Each email that is being sent I receive the security Pop up box that say someone is trying to send an email on behalf of myser.
My question is, is there a code I can put in for when someone presses the No button because at the moment when it is pressed, I am getting a debug error.
... -
Hi Nico,
I am not trying to post a web address, I am trying to insert a hyperlink to a document. When the address is entered it is all looking correct, but when I go into view the Hyperlink, the information that has gone into the field is sitting in the Text of the Hyperlink but nothing is in the actual Hyperlink Address.Leave a comment:
-
Inserting Hyperlink into a table
Hi all
I have an issue inserting a hyperlink into a table. I have all of the detail going into the field but it is going in as only the text of the hyperlink not the file address.
How do I get the Record to read eg QSTR001 (this is the actual file name eg QSTR001.pdf) and the actual file path comes from a file picker which is working fantastically.
The coding that I have so far is:
...Code:Set db
-
I understand what you mean, why do you think I only type AK.....lol, I am just as lazy.....hehe...Leave a comment:
No activity results to display
Leave a comment: