Search results

Thanks for the code example. I think I can take it from here....I'll let you know. oldgnome

I know how to create a Do While loop, but I'm not sure what to pass through to the reports to print just one record. Can you point me in the right direction? TIA oldgnome

(Access 97 running on Windows 95) I am seeking to print multiple reports one record at a time. I can get the reports to print from VB code, but I can't seem to find a way to print just one record at a time. The report source table is based on an input table run through some calculations. The...

Jack: Thanks! Now I know how to go about it. oldgnome

Does the order in which the SQL code appears have anything to do with the order in which the fields appear in the field selection box in reports? If so, I could take the SQL code and sort that. A bit tedious, but I think that's a lot easier than trying to drag the fields around in Query Design...

Right. So, back to my original questions: Split the query? Any way to automatically sort (even with export/import) the query's resulting field names? TIA oldgnome

The problem with only one report is that all of the information didn't fit within the confines of an Access report. Yes, 200 fields. It is a cost modeling program for IS projects. oldgnome

I have a query that contains nearly 200 fields. I have used naming conventions to name the fields -- most of them are as a result of performing using the result of a function against a value in the source table, the few others are just brought over from the single source table. I started...

Thanks for the input. I managed to figure it out and I have it working this way: The table of values remains one record and I have form to use in updating those values. I created a function for each value that creates a variable containing the contents of each field for the record with ID=1. I...

The values in table1 represent the unit costs for various pieces of computer equipment and standard efforts for installing those pieces of equipment for generating an IT cost model for proposed projects. I need to be able to produce reports that show (2 widgets times the price of a widget)...

I am real new to trying my hand at VB coding, and I'm not sure that's the answer to my dilemma. However, I think it is, so I will pose the question here. I have about 200 values I have stored in a table. These values will occasionally change, but not very often. They are dollar and effort hours...