access 2007

  1. P

    Question How can i make auto increment in my textbox

    All i want is every time i finish the registration and I click ADD button I want my ID increase one . Like 1 , 2 , 3, ... Here's my code Try cn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source= " & Application.StartupPath & "\HMSdb.accdb") cn.Open()...
  2. M

    Overload resolution failed

    Hello below is my code, i got this error Error "Overload resolution failed because no accessible 'New' can be called without a narrowing conversion:'Public SubNew(selectCommandText As String, selectConnection As System.Data.OleDb.OleDbConnection)': Argument matching parameter 'selectConnection'...
  3. V

    Refresh button

    i have 2 separate forms. .both my first and second form has a refresh button when i refresh first button my second table not refresh..i want my table to be like this. my second Question whats the refresh button code in access 2007..i try many but unsuccessful.. thanks
  4. U

    Is Visual Studio the correct IDE to use for this project?

    Hi All I have a project I need to do for work, and I would just like to know whether VB would be the right way to go? I need to create quite a simple program in which our equipment can be booked out to various clients, and then a popup reminder comes up if the equipment is not returned in...
  5. S

    query db, delete based on results

    ok, I have what I hope is an easy problem to fix. i'm try to query a db, store to a temp table, and then query the same db, inner joined with first query. please help. I'm currently getting "access cant find table/query" error. I've tried putting quotes around tmp, and that doesnt work either...
  6. J

    problem with listview

    i'm having problem saving records in my listview into ms access database table , heres my code , Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim con As New OleDbConnection con.ConnectionString = "Provider=...
  7. J

    Datagrid export to Word

    Hello, I want to export my DataGridView to a table in a word document. I am not an advanced user and all the search i have done didn't help me! Can anyone help me ??? Also plz tell me what should i "Import" and what reference to add ? and what to do if the reference i wanted to add i...
  8. J

    Question Import daily file into Access Table

    Hello, I have a daily file that is downloaded into a directory at a specefied time. If the computer is off, it will download the files when network access is granted. Each file is a comma seperated (.csv). Currently I am running each file through a batch script, which replaces the first four...
  9. G

    Efficiently linking to an Access 2007 Database

    Hello all, I've got a quick question. I'm very experienced developping database interfaces using the MS Access 2007 VBA. I've just switched to Vb Net for various reasons. I've got the link with my database working, I can access all the info correctly. It was surprisingly simple to get it to...