Search results for query: *

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...

...set) her is the code remember i am using SQL SERVER back and ADP front '---------------------------------------------------- Sub SeparateEmails() '*** error trapping - execution goes to bottom on error On Error GoTo Err_SeparateEmails Dim db As Database Dim qdf As QueryDef Dim strSQL As...

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

Dear All I have an ADP form back is sql server now i want a texbox in my form , with a button any thing i write in box , it should search any value in the corespondent filed in table.... it must work like google search engine or .... regards

I have a Form with boxes and a button , when i write criteria and click the button records are filtered ,on the current form and i can see the result very well, now i want to send all these records to a report after i click the button, this is the code i have for the button and boxes...

Dear Payback, what i said before , is what i seen somewhere , when they clickd the button all the records from access exported to excel template and automatically placed in the cells formated in excel and i think it needs alot of codes cheers iam witing for reply thanks

Dear All, I want to export tables from database access to excel but , i want to have a template ready made in excel and when i do export the table records, it should go to that excel template file with pre formatted culmns regards

Dear All , here is a simple and great solutions first make an unbound form then two buttons , name of them lock and another unlock behind the lock one put this code CurrentProject.Properties.Add "AllowBypassKey", False and behind the unlock put this code CurrentProject.Properties.Add...