Search results for query: *

that is what i am saying it should work as far as it is all access environment, but as the function IF and IIF with double I is different i think the engine of access differs, they dont work " I mean the function SUM(IIF()) and other conditional aggregate functions do not work if you have SQL...

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

Actually, I am going to Sum up the amount which contains some null values I have used this successfully in the Forms of Ms Access Project back SQL Server but in report it shows #error I dont know why? my formula is like =IsNull(figure1)+Isnull(figureb) that is simple working in forms but...

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

Code On Open of Main Report though i used different syntax references like Report_Matrix_Report45.MxYear1.Report.RecordSource Reports![Matrix_Report45]![MxYear1].Report.RecordSource Reports![Matrix_Report45]![MxYear1]!Report.RecordSource etc......but gettting that famouse error...

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

Dear PHV, I think that is the last possible thing to do. isnt there any other sloution perhaps...???? regards,

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" & _...

yes i can access the default database when i login, to QA. also i can exec procedures. but the question is when i put the user into SERVER ROLE (System Administrator) it works. but it never works with other ROLEs. if something would be worng with Access project it should not work with SA...

Problem was and still is with ROLEs , when i apply System Administrator Role to members they work fine ..as SA. but applying such role makes everyone as administrator... but when i create my own role and give specific permissions including to stored procedures ... they dont work... can you find...

jrbarnett > I just did everything you said. I set permission for ROLE and added the member to that role and also i give individual permission to user for SP. It is working with SA (DBO) very fine, but not with other accounts even having full permission i am really confused. is there anyother...

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

GingerR. That is great man ! it worked 100% thank you For anyone who faces this problem please create relationship between main and sub table. and also important make sure cascade updates are on. regards farzam

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

It worked but , i am calculating a 3.5 hours differenct but it seems that VBA is not calculating the decimals like 3.5 but it dose a fixed number like 3 any solutions cheers,

Dear All, I have found a good sloution for this... what you have to do is all simple, 1 -- create your picture with GIF without background, 2 -- Import it to MS Word. 3 -- Copy it and paste it to Access form 4 -- Set the back style (property of image) to Transparent and that is it. you will...

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