User Only Allowed To Use The Form And Can Do Nothing Else Outside Of The Form

Mar 31, 2006

Hi Folks,

I am wondering if someone can help me determine someway to setup a microsoft access database that I have so that the user can do nothing at all besides using the input form that I created and that automatically opens and is maximized via the autoexec macro. The reason for this is because although the user does need to use the form to enter or edit data, I do not want the user to close out the form and start playing with the data table or queries outside of the form. Is there a way where if the user closes the form, it will re-open very quickly so that there is no way they can do anything but use the form ... or some method that anyone knows about that might work. I really appreciate any help I can get, because this is for a non-profit governmental agency and this is the final piece that I would like to impliment before roll out into production on Monday.

Thank you,

Joe

View Replies


ADVERTISEMENT

User Only Allowed To Use The Form And Can Do Nothing Else Outside Of The Form

Mar 31, 2006

Hi Folks,

I am wondering if someone can help me determine someway to setup a microsoft access database that I have so that the user can do nothing at all besides using the input form that I created and that automatically opens and is maximized via the autoexec macro. The reason for this is because although the user does need to use the form to enter or edit data, I do not want the user to close out the form and start playing with the data table or queries outside of the form. Is there a way where if the user closes the form, it will re-open very quickly so that there is no way they can do anything but use the form ... or some method that anyone knows about that might work. I really appreciate any help I can get, because this is for a non-profit governmental agency and this is the final piece that I would like to impliment before roll out into production on Monday.

Thank you,

Joe

View 1 Replies View Related

Null Not Allowed, User Friendly Msgbox

Jul 27, 2005

I have a table field where Null is not allowed, how do I use a user freindly message to tell the user to add data to this field. When a user tries to leave the field Null (ie by tabbing out), they get a message, "tried to assign NUl value to vaiarble which is not variant datatype.

What I want to appear is more like "Please enter a name" or some other custom message.

Any ideas - I have tried before anfd aftyer update events and vaidation rule on the form field of Not Null, but the underlying message always appears first.

Paul

View 3 Replies View Related

No More Than 4 Employees Allowed On Form

Oct 25, 2012

On my form I need to limit the number of employees that can be entered using OnCall as the criteria or use ExpName or Employee ID

If this criteria is NOT met then disable On Call. In other words if they try and enter a 5th employee then the field On Call/checkbox is disabled

name of field is OnCall and actual control is named On Call

I need this to fire on the OnCurrent Event for the form which is named frm_Employees_on_Call_What_Order

In other words, no more than 4 employees are allowed to be on call at the same time. The fields for the query the form is based on are:

All are form the Employees table

Employee ID Employee autonumber primary key
ExpName name of employee, includes first and last name
On Call Yes/No checkbox used for if a employee is on call or not

query used is named qry_On_Call

View 1 Replies View Related

General :: Create A User Form With Sub Form Using Form Wizard?

Aug 10, 2013

I am trying to create a user form with sub form using the form wizard. I have only 2 tables, Employee (main table) and Vacation (subform table). I pick the fields from Employee Table then fields fro Vacation, but the wizard treat the Vacation as main form and Employee as sub form.

View 4 Replies View Related

Forms :: Based On User Selection In A Form / Create New Records For Subsequent Form

Feb 3, 2014

The user will be creating a new project that contains a bunch of releases. The releases have standard names which are stored in a table tbl_ReleaseNames It should be noted that the list of names is not static.

The user selects which of the releases pertains to their project and then based on their selections, new records would be created in tbl_RFP_Release and then a subsequent form would open where it would display each of these newly created releases where they could enter additional information. I thought of creating an unbound checkbox associated with each of the standard names, and then checking to see if the checkbox was checked and then creating the new records followed by opening up the new form.

View 6 Replies View Related

User's Form Or Login????

Jul 17, 2005

hey,
can ne1 tell me how to create a User Login form in Access??? i want disply this form 1st, when i open the bd???? i am very new to Access. :)

thanks :) :)

View 3 Replies View Related

User Input Form

May 22, 2006

I am trying to make user input forms for each of the tables in my current database. I have made the forms, but I am required to have the forms come up blank first (so they can create a new record), but allow the user to edit existing records too. How do I do this?

View 3 Replies View Related

Trap User In Form

Oct 18, 2006

I know this topic has been covered over and over but I've searched and searched and can't find my answer. I did find one post with a link to a possible answer but the link was broken.

My form has a required field. When a user attempts to X out of the form I have code in the Before Update event that checks this field and if it is blank:

MsgBox "Payment Terms must be filled in before closing the form"
Me.PaymentTerms.SetFocus
Cancel = True

The message box appears, but then the

You can't save this record at this time...blah blah blah.....

dialog appears and then the form closes.

