Click on someone's post. In the upper right, click on the wee little green box directly under Posts:
We then see [UserID] & " is on a distinguished road", e.g.
"Stumpy is on a distinguished road"
What do you suppose that's about?
Bob
Hi –
Situation: I pay all of my recurring bills (mortgage, insurance, utilities, medical, credit cards, etc..) via internet accounts. A dubious decision on my part which was driven home when my ISP (the only game in town out here in the woods)...reassigned their remote servers without informing their help desk, and failed to calibrate the new settings to equal the previous settings. Result: I was without DSL access for six to eight weeks while the help desk folks repeatedly referred to their documentation and instructed me in establishing a new connection, which was an absolutely worthless effort. Why, do you ask, did you not request for a technician to be sent to yiour site? Cause, they (the help folks people) apparently receive bonuses for blocking on-site service calls.
Having said that, my 14 – 17 accounts have varying UserID/Password creation and input criteria. It’s quite easy to assign an HTML field which, when clicked, takes the user to the initial site. In some situations, I’m allowed to click a “Fill And Submit” button, which brings up and submits previously saved criteria.
In other cases, the user is required to submit both UserID and Password, and God help you if the information is case sensitive and you screw it up.
Bottom line: The UserID/Password has been captured for each and saved in a separate database. It’s thus possible—but a real pain—to refer back in each instance to ensure the correct data is being submitted. A Google on “Automate Password” shows that this problem has been previously addressed, but not in an Access environment.
My Question: Have any of you run into this, and is there an Access-related solution?
Thanks,
Bob
Hello,
I have a query (used in a combox) with a field called "UserID" and in the query I would like to have the UserID field get it's criteria from the "User" field on a hidden form.
I have it for the most part however, I have two users (myself and another) that when we use the combo box we se "All" the records in the query.
I was thinking something like:
IIf([Forms]![frmUser]![user]= [User],true, "*")
I hope this makes sense.
Thank you
Hi I want to do following in my application
1. Display userid and user name on the form, how can i do it.
2. When i am adding record, user should not be able to go back to previous record.
3. A form should open automatically when i open my application.
I have a form that several different people use. I would like to capture who created or modified the record. I don't need any fancy security such as a password. I just simply want the user to select their name from a combobox and then any records that they create or modify is saved in the records table. I would like this name to be the active name for all records worked on untill another person logs on. In other words, I don't want them to need to select their name for each and every record they work on.
Thanks in advance - John
One table contains UserID and information related to the user. Another table has been created and will be populated by a form. Basically the form asks approx 65 questions and I need the answers (for each question) to populate the table, so 65 records of data.
From everything I have read, for me to be able to pull all of the answers linked to the UserID (the person answering the questions), the UserID has to be in the table with each record. How do I link the UserID to each line automatically. To give you a bigger picture, I will have 5 users going into the database daily to answer the questions and I will need to link the user ID to each of the answers selected by each user. Over time, there will be thousands of records and I need to pull stats by UserID.
How do I create the form so that the answers to each question creates 65 separate records. Do I have to create a save button after each question?