Recent content by Principal

Thanks for both approaches. I opted for an approach similiar to Bob's because these reports were ad hoc. however, as I build this report and similiar ones for future use, Duane's approach has an appeal for ease of system mantainance and and change. Thank you both. Steve

I have a table that consists of scores. I have a report that lists the scores by the course they are associated with. What I want to do is to create some stats that would print in the footer for each group. The stats would count the number of scores in five different ranges, for example, How...

Tom: That worked perfectly. It was a very simple, elegant solution. I have doe some fairly complex things with Access (I have a SQL backaground) and I stumble with these items. I am so used to working with variables and moving them around. Again, thank you. Steve

As usual, I seem to have most of my Access difficulties with simple requests. I am using Access 2002. I have a form that utilizes a checkbox indicating an individual's status. For those users who have the status box checked I want to add text to the end of the first line of my label. The...

I think I found another way and it is in part due to my ignorance of the report structure. I can stash my text in the group header and footer and sandwich the detail data in the way I want. The group footer starts as soon as the details are done as opposed to the page footer which only prints...

I have a report that breaks on student id and lists three records per student. I have blocks of text that must go into this letter. Is there a way to put the blocks of text into the detail section and it only prints once? Thanks for any insight. Steve

SOrry - that should import specs and import file.

I populate an Access database with data from another system. Has anyone every coded this process, i.e. go to disk, pick up an import file and then apply to an Access import spec? Thanks

I populate an Access database with data from another system. Has anyone every coded this process, i.e. go to disk, pick up an export file and then apply to an Access export spec? Thanks.

I would like to print out lists of all the various VB components, i.e. methods, objects, properties, functions. THe help function in Access has info but I want a list I can print easily so I can see the full range of available tools. I realize I should purchase MS program reference but I was...

In any application on my PC only any attempt to create a combo box or list box in any database results in the following message: Class does not support automation or support the ....interface. I have not installed any new software in quite some time. Any ideas? Thanks in advance. Steve

I think I solved this one. When I changed the default action for the enter key to new line everything worked just fine. Having is set at the default setting must have been throwing Access into a panic for some reason. Thanks for your help. Steve

I am trying to use an unbound form and field to input short text data into a report in the report footer section. My form is open when the report is printing and I have a reference to the filed and unbound form in the report footer. I can only add a few words. Anymore than that and Access...

I have a master form- subform that has several controls that only appear when certain data is selected in the sub form. WHen I create a new record in the sub form the controls appear as programmed. WHen I go back to the sub form and cycle through records I am having problems getting the...

Rick: Thanks for the help. Your code worked very nicely. My job as a high school principal does not leave me the time I would like to study and experiment with coding techniques. I have programmed with applications using SQL and some of the early Dbase and Rbase packages. While Access is...