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

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

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

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

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

Hiya im trying to add new records from one table to another, this will be done on a weekly basis. What i need to do is add new records to exisitng table according to Student Number, but because the same student can apply to many courses i need to allow duplicates I get error "Duplicate output...

hello have a quick short question i have 3 txt boxes (title, name, surname) placed horizontally in a report, i know we can do this vertically but is there anyway i can get them to resize according to the length of letters? or is not possible? thanks

Hello Everyone On a report i print the address from sql query the format is address line1 address line2 address line3 address line4 address line5 Country Postcode as address sometimes dont have all lines, sum fields contain no values so on report it puts a blank line, is there a way i can not...

Hiya i want to add todays date automatically after selecting some fileds so say i have records of students, by a sql query i can select all the records when students have withdrawn but then i need to add todays date to the "date field" for each record, does any one know how i can go about doing...

Hello every1 I have mostly read all threads on errors when appending records but i have no solution im trying to add new records from one table to another, i can do this successfully but i get the following error "Microsoft Office Acess set 0 field(s) to Null due to type conversion failure...