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 Chriss Miller 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. aliiiish

    How to create a User Interface

    Hi guys, I forgot to mention that I will need to enforce some rules on the fields. For instance, if the user selects Product A, he will be prompted to enter 3 fields but if he selects Product B, he is prompted to enter 2 fields. Thanks, AH
  2. aliiiish

    How to create a User Interface

    Hi guys, I would like to know if there is a way to create a user interface in Access. I just need a simple UI, where I can prompt the user to enter some data. Thanks for your help. AH
  3. aliiiish

    Select and Indexes

    Hi, Assume we have the following: CREATE TABLE test1 ( id integer, content varchar ); & CREATE INDEX test1_id_index ON test1 (id); CREATE INDEX test1_content_index ON test1 (content); Which Select statement would perfom better? 1) SELECT content FROM test1 WHERE id = constant; 2)...
  4. aliiiish

    Passing data by referencing or by data field

    Hi guys, I have a general question.who is more perfomanant: Passing data by Referencing or by data Field. When I was asked this question, I answered that passing data by referencing is better or faster since here you are accessing the memory directly to perform your action, whether it is a read...
  5. aliiiish

    Select and Indexes

    Hi, I would like to know if there is an optimum number of indexes that can be used with the Select or if not, is there a way to find out (by column, by table). Thanks for your help. ASH
  6. aliiiish

    General Question about the Select Statement

    Hi, I would like to know if there is an optimum number of indexes that can be used with the Select or if not, is there a way to find out. Thanks for your help. ASH
  7. aliiiish

    How do I group

    Hi all, I have this stored procedure and I want it to produce the results to GROUP BY Style1, Style2, StyleColor, Whrse_No, Bin_No ...... This procedure is used by a crystal report file to produce a report.... Below is the code: ( I think that the problem is in that some fields which are not...
  8. aliiiish

    Beginner's Question

    Hi Guys, I have this rpt file and I was wondering how do u edit the file. I want some of the fields to get the value from anoth location ( i.e I want to change the location)....Could it be done form the report or it is always done from another function or so.. Thx alot
  9. aliiiish

    Beginner Question

    Hi Guys, I have this rpt file and I was wondering how do u edit the file. I want some of the fields to get the value from anoth location ( i.e I want to change the location)....Could it be done form the report or it is always done from another function or so.. Thx alot
  10. aliiiish

    ADODB

    I want to know how the nbatchsize is calculated
  11. aliiiish

    What does '' inside the "" mean in Sql

    strSQL = "SELECT setting_value FROM _setting WHERE Setting_Name = 'Interface_Installed'
  12. aliiiish

    ADODB

    Hi Guys, It is the first time I use ADO and I cannot really understand how the batch size in this code is being calculated....A brief description would really be helpful. <% dim nBatchSize strSQL = "SELECT setting_value FROM _setting WHERE Setting_Name = 'Interface_Installed'" SET...
  13. aliiiish

    New Sql Programmer: Help Please

    Hi Guys, I am a new programmer and I was given a code to fix....I just would like to know what does this portion of code do (i.e the write flag part): Description: Exports Style info to flat file. CREATE PROCEDURE dbo.msp_EIExportStyleCornell @intSessionNo int , @intType int --...

Part and Inventory Search

Back
Top