Search results

Embarrisingly no. My VBA skills are pretty rudimentary, and file manipulation is not amongst them. Do I need to write the report out as a text file? Any pointers you can give on the code needed? Thanks for your help so far.

Unfortunately the file does need to be edited by the marketing guys afterwards, to add in some further data.

Hi, I have an unusual problem which I can't seem to solve. I have a report built up from sub reports containg product information (name, title price etc..) which I deliver in text format to the Marketing department. The report looks fine when I view it in Access (except for the extra spacing)...

RexesOperator - I tried that and looked at the outputted text file in Word, and it still had the œ character in place of the £ symbol.

Hi, I have a set of reports that I output in text, and open in notepad. It outputs a list of products and their details, one of which is price. Although it looks fine in Access when I look at the reports, after outputting and viewing in notepad the £ symbol has changed into œ. I have tried...

ipr1 - I have just this afternoon have had exactly the same error. I have a large (approx 1.7 million line) linked ODBC table. I had a Make Table query running across it to extract records within a certain date range. I've come back from lunch and now everytime I try to run the query I get the...

Hi, I have a table(Unencodeable) which contains ProductID 's and Reason which new products are checked against. I'm trying to use an append query to input new data to this table. Adding the ProductID is easy, I'm just using a Parameter. What I need though is to limit the choice of the Reason...

Aaargghhh!! So simple I didn't even see it, I eventually noticed the little box on the toolbar that lets you specify the number of records you want. Solved all my problems in about 5 seconds. Such a dunce :p Simon

Thanks namliam, I've had a look at that Alter Table data definition language stuff, but its a bit beyond me at the moment. Also I have no idea what an 'autoincrementor' is. I've been thinking maybe there is an easier way to do what I'm after. I have a table derived from a make table query, and...

Hi all, Okay I'm fairly new to Access, so this may be real simple, but I couldn't find any answers in the Access help. I have a table with a list of products in: Products I want to run a query which will create a new table (Albums) with only products from a specific department. What I would...