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
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
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
Hi stoey
Why don't you give me an example and I can show you how to make it work.
Dave
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
Hi dave,
here is an example of a database that I am referring to.
Thanks,
stoey
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).
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
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,
do i need to change something in the macro for it to show the user's data?
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?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks