Search results

  1. 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...
  2. 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 ...
  3. Ryobi

    Importing Only Certain Fields From Excel

    Usually is I clear the import tables since we are usng the table get totals and not any other purpose. You are correct as far going line by line it a very time consuming process, but least now I have an option if I want to go that route. Thank you for the information.
  4. Ryobi

    Importing Only Certain Fields From Excel

    Thank you for replying. I will give a shot later since I need to create something quickly for now. The reason that I wanted to imported certain columns is because the spreadsheet has 22,000 records. Having said that, I only need certain fields, but the software company will not gives us the...
  5. 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...
  6. Ryobi

    Need to assign a query to Combo boxes using VBA.

    That is a good Idea... This morning when I woke up it occurred to me that the problem might be variable that I am passing to the procedure. I was sending "Supply" instead of "CboSupply". I will test my theory and let you know if that is the problem so that I can proceed to the problem of assign...
  7. Ryobi

    Need to assign a query to Combo boxes using VBA.

    You are correct I am looping through the controls, but I can not determine whether the known value is equal to any of the control names. I probably need to send the control name to list or a table. I wonder if the control names are in the hidden table ?
  8. Ryobi

    Need to assign a query to Combo boxes using VBA.

    I was going to try your suggestion, however, now not realize that the procedure is not working because for some reason the names of the combo boxes do not equal the name that I submit when I call the procedure. The problem is in the line. If ctl.Name = CtlName Then I place at stop after the...
  9. 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...
Back
Top Bottom