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!

  • Congratulations Mike Lewis 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: *

  1. patiya

    How to convert string Data into SQL 2005 Datetime Data...

    Hellow there, I have a SQL 2005 Table with 2 Columns: Column Name: Data Type: PERIOD_END_DATE Nvarchar(50) Date_Period_End Datetime ___________________________________________________________ Currently Data in Column's: PERIOD_END_DATE...
  2. patiya

    How to read Multiple Rows Data into single Record or String.

    Hellow Folks. Here is the Original Data in my single SQL 2005 Table (Common Column is Department# in rows): Department: Sells: 1 Meat 1 Rice 1 Orange 2 Orange 2 Apple 3 Pears The Data I am expecting separated by Semi-colon: Department: Sells: 1...
  3. patiya

    How to Send E-Mail (Parent - Child matching records) from SP

    Hi Everyone. I am using NorthWind as an Example: Parent Table derived from: Categories. I added a new Column E-Mail and Selecting rows where Category Id <=3. Here is my Data. Category ID Category Name Category E-mail 1 Beverages Beverages.com 2 Condiments Condiments.com 3 Confections...
  4. patiya

    • Help with How to Send E-Mail (Parent - Child matching records) from

    Hi Everyone. I am using NorthWind as an Example: Parent Table derived from: Categories. I added a new Column E-Mail and Selecting rows where Category Id <=3. Here is my Data. Category ID Category Name Category E-mail 1 Beverages Beverages.com 2 Condiments Condiments.com 3...
  5. patiya

    Import Excel Data does not work 1st time, then works all time

    Folks, I am using ADP (2K) from end, SQL back end. I am having a weird problem. I have a DTS Package that imports EXCEL data from Local Drive to a SQL Temporary File. 1) When I Execute the Package from the EnterPrise Manager, it always Works. 2) But when I start my ADP program (Below is...
  6. patiya

    Weird Problem..import Excel fails first time, then works

    Folks, I am using ADP (2K) from end, SQL back end. I am having a weird problem. I have a DTS Package that imports EXCEL data from Local Drive to a SQL Temporary File. 1) When I Execute the Package from the EnterPrise Manager, it always Works. 2) But when I start my ADP program (Below is...
  7. patiya

    Please help to Create Menu items

    Thanks Fancy and Bisman, Bisman, I like the Idea that you mentioned in #2. I think it is more flexible. But I only know how to create Custom Menu Bars using Access Tutorial. I do not know how to create Navigation controls or Create Menu bars in Form. If you have some tutorial or sample...
  8. patiya

    Help to create menu bar items.

    Hi there, I am designing a new Access 2003 database, hoping to migrate into ADP in the near future. I would like to create separate menu items like Access (such as File, Edit, View etc). And each of the menu items will have drop down menu pads (Ex. File Menu items have: New, Open etc). What I...
  9. patiya

    Please help to Create Menu items

    Hi there, I am designing a new Access 2003 database, hoping to migrate into ADP in the near future. I would like to create separate menu items like Access (such as File, Edit, View etc). And each of the menu items will have drop down menu pads (Ex. File Menu items have: New, Open etc). What I...
  10. patiya

    ADP/SQL Data Selection Criteria

    Thanks Nevermoor (Programmer) for your help. But If I need to return more fields such as employee Id, the grouping seems not working.
  11. patiya

    ADP/SQL Report Selection Criteria

    I am using ADP front end and SQL on the back end. I want to run a report based on these 2 tables. Table1 Data: Client Id Date Employee ID Record Source 23376 1/9/2004 128 Table1 23376 1/8/2004 30 Table1 23379 1/6/2004 15 Table1 23377 1/6/2004...
  12. patiya

    ADP/SQL Data Selection Criteria

    ADP/SQL Report Selection Criteria I am using ADP front end and SQL on the back end. I want to run a report based on these 2 tables. Table1 Data: Client Id Date Employee ID Record Source 23376 1/9/2004 128 Table1 23376 1/8/2004 30 Table1 23379 1/6/2004 15...
  13. patiya

    ADP/SQL Data Selection Criteria

    I am using ADP front end and SQL on the back end. I want to run a report based on these 2 tables. Table1 Data: Client Id Date Employee ID Record Source 23376 1/9/2004 128 Table1 23376 1/8/2004 30 Table1 23379 1/6/2004 15 Table1 23377...
  14. patiya

    Beginners learning help with ADO/ASP.Net.

    Thanks Omega36. Thanks for your help and suggestions. Appreciate
  15. patiya

    Beginners learning help with ADO/ASP.Net.

    Omega36, Thanks for your response. Could you please tell this book ASP.NET Unleashed is published by whom and author? Thanks
  16. patiya

    Beginners learning help with ADO/ASP.Net.

    I am using an MS Access 2k ADP (Converted into ADE) front end and SQL 2K on the backend. Although I taught pretty much myself into these concept with the help of some publications and users group posts, some time I would like to seek some specific help from fellow members. Now my organization...
  17. patiya

    Beginners learning help with ADO/ASP.Net.

    I am using an MS Access 2k ADP (Converted into ADE) front end and SQL 2K on the backend. Although I taught pretty much myself into these concept with the help of some publications and users group posts, some time I would like to seek some specific help from fellow members. Now my organization...
  18. patiya

    Disabling SHIFT Bypass Key for Users, but Not Network Administrators.

    I am using an Access 2k ADP (Converted into ADE) front end and SQL 2K on the backend. Although I taught pretty much myself into these concept with the help of some publications and users group posts, some time I would like to seek some specific help from fellow members. My Question is: Is there...
  19. patiya

    Disabling SHIFT Bypass Key for Users, Not Network Administrators.

    I am using an Access 2k ADP (Converted into ADE) front end and SQL 2K on the backend. Although I taught pretty much myself into these concept with the help of some publications and users group posts, some time I would like to seek some specific help from fellow members. My Question is: Is there...

Part and Inventory Search

Back
Top