Search results for query: *

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...

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 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

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 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...

I download from a data source that puts all text in caps. I would like to use format strings in the table design to force the data the way I want it. Two questions - I cannot find documentation on how to change uppercase to text to first letter upper case and the rest lower case. Also, I need...

I recently secured a database and was having some problems with passwords. I removed the admin password by clearing it. I also experienced a computer crash with an hour of clearing the password. Afterwards, when I attempted to get into the database I received the message that the user does...

I have a database that is on a Novell Server. WHen I run the applicaiton from my PC all is OK. WHen I run it from any other PC ,any report I have that utilizes the function "trim" will not run. I am prompted for a value for trim. Is there something I have to install on the other...

I have a database that is on a Novell Server. WHen I run the applicaiton from my PC all is OK. WHen I run it from any other PC ,any report I have that utilizes the function "trim" will not run. I am prompted for a value for trim. Is there something I have to install on the other...

My code attempts to assign a string variable that will print on the first line of a label report. The question is how do I pass the variable to the report w/o Access prompting me for a parameter. I have a text box bound to the variable name. Pu another way, I want to use code to assign the...

I have a form that features a command button that runs an update query to clear all checkboxes. THe last checkbox to be selected remains. If I run my procedure twice (update query/Requery) the last box is cleared. HOw do I get it right the first time? Thanks.

I have a report that has several group levels. I track school districts and schools within the district. WHat I am trying to do is simple. I have a total for detail records that prints on the footer for school districts that counts the number of detail records which represents students in...

I am using Access 2002 and no matter how many times i design my report using Avery labels 3 across / 10 down, Access only prints to the ninth row. Any help or insigt would be greatly appreciated. Steve

I have a table that contains an id nunmber and a path to a JPG file. I want to update the data so that I can feature the image on a form. The best Ihave been able to do so far is to update the path as a link. THis doesn't provide the desired effect. I want the picture to be visible when the...

I have a table that has been updated to provide links pointing to jpg photo files. HOw do I have Access execute the link and display the photo upon opening the form? Thanks for any help.

I have a text-delimited file that contains an ID that will easily update to my main table. The file also contains a path to a photo. I need some approaches to doing an upload of all photos into the database. THanks.