General :: Auto Logout - User Settings

Jul 11, 2014

I am using this [URL] .... in our project but have made a minor change so it logs people out rather than close Access completely. It works beautifully but I want to take it a step further.

Instead of hardcoding the times in these two values

intMinutesUntilShutDown = 10
intMinutesWarningAppears = 2

I'd like to give users the options to set these themselves as not everyone will be the same. I am thinking I would have to check for who is currently using the database, this is stored in a hidden form in the following field.

[Forms]![frmwhoson]![whoson]

This username matches the users First Name in table Employees and in this table I have two fields to store these values

logmeoutafter
showlogoutmessagefor

So passing these values for the current user rather than having the logout times hardcoded.

View Replies


ADVERTISEMENT

Modules & VBA :: Tracking User Login / Logout

Mar 11, 2015

where I can find VBA for (Tracking User LogIn/LogOut) I have tried researching to no avail.I just need a simple code to track users logging date & time in and out of my DB.When they click on the icon on the desktop id opens the DB to login screen with username & password then into the DB.

View 9 Replies View Related

General :: Auto Email After User Input

Jan 10, 2013

Access 2007 DB. Is there a way to have an auto gen. email sent to me and or other admin. After user has completed input into form...

View 1 Replies View Related

General :: Auto Sending Email With Wrong User ID

Jan 21, 2013

have a vba code written to have my MS Access 2007 tell Outlook to send an e-mail with several attachments to whom it may concern, but I need it to change the "From" field in the e-mail, because there's many people who can send this, but it's looking like it's all being sent as my user. This is the code, it all works, but it doesn't change the sender field. Should I make some sort of auto-login macro or something?

Call fctnOutlook("Reconsideraciones BCH", EmailTasador, Email, , Subjet, "Agradecer revisar la tasacin indicada, de acuerdo a lo pedido en email adjunto, y me des tu opinin. " & vbCrLf & vbCrLf & "Favor no responder a Reconsideraciones BCH, no recibe correos es solo para enos, enviar a visador indicado en el email" & vbCrLf & vbCrLf & "Le saluda atte." & vbCrLf & vbCrLf & usu & vbCrLf & "Seccin Tasaciones" & vbCrLf & "Banco de Chile" & vbCrLf & vbCrLf & vbCrLf, Nz(Tpath), "Yes;No;Maybe", 2, True)

With objMail
.To = EmailTasador
.CC = Email
.Subject = Subjet
.Attachments.Add (Tpath)

[code]....

View 2 Replies View Related

General :: Access FE User Auto Copy Most Recent File

Jun 4, 2013

I have an access 2007 database that is split front end and back end. There are about 15 users and the backend is stored on the network. Currently I am e-mailing out the FE when chagnes are made so they have the latest copy.

With everything I have read I think a bat file would work the best at allowing me to make changes on demand without having to continually email out new versions of the FE. Sometimes the changes are behind the scenes unnoticable to the user while others are obvious.

Questions: Exactly HOW does a bat file work? When the user clicks on the access file stored on their laptop? Where is the bat file stored? I am unfamiliar with where to write the bat file code as well - notepad perhaps?

I am not sure how to create a bat file and what the code should be?

For version tracking I need to put a version table in the BE and in the front end correct?

have made a few significant changes but I'm holding out e-mailing it if I can get this version copying figured out and in place first.

View 4 Replies View Related

General :: User To Review Address Register - Auto Alert When Changes / Additions Made

Sep 27, 2012

I've got a database that allows all users to review an address register. If they find errors or mostly get updated information they have another form they can fill out to make the recommended changes. Only I have access to the main DB to make the change permanent.

The question I have is there a way for Access to send me a notification that someone has requested the change?

I know that sending an email is doable - in Access. However, that's not an option for our network here. I was thinking something along the command prompt "Net Send" command. However I've not been able to get that to work by itself - let alone within Access...

I have used VB code in the past to store what PC is using the database, I could modify that to alert me whenever I open the DB up from my PC. But I was trying to get away from having to open this particular DB up every day and check for changes.

View 2 Replies View Related

General :: Enable All Macros Settings

Aug 26, 2013

Why does one have to enable all macros in the trust center in order for VBA to run? I'm making front end applications with Access and having to allow ALL macros to make them user friendly makes a huge hole in general security. I don't use any macros - it's all done by VBA.

Users are on a plethora of different platforms so changing reg keys is out of the question. Is there some way of self sign an Access accde? Is there some safe GENERAL approach (trusted sites is not good either) to allowing VBA from my applications ONLY?

View 5 Replies View Related

Login And Logout

Jan 17, 2006

