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

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

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

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

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

Dear All. I want to output records from access form to excel but i want two thngs as follows 1- to exclude some unnecessery fields. 2- to make a template in excel , and while exporting the records from access should fit to that excel template. is it possible regards

Dear All, i have a from , with some 2 text boxes at the header of ther form, and i have a button this code below is behind the button when i press the button it should filter the data matchin the values from text boxes and thoes fields on the form. NOW, the problem is that it do filter but one...

Hi all I have developed a full Access Project Front end now i want something for security how to disable the bypass key (SHIFT KEY) inorder to make the front end more safer regards

Dear All, i have a little problem i want to count all records on the form it is working , but when i apply filter it does not count the filterd records it just conts all of reocrds always regards

Dear All , Specially Paul i have 4 or 5 text boxes on top of my form now i can do filter with one text box and a button when i click the button it matches the value in the box and a filed on the form , now i want to have 5 boxes which i write the values and it match all of them with fields ...

when i do apply fitler in ACCESS it works but when i use it in ADP , form , where i have a text box and a button , when i click the button , it says this messege "Can not apply filter on one or more fields Specified in the filter property" why this message appears any solution plz regards

Dears, as i was working with Access Forms i could create Text box with a button , behind button i would set this code to match and then filter up data inside a form. docmd.applyfilter ,"", "[Contract_details]![province]=[Forms]![filter_form]![Text116]" but now , iam using ADP .Access Project...

Hi dear all! I have developed everything , but now i want to have some calculations based on a query i can create anykind of query such as cross tab query in Acess , but i want to make a cross tab query in ACCESS PROJECT , so how can i do that please help argent Aliffi