Search results

  1. S

    Using Code to create criteria in query

    Hi Everyone, I'm creating a new database in which I'm trying to use VB to create criteria for use in query. But no luck. Here is what I have so far Sub Array_Query() MyQry(0) = "In ('0014705','0014710','0014715')": End Sub Function GL_Code(i As Integer) On Error GoTo err_gl Dim...
  2. S

    Conversion to 2002

    Hi Everyone, we are currently converting from Access97 to 2002. When I start a conversion it comes back with a message saying the new file to which I'm converting is in use. For ex. if I'm converting Access97.mdb to Access2002.mdb half way through the process it will come back and say that...
  3. S

    ODBC for Stucky(Asset Basset System)

    Hi, Has anyone tried to ODBC into the Stucky system which is an Asset based lending system. I need help to setup the ODBC. Thanks Sandman
  4. S

    adding an entry to the registry

    Greetings everyone, has anyone made an entry into registry of a computer using visual basic(window95, 98 or XP), if so can you send me examples. Thanks. Sandman
  5. S

    Creating A Report Control

    Hi Everyone, is it possible to create a new report control specifically a Label, using the no data property on the report? I want to create a generic code which puts a label in a report which has no data. The message I'm getting is that the report needs to be in design view to create a report...
  6. S

    Boxes

    I do a summary report and I'm trying to put a box(rectangle) around the data. The report has a group header and footer. I'm trying to use the "Line Method" in vb. But the box created does not cross sections of the report. It remains within the section in which I paste the VB code into(I put the...
  7. S

    Changing Data type

    can someone tell me how to change a data type of a table, using vb. I need to change it from a numeric field to a text field. The reason being when I import this table into another database this field attaches to another table whose data type cannot be changed. Any help would be apprieciated. Thanks
Back
Top Bottom