Search results

  1. G

    Update Query and Memo Fields

    I receive a flat text file from another database application. From this text file, I import the data and run update queries to build 2 related tables (Inspection and Inspection detail). Everything works fine except one of the fields that is generated in the text file that I import is a memo...
  2. G

    Write Text File From 2 tables

    I have a situation where I need to write a text file from Access. There are two related tables that need to be written to this file. Below is the format of the file that I need write to: BEGIN: Inspection #23423423DVA Tag#: 47BHY1926 Tag#: 47VDK1262 Tag#: 47VCC4861 END: As you can see, I...
  3. G

    Export text file from MS Access to Public Desktop in Windows 7

    I would like to export text data from MS Access using VB code. The export file needs to go to the public desktop directory in Windows 7. There are some permission issues when I do this. Has anyone been able to work around this? Thanks, Greg
  4. G

    Error 3162

    I have an inspection database that I am having problems with. My main (Inspection) form has a subform (Owner). These forms are based on Inspection and Owner tables. The Owner table has a primary key field called Owner ID. The inspection table has a foreign key called Owner ID. This is set...
  5. G

    Complex Report/Query Help

    How do I get a count of firms by location when I am trying to get a total of $ paid in the same report? These records could contain multiple $ amounts for each firm. I only want each firm counted once. I have created a main report that is grouped by location. There is a subreport that will count...
  6. G

    Print page footer only on the first page

    I am working on a report that is going to be emailed and transferred electronically to other people. The user has requested that the first page of the report must have our company letterhead on the page. I created the report and placed the image of the top of our letterhead in the report header...
  7. G

    Combine Child records in a report

    I have a report that I would like to have print several child records on a line. These records happen to be names and the way I want them to print is as follows ("First name" "Last name", "First Name" "Last Name") There could be as many as 4 names that I would like to print on one line. Is...
  8. G

    Reference Manuals

    I am looking for a good Access 2007 VBA reference manual. Does anyone know of a good reference manual that is worth purchasing? Thanks G
Top Bottom