Search results

Hi, Been a while since I posted on here but altering the previous project I worked on... I am trying to create a mailing list feature for the database I previously worked on. I am doing this using an update query. My table structure is as follows: Contacts Title FirstName Surname...

Hi Guys, I have included a function in the database so as when a user enters an email address it stores it as a hyperlink. The user can then click on the hyperlink and it opens a new email message to that person. This is great when sending an email to individuals when using the database...

Hi, When I add a new contact to an organisation I get the error message: You cannot add or change the record because a related record is required in the table tblInstitution. This only happens if I add a new institution/organisation and then add a new contact to that organisation. However...

Hi there, I posted on here a while ago but cant find the thread. I'm having some issues with my database system. I think it is a problem with the relationships I have created and I cant seem to work out why it wont work. Incidently if someone can help me i'd be happy to provide an example of...

Hi there, I have designed an accounts management system and was hoping to use the import function, however I have some issues which I think are down to the relationships. I have two tables that I want to import the data to - InstitutionsTbl and ContactsTbl. I have ensured that the fields...

Hi, Not sure if you can do this but thought I may ask. I have created a contacts management system and in which there are multiple tables. One table is called contacts in which there are the two fields I want to append *date of contact* and *comments*. I want to append this information...

Afternoon all, Can someone help me - i'm building an account amanagement system in access and I would like to add an auto date field to a form I am working on...sounds simple enough you say - however here's the twist. I want the form to return the current date and time only when the user...

Hi, I'm relatively new to access but can just about make my way around. I just wanted help with building an expression to use in a query. Basically i want to put in a calculated date field called AwardExpiry, based on the AwardStart date in a table entitled "Institutions". For backgrounds...