Search results

Using Access 2003 and XP I am able to effect a merge from Access and Word appears maximised ready for the user to make additional changes etc. However using the same code on my Access 2003 and Vista machine the resulting merged Word document appears minimised on my desktop. Why is there a...

I use Access to merge a query with a Word 2003 document then save it ready for emailing. However as the clients receive the document via email the view appears to be "normal". Is there a way I can force Print Layout by saving the document in that Print Layout view by code after the merge is...

I am trying to merge multiple records into one Word document with the following code, however only the first record is merged into the single document....What do I need to add to my code below. Many thanks Sub ConstructStudentReport() Dim objWRD As Word.Application Dim objDoc As...

KB article 885832 states exactly my problem. I have a query which makes a table as the data source for a Word 2003 merge document. It takes the results of a single record and plonks it in a table and does that exactly as expected. However when access calls word it says I need to locate the data...

Is it possible to place an image on a single Tab which does not then appear on the 2nd and third tabs of the form? Access 2003

I wonder which is correct If IsNull(DLookup("PrivateContractFee", "tblAllStatementTEMP")) Or (DLookup("PrivateContractFee", "tblAllStatementTEMP")) = "0" Then objDoc.Bookmarks("PrivateContract").Select objWRD.Selection.Rows.Delete End If or is it ? If...

I have a query which populates a form with one record. I have a list box on that form which is a list of current Word Merege documents. (created in Word 2000 and Access2000) I am upgrading to Word and Access 2003 and I am wanting to merge the data from the record displayed on the form into the...

I am wanting to merge data from a specific record in Access. I have created a query in which I have placed a parameter in the criteria [Enter a file Number] in the appropriate field in the query. The query works properly. I have then merged it with Word and selected an existing document...

I am wanting to create a small program which enables three users on a XP network peer to peer which enables each user to send a pop up message (i.e. You have a message waiting). This would be used to alert a user they have a message waiting and or just to send a simple message to the other. I...

I am wishing to minimise the whole of the Access Application not just the form which is currently open and using Docmd.Minimise only minmises the current form. How do I minimise the whole application so that another instance of an Access application can run? Thanx

I am trying to develop a simple message book using Access. Unfortunately when I start this database it closes our other Access application. It would seem that what I need is the method of starting a second instance of Access after checking if one is already running? Many thanx

I have one Access 2000 running which I want to run at all times. I want to create an Access program which will be used for a Telephone message book. Is it possible to do this with the user able to minimise the current Access program and start another. i.e. the staff are working as per usual and...

I have a large form consisting of five TABS which is populated by a query. The query is accross a number of tables however all the fields it queries it does need to complete the one form. Fundamentally how do I break down the query into smaller numbers of fields when I need all information to...

Which is best to use in Access Backgound images? Bitmaps are big, JPEGs are small. Even linking to the images the DB increases in size greater than the image kbs. Given that I am adding different backround images to five Tabs on one form the size has dramatically increased the size of the db...

I have been inserting some JPG pictures as background images on my 5 tabs which makes up one form. First I thought that using low quality JPG would be better because of their size against the bigger bmp files which Access seem to generally use. However when I use either BMP or JPG(at a fraction...

I am using a long long form and have used Tabs to make it more presentable. If I insert a picture on one "Tab" it is repeated on every Tab...Why is this so and what can I do to prevent this