Search results

Thanks for the response.

Thanks for the reply. Would that not disable all the controls? I only want to disable the search and unfiltered options but want just the navigation buttons.

Hello, Is it possible to remove the 'search' and unfiltered' options on a form's navigation control (see image)? Thanks for the help.

Hello, Thanks for the reply. I understand how to use the function, but not why the answer is '67' minutes rather than '40' (which seems to be common sense).

Hello, I've used Brian Warnock's given below, which appears to be working well: https://access-programmers.co.uk/forums/showthread.php?t=243445 Thanks for the replies and to Brian!

Hello, Yes should have been '3.4'.:rolleyes:

Hello, I'm using a DateDiff expression to calculate the difference in hours and minutes between two dates. For example, Start date: 12/07/2017 13:20 End date: 12/07/2017 17:00 will return the correct value '4.4' (4 hours 40 mins). However, the following does not: Start date: 12/07/2017...

Of course! It was the other control that was missing. :banghead: Thanks very much!

I get a 'Method or data member not found' error message when trying to compile code. The code falls over when it gets to a particular control (txtKARY) at a line which reads: If Me.txtKARY = "47,_ _,+21" Then Me.txtKCD = 0 I'm not sure what the problem is. I know there is a control called...

After practically re-building the database, we've now discovered that the issue was resolved with a Novell Client (2 SP2) update. Go figure!

Hello, The problem has only been occurring since yesterday and no changes were made to either table structure or forms (apart from moving one textbox on a form a couple of centimeters). I have two databases, front- and back-end. The two forms in question are based on one table each (table1 and...

Hello, Thanks for the response. I'm afraid the caption is only visible if the form is not maximised.

Hello, I use some code to write some information into the caption of a form, like so (in form's open event): Me.Caption = "Subject Number: " & Forms!frmperson!txtSubjectNumber & "; Name: " & Forms!frmperson!txtSurname & ", " & Forms!frmperson!txtFirstname This works fine if the form is not...

Yep - thanks.

Hello CJ_London, That appears to work beautifully! Just one minor question. When you say to call the code from the open event of the form, do you mean the subform and not the main form? Thanks again.

Hello All, I have a form-subform situation. The subform, which is in datasheet view, contains two dropdown boxes, Country and District (1-n). I want the district dropdown to only display records based on what's selected in the country dropdown. There will only ever be any content in District...

Thank you pbaldy. Yes it was a problem with how the form was laid. I've now re-organised slightly and things are OK.

Thanks for the reply. Are you suggesting that I need to make my (sub)form unbound? That seems like a lot of extra work.

I have two subforms on a main form. When I move out of the last control of the first subform, I use the following code to move to the first control of the second subform: Forms!frmFMVisit!frmSubFamilyEthnicDetails.SetFocus This is giving me problems in that it appears that moving out of the...

Thanks Michael. I'll try that out and see if it works for me.