Recent content by Paul Cooke

Thanks Bob, To be honest now you mentioned that I was aware of it but copied that line 'as is' as I was doing changes to the form and kept forgetting to save it and losing some code changes (long story!) however I did not take it out of the finished bit so it's a good reminder for me and a...

Sorry for not replying sooner DoEvents didn't work so I went for the first option which works a treat !! thanks so much for your help Regards Paul

Basically the report values are all "=Forms!AccidentOnly.mycontrol... ect ect [/CODE]

Thanks again for the reply.. The SelectObject didn't work How would / do I save the values into 'public' variables? say for example on value is txtFirstName ?

Thanks for the reply - hangovers gone - thankfully !! There are no errors at all everything works as it should apart from closing the forms that are open to take the user back to the Navigation form. The main form "AccidentOnly" has to stay open until the report has been generated so I need...

Hi guys I have a select case statement to send a report via print or email from the active form "AccidentOnly". I am having problems closing the form within it and would be very grateful for some advice on how to resolve this. I need to place these two lines somewhere after the 'sendobject'...

Hi in relation to the DB fitting on the screen try adjusting the text size in the screen preferences. I had the same issue a few weeks ago and this worked for me. - good luck

Hi guys is it possible to spell check a combo box before the NotInlist event triggers? I have the following code in the event Private Sub cboPatientOccupation_NotInList(NewData As String, Response As Integer) 'Checks occuptaion typed in against current records and adds it to table if user...

No its just a 'bog' standard form it is opened based on two different 'openargs' but I can see that being the reason can it?

nope - that does not work either I really cannot think as to why the mainform it is not hiding but (on the last bit of code the Subform is hiding) I'm tottally lost ! thanks

nope that didn't work ... so what I have at the moment is If Len(Nz(txtEmailAddress, "")) = 0 Then 'If IsNull(Me.txtEmailAddress) = True Then Beep MsgResponse = MsgBox("There is no email address on record for this patient, please update the missing information before entering the...

Im just having a quick play with it as the control on the main form that is getting the focus is a 'required' field so i'm think that may be blocking it from hiding will post back in a mo

Thanks Dave - I wasn't aware of that but it does make sense So i will change it now ! thanks again

oops maybe spoke to soon ! its hiding the subform but not the mainform - the subform has the focus on opening so not sure why this is not working ? any ideas? thanks

Thanks so much I can't believe I was so stupid in forgetting about the Subform !! it all makes sense now !! thanks again