Search results

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

Sorry for late reply I have but it puts date in all the records, when i only want it to put date in the top 50 i select!! :(

yeah ive had a look and not really found what i need thanks anyway i have another question based around this query if i use select top 50 then if i want to update the top 50 with say todays date in the date field is there a way i can do that? As everytime im trying to change the select query...

thanks for reply but i dont have a date field that i can use i have tried using the top value but i would like the user to type in the number of records like a parameter e.g. show me 100 records then maybe next time the user only wants to see 25 then maybe different next time any more ideas?

Hello everyone need sum help stuck on a simple query im trying to create a basic query which prompts user to type number records they would like to view, so say we have 5000 records, from the 5000 the user only wants to see 100 or 50 or 20 how can i go about doing this thanks

This is quite simple but im finding it quite hard to cum up with a solution i have 2 select queries from one table which give me different results, i would like the results to come togther and add to another table I have also done this as 2 seperate append queries which works fine but would be...