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 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: *

  • Users: mshetti
  • Order by date
  1. mshetti

    Creating a recordset

    Dear paultervit Yes I think this is possible, please read some help for creating recordset. At now I do'nt have any code and will take some time to write this. I will paste it here tomorrow. Best Regards Mahesh
  2. mshetti

    "Physical Database not found" in CR8.5 in VB

    Dear BWinkler If you are using a DSN to execute your reports then you need to copy the p2sodbc.dll file to the system folder and register it using the regsvr32 command else if you are directly connecting to the AS400 server (i.e with out the DSN) then you need to copy the respective dll eg: if...
  3. mshetti

    Importing a text File into database

    Dear WolverineLogan Take a look at this code, I import data from a text file the column delimiter is a pipe "|" and the rowdelimiter is "\n". Create Table #Temp ( ClientName varchar(25) NULL , CategoryName varchar(15) NULL , InventoryNumber varchar(20) NULL ...
  4. mshetti

    Primary key?

    Dear derketa Ypu donot need to refrence the identity column/field in your SQL statement, and on adding a new record the identity column will automatically get inserted with the value of max (identity value before the insert) + 1. Bye mshetti@yahoo.com
  5. mshetti

    AppActivate not working

    Dear GlynA Try setting the zorder to 0... form1.zorder 0 if this does not work... add on more form (form2) to ur application and load the actual form (form1) from form2... eg: form1_Activate() form2.show form2.zorder 0 and the use appactivate(form2.caption) Hope this helps. Bye...
  6. mshetti

    to save data in flexgrid

    Dear Akshita Here is a solution for ur problem...hope it helps... I have a MSFlexGrid, Textbox, Command button...I use the Northwind.mdbDB's employees table to create my recordset. Option Explicit Dim con As ADODB.Connection Dim rsd As ADODB.Recordset Dim intI As Integer Private Sub...
  7. mshetti

    table relation problem

    Dear craigk Can you clarify this a bit more... &quot;I want to know how many records in table &quot;A&quot; <> value C.&quot; Bye Mahesh mshetti@yahoo.com
  8. mshetti

    help Web integration with CR8

    Dear dreman Please look for help under &quot;Crystal Web Report Server&quot; in help available for crystal report8 Bye Mahesh mshetti@yahoo.com
  9. mshetti

    Urgent Hai I am Using Crystal re

    Dear Darshu If your subreport is linked to a main report, you do'nt have to explicitly open the subreport. Bye Mahesh mshetti@yahoo.com
  10. mshetti

    suppress subreport!?

    Dear andreako, try this... right click on the section where the subreport is placed goto format section and check the &quot;Supress if blank&quot; option there. Hope this helps Bye Mahesh mshetti@yahoo.com
  11. mshetti

    Using a form twice in a program

    Dear Shane Brennan Try this... loop thru the forms collection for each frm in forms if typeof frm is form1 then msgbox frm.text1.text end if next Hope this helps Regards Mahesh mshetti@yahoo.com
  12. mshetti

    UN login to access db passed to another form

    Dear Peter Try this... Create a table as users in ur access DB which can have cols like UserName and PassWD Get a connection to the DB first and then ask the user for his username and passwd then query the users table like... Select Count(UsedName) From users Where username = '' and passwd...
  13. mshetti

    Hi ! I have grouped 3 different

    Dear rpathy I do'nt think we can do this... Regards Mahesh mshetti@yahoo.com
  14. mshetti

    shell execute parameter

    Dear ghobbes98 can you provide more details on what r u executing using the command...Why do'nt u try shell function which is used to run a excutable program Regards Mahesh mshetti@yahoo.com
  15. mshetti

    Using a form twice in a program

    Dear Shane Brennan Try this... Create a form name it form1 which may contain a text box to which u write ur notes and another one form2, add a command button on form2 name it cmdStickNote in the click event write this dim frm as new form1 frm.show so every time u click the cmdStickyNote...
  16. mshetti

    addition in data grid

    I don't think u can do it using MS DataGrid 6 oledb...Sorry I also replied ur mail regarding..this is only in case u don't receive the reply Regards Mahesh
  17. mshetti

    addition in data grid

    Hello akshita, If you r using MS DataGrid 6 (OLEDB), then you must check the &quot;AllowAddNew&quot; check box in the property page for the grid. Hope this helps Regards Mahesh mshetti@yahoo.com
  18. mshetti

    Grid with combo box

    Dear ahi, I have been using apex true db grid for a very long time and am quite satisfied with it, it has some excellent features whis common grids don't provide and is very easy to use. u will get a trial version at www.componentone.com Regards Mahesh
  19. mshetti

    Date format and right aligment in True DB Grid

    Dear Devriendt ur 1 problem... if ur setting the allowfocus property to false for the date column then the alignment property changes for that column, i mean i used to come across this problem when i used to do so. if ur doing the same then try reinstalling the TDB Grid again. Hope this...
  20. mshetti

    List(index) Limit crossed

    I think the max limit for the numbers of items in a combo box is 32736....and u r crossing the limit for the no of items in a combo box. Regards Mahesh

Part and Inventory Search

Back
Top