Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. oggstar

    Merging word documents from Access, to open only the current record.

    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
  2. oggstar

    Merging word documents from Access, to open only the current record.

    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...
  3. oggstar

    Mail merge documents from an access form

    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...
  4. oggstar

    Converting a form into word, whilest retaining the report formatting.

    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...
  5. oggstar

    Hiding feilds in a form based on the users input in a particular feil

    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...
  6. oggstar

    Hiding feilds in a form based on the users input in a particular feil

    Thanks Maquis that has solved the problem.
  7. oggstar

    Hiding feilds in a form based on the users input in a particular feil

    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()...
  8. oggstar

    Hiding feilds in a form based on the users input in a particular feil

    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...
  9. oggstar

    Dcount

    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] >...
  10. oggstar

    Hiding feilds in a form based on the users input in a particular feil

    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...
  11. oggstar

    Examples of Acess databases

    Thanks guys they were helpful
  12. oggstar

    opening a new record within a text box feild

    Thanks nickjar2 it most certianly works
  13. oggstar

    Examples of Acess databases

    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.
  14. oggstar

    opening a new record within a text box feild

    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...
  15. oggstar

    opening a new record within a text box feild

    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...
  16. oggstar

    Examples of Acess databases

    Hello Is anybody aware of websites that contain examples of effective well designed Access databases. Which include Access form functions, queries, macros, Releationships Visual Basic Code. I am after a database to provide a learning tool that i can use to get a better understanding of the...
  17. oggstar

    format text in form view

    This appears to be a fairly simple task. I am trying to format individual records in form view. (the field is in a memo box). However my formatting (form report)toolbar is selected however all the options (eg bold underline, italics) are basically switched off and not allowing me to format...
  18. oggstar

    Combinding Datediff and iIF functions in a form

    I have two variables, date lodged and date determined. I am simply trying to establish the difference in number of days between the dates entered in a form. This is to be displayed in the form under the field name “number of days”. There are two scenarios to determine the difference between...

Part and Inventory Search

Back
Top