Search results

  1. A

    Incorporate SQL in VB Code

    I am Using VB 2008. I created a project in VB 2008 with a MS Access 2003 db. The DB is accessed from outside the VB Project. The DataSet, Record Source are all set up in the Project and I can write data, delete data from the DB when I run the VB project. Here is where I am confused. I am...
  2. A

    Totals from another query

    I have a report that is based on a Query. On that report I would like to put the result from a second query (numerical - b/forward total) on the report also. I have an Unbounded text box on the report and has put the formula in the text box as =sum([secondqueryname]![fieldname]), however when I...
  3. A

    Problem with referring to Query in VBA

    The error now becomes: User-Defined type not defined.
  4. A

    Problem with referring to Query in VBA

    I am attempting to do a search before an entry is made in a text box of a Form. The source of the search is a query named Fan Equipment Log. If an entry is made in the text box that is also in the Query then a message box should generate. The code on the BeforeUpdate property of the text box...
Top Bottom