Search results

Thanks for your help, I realised it was so simple just to Hide the 'Event' field on the query so that it wasn't a determining factor of a unique entry.

I probably should have specified, but I dont need to see what 'events' they went to. All I want is to see how many unique people have been. I just need to see that Joe came. I just want to have 1 field in the subform display unique values. I dont care about the other fields :P

Hi, I have a table with thousands of patron details. In this table I have a field for 'Events'. Regular patrons obviously come to multiple events. So, this is a rough example of my table; Name - Event Joe - Concert Jim - Concert Mary - Dance Jane - Concert Tim - Dance Joe - Dance Mary - Choir...

I came to the conclussion that the report was forgetting the parameters and so implemented a form to pass the parameters which I found an example here: http://www.access-programmers.co.uk/forums/showthread.php?t=173661 Now, because there are soo many records with so many possibilities being...

Hi, I have a table that has an event field and several date/time fields eg: Event-----Date1---------Date2---------Date3 etc Expo------01/04/2010----24/03/2010----10/03/2010 Expo------01/03/2010----24/02/2010----10/02/2010 Expo------01/02/2010----24/01/2010----10/01/2010...

I dont want to exclude addresses. The only addresses to show up are those relative to a category selected by the user prior to the addresses appearing.

If you can dig up that macro to copy and paste the entries I'll be set :) Thanks for your help Matt

The EmailAddress is not a mandatory part of my original form which I use to enter all of my Contacts info into. The second form, that I am working on now, will be used to send Emails to those that have given an Email Address, hence why I need all addresses to end with ; On the Subform I have...

Ok I have got it working with this code, Now whenever I update the EmailAddress and hit enter to move to next field, it will only add the ; to EmailList if EmailAddress is not NULL :) Now I just need help with grabbing all of the Emails from EmailList and add them to my text box called txtBcc...

I use 2007 at home but 2003 at work, home is set to default version 2002-2003

if not, yes I have A2007 at home, but work only has 2003, so I have my version set to default version 2002-2003

do you have msn? if so could you chat with me there?

heh i got that part working, but as an on update of the EmailAddress Field, the only problem is if the EmailAddress Field is blank, EmailList still shows the ; How can I skip a field if blank, ie If Me!EmailAddress = Null Then goto next record???? Else Me!EmailList = Me!EmailAddress & "" &...

That sounds like it would work perfectly. I'll try work on the new field to combine emailaddress and ;

that would be perfect, how do i go about formatting the new field?

that should work perfectly, should i start working on the extra field and just use a similar to this? EmailList = EmailAddress & " " & ";" would this actually work?

I probably should have mentioned that there could be hundreds of email addresses listed in the subform :( which is why I'm after an automated action.

Hi, I have a form with a subform. On the main form I have a combobox to select a category. The subform then displays all email addresses linked to that category. What I now want to do is (by double clicking (on_dbl_click) my BCC textbox (shown below)) grab all of the email addresses and put...

Hey Mick I worked out the problem. My ID field had autonumber and primary key so i deleted the field and ran a macro that select the fields like A1:O398 with contains field names(identical to my table) and it worked like a charm. Once all data was there i re-added the ID field with primary...

Thanks for your help, I got it working thanks to you :) Now if only it would let me import the data from Excel... When I try to import the data to an existing table it gives me an error with no message other then the import failed. I tried importing the data to a new table but this time it...