Search results for query: *

Goal: To take a 0-5 evaluation rating score for 12 instructor feedback questions and then divide that score by the number of questions (12 max) that had a rating of 1-5. The rating score of zero in this example indicates a N/A for the question. so...if one of the questions was scored n/a or 0...

I have 2 list boxes: lstMake & lstModel lstCatagory is populated from a query, qryMake Lets say that in this query/list box I have selections of: Ford, Chevy, and Dodge. If I choose Ford in lstMake I want only Ford models to appear in the second list box (lstModel). I have other queries set...

I am having a problem with the legends on my charts. In some of them (bar charts) is total is shown. The legend wants to display, for example "SumOfFieldName". I want to rename the labels in the legend for each cooresponding bar. Any suggestions?

Normally when I want to print the record data on the screen (one record) I create the query and use the criteria property in the unique field. ([forms]![formname].[fieldname]. A command button referencing a macro to run the query and print the record in the report always works until now. The...

How do you go about setting up a report to print only the current record showing on main form with an accompanying sub-form (single page view)? The data for the main form and sub-form are in separate tables (client info-main form and estimate info-subform). I can only get the client info to...

I have a project where each new record needs a message number automatically generated , increments by one, and does not allow duplicates. I favor using the DMax method while others advocate the autonumber method because that is what they have always used. How can I best argue the point that...

I have a field in which I am using =DMax("[fieldname]","tablename")+1 to automatically increment the # displayed in the field. (autonumber substitute) What I would really like the field to do is: 02-####. Where 02- equals the last two digits of the current year and ####...

Upon duplicating a record, each field of the record has all of the text highlighted. If I begin typing to edit the data it all gets erased. If I click on the field first, the text is de-selected and I can edit away. How do I eliminate this extra step of having to click on the field?

I am duplicating a previous record and editing that record while maintaining the integrity of the original data. The duplication is done through the "duplicate" command button and I can distinguish between the original and edited records by means of an auto # field. When I...

Any suggestions on how to speed up the loading of linked images for records other than playing around with image size and resolution? In my DB, each photo is linked via a path (imagepath) and displayed in (imageframe)-similar to the Northwind DB example.

I have form where the user can perform preset filters by selecting a radio button. This is carried out in a macro (ApplyFilter). The same form also has an image control that changes pictures as you scroll through each record, this is accomplished by code in (Sub_Form_Current). Both of these...