Search results

I have one form, operator_details, that has a close button, which when clicked on runs code; Private Sub close_Click() Forms!training_record_tableview1.Refresh On Error GoTo HandleError DoCmd.RunCommand acCmdSaveRecord DoCmd.close ObjectType:=acForm, ObjectName:="operator_details"...

ridders, the underlying form and the ssubforms do not have to be editable, this is done elsewhere. The subforms will conditionally formatted so that the text goes red or orange depending on whether the trainingdate is overdue. I will look into the links you have supplied, to see if I can make...

Ranman256, thanks for your reply. I am still struggling to understand how I can get the results I require. There must be a way of adding an extra training type automatically. Plog, I think I have made the changes based on your suggestions. If you have suggestions they would be most welcome...

Evening all, I have a form "training record tableview1" which at the moment has 2 subforms, which each give details of training for each employee. When a new training type is created, using form "training type" this type is added to the relevant crosstab queries, but I need this new training...

thanks for your help.

plog, I'm very nearly there I think! One problem, when I open Form1, I can select an employee from the combo box. For example, if you click on B THOMAS the sub form is populated with training types and dates. I think this is along the lines of what you described. However to make the rest of the...

I plan on entering a bunch of training dates for each operator. I will have a go a your instructions. Thanks again

plog, many thanks for your help, one last question, I hope! I cant find a nice user friendly way of entering trainingdate for each operator, for each type of training. I was thinking I could use form training_record where it would list all types of training in the subform, then all a user would...

plog, I have done as you suggested, many thanks

plog, many thanks for your assistance. It seems to make bit of sense, now you have taken the time to explain it. I can get the results I need in a crosstab. A bit more work is required to make a user friendly form to add / amend training dates for each employee. Thanks

plog, thanks again. I work in the rail industry and I have a need to track training of employees in my department and show when their training has expired for any particular type of training. As for linking the tables, I don't know if it works as I'm expecting, but I would like for each operator...

plog, many thanks once again. I seem to be making slow progress, I think! I still don't seem to be able to link training table with operators table to get the results I desire. I will persevere however.:confused:

plog, thanks for your reply and taking the time to explain some fundamentals. As you can guess I am a novice at bd design and finding my way as I go! I will persevere to get the results I'm after.

Afternoon all, this is a follow up from an earlier post, which I am still struggling with. I have 2 tables which have no common fields, which I need to combine into Query1, from which I can build forms etc. I can't find a way of making Query1 updateable, so I can add [passed on] dates and also...

CJ_London, thanks for your help, a simple select query did the job. I should try and remember to look for the simple solution, not over complicate things! :)

CJ_London, thanks for your reply. I will look at it again and try using a simple query, never thought of that! I know there are some basic flaws in the design, this is due to being a novice at access and building it "as I go". Thanks

Forgot to mention, the attached database has to opened using Ctrl+Enter as it is an extract of an ongoing database. Thanks

I'm sure i'm doing something very dumb! I'm trying to create a delete query that deletes operators, [op name] and all their records from [train_tbl], when they are ticked as "left team" in the form [operator details]. I have spent all weekend on this, so any assistance would be very, very...

Morning all, I'm sure this has been asked before, but I don't seem to be able to find the thread. I have a form, [operator details] that has 3 checkboxes. I want to checkbox3 to untick checkbox1 and checkbox2. Also checkbox2 to untick checkbox3. Any help would be gratefully received Thanks

Just an update, I have deleted the system.mdw file, as suggested by ridders and uninstalled Ofiice2013. After re-installing Office2013 my databases open without the unwanted password form popping up. A hard lesson learnt! Thanks for everybodies input. :)