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!

  • Congratulations bkrike 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: *

  • Users: oggstar
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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] >...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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