+ Reply to Thread
Results 1 to 9 of 9

Display user's database or record after login

  1. 09-02-2011, 02:27 PM #1
    stoey
    stoey is offline
    Forum Contributor
    Join Date
    08-07-2008
    Location
    United States
    MS-Off Ver
    Microsoft Office 2003
    Posts
    362

    Display user's database or record after login

    Hi there,

    anybody knows how to display the user's record or database after he/she login in on the system. Currently I have a database where in the user enters his username and password. But the I dont know how can I make his records display after login. Any help help would be appreciated.

    Regards,

    stoey
    Reply With QuoteRegister To Reply
  2. 09-02-2011, 04:49 PM #2
    davegugg
    davegugg is offline
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: Display user's database or record after login

    I'd think you'd want to capture the username with a variable, then use that variable as a parameter for a query used to populate the form that opens when the database opens.
    Is your code running too slowly?
    Does your workbook or database have a bunch of duplicate pieces of data?
    Have a look at this article to learn the best ways to set up your projects.
    It will save both time and effort in the long run!


    Dave
    Reply With QuoteRegister To Reply
  3. 09-02-2011, 04:55 PM #3
    stoey
    stoey is offline
    Forum Contributor
    Join Date
    08-07-2008
    Location
    United States
    MS-Off Ver
    Microsoft Office 2003
    Posts
    362

    Re: Display user's database or record after login

    hi dave,

    thanks for the quick reply...if this is not too much to ask, would you mind providing me a sample which can help me to start with? I just dont seem to make it work how I can link the user's id to display the record after logging in.

    thanks in advance

    stoey
    Reply With QuoteRegister To Reply
  4. 09-06-2011, 11:42 AM #4
    davegugg
    davegugg is offline
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: Display user's database or record after login

    Hi stoey

    Why don't you give me an example and I can show you how to make it work.

    Dave
    Reply With QuoteRegister To Reply
  5. 09-09-2011, 12:14 PM #5
    stoey
    stoey is offline
    Forum Contributor
    Join Date
    08-07-2008
    Location
    United States
    MS-Off Ver
    Microsoft Office 2003
    Posts
    362

    Re: Display user's database or record after login

    Hi dave,

    here is an example of a database that I am referring to.

    Thanks,

    stoey
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 09-09-2011, 12:48 PM #6
    davegugg
    davegugg is offline
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: Display user's database or record after login

    You need to merge your tables into one table. Each record should have a numerical ID. You have an ID field set up in tbldata, but you have it set as text. Change it (in the table's design mode) to an autonumber. Then you can use the ID number on your Switchboard form. Let me know if you need more guidance.

    You're very close, and with the changes described above, you should be able to make it work. As a guide for helping you to know how to set up tables and what info should be in each table, check out this article (props to Alansidman).
    Reply With QuoteRegister To Reply
  7. 09-09-2011, 12:58 PM #7
    stoey
    stoey is offline
    Forum Contributor
    Join Date
    08-07-2008
    Location
    United States
    MS-Off Ver
    Microsoft Office 2003
    Posts
    362

    Re: Display user's database or record after login

    Alright, I change the ID from text to Autonumber...still it doesn't display the user's database...hmm...not sure what do you mean by merging tables how can I do that?

    regards,
    Reply With QuoteRegister To Reply
  8. 09-09-2011, 01:02 PM #8
    stoey
    stoey is offline
    Forum Contributor
    Join Date
    08-07-2008
    Location
    United States
    MS-Off Ver
    Microsoft Office 2003
    Posts
    362

    Re: Display user's database or record after login

    do i need to change something in the macro for it to show the user's data?
    Reply With QuoteRegister To Reply
  9. 09-12-2011, 11:58 AM #9
    davegugg
    davegugg is offline
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: Display user's database or record after login

    The code looked fine to me. I think you should combine your tables. Just have one table. Did you read the article I linked to?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1