Recent content by ashley1

can anyone guide me in the right direction when sending my email using DoCmd.SendObject i would like to attach a image at the top of the email is that possible? thanks

Hi Below is my code to send emails What i want to do is change font styles Is it a possible to get strEmail2 bold? also how would you get text to change font size/colour? Dim rsEmail As DAO.Recordset Dim strCustomerNo As String Dim strCustomerName As String Dim strEmail1 As String Dim...

that didnt really work it bought out no records i think this mite have ((Main.PostDate)<=Date()-14)

hmmm not what i quite want its pulling out all dates bascially what i want the query to do is pull out records where the date is 14 days old so if it has date 25/05/2005 then dont bother with that record but any dates 17/05/2005 and 16/05/2005 then pull out

i want all records that are 14+ days old So i have field "PostDate" if the date is 14 or more days old then pull out that record!!!!

i got no results at all no errors i put the DateAdd("d",-14,[PostDate]) in the PostDate Field in a query so my query looks like this SELECT Main.[Student code], Main.[Address Line 1], Main.[Address Line 2], Main.[Address Line 3], Main.[Address Line 4], Main.[Address Line 5], Main.Country...

can any1 help???

i have tried but its not giving me any results this is what i use DateAdd("d",-14,[PostDate])

Hi Every1 I need sum quick help I want to pick out the date from my table that is 2 weeks old? Any ideas how to do this? thanks

That does bring out duplicates but how would i when clicking the print button allow to print one duplicate The query is updated with current date so cant use Select DISTINCT Top 100, otherwise that would have been the best solution.

anyone? :(

Hello everyone I have a little print problem I have a student database with student code, addresses, names etc. Because there are so many records i nedd to print them in batches of 100 i did select top 100 but i have duplicates Is there a way where before a reports gets printed to check to see...

thanks will try the coding much appreciated dalien col i cant split my tables up due to the way our database runs, we have to have all the information in one table thanks for ur help,

its duplicate in the sense that a student can apply to more then one course tableA gets imported weekly by an excel sheet so the data changes, thats why we have tableB as a main table

Hiya Need sum quick help i have 2 tables tableA and tableB by queries i used to add any new records from tableA to tableB and allowed duplicates, but it doesnt give me accurate results. (id number is generated automatically but the id number changes to every record) This basically doesnt add the...