Search results for query: *

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

Try this technique. Substitute recordset to array faq222-6134

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

what data access technology are you using? ADO or DAO? do you mean that you want to put the data into table2 with no duplicates?? if you are using ADO then this is the code: Assume that you have a connection variable nameD dbConnection and your Table2 has the same structure as table 1...

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

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

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

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.

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)

'-------Code in the form where you place the datagrid object --- '-- assume that the name of the form where this code is: Form1 Public PKVar as string Private Sub DataGrid1_DblClick() '--LOAD THE DETAILS OF THE DATA INTO THE DETAIL WINDOW If rs.RecordCount <> 0 Then...

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

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

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

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

try: dgrdEmployees.DataSource = vwEmployees

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

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.

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

I have the code below... but it says: Incorrect syntax near 'FUNCTION' when creating a function. What seem to be wrong with the statement??? CREATE FUNCTION fn__k_payroll_compute_payroll (@co_code varchar(15), @payroll_period varchar(20) ) returns @retValue table (co_code varchar(15) not...

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