Search results for query: *

Dear all, I have SQL back and Access Project ADP as front the problem is infact with ADP ... i have been using Acess and VBA for long , when i was using MDB simple access database sumif and or conditional sum like =sum(iif(A=9,amount)) they worked perfectly alright, but in ADP report i can not...

Dear all, Iam using back SQL server 2000 front ADP, in access report i cant use the IsNull function in access form I successfully used it. but in report it gives me the error of ... ("The expression 'Sum(IsNull([Amount])) is invalid Aggregate functions are only allowed on output fileds of the...

Dear All, Iam using MS Access Project ADP as Front back SQL SERVER. I have a main report (Matrix_Report45) having some 30 subreports, I want to change the control source of all subreports based on value choosen from a form. I put a simple code on behind the button on the from ... to open the...

I have a back SQL database with front end ms access ADP I have ArcGIS desktop 9.1 installed in my computer I made a form and inserted an ActiveX control of ESRI MapControl, It works fine in my own comptuer .... but when other users access the database through ADP connected to SQL SERVER 2000...

Dear all, I have a SQL SERVER with ADP Front. I put a copy of the ADP front for all my clients the original copy is in the server by time passes i usually update the front END ADP in the server. now my question is when ever client runs the front ADP it must check the current open ADP with the...

Dear all, I have a project back end SQL SERVER front end ADP access I want to run this SQL statement but iam faild to. i dont know what is the problem -------------------------------------------------- Dim SQL As String SQL = "INSERT INTO Forecast_NEW_TEMP_Table" & _...

Dear All, I have a SQL SERVER back end and Access project 2003 front end, everything is working smootly but now i have a form which has a button on it, when i push the button it executes or opens the Stored procedure and performs actions in the background. though this works best with SA login...

Dear All, I have a Main form and a Subform in it both forms are linked by a main ID which is CRIS_NO (int) both master and child are the same CRIS_NO in main and subform. now. The main form contains information about a Contract and the subform contains information of forecasted payments to be...

Dear smarts, any one can help with this trick? i am trying to import a picture of any type ... to ms access form but the problem is it comes with white background though i dont want this white background i want a transparent view, even i tried the property transparent in image property but...