Hello I would like to avoid line brake in fileds by using validation rules. All other characters should be valid How can I do that?

Form:Form(1) View: Datasheet Record Source: Query(1) Table Source: Multiple tables Problem: Entering data into any control in a New Record causes the "Field...

Form:Form(1) View: Datasheet Record Source: Query(1) Table Source: Multiple tables Problem: Entering data into any control in a New Record causes the "Field...

I have a form with a subform that is viewed as a continuous form. To visually differentiate some of the columns I used a blank label as a background behind a...

I got the e-mail to open with the correct e-mail address, also got rid of the error message. Now I would like to be able to add a report to the...

Dear all, I've designed a database with two primary tables: 1) deactivation_requests 2) action_plans I have designed forms for both of these to allow for...

Dear all, I've produced a series of forms, which open as pivot tables when I select them from the database window view. All are a series of summary tables,...

I have designed two forms... The first details the particulars of a request and the second details any action plans associated with each request. I would...

Thank you to Doug Steele for helping me out with a Dlookup query. I've used this code on the 'Afterupdate' function of my patiendID field ("eNumber") to look...

I have three fields: - eNumber - Surname - Forenames I have two tables linked by the eNumber field - one with 1000s of patient details in (PatientTable) and...

I've written the following code to popup a warning message if a user goes to enter another record for a patient with a duplicate record id (eNumber). Dim...

Hi, I've created a database which keeps a record of appointments for a service in our hospital. There are two fields of importance in relation to this...

Presuming your handover date field is called "Handover Date", create a second text box and enter the following into the control source: =+335 (This presume...

Click on Tools--Startup In this pop-up you can select what you want the database to do when you start up. In the top-right of the pop-up box you will see a...

Hi guys, i have a quick one here, if i have set up a query to exclude surnames with "Z-" but have found that some fields have had "Z -" in them will these...

Hi could someone please help me with a small problem i have encountered i have 2 combo boxes on a form combo1 - software,hardware,servers,misc combo2 -...

Hi just a query guys i have a problem i have a form which contains information about devices with DeviceID as the primary key. This ID is the identifier i...

Hi, I am trying to set up a form that will display the reults of a query, then the user will be able to check of paticular records, and click the print button...

i am making a tab form with weekday titles. i was hoping that when in the monday form when you want to select a date it would only show monday dates. is this...

once i selected a value in the combo box i dont want it to be avalible to be selected again. this is in use as an appointment system eg. if i select a time for...