Search results

Hi, Is there a way of creating a link to a Word document which I have written as a set of instructions for users of our database, and having that link appear on the main database switchboard?

How do I do this?

I'm sure there's a simple way to do this - how can I get Access to close down completely when I click the "Close" button on my database switchboard?

which is what I find strange because "ContactID" is an autonumber on the main contacts table assigned to clients, and this refers to the name of the client on the Calls sub-form, so why has it now stopped populating from the main form?

Our contacts database has a sub-form for recording calls from our clients. Apparently for no reason when I try to enter information into it, it has suddenly started displaying the message "The field 'Calls.ContactID' cannot contain a Null value because the required property for this field is set...

Thanks so much Peter, that's very kind of you.

We use Access 2003

Hi Dave, I use a date field to de-activate, this indicates the date the contact was deactivated from the list (therefore blank fields are still "live"). If I create a query to sum the records, how do I get that number to display on the total number of records on the form?

Hi, Our charity depends a great deal upon funding from the five local authorities whose areas we serve, the amount they award us depending upon the number of visitors we receive from their areas. Up until now we have operated a visitors-book system whereby we ask all visitors to sign in...

Hi, Our contacts database has the regular record navigation buttons plus the total count of records on the database on the bottom of the main form. This total is made up of all our contacts. However, as we "de-activate" contacts on a regular basis for whatever reason (moved away, deceased etc.)...

Thanks Gary, works fine now.

Hi, I'm trying to set up a label-printing report using the wizard. I am using a non-standard size sheet of labels on an A4 sheet where each label is 104mm by 58mm (ten per sheet), and have inputted all the measurements into the custom size screen, but when I come to preview the labels, there...

Both work - I new it would be embarassingly simple! Thanks

I'm trying to write a very simple query which will return everyone in my contacts database who does not have a date in the "case closed" field (NB everyone who is "live" as a contact). What do I need to put in the criteria of the query to return only the live contacts?

Thanks John that worked perfectly. Duly noted about the graphics too.

I've e-mailed it to you as its too big for the Forum size limitations

screen shot

This is the entire code behind the form in case anything is conflicting

LoneWorkerCaution

I've got all this code in place, but am still getting the "Compile Error. Method or Data Member Not Found" message whenever I click the LoneWorkerCaution tick-box. VBA opens with Private Sub LoneWorkerCaution__AfterUpdate() highlighted in yellow.