Search results

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

Could someone please advise me how to hide a form if a text control on it is null? At the moment I have the following code Private Sub Form_Current() 'Looks up current Patient Name and DOB to show on forms Dim strFirstName As String Dim strSurname As String Dim strDob As String...

To be honest it was so long ago when I put them in I can't really remember why I did - lack of experience at the time most likely. I've been building this DB for quiet a few months now and its finally gone on our system for some 'live' testing and I am just going through all the 'issues' that...

Yep that was my thoughts as well about changing to combo's but to be honest I was hoping for an 'easy' fix (if there was / is one) to save me having to change them - hindsight is a wonderful thing or so they say !! thanks for your reply

Hi I have a small issue with list boxes and wonder if ther is a fix for it. I have two list boxes on a form 1 for Gender and one for Title. At the moment, if a user types in 'M' in gender Male comes up which is correct, but if they typed in something like Mail or even '123' that stays in the...

Hi thanks for the reply - I'm pretty sure the machines do not have any sort of desktop 'friend' but will check just to be 100% sure. The printer bit makes sense and could be the cause as the machines that are not 'working' are using a network printer - so I will need to investigate that one as...