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 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...
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...
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...
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...
Interesting responses. How about a compromise?
Use Autonumber as a primary key, but not visible on the form.
Use Dmax as the reference # (work order #, Invoice #, Message #, etc.) which is visible on the form and applicable reports for user reference.
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...
Use the example in the Northwind database as a reference. This does exactly what you are describing. The example is on the "employee: form. Go to design view and you will see the hidden text box which contains the path for the picture on the hard drive to ther image control.
I know exactly what you are talking about. Linked photos take up less space for some reason. I am looking for a better way, but my solution to date is:
Add a field to your table "Photo"
Add a txt box to your form "Image Path"
Add a image frame to your form...
Putting all this together, I get:
Private Sub cmdsendjobopps_Enter()
Dim db as Database, rst as Recordset
Dim strSQL as String
Dim Names as String
Set db = CurrentDb
strSQL = "SELECT[joblist Email List].[Email Address]FROM[Joblist Email List;"
Setrst=db.OpenRecordset(strSQL)
With...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.