Recent content by Keith Sparkes

Many thanks for this, you have been a great help! I will have a play to see if I can get it to work and should be able to now after your great help.

Many thanks for this. Being a fairly novice at this, do you think that you/someone will be able to help me code this. E.g where should objMessage = CreateObject("CDO.Message") go in the loop as well as where the subject should go to? Once again, many thanks for all your help, it is much...

I am trying to send emails using CDO to different email recipients based on fields in a simple table called tblEmailRecipients. There are currently 2 records in the table. When I run my code, 2 emails are sent but the subject and text body are the same as the first record in my table. What I...

I'm sorry, you have lost me!! I will try to explain where I trying to come from. I have a simple macro that imports a text file. Within that text file I have some dates and times. I need those date and time field to change from text fields to date and time fields. If I change the import...

Thanks for this - but does anyone know how to run a query via a macro please?

I have an import routine which imports a txt file into a database via a macro which works really well but I need to be able to change the date and time fields from text to date/time so that after import the table has all the correct formats. Is this possible through a macro so that after the...

Excellent - thankyou, works a treat!!

I want to format a time to hh:mm:ss and I can only see the option for Long Time that gives me hh:mm:ss plus AM/PM. Does anyone know if and how you can show all time formats just as hh:mm:ss not including AM or PM? Any assistance would be most appreciated. Many thanks, Keith

Thanks GumpyD - works perfect!!

I have a simple portrait report that has hundreds of pages and I have a lot of un-used areas. Is it possible to have the report so that the 3 colums that have the data in them on the same page more than once? I.E: - Date User Duration Date User Duration Date User Duration I hope...