Recent content by mshetti

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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