Recent content by pastamark

Hello, Does anyone know if there is a way in which you can dictate the display height of a form so that it is set to a specific height on display. I am trying to display a pretty large form. However it easily fits within the Access window. Have tried switching the border property to sizeable...

Mike, You are right in that you can blindly execute the wdDialogFileSaveAs code. However when I do this it does not update the File name that appears if I do File SaveAs. I don't know the reason why this is not working but wdDialogFileSummaryInfo does seem to work and I am satisfied with the...

Hello, Thanks for the reply. I don't want to show the dialogue box to the customer automatically, I just want to set the File name correctly for when the user chooses to (hence the .Execute). However having tried to set some proper titles using this method I seem to be having some problems in...

Hi, Thanks for the reply, really appreciate it. Tried that and although VBA executed it it did not seem to do anything. Have found a solution that seems to work though... With Dialogs(wdDialogFileSummaryInfo) .Title = MyDocTitle .Execute End With Once executed if I then...

Hello, I was wondering if anyone has encountered the following problem when using automation through VBA to manipulate Word 2000 Dialog objects.... I am using automation to create a document in word that is based upon the data I have built up in word. Once I have created the document I would...

Hello, I was wondering if someone might be able to shed some light on this. I have created a continuous form in Microsoft Access 2000 that displays data from two models side by side. I would like to show in each record discrepancies between data that is in each model by highlighting the...