Search results

scenario: if compliance = 1 then flagawarded = "red flag" and totalevaluationscore = "n/a" if compliance = 1 and quality = 1 then flagawarded = "red flag" and totalevaluationscore = "n/a" if compliance = 0 and quality = 1 then flagawarded = "amber flag" and total evaluation score = "the...

any help on this still, is really apriciated

thank you for this still playing with this at the moment, however what happens if quality is clicked and then compliance is clicked, red flag still needs to take priorty if you have a look at my db(if you havnt already) you will get more of an idea than i can explain here thank you

would i put this on the compliance checkboxes (on click ) which is the one that takes priorty or quaity

Hi My db is below http://emotiveexposed.mysite.wanado....co.uk/test.mdb i have a series of checkboxes in sections Compliance and Quality here is my required scenario what i want is if compliance checkbox.value = 1 then flagawarded = "Red Flag" else "n/a" if quality checkbox.value = 1 then...

Hi, I have a form with a subform, i want the subform to show (like a filter) existing records based on a combobox value can someone explain how i can do this please? thanks you

Ok ive realised it needs to be bound to a field before it will reset to default value, however, how can i bind these textboxes to a different table (i.e not the table the form is bound to) thanks

Hi, I have a db that has a sub form, the checkboxes on the sub form give values to parent form textboxes, however on next record the checkboxes have the same value as the last record and do not revert to their default values. these are compliancescore, qualityscore, HSsoundscore...

Hi i have a make table query that outputs a normalised database to text format (bringing linked info from another table) but checkboxes that are 1 on the source table are being output on the new table as -1 anyone know why this is, and how i can fix it? thank you SQL: SELECT [CMS Compliance...

Hi, I have some checkboxes as you can see from the attachment its pretty self explanatory what im trying to acheive. does anyone know of a better way of doing what ive done so far? thank you scott

Hi, I have inserted an activex media player control into a form, but i cant seem to figure out how to get it to ask which file to open? does anyone have an idea or documentation on the properties for this control (its access 97 btw) thank you

Hi, I have a tblMaster and tblScreeningForm and a frmMaster and frmSubMaster tblScreeningForm has questions such as salutation complete? etc... frmMaster has name, dept. etc.. that is stored in tblMaster, what i want is to have a frmSubMaster inside frmMaster as a subform frmSubMaster will...

ill try it thanks

i like the sound of the make table query, how would i format this? sorry to be a complete newbie pain. thanks scott

becuase i export the table into a excel pivot table where i report and compare results of my data. which is the reason i need text values thank you

Hi, I have a db (fiel too big to attach i can email if required) which has three comboboxs which are all related to their relevent tables. i.e Employee combobox links to employee table etc... The question: the three comboboxes output to a table calls CMS Compliance Table, (which is where i...