Usernames in MS Access forms

Posted on 2009-12-18
Last Modified: 2012-05-08

 I have a making an access database which has a login form. I would like to pass the login name to other forms so that it maybe submitted into when the user completes the forms. Any information would be greatly appreciated.
Question by:Silverthorne
    LVL 6

    Accepted Solution

    create a public string in a module and save the username to that module and then you reference it the same as any other without having to do dim sqlstr as string first.

    Either that or when you open the form pass the txtusername.value to the new form with a similar name that is hidden from users so you can reference it whenever you want.

    so on the openform of the next form do a me.txtusername.value = forms!loginform!txtusername.value

    Author Comment

    Thanks for the help. Since I am new to Access, can you please provide a sample?

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    If I have to fix slow responding website my first thoughts are server side optimizations: the database may not be optimized or caching is not enabled, or things like that. We often overlook another major part of our web application: the client. We o…
    Developer tools in browsers have been around for a while, yet they are still heavily underused by developers. Developers still fix html or CSS then refresh page to see effect, or they put alert or debugger in JavaScript and then try again and again …
    Use Wufoo, an online form creation tool, to make powerful forms. Learn how to selectively show certain fields based on user input using rules to gather relevant information and data from your forms. The rules feature provides you with an opportunity…
    Learn how to set-up PayPal payment integration in your Wufoo form. Allow your users to remit payment through PayPal upon completion of your online form. This is helpful for collecting membership payments, customer payments, donations, and more.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now