Resizing Bound Object Frames - Inserting Word Docs

Feb 17, 2005

I have created a table with ole object types and linked word documents. I am now trying to create a report with the word documents showing up. The problem is that the size of the word document varies, some are half a page some are several pages. When I create the report with the object frame, I can't seem to find a control property to 'can grow'. Is there some way, possibly using VB, to create that feature. I'm thinking the VB way might be to access the embedded file and find out it's size and then size the object frame accordingly. I don't want to make the frame set to the largest document because then there will be blank pages that I don't want in the smaller documents.

Thanks for any help

View Replies


ADVERTISEMENT

Insert OLE Object (Mainly Word Docs)

Aug 22, 2005

Quick overview so you understand: I have two databases, one which contains form(s) that allow users to enter in legal type cases. It has a subform in which has four fields to insert OLE objects. This form draws its data from a linked table in a database called Attachments. Not all cases have 'attachments' & the attachments are associated to cases by case number.

Anyway, my delima is - I am trying to make a less 'clunky' way for the end-user to insert objects to the cases. Currently, they can click on a button that will open the Insert Object box. It isn't that complex for a developer to use, but the regular end user, it is quite complex. Also, once an object has been inserted, it renames it. (FYI: These objects are being imported & not linked) When inserting the object, you can decide you want it to be an icon shown in the OLE field & thus you can name it there. But the problem is, if you double-click to open the document it gives it a new name that is associated with the form name. It does not retain the original file name. Does anyone know of a way for it to retain the original file name??

That is my 'biggest' problem here since these files maybe updated & even emailed - Being that they are legal documents, it would be good that they retain the name. I have just begun to use OLE objects fields so I am very, very new to this.

View 3 Replies View Related

Opening Word Docs From Form

Sep 7, 2005

I have searched this topic but can't find exactly what I'm looking for so I hope someone help.

I have a directory full of doc files which are constantly being updated. I would want to be able to browse the directory from Access and click on the relevant file to open it directly.

So there's no storing the pathnames in a table etc...just open the doc to view.

Any ideas?

Dave Eyley

View 4 Replies View Related

Adding And Viewing Ms Word Docs

Sep 29, 2005

Hi all,

Just looking for some more advice I am creating an application that contains employee details in access. I have the majority of the database working but I am stuck on a couple of thins, Firstly I would like to add the option to be able to add an employees CV to the databse and an option to open this. I found a good example that I thought would help me and it did in post 11 of the thread below but I cannot get the files to open in MS word so they can be viewed. The majority of the files to be opened will be ms word format. I just get the error object doesnt support this property or method

http://www.access-programmers.co.uk/forums/showthread.php?t=7137&highlight=attaching+files+records

hope someone can help
thanks in advance
J

View 1 Replies View Related

General :: Merge With Word Docs

Apr 4, 2013

I have a access database with 125 names and addresses and need to merge and send out the a doc for each one. Does anyone have experience with the multiple factor of this process. I can merge one but then have to repeat several times.

View 5 Replies View Related

Openning Word And Excel To Show Default Docs

Dec 6, 2006

I'm using this code which I think Came from a Button Wizard many moons ago but when I use it It opens the app for the function but does not display the default Blank Doc.Could anybody point me in the right direction for getting them to show the default blank DocsMany ThanksMickPrivate Sub CmdRunWord_Click()On Error GoTo Err_CmdRunWord_Click Dim oApp As Object Set oApp = CreateObject("Word.Application") oApp.Visible = True oApp.Caption = "Database Dreams - Word"Exit_CmdRunWord_Click: Exit SubErr_CmdRunWord_Click: MsgBox Err.Description Resume Exit_CmdRunWord_Click End SubPrivate Sub CmdRunExcel_Click()On Error GoTo Err_CmdRunExcel_Click Dim oApp As Object Set oApp = CreateObject("Excel.Application") oApp.Visible = True 'Only XL 97 supports UserControl Property On Error Resume Next oApp.UserControl = True oApp.Caption = "Database Dreams - Excel" Exit_CmdRunExcel_Click: Exit SubErr_CmdRunExcel_Click: MsgBox Err.Description Resume Exit_CmdRunExcel_Click End Sub

View 3 Replies View Related

Inserting An Object In A Table

Jul 28, 2005

I have been inserting thumbnail pictures into my table for the last six months with no problem. The field in my table displays "Microsoft Photo Editor 3.0 Photo." Now when I enter my thumbnail by inserting an object, the field displays the word "package" and the photo does not appear in the form where the pictures are displayed.
What would cause the word "package" to appear when I am inserting an object just like I have been doing for months?

View 2 Replies View Related

Include Bound OLE Object In Mail Merge

Feb 6, 2006

Is it possible to include a bound OLE object in Access in a mail merge using a Word document? If so, can someone tell me the procedure? When I include the OLE object as a merge field, and complete the merge, only a code shows, not the document it is linked to.

View 2 Replies View Related

Adobe - Bound Object - OLE Server Error

Jul 13, 2006

I have the strangest error.

