Search results

thanks for that. i have some failsafes for my daily tasks. i used to have them on open of the database but the task scheduler not working correctly meant that on a sunday and monday when we are not in work the database did not get opened thus the daily tasks not being daily. i have gone down the...

thank you. i want to use this to run daily tasks. these tasks have been the bain of my life. now i wont have to worry about them at all. thank you

i have a real time clock. i want to run daily tasks when the clock is x something like If Me.txtClock = 10:15 then MsgBox "you have chosen to run at 10:15!", vbOKOnly, "Weldone!." the thing i am finding is that it doesnt liek the : so i put it in "xxx" and it still didnt work. is there...

i have just had a quick look around at the timer thing. does the timer start from when the database/form opens. if so then if i open the database at 01:00 and want to run a task daily then the timer will have to countdown from 24hrs. but if i open it up at 15:00 then it will run at 15:00 the...

the reason i use a task kill .dat file is that we might not always remember to close it. also i would prefer to fit to always be open. i like the sound of the timer event. i knew that there must be one but never knew anything about it. you did say however that you would lean more towards the...

in all honesty, i dont think i would ever have got that layout. thanks again

thanks. ive just been playing around with it, i got "Appointment Reminder: " & rs.Fields(Format(StartDate, "dddd d mmm")) & " at " & rs.Fields(Format(StartTime, "hh:nn")) & ". If you would like to cancel or change this, please ring Lytham on 01253 739432. Thanks Chrysalis." this time i didnt...

hi again. i am now trying to do this for another application. i am wanting to automate it. ie on open of a form it runs. im just struggling to refer to the record set. i have tried to follow what you did yesterday and what you have done today. ie rs.Field("etc") and " & Me.MyField & " but it...

can you tell me which part of this record set code tells it to loop through the records please.

i have had a whirl. if this is correct then it is easy. im guessing that nothing is this easy but i might be suprised. hopefully!! Sub DoSomething() On Error Goto Err_Proc Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("tmptblTextMessages") If rs.Recordcount <> 0 Then With rs...

thanks for helping me out so much recently. what i am wanting to do is send a message to every number that has the SendMessage = true. i was hoping that it would loop itself through all the records. how would i do this if the DLookup will only return the first record it finds?

i would like to know what i am missing in this sendSMS "118-324-1616", DLookup("[MobileTelephoneNumber]", "tmptblTextMarketing", "SendText" = True , " " & Me.txtTextMessage & ". Thanks Chrysalis." i have never used a true aspect in dlookup before. the results will also be many records. will...

in the main form i have two list boxes. one for item type. ie retail, treatments. the second lst box has criteria from the first so it will only show the categories within treatments or retail. then the subform below requeries and displays the client details that have had such treatments that...

the duplicates arise from the tables i need to get the info from. i want the client firstname surname and mobile number. this is deduced from the criteria of what categorie of treatments they have had in the past. which means i have to insert my tables that hold the appointments and the table...

would a way of doing this be by creating a temp table and having sql append records then get the data from that and then at least i will be able to edit it. or is there a better way.

i thought it was because of the grouping. how do it get it to show only one record for each client then?

i am having some problems with windows task scheduler. each night i have told the scheduler to run a .dat file to kill the access process, then a few minutes later( i have also tried hours later) to open my access database. it does do it when i first set it up but only once. i have checked that...

i have a form that has a record source SELECT tblClientDetails.FirstName, tblClientDetails.Surname, tblClientDetails.MobileTelephoneNumber, tblClientDetails.SentTextMarketing FROM (tblCategories INNER JOIN tblItems ON tblCategories.CategoriesID = tblItems.CategoriesID) INNER JOIN...

sorry, scratch that. i just tried it again and its working. Format(Me.OrderTime, "hh:nn") i think it was the space between the , and the first " that did it.

thanks. i knew i had to do something but wasnt sure what. just one last thing before i really make this wole thing very complicated. the time keeps coming through as hh:mm:ss. is the a possibility to format " & Format(Me.OrderTime,"hh:mm") & " i tried that but it didnt work. i think i have...