Search results

Just an update. Managed to get the query to function by using Like "*B/S*" in the [Service Information] field. Thanks for the help Rich.

Thanks for the reply. I should mention that the database has alot of information held within it, and the acronym's are all ready used in a text field called [Service Information] which contains information for example "H/R (Heating Repair) supply and install divertor valve to heating system." I...

Hi everyone I have a database that I built myself and use on a daily bases for keeping track of customers and there service records for a small sized plumbing and drainage firm. The database has a function that is designed to automatically search for upcoming boiler services that are due or...

Hi I have a small problem with a label which runs from a formula and displays as "Possible Duplicate" on my main form when the First and Last Names are entered but already exsist in the database. I am trying to add a field to this fomula called "[Address]" so that the "Possible Duplicate"...

Hi all I am trying to figure out a way of automatically marking a checkbox called [Printed Yes/No] in a table called [Contacts]! that will check as No when a field called [ServiceDueDate] which has a data type of Date/Time is changed or updated. Thanks for any help. :)

I followed the update query soultion as posted by ejstefl which works perfectly. Thanks :)

Thanks for your advice I will give both options a go Thanks

Hi Everyone I am building a database for a friend of mine and I would like to give the user the option to mark all of the checkboxes simultaneously. The Checkbox field is called "[Printed Yes/No]". I have set up the command button which is called Check All and I would like it to function like...

Hi Oldsoftboss Thanks for your advice I will give it a try. Christopher

Hi I am new to the forum. :) I am creating an access database that holds customer information for a friend of mine. I am struggleing to think of ways to make Access do several tasks. I have created several forms that display when reletive buttons are clicked and some run automatically using...