Recent content by harryfraser

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...

I'd disagree with that smig - it sends each email individualy.

Hi Bob, Sorry I'm a bit confused by this. Do I have the foreign key as a lookup field? I also made the institution the primary key as it is unique - why do I need an autonumber in this case? Isn't the purpose of the primary key to be a unique identifier? Just to clarify I wanted the user to...

Just the trick...cheers!

Hi Chris, Sorry, just realised there is a # at the end of the email. How can I get rid of this too? The rest of code is fine to remove the 'mailto' part. Thanks Harry

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 Bob, Neither of these i'm afraid, unless you're referring to the primary key/foreign key? In the contacts table I have the primary key for the institution (i.e. institution name is the foreign key in the contacts table)? Any other ideas? Thanks Harry

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...

It just says could not import table from source.

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...

Ok, sorry iff this sounds a bit daft, i'm having one of those days... How would I go about creating my new table? I assume that I would need something along the following: *Comment ID (PK) *Employee ID (FK) *Comment *Date of comment That about right? H

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...

ContactsSub

Hi, Please find attached a copy of the file I am using. I have attached a briedf description of what I am looking to to in the contacts comments. Cheers Harry