Hello, guys, i have just now updated my profile. In my first attempt i tried to write in my native language German, but my Keyboard failed.
I am looking for a support in that Forum. Aktual just simple, i wish to copy a Number Field from one Formular to an other. that sound simple but is not.
here a sample of my last coding
Sub dingsda...
FomsF1!TNr = FormsF2!TNr ' TNR is a Number and this number should transferred copied to Forms F1
' that sample does'n work properly
end sub
.
my first attempt with a text field and a "sendkey" was successful if I selected the field with the cursor beforehand.
I'm still in the process of finding a property to mark a field with VBA code?
If someone there to help please thanks in advance
Hier an other sample
Sub...
DoCmd.GoToControl "TNr" 'Position Cursor to NumFld "TNr"
SendKeys "^{c}", True ' Send ctlT + C to cut TNr it should be stored in to clipboard, but it does'n
' it copied the total Sub...instead of the content of "TNr"
DoCmd.Close acForm, "FThema"
End Sub
Thanks in advance
I am looking for a support in that Forum. Aktual just simple, i wish to copy a Number Field from one Formular to an other. that sound simple but is not.
here a sample of my last coding
Sub dingsda...
FomsF1!TNr = FormsF2!TNr ' TNR is a Number and this number should transferred copied to Forms F1
' that sample does'n work properly
end sub
.
my first attempt with a text field and a "sendkey" was successful if I selected the field with the cursor beforehand.
I'm still in the process of finding a property to mark a field with VBA code?
If someone there to help please thanks in advance
Hier an other sample
Sub...
DoCmd.GoToControl "TNr" 'Position Cursor to NumFld "TNr"
SendKeys "^{c}", True ' Send ctlT + C to cut TNr it should be stored in to clipboard, but it does'n
' it copied the total Sub...instead of the content of "TNr"
DoCmd.Close acForm, "FThema"
End Sub
Thanks in advance