No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
12 Posted Topics
 | 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 |
| | 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 …  |
| | 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 … |
| | 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 ? |
| | MY code doesnt saves the data entered through dropdown box into access database |
| | 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 |
| | 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? |
| | 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  |
| | 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 … |
| | Is it possible to send mails without using MAPI controls6 reference files |
| | how will you generate a csv file after entering data through forms into access db.? |
| | 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 … |
The End.