Search results

Thanks Darbid, i will give them a try. Everything seems to be working task creation wise it just doesnt hold the data that has been filled in!

Hi Sorry for the reply, doing this at work and i dont work weekends :) The task and the first tab (which is outlook default) is filled in and the task/date is set in the other persons task list as you would expect, its just the custom form that we have designed that isnt filled in. I have...

Hi and thanks for the reply. The form is designed to be a 2nd tab on a task (In the Task pane view File > New > Choose Form > Look In 'Tasks' (where it is published) and then chose the custom form). You get the standard information as you always do in Outlook on the first tab, but the 2nd tab...

Hi All I hope somewhere here might be able to answer what should be a simple question! We are a Corporate Outlook user so we have all our emails on Several Exhange servers, i dont think this would be an issue but a bit of background doesnt hurt. We have designed a custom Task Form that you...

Ahhhhhhhhhhhhh I see it now, doh for not reading. Showing that and trying it :) Edit: Yey, it works. Thank you so much :)

I think that's the problem, i dont actually see a "Consultation" footer you are speaking of and i dont know how to show it. I hate using Access for reports, its a two second job in Crystal Reports :( Hopefully ive attached an image of what the design of the report looks like, if you could tell...

Hi Thanks for replying, there is a group on Consultation Name set on the report that is set to keep these together as they could span pages. Im already using the Report and Page Header/Footer so im being dense and not seeing what you are suggesting. I have attached (i hope) a Report.txt file...

Hi Sorry to barge in on your thread, but this is really close to what id like to do! I to have a report that produces any number of records, in this instance they are Consultations. Each consultation has a Area of Interest so you could get 3 or 4 lines per consultation. I have used the field...

Worked like a charm, thanks all :)

ElapsedTimeString looks perfect, trying it out now! :)

Never have much luck at functions, i'll have a google and see what i can find. Thanks :)

Hi All I have a little form, that is used for recording time spent on a task, mainly receiving a phonecall. It has other information on it, but for this task we are just working from the start time and end time of a "call" So, i have fields and they have the time in. When the record i want the...

I think this could be done with a For statement, ive no chance of writing the code cos its too early but something like counting the records to get the total, then doing a for each with maybe a do loop until you get to say 65000, put that in one spreadsheet/temp table, then for the next lot of...

Excellent, cheers for that it worked perfectly :) Scott

The code is used many times, so i make sure that it clears the defaults first so dont end up with crossed connections or anything. It took me a while to get this working, cos as you say VBA can be very annoying. I cant see anything wrong with the code you are using at all. All i can think is...

Hi I use the following piece of code to run an SQL statement on a server. Its in a module so i just use DbConnectionExecute(strSQL) to call it... Sub DBConnectionExecute(CommandText As String) 'Main Use: Delete Or Update Statements, SQL String Set conn = Nothing Set cmd = Nothing...

Hi All I have a piece of code that creates an email and sends it out to relevant people, using MS Access 2000. Problem is, i want to be able to add who its from, as we can send emails on other peoples behalf if we have access to their mailbox. Looking in the Objects i cant seem to see one, is...

Yeah, thats exactly what he means. It will have to be a SQL Pass-Thru query i think, you then just create a Query Def in the Code and then you can amend it via the code. Dim qdfCarer As QueryDef 'Assign the value of the form's PARIS ID to a string variable 'Assign the query...

Forgot about SendKeys, will have a try with that :) Bod: Not sure what the return listener is?

Again, logically that is sound however all the fields for a given day are not always filled in. A client might have care 7 til 8, 12 til 2 and thats it. Where as others might have 7 til 8, 9 til 10, 12 til 13, 14 til 15 and so forth...