How can I prevent the user from closing the form if this field is blank? It seems like once the X is clicked there is no turning back. I realize that I could remove the close button (X) from the form and use a command button instead but this may only mess up the users who have been using this DB for years. Is there any way to go backward once the close button has been clicked?

Thanks for your help.

View 6 Replies View Related

Adding User Help To A Form

Sep 30, 2004

Newbie here.

I would like to add some text help describing what the fields in an Access form mean. Under "Help" it mentions a What's This button which can be found in the properties box under design view. I have been unable to find any "What's This" fields in the property box. Can anyone point me to this?

Also, I saw that I could create a rich text file to be displayed when a user presses the F1 key. Can this just be an HTML file? It mentions needing to compile the .rtf file. How does one compile this?

Any insightful comments would be greatly appreciated.

Thank you.

G

View 1 Replies View Related

Multi-user Form

Jan 13, 2005

I have a form "log_file" that I am going to be placing a nework. All I have done is create a new DB, create a table, and create a form. Now I want to make it so users open up the DB file and only see the form and cannot access/edit the table. Basically, It is okay if they go back and forth through the records and change those, but I don't want them to be able to edit the form either.

I'm just not sure where to go from here. If there is more info I should provide please let me know.

Thanks in advance.

View 3 Replies View Related

Stop A Form Being Moved By User

Feb 20, 2005

Is there anyway to stop the user from beng able to move a form. I.e. as in change its position on screen.

I am aware that you can do this by setting the border type to "none". However, I want my form to have a title bar along the top, so I cant use this method.

Is there another way to do this?

Thanks in advance.

EDIT: Ive found some information on the "movable" property, but I am using access 2000 and cant get it to work.

View 7 Replies View Related

User Change Image On Form

Sep 25, 2005

Wonder if you guys can help, I have searched the forums, but can't find an exact match to my query...

... i want my users to see a coloured image on their form to alert them to the status of a record in the database.

I have 3 very small bitmap images (named red, amber and green and stored directly next to my database ). I want to allow users to change which image should display on any given record by choosing either from a combo-box or radio buttons located next to the 'image space' on the same form. This image change will then save when the database is closed and remain until it is changed to another staus by a subsequent user at a later date.

Any ideas greatly appreciated (I'm currently at [I]'dimwit' level with coding)

Id

View 3 Replies View Related

How Do I Capture User Info In A Form

Jan 22, 2006

:) Hi Guys,
I have a small problem, hope you can help me out. I have created a a form in Access for data entry. But I would like the form to capture the data and time and the user who's entering the data into the form.
How do I do that. Been trying to figure it out:rolleyes: . Hope you can help. Attached is the screenshot of the form I created. Thanks a bunch

http://img21.imageshack.us/img21/5612/screenshot4ic.th.jpg (http://img21.imageshack.us/my.php?image=screenshot4ic.jpg)

http://img21.imageshack.us/my.php?image=screenshot4ic.jpg

View 3 Replies View Related

Preventing User From Restoring Form

Jul 11, 2006

Hi

Hoping someone can help me here. I have a form which is maximised on startup which also has the min/max and close button disabled. What i'd like to do is also prevent the user from restoring the form to ie. click the restore button which then makes the form smaller as i'd like the form to permanently remain maximised.

I'm not sure if this is possible, but if not is there a way to size the form to fit the height and width of the screen as if it was maximised regardless of the screen resolution the user is using.

Any help would be appreciated.

View 3 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

User Must Save On Form Or No Entry

Feb 3, 2005

Hello,

Can someone please tell me how to make it so that a user must save on a form or there is nothing entered into the table? As it stands anyone who views the form creates a new record.

Thanks in advance!

View 4 Replies View Related

Creating User Form Filter

Aug 2, 2005

Hi can anyone help me. I need to create a form filter that will allow a user to enter an amount into a text box and then run the filter to match the amount entered. I have tried creating a macro that will execute this but it wont work. any ideas?

Thanks

View 2 Replies View Related

User Input From Form To Table

Oct 9, 2006

I want to put a textbox on a form that will take user input (a zip code) and put it into a table. I'm not sure how to do this. Is it even possible, and if so, any suggestions?

View 2 Replies View Related

Forms :: User Input Form

Jul 29, 2014

I am working on a database that uses a form requiring personnel to log in. This information comes from a user table and is something that I have added on numerous occasions to various databases. The question I have is in relations to a "lockout." How do I set it up so that someone gets locked out after so many attempts loging in on this form?

View 8 Replies View Related

Forms :: Same Form But Different Controls Per User

Sep 19, 2014

Is it possible to have a form and dependant on the security level of the user, will depend on what control will appear?
Or can I have the controls there and lock them to a user?

I have a DB of staff directory and I want to lock it so users can only view information, supervisors can edit and admin have full control.

I've done it so far by creating a different form and controls for each level but it a lot of work and queries. Is there a simpler way to do it?

View 6 Replies View Related

Multi User Login Form

