Search results for query: *

Thank you very much. Its working now. Indr.

Hi There, I wanted to know if there is any way to manupulate this type of string in sql. I tried couple of function but its now giving me what i want. Pleae let me know if there is solution of this kind of problem. In my database, [FirstName] is store as Joason P. or Mike H. or Jack ( Tom) I...

Hi there, i am having problem with combox related update, please help me. in my form i have a combo box whose record source is table/query. i also have other field inthe form. what i wantis when user select item number form the combo box the ohter field in the forms like item description, unit...

Thanks Richard, I am checking this and let you know once done. Indra.

Hi There, I converted access database to sql with adp file for the front end. many of our query was not working so i had to rewrite it and its come with dbo.table name etc. Now when i did everything and try to distribute the adp file to our users many of its function not working because those...

Hi there, I have a form in which there is one combo box.when user select any items from that combo box on the basis of that i want another combo box to display the information. this is in the same form. Is there any information how can i do this. the first combo box display all the items...

Thanks for the help. I will try this. Indra.

Thanks for your help, but i just wanted to know how can i write case statement in the adp forms or report suppose i have a field in form which is not directly comming from the query but its using field from the query and calculating it in the control as =Case when (

Actually now i included that field in table and as well as in query.

Hi Cmmrfrds, I have lots of iff statement in my form and report, which i could not able to use after i converted to adp from access db. here is the formula. =IIf(

Hi There, I have lot of iff statement in MS ACCESS mdb forms, which i converted to adp file. Some of the if statement i converted to case statment in query, but some of them i canot convert to query as i am using in forms. I change iff statment with case statement but its giving me error...

Its working fine with IsNull() function. Thanks you all for help. Indra.

Hi there, I have Nz() function in my access database which i converted to adp with sql back end. now my Nz() function is not working or displaying the message saying there is no function Nz() from my adp file which link to sql server. Could i please have information by which function i can...

Hi there, thanks again for all your help, but how can i fix the prefix dbo in all the object in sql. I donot know why filtering is not working with object or querry having dbo prefix. any inf. please. Indra.

I check the property in each field in report under other tab and name refer are same as they are in used. but still giving same error massage saying " aggregate function are only allowed on output fields of gthe record source". Thanks.

Thanks, I just in and will check this and let you know how its goes. Thanks very much for help. Indra.

thanks for help. Does server filter have problem with the dbo. When i migrate from access to sql, some of the querry (UDF) had problem and i had to redo that again which has dbo infornt of table or any slelct column. i am thinking when i set the server filter between form and report or report...

Some of the total are group total as a report header and some are report total in footer. Actually my sum function in report is as below: =Sum(([Service]*[ElectriclineBonus]/100)+([Mechanical]*[SlicklineBonus]/100)+([Expendable]*[ConsumableBonus]/100)) If you can give me bit brife information...

Do i have to specify the particular job number, if so this is not going to fit for our criteria. what i wanted is in my form it display all the active job and there is a button on each job inf. when user click that button, it should open the report only for that job number. so i canot specify...

Here is the detail explaination: SELECT dbo.Jobs.JobID, dbo.Jobs.JobStation, dbo.Jobs.JobStatus, dbo.Jobs.InvoiceDate, dbo.Jobs.JobDate, dbo.Jobs.JobUnit, dbo.Jobs.Customer, dbo.Jobs.Field, dbo.Jobs.WellName, dbo.Jobs.WellID, dbo.Jobs.WellQuarter...