Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~9K People Reached
Favorite Forums
Member Avatar for ponnu

I have vb form that accepts input from user,search in database(database acess) and displays matching records if any in the listview .The problem is that the search query will display only one matching record even if there are many matching records .anyone please help

Member Avatar for hannah_2
0
2K
Member Avatar for ponnu

I am trying to compare one column of an excel sheet with the database table.If the value in the column matches with the data in the table,the excel has to be populated with another value in the table in a new column.If match is not found the value in the …

Member Avatar for Reverend Jim
0
123
Member Avatar for ponnu

I want to populate combo box with particular field value of a table in ms access. datafile = "D:\database.accdb" With cn .Provider = "microsoft.ACE.OLEDB.12.0" .ConnectionString = datafile End With cn.Open Set rs = cn.Execute("select * from mytable") Do Until rs.EOF combo1.AddItem rs!name rs.MoveNext Loop cn.Close I am getting runtime error …

Member Avatar for ponnu
0
260
Member Avatar for ponnu

READ a text file line by line and store it into string if a particular pattern is found ,then output the pattern into differnt string ?

Member Avatar for ponnu
0
1K
Member Avatar for ponnu
Member Avatar for ponnu

I have vb form tht accepts user data.I need to check whether user enters emailid in the correct format ?Please provide suggestion .Thanks in advance

Member Avatar for ponnu
0
239
Member Avatar for ponnu

Runtime error 2147467259(80004005): The changes you requested to the table were not successful because they would create duplicate values in the index, primary key..How to catch the exception?

Member Avatar for G_Waddell
0
138
Member Avatar for ponnu

L1.ListItems.Clear Dim li1 As ListItem Set li1 = LV1.ListItems.Add() While Not (rs.EOF) li1.Text = rs(0) rs.MoveNext Wend rs.Close

Member Avatar for ImZick
0
164
Member Avatar for ponnu

GIVEN below is vbscript to connect to acess database and insert records into the table using forms Private Sub Command1_Click() Set rs = cn.Execute("insert into employee values('txtempname.text',txtempid.text,txtssn.text) ") rs.Close cn.Close End Sub Private Sub Form_Load() datafile = "C:\mas.accdb" With cn .Provider = "microsoft.ACE.OLEDB.12.0" .ConnectionString = datafile .Open End With End …

Member Avatar for pradipkar
0
2K
Member Avatar for ponnu
Member Avatar for ponnu
Member Avatar for ponnu

vb6 code to check if record doesnt exist,then insert new record.server is ms access 2010.So when i used the Dlookup function If IsNull(DLookup("[empid]", "[employee]", "[empid]= & txtemplid.text")) Then I got error like "function or subfunction not defined .is it due to issues with referencs .how can i fix this error …

Member Avatar for ponnu
0
2K