Aug 3, 2015

I am trying to create a multi user login form for my Access 2010 database. I will have 2 different types of users (administrator and staff). The administrator will be able to see all tables and forms and edit/ add to them. The staff will only be able to view a switchboard form and 2 forms (as well as using combo boxes to look up specific records). However, I don't want the staff to be able to view the tables or edit anything.

View 3 Replies View Related

Capturing User Name From Form Field Entry

Feb 6, 2007

In this db, the users select their name from a dropdown in an auto-open form, but with no password. I want to capture this value for use as the default value in a field on another form, but with the first form closed. I have seen the ENVIRON(Username) function referred to many times on here, but I need to capture the entered value, not the Windows or network login.

Is this possible without leaving the form open? I suppose I could just set its Visible to False when they enter their name, but I try not to have any more windows open than are necessary.

THANKS for your help!!

View 8 Replies View Related

Limit User From Accessing A Specific Form

Jan 11, 2008

I am having a problem restricting a user from a certain form.
I have a module that detects if a user or admin based on the roles entered in the employees table.

If their windows login is not listed in the employees table, they will not be able to view any of the forms.

Here's my problem, I want the users to access the switchboard, but they should not be able to get into the reporting button.

here's my code:
If LOAStatusbtn.Caption = "View Report" _
And Not admin _
Then
'useraccess denied because not an admin
error_text = "You do not have privileges to access this screen." & vbCr & "Please contact an administrator"
MsgBox error_text, , "No Privileges"

End If

If they click on LOAStatusbtn and their role is not admin, then a message should pop up.

I searched the forum and could not find anything similar to this.

Thank you,

View 4 Replies View Related

Code Before Opening Form To Check User's Right

Oct 23, 2005

Hello Gentlemen,

I am planning to give different rights (AllowEdit, ViewOnly…) to the user on accessing forms and reports in a db on a single pc instead of dealing with server as my client have only one pc.

As a present requirement, db would be in one pc only and would be used by 3-4 users. I need each of users to limit their access to some of the forms and reports in the same pc. To get it, what I did is as follows:

Example:

One of my tables called tblEmployees (Back End Table) linked in FE containing following fields:

1.Unumber- Autonumber
2.UNames - Text
3.Pwd- Password
4.F1- Yes/No
5.F2- Yes/No
6.F3- Yes/No

F1, F2….stands for form1, form2…

There is a login menu form. Something like 2 text boxes on the form and opening at the startup. User selects his name from a combo and types his password. If the user is available in the tblEmployees, Access opens main form and store UNumber and UName with time stamp in a local table called “T_CurrUser. If user not available in tblEmployees, it should close or give some msg.

Now, when the Main form opens (after login with correct user and pwd) and user wants to click different command buttons to open the form, I need to write code to check whether the current user have right to open the selected form (check marked to allow opening this form in the table tblEmployees) BEFORE opening it.

If check mark is set to false on F1 in the table tblEmployees, it means he can’t open form1, and a msg should pop up “Not allowed to view”..Something likes that.

1. I don’t know the code I created with simple if then, where to write ? I mean on which event of form ? On open / On Activate or where. Bcz the code should run before form opens and should check the table whether the user have check mark value true or false.

I tried to write the following code but some time it works some time doesn’t. What is wrong with code lines?

On Click of Command Button that opens Form1

Dim USR = DlookUp(“lngEmpId”,”T_CurrUser”) ‘ Local Table emp.

‘To check if Form1 check mark is set to true
If DlookUp(“F1”,”tblEmployees”,”lngEmpId=USR)=True Then
Docmd.OpenForm “Form1”
Else
End If

When another user logs on the same pc (off course, after login out of first user) the local table T_CurrUser record will be replaced with new user. Note that local table T_CurrUser contains always one record. Hopefully I described correctly.

Any idea will be respected.

With kind regards

Ashfaque

View 3 Replies View Related

Form Opens To Records Only For Specific User?

Nov 7, 2005

I have a User Main Menu as seen below with the command buttons for New Work Log Entry and Edit Work Log Entry. The New Work Log entry opens a blank Work Log as shown below. The Work Log form's record source is tblWorkLog. The user will fill out all the fields except the End Page and Total Worked Pages. The user will then exit out of the database. When ready to enter the total worked pages the user log back in to the db and will click on the Edit Work Log Entry.

This is supposed to open up the last entry the current user was working on so that he or she can enter the End Page and Total Worked Pages

Currently it is opening up the last entry of the table even if it was a different user's.

How can I change this? I need it where it opens up the last record for that person. There are going to be 50 users so I can't have it open up to the last record of the table.

Any help will be apppreciated.


http://img.photobucket.com/albums/v332/youmnac/UserMenu.jpg

http://img.photobucket.com/albums/v332/youmnac/WorkLog.jpg

View 2 Replies View Related







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