Recent content by oggstar

Thanks Lozere used the followeing link to cretae the merge using bookmarks, i never though of doing it this way. http://support.microsoft.com/support/kb/articles/Q210/2/71.ASP

I have been able to configure an access form to open a word mail merge document. The problem is that when the word document opens it opens all 41 records and displays the first mail merged record. I would like the word document to open the record that i am currently in when i click on my...

I am using the following expression that will open and display a mail merge word document from an access form. The only problem is that it opens the first record of the query as opposed to the specific record that i am in. How do i open up the specific record and is it possible to...

This is a simple question, when I convert my form into a word document using the menu tools/Office links/publish in MS word, my form only displays text minus the table borders. Is there anyway to display the borders in Word or excell, the same as the report displays in Microsoft Access. Any...

Hello I am trying to use the following code which has been succusfully adapeted in another datebase of mine. I have changed around the field names and relevent details. However it is not working and the following message appaers "Run time errer 438, Property does not support this property...

Thanks Maquis that has solved the problem.

Thanks Marquis your a champion, 'it works'. Howver what if i want the status to = "low impact" and "on hold" to be invisable. I tryed typing in or "on hold" or and "on hold" This was unsuccusful, any ideas. Private Sub Form_Current()...

Thanks for the replys they were very helpful I was using the wrong feild and the wrong event. Lost focus did not seem to work however Got focus seemed to work well. However the only problem is that when i close my database and then re-open it, it does not make the owners consent immediately...

I am not having any luck with the following expression, I had a look at the help function it provides the following information and examples. «Expr» DCount («expr», «domain», «criteria») DCount("[ShippedDate]", "Orders", _ "[ShipCountry] = 'UK' AND [ShippedDate] >...

I want the field [OWNERS CONSENT] to be visible and editable only when the field [LI or DA Status]="DA". (Both fields are in the same table) I did try and use VB by doing the following. I would right click the field [OWNERS CONSENT], build code followed by code builder. Then I...

Thanks guys they were helpful

Thanks nickjar2 it most certianly works

Thanks Shirley they were usefull Does anybody know of any others which have a bit more complicated access functions and examples of Visual basic code.

Thanks nickjar2 for teh reply Still unsure about the code to use, specifically what does & textBoxName refer to. I thought it refered to the feild name but that was unsuccusful. This was the code i included, - " & textBoxName Private Sub Site_Number_AfterUpdate() Dim rs As Object...

I am editing a form and the curser is within the Feild [number] (Say 1500 is entered). If i change the number to 1600, how can i set the database so the record relating to the number 1600 appears, as opposed to the information relating to 1500 record remaining with the new number 1600 appearing...