dale5804
Last Activity: May 29 '08, 07:09 PM
Joined: Nov 12 '07
Location: wakefield
-
thankyou so much Stewart. it works :-)... -
cheers, getting there, the code doesnt throw an error up, but when the data is transferred, it prints the user as '1' then the time/date stamp?? I've also tried and removed the brackets as you suggested, and i stll get 1 as the username???...Leave a comment:
-
hi Stewart, thanks for all you help. i will keep trying, but you've been a star. wouldn't have got this far without your advice. cheersLeave a comment:
-
thought so, so i did what u said, and still having the same problem. any other ideas. cheers...Leave a comment:
-
do i need to call the module anything for it to work?Leave a comment:
-
hi...sorry, as you may have guessed, still new at this vb stuff. not quite sure what your telling me to do....Leave a comment:
-
didnt work, have changed to ReturnUsername (capital R & U, small n) and same problem???...Leave a comment:
-
hi Stewart, ive, tried and removed the & UserName(), and when i do, it works again????
if it helps...
This is the whole login form VB code
...Code:Option Compare Database Private intLogonAttempts As Integer Public UserName As String Public Function ReturnUsername() ReturnUsername = UserName End Function Private Sub Form_Open(CancelLeave a comment:
-
stuck again. when i click to add data (and stamp) having issue with this line:
Me.Comment = Me.Comment & " " & vbNewLine & UserName() & Now & ": " & Me.NotesMemoFie ld & vbNewLine
getting a compile error, which highlights the the Me.Comment, after the = sign.
It worked before, but once i add the UserName() it does as above.
any ideas. cheersLeave a comment:
-
hi.. thanks for that i understand better now.
now to move onto the code that does the time/users stamping
cheersLeave a comment:
-
Hi Stewart, thanks for the reply, ive done...
...Code:Private Sub cmdLogin_Click() Public UserName As String 'global to store current user name Public Function ReturnUsername() ReturnUsername = UserName End Function 'Check to see if data is entered into the UserName combo box If IsNull(Me.cboEmployee) Or Me.cboEmployee = "" ThenLeave a comment:
-
hi, tried it, but the code below on the 'on open' is giving me a compile error, a invalid attribute in sub or function, ad is highlighting this bit...
Public UserName As String
any ideas
cheersLeave a comment:
-
cheers for this, will give it a go today. many thanksLeave a comment:
-
login / username
hi.... i am used a tutorial found at...http://www.databasedev .co.uk/login.html... to create a login form. works fine, what i am wanting to do is on one of my forms, where data is entered i use the following code..
...Code:Private Sub InputData_Click() If InputData.Caption = "Input New Notes" Then NotesMemoField.Visible = True NotesMemoField.SetFocus InputData.Caption = "Add Data"
-
sorry... do you mean the properties for the 'input box' that pops up, as i can not goto properties for this.Leave a comment:
-
asterix password
hi im using the code below to password protect a button on a form.... is there any code i can use within the below to *asterix* out the password when typed in cheers.
...Code:Private Sub Edit_Staff_Click() Dim strInput As String, strMsg As String strMsg = "Enter your password to proceed." strInput = InputBox(Prompt:=strMsg, _ Title:="SCRM Security Check") -
done it.... tested it at home like u said and it works. fantastic. thank you so much for your help, your a star!...Leave a comment:
-
sorry, just to clarify, manual link?Leave a comment:
-
basically what i have done, is start with my current database, called SCRM. saed a second copy of it, and called it SCRM BE.
Within SCRM BE, i deleted all the forms etc, leaving only the tables.
Renamed SCRM to SCRM FE, and deleted all its tables, leaving only forms, queries etc.
I know if i use the 'get external data' with access i can link the two and it works. But i can not do this at work, where SCRM will be deployed,...Leave a comment:
-
hi, changed code to
strBeFile = "c:\SCRM_BE.mdb "
and changed file name, but still doesnt link. any more suggestions please.Leave a comment:
No activity results to display
Leave a comment: