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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.