Search results

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!

Yes it's sent via a commond button.

Currently all the old values for this field are Raven.... but in the future there will be others to add. Thanks I'll give the update query a go, although I'm not 100% how to do this! Will post again if I'm really struggling.

I have a combo box on a form.... which you can make a selection from a drop down list and print the selected report. I would like this field to be cleared once the print has been taken. I have tried me.[fieldname]=Null but I'm not sure exactly where to place this code - or if this code is...

Hallo! Here's a nice easy one for ya... how do I complete a field on an already enter record within Access. ie say the [Name] should always read Raven... I know to set the default value to Raven but that doesn't update already entered records. Any clues?

Hey a big thanks from me too, I didn't have much time to check this one out for a colleagues, so I searched the forum and found yer post. It worked first time, which is pretty amazin for me! Thanks again.