Hi.. Been trying to work this out for a little while now. I run an IT workshop for adults with learning issues and although my other office skils are pretty good, my Access skills are a little lacking.

My clients login and out on paper at the moment but I would like to change this to a database type system. The entries would only be name and an automatic one to record actual time of login.

Can anybody help me with the automatic entries?

Many thanks
Hoodlums

View 4 Replies View Related

Confirm Logout!!!!!

Jul 21, 2005

hi,
can any i tell me how to create a form or a simple messege to show the user, whe click to close the db???

for eg, show a messege like " Are you sure you want exit" Yes for Exit and No for carryon.

thanx

View 2 Replies View Related

Report Logout Help

Sep 29, 2005

Hi I am in need of help again.. Want to thank Ghudson for his help previously.

Now I am stuck in a stupid problem.

I have a log out button, but I cannot code up the button, where when I want to log out, it will automatically saves the record in a temporary database[auto generated] and it will date the database record on the day that i save.

View 7 Replies View Related

General :: Access Multi User Database - Error On Only One User

Apr 24, 2013

I have a multi user database in Access 2000 that is on a server. The individual users have shortcuts pointing towards the server instance. One user and one user only when opening the shortcut gets the error "you do not have exclusive rights to the database" .

All other users can enter the database with no error box. I have checked the advanced setting under options and they are correct. Ironically if you go to start and open access then navigate to the database shortcut. It opens with no error.

View 1 Replies View Related

Login Logout Project

Oct 31, 2006

Hi,

I want to make database only for time spent in office. In that database i want people to login and when they finish there work press logout. The table would consist nt username, time logged in and time logged out. This would enable time spent at work. When the person presses login it would stamp the time on the table along with the username.In this only check i want to enable is if the person presses login again then it says already logged in press logout. So no duplicate entrys in the database unless person first logs in and then logs out. I want to enable check before entering the data in the table. Attached is the database for further analysis. Please advise.

Thanks and Regards
Ankur

View 3 Replies View Related

Simple Login/logout Form For Existing DB

Jan 11, 2006

hi,

i've completed the whole access DB, but now i need to implement the login form, so each user can access their data + admin access.

what is the simples/fastes way to do this, since i've got working db. I add fields (user-log-id and password)to "userTable" and now i just need simple veryfication to login and logout.

thank you in advance,
t.

View 2 Replies View Related

Auto Populate User Name In Form

Aug 3, 2004

I am need of something that will help me auto populate the user name on a form. What I am thinking of is setting something that is diplayed when the form is open, asking users to enter their name. I then want this name to be populated in the user name of each record they update.

Can anyone help me? This sounds like a pretty easy thing to do , but sometimes what I think should be easy turns out to not do-able!

View 14 Replies View Related

Auto-modify User Form Input

Feb 2, 2006

I have a form where a user will enter a 11 digit number (12345043456). Using ASP (VB) this string of numbers queries an access database and returns the entry for that specific number to the user.

