Recent content by majhl

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.