Search results

  1. Ryobi

    Open a form and run a procedure after the form is opened

    Hello, I have this little problem where I am importing data and want to import the data when the forms open iand display the status bar in the screen. If try to run the procedure the procedure runs however the forms does show until the procedure finisheed. I need the form to be open show the...
  2. Ryobi

    Appending data into a table in message.

    Hello everybody, Does anybody know how to append data from excel CSV into an existing Msaccess table ? The vba code I had DoCmd.TransferText acImportDelim, , "InputForm8596Form8597", [Forms]![frmTimeForceReports]![Txtimportfile] used to work, but I am getting error on the data because the...
  3. Ryobi

    griddataview duplicate data message

    Hello, I have this issue that perhaps somebody can solve using a gridataview in Vb,net. The column of cells need to be unique, so I am checking for duplicates when the cells are changed or added. If the cell are duplicates then I want to cell to be reverted to the old value. I have my code...
  4. Ryobi

    Coding for connection and data binding

    Hello, I am using Vb.net 2017. I have created a crystal report and connected an msaccess database to the report and have added fields using the connection on the crystal report. I would like to code the connection my self since the I want the database to place in different place in case I...
  5. Ryobi

    Multi Column Combox

    Does anybody know how to get multi columns in combo box ? I search on the net but so far no answer. There was one that had the code, but it did not explain as to how to compile the code and using in the program. I have also saw a video on youtube that had a DLL file, but it does show where to...
  6. Ryobi

    Calling a second form and closing the first form

    I have search the web but I can not find how to open a second form and close the first form. I have try different codes (including trying to close it from the second form) but none seem to work. The code below will close the first and second form which is not what I need. I want the first form...
  7. Ryobi

    Calling a public procedure

    Hello, I hope somebody can help me with this simple problem. I created a public procedure in a Class module, but for some reason I can not call the procedure from a form. The code on the Class module is as follows: Public Class Module1 Public FileInuse As String Public Sub...
  8. Ryobi

    Saving Data in VB Net

    Hello, I am new to VB net and connections. I am trying to save data from an Ms Access table using a table adapter. Everything works fine, except that I can save changes to the data. This is what I have: MYConn = New OleDbConnection(StrConn) Dim Sql As String = "Select * From...
  9. Ryobi

    Can not reference Crytal Reports DLL's

    Hello, I am new to VB.net, I am trying to create simple crystal report which I can do, however when I try make the deployment package, I get the error messages that the following files are needed: cpre32_res_tr.dll, libcurl.dll, u2dmapi.dll, u2post.dll. These are crystal reports dll's which...
  10. Ryobi

    Opening a crystal Report from Visual Basic 2010

    Hello, I am learning Visual Basic 2010. I have the Crystal Reports reports installed. I am using an MsAccess database as backend. I am able to create the report and view with the viewer, but what I want to do is be able to open the report from a form by clicking a button. Is this possible ...
  11. Ryobi

    Importing Only Certain Fields From Excel

    Hello, I have a problem that perhaps somebody know the answer. I am importing data from an Excel spreadsheet in Msaccess table. I am using Docmd.Transferspreadsheet method. I am able to import the data, but what I would like to do is to import only certain fields from the spreadsheet. I am...
  12. Ryobi

    Need to assign a query to Combo boxes using VBA.

    Hello, I am trying to assign query to combo boxes via VBA. I have about 10 combo boxes which data is a table name supply. All the Combo boxes are name Cbobox1. CboBox2... etc. I want to create procedure that let to assign a query to each combo box. The procedure be call would be...
Top Bottom