Unfortunately, the numbers in the access table are an 11 digit number with hyphens seperating the string like this 12345-04-3456 (the ndc # of a pharmaceutical).

So What i need is some code that monitors and modifies the form input so that the hyphens are added in to the string when the user is inputting the data.

If i cannot do this, then is there some VB that I can add which modifies the field in the text file when it is imported into access on a daily basis.


Thanks
Terrons

View 7 Replies View Related

Queries :: Auto Filling User Details

Nov 4, 2013

I have been managing a database system for a homeless shelter in my volunteer role. There is a certain feature that would improve accuracy of the inputted records, as well as freeing up time for staff. That is - auto filling a user's Gender and Nationality when inputting a record for the drop-in centre.

Currently, when a forename and surname is inputted in the "DropIn_Input" form, it is checked against the stored 'service users' table and checks for the name combination. If the name combination is not present then the forename and surname fields change to 'New'.

What I would like is to keep this, but if the service user name is stored in the 'Service User's table then I would like their Gender and Nationality to be automatically filled into the fields on the 'DropIn_Input' from the relevant information in the 'Service Users' table.

View 2 Replies View Related

Tables :: Auto Number For Multi User Form

Apr 12, 2013

Started a new thread: Rebuilt database and still working with auto number for multi user form. The code I have works for single user but not multi user. Also if someone opens the form and closes without adding anything to the form the number is used with blank record.

This is what I have thus far:

Private Sub Form_Current() Me.[PO] = Nz(DMax("[PO]", "tblPurchaseOrder"), 0) + 1
End Sub

View 5 Replies View Related

How To Make A Auto Fill Fielded Based On User Selection

Feb 13, 2006

Hi,
I've been working on a database to keep track of employee time off, It consists of the main table, a employee table, and a department table.

I had a form that our admin uses to enter the info for each employee.

They would select the name of the employee from a drop down, and then select the department that employee is in from another drop down. then they would select the days off and reason ect. Then when finished they would hit submit and this would be entered into the main table.

Well they just asked if it would be possible to make it so when they enter the employee's name, that the department would automatically be filled in for the employee.

Is this possible? I'm trying to think of how to do it, but not coming up with anything.

Thanks
Chris.

View 1 Replies View Related

User Login And Have Their INITIALS Auto-Filled When Filling Out Forms

Apr 17, 2013

I have a database where multiple users log in and work in 1 of 2 different forms. The 1st form in for initial data entry where users enter data then senter there initials and save each record. the other form is for QC'ing data that has been entered and they will add additional data to the form, then enter their initials and save the record.

How can I make it so that I can have a user once they log in to the database, it will autofill their initials? I have used a dropdown box before but it is not useful for people who have the same first name initial or worst, the same first and second initial because they end up selecting the wrong initials.

I do not currently have it set up where I have a login screen, I just have only forms visible to users when they enter data. Any easiest way to go about making this happen (I am just trying to shorten the amount of data entry that gets done).

View 9 Replies View Related

Tables :: Auto Calculation In Sum Field After User Input (numbers) In Fields

Dec 28, 2012

I have a table, at the table I'v got these fields:

ID | num1 | num2 | sum

I want that the user put numbers at 'num1' and 'num2' fields and then the 'sum' field will calculate automatically the operator (sum=num1+num2).

I've tried to put any combination at 'Default value' of the sum field (all the fields are numbers , also tried to change the sum field to text...nothing works).

I'm getting a message that 'num1' field is not recognize at the table

(I tried =[num1]+[num2], without the '=', num1.table+num2.table , ...nothing works)

I also tried to do it with SQL command but it dosn't work.

There is any way to do it, is it possible? Or other way to do it at least at Form or at Report ?

View 7 Replies View Related

Auto Generate PDF When User Click A Link Based On Available Tables Within Database

Aug 9, 2012

I would like a way to auto-generate a pdf when a user clicks a link based on available tables within my database.

Basically i have developed a pricelist database and our reps need a printable pdf version of that available items and there attributes.

I have done some research and it appears that visual studio and crystal reports may be what I am looking for. This is an access web database that is accessed housed in sharepoint.

View 1 Replies View Related

What Have I Done To My Settings?

Jan 2, 2007

Installed Access 2003 recently and could swear that on a form in design view, sizing a control button for example, by holding down shift key, worked as I expected; it sized up or down by 1/4th of a grid line.

Today, I hold down shift and size a control, and it sizes up or down by one full grid line. Can't find anything in Options that I might have changed, nor in the Format menu.

Does anyone know what may have caused this?

View 2 Replies View Related

General :: Auto Number Other Than Just 1

Mar 14, 2013

I am creating a file and I am not stuck on the last part. I have to keep track of which numbers of a particular item is sold due to serial number tracking. Items are bundled in sets of 50 so I need to form to auto populate the next set of numbers (by 50) when I create a new line.

I found how to change my start number to 1751 but I can not find how to have a Begining number of 1751 Ending number 1800 and have the next line auto populate begin $ 1801 end # 1850. I have a feeling it will not be the Auto Number option and I am sure there is another way but I just can't find it.

View 4 Replies View Related

Security Settings

Jul 19, 2006

I am new to the Access database building. I am trying to create a Student database for contact information, etc. I have a main table which stores all the users' data. When the student opens the database, I would like to identify the user. They should be able to view everyone's information, but only edit their own. How can i make this happen?

Also, if that is easy enough, I would like to identify when a staff member logs on. This way they can have special permissions to access a schedule searching feature, to look at all the students schedules.

Thanks for the help.

Mike

View 5 Replies View Related

ODBC Settings

Mar 16, 2007

Good Morning,

Im trying to set an ODBC connection to automate the connection process.

The current code I have is:

Set wrkODBC = CreateWorkspace("NewODBCWorkspace", "admin", "", dbUseODBC)
MsgBox "Opening Connection...."

Set MainConn = wrkODBC.OpenConnection("Connection1", dbDriverPrompt, True, "ODBC;DATABASE=live; DSN=live;")

which works fine in bringing up a dialog box to choose the connection.

But what do i write in the database and dsn fields to enable the automation process.

See attached picture for the log in settings. All I have to do is press 'Connect' to start talking to the ODBC.

any help would be greatly appreciated.

Justin

View 6 Replies View Related

Can Anyone Help With Laptop Settings?

Jun 6, 2007

How to swith sleep mode off? Does anyone know? thanks

.................................................. ............
<offending URL removed>

View 3 Replies View Related







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