Search results for query: *

Is it possible to make a form field mandatory based on a condition. I have an on-line form and want to make a field called Reason mandatory if the answer to the previous field "Connection Required? is Yes (or True). I'm not much good with coding but can work my way through it if someone can...

Thank you

My Access form draws its data from an SQL database. Some of the fields are Y/N and are marked in SQL as bit fields. What I need is some guidance on how to display these fields as either Yes or No on the Access form. I have tried =IIf([fieldname] = "0", "No", "Yes") but not successfully. Is...

We use on-line (intranet) forms for collecting various bits of information. When submitted a Confirmation Page is printed using onload="window.print() method. We would like to be able to email this page instead of printing it. I know it can be done by using File Menu > Sned > Page by...

The tables are related by GNumber – this field appears in every table. When I first built the database I had a date in each of the tables thinking that the tests might be carried out on different dates but I understand that is not the case – all the test are carried out on the same date but...

Many thanks Ken for your reply. Sorry, I’m not really sure what you mean – could it be something to do with the way I created the form? This was by first creating individual forms then dragging them onto the various pages of a new ‘multi-page’ form. Basically I have a form to add a new...

Hi, I have a database that tracks data on patients through a series of tests. Results are held in separate tables - ie: heart rhythms in the Rhythms table, drugs taken in the Medication table etc. The results of tests are entered into a form which uses tab control - 8 pages - the patient's...