Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: indraT
  • Content: Threads
  • Order by date
  1. indraT

    Manupulating string in sql

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

    Problem with dbo access, please help.

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

    Two combo box in the same forms.

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

    Can we use Case statement in ADP forms.

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

    Nz() function in MS ACCESS, WHAT WILL BE THE EQUVALENT IN ADP OR SQL

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

    Problem with aggregate function.

    How can i write aggregate function in report in the adp file. I have a query with expression. like a+b and give the alias name as service a+b+c and give the alias name as mechanical I want to use this service and mechanical in my report as =Sum([service]*2 + [mechanical]02.5) when i run...
  7. indraT

    Filter from form to report in adp front end

    Hi there. I was using MS access database and now i migrated to sql server keeping front end as it is with adp file, but most of the filter is not working. I have a form which display all the active or completed job. in the fomr i put the button when user click it will display a report related...

Part and Inventory Search

Back
Top