Search results

I have a combo box where users can select from one of a number of even numbers, located in a table. The problem is users can also type a number into the box, they could by mistake enter an odd number, which would return incorrect data. My question is, is it possible to add a clause somewhere in...

Thanks Mark, so obvious when its in front of me.;)

Hi all, This is a follow up from a post I made some time ago. On a form I have a combo box that gives me the option of selecting from one of the next 5 Sundays; Private Sub Form_Open(Cancel As Integer) Dim I As Integer cboSundays.RowSource = "" For I = 1 To 5 cboSundays.RowSource =...

Thanks, CJ_London, it makes a lot more sense

Evening all, I have a form training_edit_dates1 that allows me to add training types and dates for each operator, which is then saved in operator_training1. When a training type and date is added for a operator I would of thought the field trainingtypeid in operator_training1 would show the id...

ridders, you are a genius. This is exactly what I need. Many many thanks

Gasman, thanks again for your input. I have just double checked the last record in the table, it does open as expected from that table. The Google record now opens as I have added the http:/ etc. I will search this site as you suggest for other options. As a last resort I will create a number of...

Gasman, thanks for your reply. I have added third entry in the table for a file located on my PC. the combo box is unable to open this one, could you please enlighten me. Many thanks

Hi all, I have a database in which I require the users to be able to access risk assessments on the company's server. To do this I have a form risk_assessments, with a combo box. This combo box needs to list the refno and risktype, but not show the actual hyperlink. I have attached a db, with...

Thanks for your help, I have tried all the suggestions but unfortunately the problem of not updating the required still exsists. As a way round it, I now access operator_details whilst either of the 2 forms are closed. This then means the updates take place. Although not what I was after, it...

Thanks MarkK, I have tried your suggestion and it seems to give the same result, ie I have to close the form operator_details twice for the change to take effect on the forms that are being refreshed/requeried. As I'm an absolute beginner at VBA I'm at a loss as to how to resolve this. The code...

just a follow up on my post. I have applied a similar code to requery another form, so that the signin form is updated from changes made to operator_details form. The peculiar thing is that the changes only happen if operator_details is closed, then reopened and then closed for a second time...

moke123, thanks very much for the code, works a treat.:)

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