Search results

ok now this is the code i want to use to send the email but can someone show me how i get it to send a report as a rich text file (or any other viewable format) in this code. Sub sbSendMessage(Optional AttachmentPath) Dim objOutlook As Outlook.Application Dim objOutlookMsg As...

OK thanks i will try and let you know how it goes, thanks

OK im not an expert with acces or VBs script could you give me some help on writing the code.

Hello all, I have a query with the following code.... SELECT NRTS.[Item], NRTS.[Description], NRTS.[NRTS No], NRTS.[Serial Number], NRTS.[Cal Due], NRTS.[Allocated To], NRTS.[Image] FROM NRTS WHERE [Cal Due]=DateAdd("D",30,date()); What I need is when the query returns a record from the...

i cant work it out then why wont it work.

im using 2003 could that be why? cause it works for me on a 2007 but not 2003

Can someone tell me why this combobox on main is not working. Thank you for your time.

Thanks that has solved it

I need to run a query that will return all records for a due date within 30 days from the computers date this is the code i have so far. SELECT NRTS.Item, NRTS.Description, NRTS.[NRTS No], NRTS.[Serial Number], NRTS.[Cal Due], NRTS.[Allocated To] FROM NRTS WHERE [Cal Due] thank you for...

I set the combobox to one column and now it works thank you very much for your help.

The file is attached

Database is to large, plus contains sensative information, what i will do is delete a large part of the table but you should still be able to see what i want to do

How do i do that

So got a bit wrong in the coding. im not using docmd im using a a openquery marco in the afterupdate property sheet. the form is not based apon the query. the combobox im using gets its values from a diiferent query which is SELECT DISTINCT [Allocated To] FROM NRTS WHERE [Allocated To] IS...

I need the code or any help to be able to get a combobox to run a query based apon the value selected within the combobox, i also dont know how to make the query variable and linked to the combobox so that i dont have to produce loads of queries. I so far have this SQL code SELECT NRTS.Item...