Recent content by gregch

I wish I could leave the field as is, but I need to create 2 related tables from the imported text file. Below is the SQL that I am working with. Is there any way to prevent Import Statement from being truncated when the query runs? INSERT INTO Inspection ( ID, Inspection_Date, Serial_No...

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...

Thank you! I will take your suggestions and run with them!

Inspection table has the following fields: Inspection ID - This field is set as the primary key Inspection_Detail table has the following fields: Inspection - This field is set as the foreign key Tag# Do you have any examples on how to write the data from these two tables to the...

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...

This is what I am using: DoCmd.TransferText acExportDelim, , "Qry_Inspection_Export", "c:\users\public\Desktop\" & stpathname & "" & lvalue & ".txt", False If I change the code to point to my user ID, it works fine.

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

Thank you for the replies! I could make the Owner subform the main form and the Inspection form a subform, but I have another subform called contact info that is set up the same way as the Owner subform. The user that I am writing this for wants to be able to enter Owner and contact info...

The one would be the Owner table and the many would be the Inspection table.

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...

Thanks for the help! I knew that there should be a way to get this count. Greg

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...

Bob, That did the trick! Thank you for your help! Greg

Bob, Thanks for the reply! I tried your suggestion and camp up with the same result when I tried to print and export. When I view the report in print preview, the page footer is there. Any other ideas would be greatly appreciated! Greg

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...