Recent content by kdt

Cheers, working now! Brilliant!

yep, created a new one for it and called it ShowError in modules. Does this seem right?

Hi Thanks a lot for this, it's exactly what I've been looking for. Just one problem... I'm getting this "Expected variable or procedure, not module" on the Call ShowError line. Any ideas on what to do? Thanks

Hi Banana Is this the error handling that you use? [URL="http://www.access-programmers.co.uk/forums/showthread.php?t=94358&highlight=error+handling"[/URL] How would I call this? Do you use On error Call xx or a GoTo statement sorry for the newb question. Thanks

Hi, I am in the process of cleaning up my code as it has been a bit buggy to say the least :( . Currently I am using error handling for some of my subs, although I have read pretty much everywhere that it should be in all subs. As I have many subs per form, would it be wise to call error...

Wow! you guys are superb! thanks a lot for all the good answers, I have been trying some of the code and there's definately a lot of good stuff here. I'm still pretty rubbish at vb but I'm getting there :) Thanks again!

thanks for the quick reply, but that is just the problem, how does access know who the user (and therefore the access level) is after the login screen is closed? I tried using an if statement on the login form but that didnt work and using a DLookup on the Switchboard, but that just returned the...

Hi I have a custom login screen created for my database and a table with access levels for different users. I am trying to assign user permissions so that certain buttons on the switchboard are visible/not visible dependent on the user security level. As the login screen and the switchboard are...

thanks for the reply, but this is returning all StudyNumbers in the table, is there a way to limit this to those that are in the subform being viewed? The subform is linked to the mainform by a master child link. Thanks a bunch!

Hi I want to create a text box on my Mainform with a list of StudyNumber values from the subform. The subform can contain many records. Putting the following into the source for the textbox: =[Subform].[Form]![StudyNumber] gives me only the first subform recordset. Is there a way that I can...

thanks a lot mate, your a star!:D

Hi I have a field in a subform that contains a primary key. When entering duplicate value, I want to be able to display a custom message and display the original entry value. So far I've modified some code from msdn to get the following Private Sub Form_Error(DataErr As Integer, Response As...

Thanks a lot, that seemed to do the trick! is there a way to stop the user progressing to another field until a full stop has been added? Thanks

right, this is what i have so far. I have added an after update event with the following: Private Sub Study_Number_AfterUpdate() If InStr(1, Me.Study_Number, ".", 0) Then MsgBox "you need to enter at least one full stop" End If End Sub Which is all well, but it does the exact opposite of what...

phew, got it now, I'd stupidly not changed the column count from 1 to 2. Thanks for all your help :D