Recent content by Aliffi

Any one needs to send automatic emails based on current form here is the code '----------------------------------------------------- Set myrecordset = Me.Recordset With myrecordset myrecordset.MoveFirst Do Until myrecordset.EOF DoCmd.SendObject acSendNoObject, , , "Email address...

PHV , Thank you very much for your kind reply I did it with replacing Set myrecordset = Me.RecordsetClone here is the final code '------------------------------------------------------ Set myrecordset = Me.Recordset With myrecordset myrecordset.MoveFirst Do Until myrecordset.EOF...

Dear All, I am trying different methods to send auto emails based on my ADP form (my back database is SQL SERVER 2000) here is an almost done CODE, but the problem is it repeat sending the email for only first record can any one please fix it to read the next record as well and then send the...

it still gives me that error of Runtime error 19 Object variable or with block variable not set any idea here is my final code this time it is on button click '------------------------------------------------ Private Sub Command18_Click() Dim rs As ADODB.Recordset Dim strEmailTo As...

hey lars7 how are you, i have the same probelm as you had , i am glad for you , you solved your problem but can you discuss it bit with me i used that ziped database which guides to automatic email .... i altered the code as below but it gives me a runtime error and says (object variable or...

Dear All, I have created this code to alert users with automatic email this is a function which i call to a click button. I am using SQL SERVER back and ADP front i face a problem 'gives me error on the below line (SET rs)it says 'Runtime-error "91" 'Object variable or with block...

Dears, I have a database back SQL Sy2k front ADP , I have a form and it has a sub form , now i want to filter my form with a combo box and a button and the button is going to alter a report with the filtered criteria and open the report restricted with that filter,. as it is a sub form , i...

It gives an error at the line Dim myRecordset as DAO.Recordset and it says Runtime Error 13 miss match type ??? Idea

Well, I have used your code with some slight changes as follows it is working but assume that i have 3 Tasks which is checked by a IF function for date_planed Filed to be higher than NOW() and it is under that loop , it checks the Field WEll but it sends only the first record for 3 msgs. it...

Dear all, I have a SQL SERVER back end db, front end ADP I am going to develope a monitoring form on contract based table. which will check if the Date is > Current Date then it will automatically sends an alert msg to person email i put this code to Form Load...

Dear All, I have an ADP File, back sql server, i distributed the ADP to client on the network now , when the clients open the ADP file i want to have a button on the switchboard when they click that the updated ADP file from server copy to their local drive , actually it overwrites the...

dear all i have and ADP which has a continues form i have a text box , its control sourse is a count function =count([field]) it counts all the records , but when i apply fitler, the records are filtered but the count remains the same , coutns all records i want the text box to show the...

It does not work mannnn i used recordsetclone , recordcount everything but not working any one can findout plz

dear! i have the same problem , everything is set with my ADP but same counting problem on filterd records i also tried alot , but i think it is a fault allover ADP and no one is present to come with a sulotion to this. wish some one who knows could see and help us or if you have found plz...

dear all it is a very small question but , i m stack into just some one tell me how to give the formula for count function to count the filtered records , after a filter is applied to an ADP form thanks