Recent content by Gremlin76

Thanks for the link. We are using A2K. We can export to a .txt file but it is a couple of manual steps that I was hoping to avoid (the software generating the file does not have the option of changing the file extensions used) and I don't want to mess with system registries. Can file names be...

I am having a couple problems with importing information from a text file. My first problem is getting Access to accept the type of text file it is. The file is save as FileName.rpt and Access doesn't seem to like the .rpt file extention. I have started by using DoCmd.TransferText, for example...

You should be able to do this a couple of different ways. My preference is with SQL and recordsets. I find it easier to manipulate (add variable information from forms) the information with SQL than with queries, but by what I have heard in this forum SQL will run slower and will increase...

I need to be able to produce a pivot table that will allow the results to be used in VB. Background: I am doing this in an Access 2000 project using a MSDE SQL server manager. I have two tables to focus on. One is a raw material table that includes all the specific information for each lot of...