Search results for query: *

Hi I have a form which reads a folder and displays all the word documents it finds into a textbox. The user can then select the file he wants from this list and lauch the document. I would like to add a un/bound frame that will display a preview of the word document selected. I have tried an...

I have a form which is linked to a main client eg. (father) and a subform which displays the children's details. The number of children in each family can vary. Could I populate a Word document with the full family details (client and all the children)? Y. ps. also I would like to know how I...

I have a function in my query that calculates the age from the DoB field. On my query I set the criteria Between [Lower Age] and [Upper Age] Where lower and upper age are parameters that the user fills in. In Access 97 this query works fine, however in XP it just produces random results...

I've made the query work fine! However on the criteria line I've added, Between [Lower Age] and [Upper Age] This asks the user to input a lower and upper age and will then only display the records that lie in between this range. This works in Access 97 but not on Access XP. Why? and how...

Where do I put the code for the BirthdaySoon() function? It doesn't like the [Days to go]:BirthdaySoon()& " days to go" line. Getting errors "Database engine can't find [days to go].."

I don't understand. How do I define a field in a query like above? Where do I put what?

I have a function BirthdaySoon() that returns the number of days left before a client's birthday. However I want to put this information on a report in sorted order from the nearest birthday until the furthest and maybe filtering out birthdays that are very far away. The design of the report...

Example At the moment I have the fields Class, Pupil and Hair Colour in the table format Pupil Class Hair Colour W 3a Yellow X 3a Red Y 3b Yellow Z 3b Blue .. .. .. I would like my report to do this Report showing Pupil's...

I have two tables which are of different recordset, A and B. Both tables have a similar field ReferenceNumber. TableA contains miscellanous information TableB contains the Name and Address fields. I would like to create a table/query where it would show me ID Name Addresss...