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

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

Just for the record, my ID field is number as in employee ID and I'm entering the data in form view.

Hi, Sorry, tried that and didnt work. I'm a relative novice at access so im a bit unsure of the lingo that you have put and how it works in VB - thought I had it but didn't work - any chance you could explain in more basic WYSIWYG terms? Thanks H

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