Recent content by bangsmic

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

Get a Invalid use of Null error in Cat = Me!lstMake.Column(1) line. I see the logic in the code but don't see where the error is.

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 don't follow. The query is based off data in a table, so the field name is fixed. I tried changing the "SumOfFieldName" in the appropriate column in the datasheet associated with the chart to no avail. The help feature in Access is really lacking in support for this feature. Actually, if...

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?

Found the solution to my own problem. Add two unbound text boxes in the header and code as follows in the control source properties: =[Forms]![sales dialog].[beginning date] =[Forms]![sales dialog].[ending date] Make these text boxes visible property = false [sales dialog] is the form name...

This works great, thank you. An added question: How do you display the date range at the top of the report so you know the time the data is related to?

I am using Bobs DateDiff example above in an unbound text box in a report to obtain the # of years seniority. "hiredate" is the start date. I have been unsuccessful in breaking it down further to accurately show the number of months as well. The hang up seems to be any of my records where an...

Works like a charm, thanks a bunch.

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 think this line should read: Me![INumber] = strYear & "-" & DMax "[fldNumber]","tblInvoiceNumber") + 1 Me![INumber] = strYear & "-" & DMax ("[fldNumber]","tblInvoiceNumber") + 1

You are correct. I was overruled by "others" and autonumber was was used over DMax. At this time, the number will continue on when the year changes over. I am curious however, how to reset the numer to 1 upon the year change. At a minimum, using DMax would have unable us to reset...

Thanks to all for the insight.

does this really come down to whether or not the program is being used in a multi-user environment? All I want is number, which automatically increments by one when a new record is created, and can't be a duplicate of a previous. Either method will accomplish this as far as i can tell (short...