I have used a OLE Bound Object, so I could create a link to some .PDF files. Everything works great, and I was ready to roll it out to the users (boy will they be excited), when I noticed a silly error I could not get rid of.

After closing the .PDF file (which opened correctly) I get an error that reads:

---------------------------------------------

The operationon on the Acrobat Document object failed.

The OLE server may not be registered

To Register the OLE server, reinstall it.
---------------------------------------------

I have searched the internet, this message board and the Microsoft website, and have come up with little. I believe it might be a .dll error, but the only thing close I could find regarded MS Access 95/98. This is an MS Access 200 DB. I get the error on both a Microsoft 2000 machine AND a Microsoft XP machine.

I tried to use "On Error Resume Next" but to no luck.

If anyone has any ideas, I would appreciate the help/suggestions.

Thank you,

TJ Bernard

View 5 Replies View Related

How To Attach Bound Object Frame To Body Of Email

Oct 17, 2015

My email comes out like this:

Here's my code:

Private Sub Complete_Click()
Dim OL As Outlook.Application
Dim MyItem As Outlook.MailItem
Dim sHTML As String
Dim sSubject As String

[Code] .....

View 14 Replies View Related

Inserting Name Into Word From Access

Jan 28, 2005

Dear All:

I am currently printing a letter from access to word using a command button. So far, so good.

However, I wish to add the person's name on the letter who I am currently viewing on the form. The name of the fields on the form is called "FULL NAME".

Here is the code I am using to print the letter from Access:

Private Sub PrintLetter_Click()
On Error GoTo Err_PrintLetter_Click
Dim oApp As Object
Set oApp = CreateObject("Word.Application")
oApp.Visible = True
Set appWord = New Word.Application
' The path/name of the Word document goes here
Set wdDoc = appWord.Documents.Open("C:documents and settingsuserdesktopEXPRESS DIPLOMA LETTER.doc")
wdDoc.PrintOut (False)
wdDoc.Close (False)
appWord.Quit
Set wdDoc = Nothing
Set appWord = Nothing
Exit_PrintLetter_Click:
Exit Sub
Err_PrintLetter_Click:
MsgBox Err.Description
Resume Exit_PrintLetter_Click

End Sub

Any help is appreciated.

Regrds,

Dee

View 6 Replies View Related

Combo Bound Column To Word Bookmark Conflict

Jul 6, 2005

Ok....Just when you think it's all running smoothly.... :(
I have a combo box, MDLastName, with a column count of 9, with column 2 displaying and all others hidden. The selection made with this combo populates 7 corresponding fields (first name, address, etc). It's working perfectly.

The first problem I encountered was with identical last names, but different corresponding data. When I selected Jones, for example, it would populate the first Dr. Jones and his info, listed in the table. However, if I selected the second Dr. Jones in the combo list, it was still populating only the first Dr. Jones' info. I resolved this by binding the fist column (ID, aka primary key), but still hiding all colums but column 2. First problem fixed..

Next, I have a Word Template document bookmarked to receive data from the form, frmDenial. I have all the coding working fine and dandy to insert the data from the fields on the form, save, and print. However, instead of inserting the text from the MDLastName, it is inserting the primary key (because it is the bound column in the combo box). Now, because of the first problem discussed above, I cannot change the bound column to column 2 (containing the data I need in the Word Template). How can I get the right info to appear in my template with the bookmarks?

View 1 Replies View Related

Resizing Subform

Sep 16, 2005

Hi,
I'm trying to resize a continuous subform automatically depending on how many records it is displaying. It needs to resize to fit all of the contents it displays, but no more. I also need to move labels and text boxes down if the subform size gets larger. This needs to be done every time the user cycles through records in the main form.
Thanks in advance. :cool:

View 3 Replies View Related

Windows Resizing

Sep 17, 2007

I have a form is set to Maximize on open
I have a drop down box on that form that allows a user to select a report and then the report runs and opens.

The problem is that when I close the report the form that I had DoCmd.Maximize is no longer maximized...

I have tried On Focus, OnOpen, OnLoad etc

I cant find the event that I can code on to get that Form to maximize when I close the report...

Any thoughts...

Can I set the Form to always be a specific size or maximized? I would prefer Maximized due to screen resolutions beign different....

THanks

View 1 Replies View Related

Preventing Form From Resizing

Sep 7, 2005

Hi
I have a Switch Board and when I click to view a report on it the report automatically opens in maximize view, this is what I want. What I dont want is when I close the report for the Switch Board form to be maximized as well

How would I be able to prevent this??
Cheers
bikeboardsurf :rolleyes:

View 2 Replies View Related

Hiding And Resizing Columns

Jul 11, 2005

What I have: I have a main form with 3 subforms viewed as datasheets.

I have read the post about hiding columns by using me.<object>.columnhidden = True and that kind of works. Once the user goes to resize the columns they can get the hidden columns back. This is a problem if I'm trying to hide a priority column only admins should see.

Is there a way to specify the width of a column and restrict the user from resizing it? That way the user can not resize and get hidden columns back.

