Search results

I think I will have to send you guys a crate of beer ... it's not working !! I have the following Private Sub PatientGender_BeforeUpdate(Cancel As Integer) Dim strMsg As String, strTitle As String Dim intStyle As Integer If Not Me.NewRecord Then If Len(Nz(Me!PatientGender...

sorry but should there be a second ) at the end of If Len(Nz(Me!PatientGender, "") = 0 Then As I am getting a compile errr - syntax error and this line is red?

ok maany thanks for the tip on the Case issue So I would assume it would be FirstName.Value = StrConv(FirstName, 3) Many thanks again. I will get this all input and post back the results

Its Red Stripe - maybe if I wasn't drinking it now I wouldn't be getting so confused !! Thanks for the reply and solution so far. I have two other controls where entry is required FirstName & LastName The code for the gender will work pretty much the same for these as well but in the...

Thanks so much for your understanding.. So just to confirm I copy the code in the BeforeUpdate Event to The OnLostFocus Event (I can actually understand how that will work !) would you mind telling me how I add the "Set.Focus" into the code please I would assume it would be Docmd somewhere in...

again thanks for you reply and your patience ! I am sorry if i am confusing everyone ! So take it back to basics I have a new table with no records I have a form with 5 controls FirstName LastName Gender Date Occupation when I open the formm to enter the first ever record its focus will be...

sorry guys I may of confused the issue with my reply. The DB is in a design testing stage so I don't really mind if the old records work or not.. what I am trying to do is "finalise" this form so that when a user ends up on the form from navigation or buttons whatever it is and begins to enter...

Thanks guys for the replys but it seems not to working fully If I open the form and go to and old record then click in the gender control the msgbox will pop up (if gender is empty that is) and it won't let me move on until I choose a gender. If I go to another old record where gender control...

Hi Not sure i this is an easy one or not but I have no idea how get around it I have for form with a required control "Gender" The following code is under the BeforeUpdate event Private Sub PatientGender_BeforeUpdate(Cancel As Integer) Dim strMsg As String, strTitle As String Dim...

ha ha - thats working perfect now Many thanks Bob & Cbrighton for your help yet again Im very grateful Paul

Thanks again Bob but I am now get a Syntax error in From clause? any ideas? Paul

Ok so good news and bad news !! I re created the tables as before... Contacts: (Primary Key) ContactID - AutoNumber FirstName - Text LastName - Text OccID - Number Occupation: (Primary Key) OccID - AutoNumber Occupation - Text (sorry that was a typo on my original post) The relationship...

Can i just quickly ask... I am assumming my relationship is set ok?

Thanks Guys I will do all that now and post back to you Paul

Hi Guys hopefully you will kind enough to point me in the right direction I am sure this is simple but I just can't seem to work it out!! I have a test DB with 2 tables Contacts: (Primary Key) ContactID - AutoNumber FirstName - Text LastName - Text OccID - Number Occupation: (Primary Key)...

This has been resolved - Many thanks Mr B ;)

Hi Mr B Many thanks for the reply .. in answer to your points Just to confirm there are 1 to many relationships set up already and all relevant "ID" fields are in the various tables. The FirstName field in the NewTreatForm is a combo box referring to my DetailsTable. this was set up using the...

Hi All After hours of searching the net to solve this myself I have finally accepted I need Help !! I currently have 3 forms designed on my DB DetailsForm TreatSubForm NewTreatForm When a user opens the NewTreatform, they first have to enter a persons 'FirstName' if the name they enter is...

I don't think I will be building databases as a profession just yet !! but I am learning at lot and that is thanks to the people like yourself on here - it's great to share knowledge ! hopefully oneday I can help another newbie out - you never know !!! Thanks all again I'm off to see The Kings...

Thank you very much