Search results

If Sesso.Value = 1 Then Forms!FRMnuovoPaziente!Sesso.Value = "M" ElseIf Sesso.Value = 2 Then Forms!FRMnuovoPaziente!Sesso.Value = "F" End If I solved this way: Thanks anyway for hint

No sorry to be in hurry. There are some point I must clear: When I press Calcola it populated the form nuovo paziente but then it closed the form so the next command from subroutine to update Sesso does not works. I should populated also sesso before push calcola

ahhhhhh. put it in before update and it works like a charm. Many thanks

@sneuberg. The code is right and it works, but there is a question that "Uomo" or "Donna" must selected before than "calcola". Infact when I press "calcola" all the data in form FRMNuovoPaziente are filled. All is done by that button. Any hint?

In the Frame Sesso there are two radio button. When selected the Uomo I would like to write an M on another textbox in another form When selected the Donna I would like to write an F on another textbox in another form

Hi I'm going to select case 1 to pass that value (in letter "M") to another form textbox: I'm trying with no avail the following: Private Sub radioUomo_GotFocus() ' radiobutton Dim strUomo As String Select Case radioUomo Case 1 strUomo = Forms!FRMnuovoPaziente.Sesso.M Case*2: strUomo =...

pbaldy...solved. exactly with that code. Many thanks

I try this way: I got FRM A: two textbox inside (1)Firstname 2) Lastname) I would like to copy the union of the both separated by space into another form B textbox (FirstnameLastname) example FORM A: firstname : SPRINGSTEEN lastname: BRUCE into FORM B...

Can you please show an example? I suppose it is the second code...am I right? Using the second code it is the same: it splits like this LASTNAME: VAN Firstname: HALEN ROBERT

Hi MissingLinq your code: Me.LastName = Left(Me.Wholename, InStr(Me.Wholename, " ")) Me.FirstName = Right(Me.Wholename, Len(Me.Wholename) - InStr(Me.Wholename, " ")) Does works nice. But there is a problem. What if the name is for example more words. in eg. Van Helen Robert Infact the code...

Hi I have surname and name in the same column. I want them separate (splitted) For the surname I use : Firstname = Split(fullname," ")(0) and that return firstname. All is ok. But afetr there is a space and then the name. How to extract the name after the space?

Solved: If CurrentProject.AllForms("FRMMeseCorrentePIP").IsLoaded Then Forms![FRMMeseCorrentePIP].[FRMSottomaschera QueryPIPMeseCorrenteConcatRelated].Form.Requery End If If CurrentProject.AllForms("FRMMesePrecedentePIP").IsLoaded Then Forms!FRMMesePrecedentePIP.[FRMSottomaschera...

Hi. I have one form (FRMPIP) which has a button to save data and requery 2 forms Forms![FRMMesePrecedentePIP].[FRMSottomaschera QueryPIPConcatRelatedsuMesePrecedente].Form.Requery Forms![FRMMeseCorrentePIP].[FRMSottomaschera QueryPIPMeseCorrenteConcatRelated].Form.Requery The two lines of code...

Solved Tieval. Simply put on mainform Me.[FRMSottomaschera QueryPIPConcatRelatedsuMesePrecedente].Requery on Activate e on SetFocus property. No more error 2450, and it requery and update the form. Thanks for your suggestion . :o

Have set up a trick. On the mainform when clicking subform is requeryed. For the moment I can accept before engaging an update query that I should study. But another problem has arised. If the mainform containing the subform is closed when I go to entry data from PIPForm I get error 2450...

I'm afraid... The hurry. Db3 I digit two times entry for a patient and each time I pressed button it updates the previous entry. It does not update in real time

I'm working on a splitted database named Work. The only BE I have is Work_BE. I include it . But I don't know if it works because the Db1 I sent it is built for the forum and it is not split. Anyway I upload also Work_BE

Yes in fact I put underscore for spacing. Anyway I have brackened as you suggest but nothing happen. I have work_BE but that I built is an example exported database. Thanks for your suggestion :)

I mistyped. sorry . Point or exclamation point it does not works

here it is :