Search results

Thanks guys - looks like vba and loop will be the best way, and I will be able to extract many different sequence items in the same process with a bit of thought. Just got to dust off my old nested Do...While skills now!

A problem that I have had lurking around for ages now is how to extract or calculate the number of records in a sequence - e.g. in a table/query ordered by ID and date, the number of consecutive records by date for a given ID that have a value >= 50 in a given field. Is there a way of doing this...

Thanks Cronk; it is just as simple as putting the distribution list name in a string. I was getting an error, but it appears that this was because I had a list named XXX and another called XXX2, and when I specified XXX it couldn't decide which to use. When I renamed the first list XXX1, all was...

Is there a way of doing the above? I have several distribution lists (some >100 recipients) defined in Outlook, and would like to use the Docmd.SendObject command to send messages to one or several of them. I cannot find a way of defining a distribution list as any of the To, Cc or Bcc...

Many thanks for the response CJ - I had looked at that as a possibility but have no idea how I might code it. I was hoping there might be a way of specifying the 'level' for the relevant fieldname within the .Document statement, but my research thus far has drawn a blank - hence the query. It...

Forgive me if this is in the wrong place and feel free to move if it is. It may also be more of an HTML problem than a VBA one, but here goes... I am using Access 2007 to update a page on an external website (amongst other things) from an Access form using VBA, but that page has recently...

Hi all. Long time and entirely self-taught Access user from the UK with a previous IT background. Have used it in the work environment, but mainly at home to administer my local cricket league. Please don't laugh too much at some of my code!