Recent content by vspsdca

Hi. Thanks once again. I was able to fix the recent issue i posted. After a few tweaks here and there I was able to make it work using this code: Private Sub Form_Current() If IsNull(Me.Logged_By) Or Trim(Me.Logged_By) = "" Then Me.Logged_By = DLookup("ADMGName", "ADMFTeamMembers"...

Thank you Solo712, the environ("username") worked and it did retrieve the team member name from tblTeamMember. Ok here's what i am actually doing, I have a form (workbank) that we use to log change requests. Every team member has to log it in the workbank when they have completed the request...

Hello, just a heads up i am a novice in using vba. So i apologise if i dont sound techy. I am trying to set the default value of a textbox for new records to Environ("Username"), I was able to get this to work by using the code below.... with default value set to =fOSUserName() Private Declare...

Thanks Tony... Just looking through it already confuses me. I'll read all the articles you have suggested and will shoot you guys a message if i have any questions... Thanks to you too Leigh for taking the time to respond to my post. Best regards.

Thanks LPurvis and Uncle Giz Btw LP, the first link you gave is not working. To answer your question, Yes - I actually want a date generated based on e.g., today's date plus 1, 5, 7, 10, 20, 30 days from now. For instance I received a request today and it will take me at least 7days to...

Thanks for the quick reply Uncle Gizmo. So there is no hope to calculate the Due_date? I've thought of using a pop-up calendar for the user to use but to for them to manually count the days from a calendar and then select that date to populate the Due_date is a bit ancient considering that...

Hello, This is my 2nd post on this forum regarding the above subject, unfortunately I haven't really gotten the answer I have been looking for. I'm a newbie in VBA and just starting to get familiar with it so please bear with me if I may sound a little ignorant about this subject. My...

Hi, I'm pretty new here. A newbie on VBA as well. I just need some help on a form i'm working on. My scenario: Date Request Raised SLA for Days = with values of 1,5,7,10,20,30 (this is in a combo box) Deadline for entry What i would like to happen is for the Deadline For Entry box be...