Search results

I have a form where it is important for the user to know whether or not to contact an employer. If the data entered in the "Contact Employer" field states "No", I would like the next person to go into this screen to be fully alerted to this, ie. say, change the background colour of the whole...

In short - have these tables in a database, with junction tables to link where necessary as some are many to many relationships Current Event Table School Table School Contacts Table Employers Table Employers Contacts Table If I want to create a form to enter in an event and then select who...

I know it is possible to copy formatting from one control to another within a form, but is it possible to copy the whole formatting of one form to another form? Thanks Just1

Hi. Have a many to many relationship with a junction table to join. Events - of which there can be many, Employers - of which there can be many. I want a form to display an event and the employers involved in that event. And another to display an employer and the events they took part in...

Hi, a simple question I'm sure for all you experts... I have used drop down tables to pick one value from a list before. What if I want to select several? I have a list of employers who can offer training in up to 10 areas and would like to record which areas they can train in. How would I...

I have a client database and whenever a new client is entered, I want this to export to Outlook as a Contact at the click of a button. This command button has the code shown below. When all the fields are complete, the code runs no problem. However, should a field be missing, eg. the person...

Hi. I have a code which someone helped me with a while ago to put meetings into Outlook from information put into an Access database. I now want to do the same with contact details, so that when a new client is added to the database, their forename, surname, email address, telephone numbers...

After entering a forename in one field on a form and then entering a surname in the next field, can anyone help me with some code so that I get a message up to tell me if I have someone in the database already who has that exact surname and forename? Thanks Justine

Hi. I have a client record form which links to a client background form. A button on the client record form opens the background form and links the client id to display the relevant record on the background form. This works if I go into an existing client and open the background form, but on...

I know you can find and replace within a datasheet or field, etc, but are you able to search the whole database, ie. all the different tables to find a particular word? Or would I need to set up a query to include all the fields from all the tables and then search that in the usual way? Thanks...

I have a database which automates Outlook - it sends reminders and appointment details automatically. However, I would like to now automate Access from Outlook so that when an appointment is opened in Outlook, the relevant record is opened in Access and the appointment date can be changed. Can...

Code to send contact reminder tasks to Outlook, as promised. Just1 Private Sub Confirm_Date_of_Next_Contact_Click() Dim OutlookApp As Outlook.Application Dim OutlookTask As Outlook.TaskItem Dim strDatabasePath As String strDatabasePath = CurrentDb.Name Set OutlookApp =...

Hi - wondered if any of you could help me. I am self-taught on Access and have designed a quite basic database for a friend who owns his own company. This is a client contact database designed to hold information about his clients and their companies, but also to send reminders to Outlook when...

I am very new to writing code, and wondered if anyone could help. (1) I have put a command button on my form to add a new record, which works fine. What I can't get it to do is then to take the cursor to the surname field so that I can start typing in a new record. Can you help me?! (2)...

Quite a newcomer to code, certainly can't confess to understanding most of it, but have found this piece of code to get started with!!...... Sub ImportContactsFromOutlook() ' This code is based in Microsoft Access. ' Set up DAO objects (uses existing "tblContacts" table) Dim rst As...

I have created a form from a query. I have then at a later date added a new field to the query. I have returned to the form and attempted to add it to the form but it doesn't show the new field within the control source options. Does anyone know why? Do I really have to start all over again...

In one of my forms I have a date field. I have a macro button to send that date to appear on an Outlook task. Is it possible for my date field to appear in different coloured text once the macro button has been pressed, so that I know it's been sent and don't send it twice? Now I know that...

You would think something like this would be easy but it appears I have never downloaded the sample database Northwind and now (a) I cannot find my CD, and (b) I have tried to download from the microsoft website and I cannot succeed with that either. Why, I don't know. Perhaps I'm going mad...

I have a formula in a field which is conditional upon a couple of other fields. (In a client contact database - I have asked for the date of next contact to be dependent upon whether the client is classed as a decision maker, networker, etc, and to add on a certain number of days from the date...

I have used the lookup wizard to create a number of lookup fields across my database. However, according to my Access for Dummies book (!) the wizard should ask me if I want the records sorting ascending or descending. My wizard isn't doing this, and hence my lookup table contains the data in...