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 derfloh 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: tonioJ
  • Order by date
  1. tonioJ

    How do I put a flash movie on a web form?

    Try to add this code in the HTML view. <OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/ swflash.cab#version=5,0,0,0"; WIDTH="550" HEIGHT="400" id="temp" ALIGN="" VIEWASTEXT>...
  2. tonioJ

    Max Array Size

    Try this technique. Substitute recordset to array faq222-6134
  3. tonioJ

    Stop Mouse click on form

    @Wayne, are you using MDI form? If yes, there should be no problem with this. if you are not using MDI form then try this code on the Command button event that will show Form2 private sub Command1_Click Form2.Show 1, Form1 end sub The code above will make the Form1 as the owner of...
  4. tonioJ

    Need Help in vb and access

    ...and your Table2 has the same structure as table 1. Private sub EleminateDuplicate() dim strSQL as string '---select the unique records and insert into table2-- strSQL = "INSERT INTO TABLE2 (select distinct * from table1) dbconnection.execute strsql end sub i hope this helps
  5. tonioJ

    array subscript out of range

    instead of using array try creating a recordset in place of array. this will fasten and make your data manipulation easier. you can add, edit, delete data easier than using array. You can access data directly using loops, find method in recordset. '---------- creation of Recordset that will...
  6. tonioJ

    Stop Mouse click on form

    try to disable the command button in form 1 after showing the form 2 and enable it back when form 2 is unloaded. on the form2 load event or activate events enter the code: form1.commandbutton1.enabled = false on the form2_queryUnload event enter the code: form1.commandbutton1.enabled...
  7. tonioJ

    Arrays----

    Instead of using these codes to check the if the items is less than 10 try my code: --Arrays2 declarations( I have same declaration for Array1) Private Count As Integer '----declare a multi dimensional array with initial value Private Array2 () As String Private MaxRows As Long Private...
  8. tonioJ

    How can I filter the recordset using IN Clause?

    Thanks for your reply. so how will i do it in ADO using filter? just like. rs.filter = "emp_no IN (1,2,4,6) i'm getting an error with this statement in VB.
  9. tonioJ

    How can I filter the recordset using IN Clause?

    I want to filter my recordset using IN clause is it possible? The filter should be like the SQL statement below. Select * from employees where emp_no in (1,2,3,4,5)
  10. tonioJ

    Datagrid double click

    ...dim strSQL as string Dim rsDetail As New ADODB.Recordset '--get the detail of the selected record ---- strSQL = "Select * from TableName where TablePKField = '" Form1.PKVar & "'" rsDetail .Open strSQL, dbConnection, adOpenKeyset, adLockOptimistic, adCmdText...
  11. tonioJ

    Cannot Hide datagrid column when using dataview

    Hello guys. Thank you for all your effort and reply. I got the code working. The error was pointed in this line: ds.MappingName = dGridSummary.DataMember I change it to: ds.MappingName = dGridSummary.Table.TableName
  12. tonioJ

    Cannot Hide datagrid column when using dataview

    Hello ThatRickGuy, thanks for your reply. the .Select Method of the datagrid pertains to select a row in the grid. But it doesn't hide a column in a datagrid. Can you please give me an sample code on how you do it? Thanks in advance :)
  13. tonioJ

    Cannot Hide datagrid column when using dataview

    Hello ThatRickGuy, I have seen the thread. But it doesn't point out to my problem.
  14. tonioJ

    DataGridColumnStyles noshow

    hello bCrowe, what have you done to solve the problem? got a sample code?
  15. tonioJ

    Bind a dataView to a DataGrid

    try: dgrdEmployees.DataSource = vwEmployees
  16. tonioJ

    Cannot Hide datagrid column when using dataview

    I have a datagrid that uses dataview for displaying the records. I want to hide some columns in the datagrid but It returns an error but when using a dataset it has no problem. The reason why I use dataview is because I am filtering some information base on the criteria set by the user. Is...
  17. tonioJ

    Executing Stored Proc within Stored Proc

    i figure out the problem on syntax error. it will only run in sql server 2000 not in sql server 7. thanks for all your replies.
  18. tonioJ

    Executing Stored Proc within Stored Proc

    by the way, I am using SQL SERVER 7.0 thank you for all the reply... problem still not solved
  19. tonioJ

    Executing Stored Proc within Stored Proc

    ...varchar(20) ) returns @retValue table (co_code varchar(15) not null, emp_code varchar(20), descriptn varchar(50), debit numeric(9,4), credit numeric(9,4)) /*Returns a result set that lists all the employees who report to given employee directly or indirectly.*/ AS Begin [My Codes] End
  20. tonioJ

    Executing Stored Proc within Stored Proc

    how about if i have to return a multiple records with multiple columns??

Part and Inventory Search

Back
Top