Search results

Pat, Thanks, I will take a look at the Parameter Query option. I have not looked for the hotfix's yet

I am running Access 2002 SPK3. As far as using a parameter query, not sure how that would work? I have never used a parameter query.... Some background information, this data is used in our publishing environment and each query represents a published table for one of our magazine issues. The...

I run a query that I export out to a tab delimited file. This text file is used for another application. The problem I am having is if I select "skip field" in my text "export specification" it still exports out that piece of data, even though I have selected "Skip Field". The data type on...

You are absolutely right! Unfortunately this structure has been handed down to me my concern with restructuring the table design is that it may have an impact on the active server page front end.

Thanks for the info, If I could do a FIND and Replace in the SQL view of the query to find the old table name and replace with the new table name that would work out great, but I'm guessing that is not possible? I'm not sure how to accomplish what you suggested?

I have a query that is complex, that changes year to year and it requires editting the query and re-adding the tables and expressions, Is there a way that I can get a macro to do a find and replace of the table names and fields in the query's sql view? Or do you have any suggestions how I...

Thanks very much for replying. I am not experienced with writing VB code but I would be willing to try anthing if you could give me a sample syntax. As far as trying suggestion B) the Company Name and Country No.are 2 separate fields in two different tables joined by a Company ID. When I...

Hi, I have a query that is made up of 5 tables. The primary key in each table is my company ID field. The query results are a formatted text file which I export to a text tab delimited file. I then import this text file into a Quark Xpress template. The problem is that it creates multiple...