Search results

  1. H

    VBA to Open a Form

    Hello, I am trying to use VBA attached to a command button in another piece of software to open just a form of an Access database. Here is the code that I have copied into VBA and this works fine except it shows everything including the form. Any help in modifying the code to just show just the...
  2. H

    Error creating a report from a query

    Hello, I can run a query but when I try to display this information on a report I get the following message: The specified field “tblMachineData.TagName’ could refer to more than one table listed in the FROM clause of your SQL Statement. Here is my SQL code from the quey. SELECT...
  3. H

    Query Help

    Hello, I have what is probably a simple problem that I just can’t solve. I have a table that has the date and time in one field that is formatted as General date. I then split the date and time using the Format() function that I found on this forum and it works great. I check the format on these...
  4. H

    Delet data from a dbf IV file

    Hello, I have a project in Access where I am linked to a .dbf IV file. This file is populated by another software and I use Access to manipulate query the data. This file that I am linked to is now 923 Mb and I can’t seem to reduce the size of it. I have run delete queries and a compact and...
Back
Top Bottom