If there is a better way if doing this please let me know. Ultimately, I just don’t want the user resizing or unhiding columns I have sized and hidden.

Thanks

View 1 Replies View Related

Automatically Resizing Forms

Feb 20, 2006

Hi,

I'm doing a database with several pop-up forms, but however small i make them ,they always resize to give a fairly large border around the controls onthe far right and bottom. Everytime i try and shrink it, in code with the Form.Width property, and in the design view, they always resize back again.

Any help would be great.

Tony

View 3 Replies View Related

Frames (?) In Forms

Apr 16, 2005

Well, I apologise now, because this will probably be badly explained, but anyway, I was wondering if there is a way to create a button in a form, which would act like a frame (or inner.HTML, etc). So for example ::

Button 1 | Button 2 | Button 3

And when you click "Button 1", it comes up with a certain section, and makes the others disappear, which could for example be a section of text, and a button to open another form, etc.

You get me? Sorry if you don't. I've always been quite bad at explaining this kind of stuff. If you don't, I'll gladly explain myself again.


Cheers,
Felony

View 3 Replies View Related

Auto-resizing Fields On Focus

Apr 15, 2005

Hi everyone,

Problem I'm running into is I need certian fields to auto-resize when they're hovered over (or have focus) so that all the information is viewable, but then resize back to normal afterwards. The forms contain a large amount of information, so the fields have to be smallish most of the time, but certain fields, such as email addresses for example, are hard to work with because you can't see most of the entry.

Any help would be greatly appreciated. Almost done with this Access project, and it's just little details at this point.

-Walter

View 6 Replies View Related

Forms :: Resizing Form With TabControl

Jun 5, 2014

In Access 2010 I want to resize my forms according to the user's screen resolution.I designed my forms to look fine for 1024x768 and then multiplied everything at higher resolutions.In the forms OnLoad event I inserted a procedure like the following:

Code:
Public Sub SetSize(aForm As Form)
Dim MV As Single
Dim ctrl As Control

[code]....

It works fine if the page doesn't have a TabControl; but with the Tab Control Pages it get missed up. I think because changing the TabControl size will affect immediately the contened Pages, and when the code arrives to change the size of the pages, it is no more the original size . So I tried this:

Code:
Public Sub SetSize(aForm As Form)
Dim MV As Single
Dim ctrl As Control

[code]...

Things are better, but still I found that the values of my pages and the background rectangle I inserted in each pages to make them of different colors are wrong, instead the values of TabControl are correct.

View 1 Replies View Related

How To Make Checklists And Other Info Docs From 'database' ???

Jan 16, 2007

Non-techy IT type of question...

How to best setup a database (knowledgebase) for use in making various work place hardcopy and electronic intetacive version process checklists that may share some of the same info ?

Eg, checklists for a building dept for how to get permits for different types of buildings that may all require some of the same types of plans and permit application docs, but may also require other plans/docs specific to the particular type of building... but in order to update a requirement in the checklist/s only one database item would need to be changed in order to update all the checklists that include that common item.

Then to carry it one step further... to use the same database to update info publications that may have checklist type information in the narratives about the same building permit requirements.

Hope that makes sense.
Thoughts ?
Where else to look ?

View 4 Replies View Related

Modules & VBA :: Merging PDF Docs Using Access 2007

Apr 1, 2015

Any simple code that merges multiple pdf documents that they are willing to share. I don't seem to be able to find anything that works so far.

View 2 Replies View Related

Two Questions- (two Frames And Html Form)

Apr 28, 2005

First quetion
how can i make some form to be with two frames, one is the navugation tree and the second one is a frame that is changing akk the time, which means the navigation tree is not changing ever.
i am trying to build somthing like asp with two frames and a record set and i dont know how.

the second question i have is how can i put an html frame in a form? i have some link to sme web site in my database, andd i want this data base to be open inside the form of the access and not with my browser in a new window.

please advice.

thanks.

View 3 Replies View Related

Two Questions- (two Frames And Html Form)

May 4, 2005

First quetion
how can i make some form to be with two frames, one is the navugation tree and the second one is a frame that is changing akk the time, which means the navigation tree is not changing ever.
i am trying to build somthing like asp with two frames and a record set and i dont know how.

the second question i have is how can i put an html frame in a form? i have some link to sme web site in my database, andd i want this data base to be open inside the form of the access and not with my browser in a new window.

please advice.

thanks.

View 1 Replies View Related

Copying Forms/subforms/frames?

Oct 24, 2005

I am in the process of trying to build a template in forms for my boss to quickly enter information and construct a PowerPoint presentation from this information.

Basically, I have a form that he can enter information, but it needs to look professional (not datasheet view). Is there a way that I can make a subform and frame it, so that I can copy the entire form (not just the data) and paste it onto powerpoint? I need the formatting to be consistent and appealing!

View 2 Replies View Related

Form - Putting Textbox Inside Frames

Mar 29, 2007

I've created a frame but I'm not able to actually to put textboxes inside it, only radio buttons. Is there anyway to force textboxes inside the Frame? Thanks in advanced.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved