Automating UserID/Password Info

Nov 3, 2007

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

View Replies


ADVERTISEMENT

[UserID] Is On A Distinguished Road? Huh...

Aug 5, 2006

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

View 14 Replies View Related

Query Results Based On UserID

Apr 17, 2008

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

View 2 Replies View Related

Display UserID And Username On The Form

Aug 16, 2005

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.

View 1 Replies View Related

Record UserID In Table Question

Oct 14, 2004

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

View 2 Replies View Related

Tables :: Relationships - Link UserID To Each Line Automatically

May 1, 2013

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?

View 1 Replies View Related

Update Order Info Based On Quote Info

Nov 7, 2006

I need help on this, from what the best concept is, to what I need to look into using:

I store Quote data from phone calls into tblQuotes. There is a seperate table that holds much of the same information except that it is for actual orders called tblOrders.

As far as function goes, I have each working much the way I need it to except for one thing... If a sales person is on the phone with a customer with a quote already in the system, right now they re-enter the data into the Order table. Most times, the order is what was quoted, but maybe with a few small changes (so I will wnt to keep a historical record of the quote). How could I copy the contents of the quote recordset into the recordset for an order, where all the sales rep does from there is edit the quote to the actual order?

Would I use VBA or an update query that is executed via VAB? Honestly, I am unsure how to do this at all, I hope someone has seen this before and has a good suggestion...

Thank you.

View 2 Replies View Related

Not Prompted For Password When Relinking - 'Not A Valid Password Message'

Mar 29, 2007

I have recently split my database and added a password to the back end. I am now trying to re-link the tables as I have seen in other threads, but when I do this I am not prompted for the password I just get the message 'Not a valid password'

I must obviously be doing something wrong, can anyone help?

View 4 Replies View Related

Password Issues With Non Protected Database Asking For Password

Nov 8, 2005

Hi,

Firstly thank you for your help, this should be a simple one I hope, but is cracking my head on the wall. Have searched and searched and can't find an answer.

I have an Access Db that is not password protected, but is asking for a password.
It opens on any other machine fine?

I think my version of Access is playing funny buggers with me, any suggestions?

I was trying to implement some security on this Db, which is why it happened I'm sure. I ran the security wizard, set-up two users and admin with passwords, I have the output file to "recreate" something too.

Issue is, I then copied this Db to another computer for use on there, it worked without a Password, so didn't need to worry about it, now I can't open any Db on my machine??

Your help on this obvious pointer would be great!

C

View 3 Replies View Related

How To Crack Ms Access Password, I Have Set User Name And Password

Sep 12, 2006

hi pals

i have set username and password for ms access file.

unfortunately i have forget that password?

how to crack that username and passowrd?

is there any softwares available?

i can easily crack the database pasword? but how to crack username and password of ms access file.

View 1 Replies View Related

Forms :: Password Protecting Field With Password?

Oct 24, 2014

i have found a code that brings up a box when tab or clicking in to a box for editing as below:-

Dim strPassword As String
If InputBox("Please enter the password:") <> strPassword Then
SomeOtherControl.SetFocus
TextBox1.Locked = True
End If

its just that need to add a password as well, i have tried to put this in between the <> but this does not work. i would like a message to say incorrect password as well if possable.

View 4 Replies View Related

Automating A Query

Oct 27, 2007

After running an UPDATE or DELETE query I get the typical Yes/No screen (ie. Do I want to procede to carry out the changes?). Is there anything than can be added to the query that would automatically answer YES, and eliminate the Yes/No screen from appearing.

View 2 Replies View Related

Automating A Import Function

Jan 23, 2007

I am trying to automate an import function for my database. I recieve a disk that has about 200 little spreadsheets on it every month. I need to either import these or set-up link tables to them in a more automated system than doing it all manually. (It takes a lot of time to do manually) Please can anyone help.
Note: The files are all named 3000 to 3200. The following month they are called the same. I'm hoping this will not cause to much of a problem.
PLEASE HELP

View 5 Replies View Related

Automating Table Deletions

Aug 30, 2006

Hello,
I have a general table question. I have a VB programmed user interface logging information to a MS Access Database Table. I want to automate it so when you open up the table to view what was logged -- any table entry older than 2 weeks is removed from the table. Will this be difficult? Any suggestions on how to start? Are there any access functions that will do something similar to this? Thanks in advance.

Zak

View 2 Replies View Related

Automating A Delete Query

Jan 2, 2008

I currently have the following query written:


DELETE * FROM TABLE1


When runs, it tells me the number of rows to be deleted and I have to click "Yes" for it to run. Is there a way to run the query and not have the prompt so it will run without human input?

View 1 Replies View Related

Automating Criteria In A Query?

Oct 7, 2004

Not sure whether this is possible. I want to use a command button on a form to set the criteria for a particular field in a query. I have created a combo box listing the possiblities I require, but don't know where to go now, I have tried using SETVALUE, but it doesn't seen to like this. Any Clues?

Thanks

View 1 Replies View Related

Automating A Datatype Change

Feb 1, 2006

When I export or do a make table query from Oracle to Access, the new table has some of the datatypes changed. Many of my numberic fields are decimal instead of Long Interger. I then need to go and manually cahnge them back. If I forget or miss one, it crashes another application we use.

Has anyone come up with a solution to automatically go through the table structure and change the datatype from one format to another? This would be a great help.

I am using Oracle 9i and Access 2002.

Thanks for you time

Sherriff

View 1 Replies View Related

Automating Import And Export

Feb 11, 2013

I would like to automate this daily process: In this order import or link, (not sure which is the best option) a fixed width table, add an ascending number to the end of each of the records, reverse the order, and finally export to fixed width .txt documents depending on the quantities in one field. There would be 3 text files exported, max.

View 4 Replies View Related

Automating Periodic Repair And Compact

Jun 6, 2005

Hi All!


I have Access 97 client and server databases linked together. My system is setup so the database is aware of how many users are currently logged in so Ill know when it is being used exclusively. What I want is some code to check every week that a repair and compact has been performed and if not start one on both the client and the server databases (assuming no one else is in them). Do I need code to delete the LDB files beforehand aswell just in case?

I kind of imagine this check will be performed when the first person logs in of a morning.

Client: rentals_prod.mdb
Server: rentals_data.mdb

Regards,

Dalien51

View 3 Replies View Related

Automating Internet Explorer With Office XP.

Jul 29, 2005

I´m thinking of starting to use office XP for a small system I have. My question is:

Is office XP more compatible with internet explorer in terms of VBA automating? I have had to work around internet explorer quite a lot in office 97, and I haven´t been able to do what I want.

Fuga.

View 4 Replies View Related

Automating Import Of Excel Into Access

Sep 7, 2005

Hello All
is there a way (i guess using VBA) to import an excel spreadsheet into an access table without having to go through the wizards, if you know all the field names and other variables ??

Yours in anticipation

DJS

View 8 Replies View Related

Automating Date-Based Updates?

Jan 20, 2006

I am a new Access user. I have created a database to track and inventory animals brought to a local animal shelter. The database includes information such as when the animal was brought in, who dropped it off, when it was adopted (Hopefully!), etc. The database is being used by people who have limited computer experience and the challenge has been to automate it and simplify it as much as possible. I have created several Switchboard pages to try and accomplish this.

I have done research through Google and MS support and have found little help with a solution to this problem:

When an animal comes to the shelter, it is held for three days before it becomes available for adoption. I have created seperate fields for Date In Day, Date In Month and Date In Year. There is also a field detailing the animals adoptability status. This field is left blank in the intake process, and is then manually updated to Adoptable, Biter, etc., after the three day period. Is there a way to automate the Adoptability Assessment Field (which is a Lookup Table Field) so that it changes from blank to Adoptable after the three day period? (We have very few animals come in that are marked as Biters, so I just need the field to change over to Adoptable after three days have passed. Unless a solution can be presented to filter animals with Biter status out of the solution.)

I truly appreciate any help that can be offered.

View 4 Replies View Related

Problems Automating Access With Powerpoint

Aug 3, 2006

Ive been following the code on the Microsoft support site for automatically creating a PowerPoint presentation using data from Access.

The sample code takes one field from the sample table and displays this on the PowerPoint slide - it then assumes the user can apply this knowledge and add more fields to the slides themselves. I have tried to do this but am getting nowhere.

Please can somebody advise how I add additional fields to the slides via the code. I am afraid Im not very confident with VBA so am stumbling a bit blindly here. Here is a sample of the code that I think I need to add to:

With ppPres
While Not rs.EOF
With .Slides.Add(rs.AbsolutePosition + 1, ppLayoutTitle)
.Shapes(1).TextFrame.TextRange.Text = "Hi! Page " & rs.AbsolutePosition + 1
.SlideShowTransition.EntryEffect = ppEffectFade
With .Shapes(2).TextFrame.TextRange
.Text = CStr(rs.Fields("LastName").Value)
.Characters.Font.Color.RGB = RGB(255, 0, 255)
.Characters.Font.Shadow = True

I tried to replicate the last bit here by adding Shapes(3) and the new field name, but I must be doing something wrong because Access throws up an error message.

If anybody can give me some pointers I would be grateful. Also, if anyone can advise how I can determine the position of the fields on the slide I would be grateful (they seem to be centering at the moment).

The link for the full code is here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno2k3ta/html/officeaccess2powerpoint.asp

Many thanks,
Adam.

View 1 Replies View Related

Automating Expiration Date (and A Few Other Things)

Aug 6, 2007

Good morning to everyone.
I am hoping that you will be able to help me with a table that I am working on. I have almost no experience with access, so I am useless when it comes to this.

I have attached a condensed version of the database that I am working on (removed everything except the one table that I am working on) so that you can see and edit what I am working on.

The requirements are simply this.
-If "Status" = 'new inquiry' and has not been update in 6 months, automatically changes to 'inactive' and "probability of order" automatically changes to 0%

-"Initial Inquiry Date" is set to the date the Inquiry was added to the table (but user has ability to change it manually)

-*bonus* If ship quarter has passed todays quarter then change "Status" to 'inactive'.

I hope I have attached enough for everyone to be able to help.
Thank you very much in advance, I really appreciate it. :)

View 14 Replies View Related

Automating A Mail- Merge In Access

Apr 18, 2006

I'm using a query that selects all customers from a Customer table who haven't made any payments for a particular week and then sends a letter to them.
I would like to use a command button on a form which the user can press and then view the letters for all the customers- they would only have to specify the week.
Is this possible?
Thanks

View 3 Replies View Related

Selecting Items And Automating Actions

May 19, 2012

I have a report, which shows all unsold items for a particular auction date, and I have created a form using this report.

I'd like my sister in law, to be able to go through and easily select which items to relist, and which to return.

I've tried using a subform, but I've either not done it correctly, or its not quite the right tool for the job. I've tried listbox control but can't get it to work properly either.

Once she has gone through the list ticking one or the other, I'd like to be able to automate with a button "Relist" and a button "ReturnItem".

I'd like Items to be returned - to automitcally close item off so it no longer incurrs a weekly listing fee and change status to "ReturnToSeller" and the relist ones, to create a new entry line into the main item table, with replicated information, except it clears out the "lot number", as they enter that manually when the generate a new list for the next auction, my ID numbers remain current and unchanged but the tableID is automated to a new one which is my key number.

then on my invoice, I get for instance, 3 rows for one Item, which could have 3 different lot and ID numbers, and get a listing fee of £1.20 for each week you see.

How can I automate the actions to relist and Return to Seller?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved