Search:

Type: Posts; User: ronelpisan

Page 1 of 2 1 2

Search: Search took 0.04 seconds.

  1. VS 2010 How to ignore saving records that can make duplicate before inserting to database?

    I have to import or copy the records from one database to another. My problem is it continuously insert records even if they are already existing. I want to control inserting duplicate records. I...
  2. VS 2010 Re: How to check duplicate records before inserting from one database to another ?

    Thank you for that Sir but I do not want to use textbox 1.text since the value to be checked is not from textbox1 but from a database field/column. So how to replace textbox1 with column/field...
  3. VS 2010 How to check duplicate records before inserting from one database to another ?

    I am able to check duplicate entry but using "WHERE name = textbox.text " clause within a windows form. Now, in this case the checking of duplicate entries is from one database to another. I want to...
  4. VS 2012 Re: How to find a record with same lastname and firstname and copy their ID Numbers?

    Thanks. Importing and linking the database make it works.
  5. Why is my MS Access database often corrupted?

    Every time it corrupted I do "compact and repair database" in MS Access. After it is repaired there are some records replaced with other characters (e.g. #####) the whole row of it. I delete the rows...
  6. VS 2012 Re: How to find a record with same lastname and firstname and copy their ID Numbers?

    I will try to link it.
  7. VS 2012 Re: How to find a record with same lastname and firstname and copy their ID Numbers?

    No. All combinations of names are unique in values.
  8. VS 2012 Re: How to find a record with same lastname and firstname and copy their ID Numbers?

    Sorry I did not included my initial input. Here is my code but it only works when they are in the same/inside database. What I want is it will also work in another database. Any suggestion please in...
  9. VS 2012 [RESOLVED] How to find a record with same lastname and firstname and copy their ID Numbers?

    I have a two(2) access databases, one(1) for the source and the other one(1) is for the destination dbase. The table of a source database and destination database have the same three(3) fields or...
  10. VS 2012 Re: How to detect one date field value is later/greater than the other date field?

    Thanks for the correction Sir. Sorry if I'm giving you the confusion.
  11. VS 2012 Re: How to detect one date field value is later/greater than the other date field?

    Thanks for your effort my friend but it still gives me an error: "Additional information: Syntax error (missing operator) in query expression 'COUNT (*) WHERE (Date1 >= Date2 AND Date1 BETWEEN...
  12. VS 2012 How to detect one date field value is later/greater than the other date field?

    I have one textbox(displays count result), one button(performs the counting), and two DateTimePickers(for date period from and to) in a form. I am using MS Access database for my program with two...
  13. VS 2013 How to get the computer name from other computer where my program installed?

    I have a shared program from other PC. I want to display into textbox the computer name from other PC where my shared program installed.
    Using "application.startup" the vb can detect where the...
  14. VS 2013 Re: How to add column and ignoring existing column in ms access dbase?

    Thanks my friend jmcilhinney. It works without even using "On Error Resume Next". You're truly genius man. Thank you so much.
  15. VS 2013 Re: How to add column and ignoring existing column in ms access dbase?

    Sorry for what I have done but this is the easiest thing to do. Do you have any idea or suggestion to modify the code and not using "On Error Resume Next"? Thanks.
  16. VS 2013 Re: How to add column and ignoring existing column in ms access dbase?

    Thanks buddy. I just put "On error Resume Next" and replacing column "name" with "fullname". Finally it works.
  17. VS 2013 Re: How to add column and ignoring existing column in ms access dbase?

    Thanks for your help my friend but it did not work. Same error prompted. Field 'name' already exists in table 'Table1'. Any modification please.
  18. VS 2013 How to add column and ignoring existing column in ms access dbase?

    The scenario is this. I have an existing ms access database. Inside the database has Table1. Assuming that I do not know what columns or existing columns are there already. My program using vb.net...
  19. VS 2010 Re: How to merge cells and put border on text after exporting datagridview data in ex

    Hello Sir. It's been a long time since I have posted this question seeking to merge cells. Thank you sir for your reply but I don' t want to merge cells this way: oSheet.Range("D9", "H13").Merge()...
  20. VS 2010 Re: How to merge cells and put border on text after exporting datagridview data in ex

    Hello Sir. It's been a long time since I have posted this question seeking to merge cells. Thank you sir for your reply but I don' t want to merge cells this way: oSheet.Range("D9", "H13").Merge()...
  21. How to UPDATE JOIN data from another database table with different connection string?

    I have codes below that can update and inner join data with another table within a database, also it uses only one connection string because they are both in the same database.



    Dim...
  22. VS 2010 Re: How to copy records from one database table to another database table?

    Thank you jmcilhinney. It works now. You're the man👍💪.
  23. VS 2010 How to copy records from one database table to another database table?

    This my code:



    Dim con1 As New OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=AMT.accdb ")
    Dim con2 As New...
  24. VS 2010 Re: How to convert this piece of sql code to oledb command?

    already solved. Thanks
  25. VS 2010 Re: How to convert this piece of sql code to oledb command?

    Thank you Gary for responding my concern. Actually it should be done by finding Fullname and Birthday for the exact. FirstName there is just an example. Any idea? I would highly appreciate your ideas...
  26. VS 2010 How to convert this piece of sql code to oledb command?

    scard and Employee_Records are tables
    empnum and FirstName(field/column of scard)
    Employee_Number and First_Name(field/column of Employee_Records)




    UPDATE scard INNER JOIN...
  27. VS 2010 Re: How to update rows value of specific column from another table's specific column?

    I don't want to insert or add new record, I want to modify/update existing rows.
    I just want to update existing rows of "empnum" field of "scard" table with the value from "Employee_Number" of...
  28. VS 2010 How to update rows value of specific column from another table's specific column?

    Hi friends. I'm new into this combination of sql query. I want to update all rows value of column "empnum" of table "scard" from column "Employee_Number"
    of table "Employee_Records". If two(2)...
  29. VS 2010 Re: How to merge cells and put border on text after exporting datagridview data in ex

    Thanks for the correction but I want to merge those cells(after the paragraph). Thanks.
  30. VS 2010 Re: How to merge cells and put border on text after exporting datagridview data in ex

    Thanks for sharing..but I want to merge those cells(after the paragraph). Thanks.
  31. VS 2010 Re: How to merge cells and put border on text after exporting datagridview data in ex

    Thank you sir for the correction.
  32. VS 2010 How to merge cells and put border on text after exporting datagridview data in excel?

    I want to merge and put borders around text. This text is comes after datagridview data.

    This is my code:
    Imports Microsoft.Office.Interop

    Public Class Form1

    Private Sub Form1_Load(ByVal...
  33. Re: How to add paragraph after datagridview data in excel using vb.net?

    Thank you very much man it works! I forgot to mention on merging cells in this cell "xlWorkSheet.Cells(lastRowForGrid + 2, 1) = "something here"". How to merge cells from range of 1st column(A) to...
  34. How to add paragraph after datagridview data in excel using vb.net?

    I want to add a text or paragraph after exporting datagridview data. I don't know how to add because there is no specific cell where I can put the text/paragraph or value and also because the data...
  35. VS 2010 Re: How to export to excel the autoincremented row value of datagridview using VB.NET

    Thanks..already solved.
  36. VS 2010 Re: How to export to excel the autoincremented row value of datagridview using VB.NET

    This is my revised code:

    For i = 0 To DataGridView1.RowCount - 2
    For j = 0 To DataGridView1.ColumnCount - 1
    xlWorkSheet.Cells(i + 18, j + 2) = DataGridView1(j,...
  37. VS 2010 How to export to excel the autoincremented row value of datagridview using VB.NET?

    I have datagridview with columns: FullName, Age, Birthday, Degree.

    The autoincremented row value displayed/located at the first column of datagridview that is automatically generated by the...
  38. VS 2010 Re: How to export data of a selected columns from database to excel using vb.net?

    Thanks..it works.
  39. VS 2010 How to export data of a selected columns from database to excel using vb.net?

    I have only one button on my windows form, a button that performs exporting of data from database to excel.
    It works in exporting but all those columns in database have exported. I want to export...
  40. VS 2010 Re: How to create dropdown list with source from another sheet in excel using vb.net

    Thanks it solved now.
Results 1 to 40 of 54
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width