Recent content by Raven

I'll set the sheep aboot ye! ;)

Hehehe! Oh how I wish for Cape Verde!!! But sadly no, I'm now in Wales! Still a different country thou ;)

Fankya :cool:

Hey who are you callin freelance ;) Oh OK you must know me well... cos I am a looney :D

Too right - this is a well handy trick! I've used this years ago on previous databases in another life, but I had forgotten all about it. Thanks :)

Well I used to use this forum constantly when I worked for a Scottish Council... and since then I've moved to a different country, got a great job and had some mad life changes! So here I am building new databases... and searching the forum for answers again! Nice to be back thou :)

LOL.... simple when ya know how!!!! :eek: FANK YOU! ;)

How do I specify the format of the date to display like: 01/12/1982 on a form? I've played around with the Format in the properties, but the above format is not one of the offered options. Thanks.

This answer WORKED - fanks Rich :)

This answer gave me a run time error on the setwarnings :(

I have a combo box which has limit to list selected and in the Not on List event I have: Private Sub Combo102_NotInList(NewData As String, Response As Integer) MsgBox "Delete keyword entered, select from list or use Add Keyword", vbExclamation, "IMPORTANT NOTICE" End Sub This works...

Hmmm Barry, I thought this was a little complicated, so I tried Me.Refresh in various events and it working in the onmousedown event of the combo box on the original form :D Seems to do the job!

Thanks Barry I'ved used your code, it works really well! :) Only thing is when I return to the original form, the combo box that is looking up the table that has just had information added to it is not updated, ie I have to close the form to refresh it so to speak... can you advise how to...

I have main form wiv button that opens new keyword form. I would like to have new keyword form open on a new record in order that user can input new data. I know all you 'experts' out there will find this a very simple one.. ! I suspect it's a one line piece of code in the code on the button...

Thanks for the prompt, your hints led me to place the code on the print command button which worked!