Search results

I have a report based on the information from a combo box on the data input form. The combo box has an associated numerical score that is necessary to calculate risk factors, as well as text for the user to select the appropriate risk. the 'score' is in column 1 of the combo box with the width...

it helps that I am dyslexic... why is that such a hard word to spell??

You sir are a f***ing genius:D.

Damn. I was so hopeful that would work but alas no :confused:

Ok, Lets try this. Column 1 contains the text and column 2 is the score No Damage = 0 Slight Damage = 1 Damaged= 2 Baldy Damaged = 4 These values are taken from a table called tblMatter How can I display the scores in the fields immediately to the right of the drop down boxes after...

No, not for the entire table. Just the record. Each record will have the three drop down lists but I need to add the scores from each of those lists to each other to get a total score. I have attached a small screenshot of what I am attempting to do. Sorry if I'm frustrating you. I know you...

No sorry. Ok I have three drop down boxes (it is an asbestos management database I'm working on so the drop downs are Surface Treatment with potential scores from 1 to 4 Condition With potential scores from 1 to 3 and Material Type with scores from 1 to 3 The description text is in...

Hi guys, I have a form with several drop down boxes on it. These have a score associated with each selection: Column 1 is the Text and Column 2 is the score. if you select : 'No damage' the score is 0 'Slight Damage' the score is 1 'Damaged' the score is 2 etc I would like to add the...

I am having a complete brain f*rt today with a simple problem. If the field [ItemDesc] is null then I want the formatting of the field [Reason] to be green. If it is not Null I'd like it to be red. I am a bear of little brain so be gentle with me :):banghead: I will kick myself when you...

I have a data input form with drop down list of 9 options. [Media] On the associated report I would like a jpg associated with the options to be printed. Can this be done please? Thanks in anticipation

Hello you wonderful people. I have a database, part of which looks after equipment that needs servicing and calibration. For other reasons, this database is opened every day so I thought my problem could be solved with an On Open or AutoExec command but I bow to your much superior knowledge...

I have a form on which there is a text field that will return a value or accept or decline. In the event that 'Decline' is selected, I'd like to have an email sent to notify the manager if 'Decline' is selected. Any ideas guys ?

.I will try that Once the [MedBooked] is updated the previous Medical date [MedDate] is redundant

Hi, I have a form on which are two fields [MedDate] and [MedBooked] I am tying to input short code to clear the contents of [MedDate] when [MedBooked] is updated. I know it is an AfterUpdate but cannot get it to work. :banghead:

I have a report based on table OWM which has a fields Samp1, Samp2, samp3 and Samp4. these fields are a single letter 'A', 'B','D', 'F' or 'X' I am trying to build a calculated field to count the number of each specific entry to give me the number of 'A' s for instance. I'm fairly confident it...

As I am very inexperienced Could you show me how I can present that in a calculated field within a report please? The fields Are [Done], [DoneBy], & [Pump] The Table is [tblColdWater]

I have a report on which are some dates of activities. The Details section reads across Done(date field) Pump(A or B) Done By(a name) I would like Access to calculate the number of days that have elapsed between consecutive entries. so something like 12/10/16 A...

Guys, Im fairly 'fisher price' on this so bear that in mind. I want to create a feild on a form lets call it "email" In that form i wnat to type the individuals email address and be able to click on it to generate the message directly from the form. I am oly interested in generating a blank...

Hi, I managed to sort this issue by adding this to the OnOpen Private Sub Form_Open(Cancel As Integer) ID = DMax("DailyWater", "tblDailyWater") DoCmd.GoToRecord , , acNewRec CalibNo = DLookup("CalibNo", "tblDailyWater", "DailyWater=" & ID) End Sub :)

The code works to carry the data from one form to the next but if I change the value in the filed it reverts back to the original value. I need to be able to update the value then carry that forward for future values