General :: Disable Home Screen For Front End Users?
Jul 23, 2014
I have a database that logs people in and out. Works great unless the user minimizes the navigation page and clicks the X on the main Access Page. I have to keep the minimize button active on my nav page.
Is it at all possible to disable the main access page for the user?
If not, is it at all possible to set a logout macro to the X button on the main page?
If not, is it at all possible to set a logout macro to activate on "Quit Access"?
View Replies
ADVERTISEMENT
Jun 8, 2012
Is there anyway to diasble the window that has the circle in the left hand. When I open my database I just want the form to open. I dont want the window with the toolbars to open it jus gets in the way an is more of a hassle to deal with.
View 3 Replies
View Related
Apr 12, 2013
How do I hide or disable the File tab in Access 2010 on my front ends?
The file tab being present allows end user to get into Privacy Options and Printing. Printing is okay if I could disable the Privacy Options for end users, then it wouldn't matter if they have access to the File Tab.
Possible very serious security issue!
View 2 Replies
View Related
Aug 12, 2013
Currently the system where I work is set up so that everyone has their own front end on the local network. I would like to change this because updating all of them takes a lot of time for me and skill level for users is too low for me to trust them with updating it on there own.
My question is this:
If I were to create a shortcut on everyone's desktop that linked to one front end would this be wise? I can't seem to get a straight answer from anywhere on the internet. I know most places say that it is better to have the actual front end on the staffs computer but that would make my job of keeping the database updated even worse because staff have multiple computers and this isn't my full time job.
If this is okay practice how many users would this be able to sustain? Currently we only have 6 users on the database with there own front end and it works great. I am planning on adding around 10 more users in the future but if needed they could have there own database as they are separate programs.
View 14 Replies
View Related
Oct 22, 2012
I've prepared a front end database with forms that allow data to be keyed into linked tables to my main databse.
However, currently the front end database only allows 1 user to do it at 1 time and when another user tries to open the file, an error "The Database Has Been Placed in a State by User on Machine That Prevents It From Being Opened or Locked'
Is there anyway to allow multiple users to use the front end database at the same time?
View 11 Replies
View Related
Aug 7, 2014
I have been trying to set up a batch file to allow users to copy the latest version of the front end whenever a change is made. The following is the code that I am trying to get to work properly. The first part works fine, the old front end is copied to a folder on the user's desktop as a backup. But I cannot get the copy of the server - the "P" drive, to overwrite the current copy on the user's desktop. Actually I cannot get the code to copy the new front end from the server and install it on the user's desktop. I think the path is correct for I seem to be able to run the new front end from the server.
When I look for the location on my computer, the server locations is listed as:
General (Servernamefiles) (P: ) (there is no space after the P: it seems to result in a smiley face when I type it and try to post it).
for /f "tokens=2-4 delims=/ " %%a in ('date /T') do set year=%%c
for /f "tokens=2-4 delims=/ " %%a in ('date /T') do set month=%%a
for /f "tokens=2-4 delims=/ " %%a in ('date /T') do set day=%%b
set TODAY=%year%-%month%-%day%
rem echo %TODAY%
[Code] .....
This code works so I thought that the path was correct
rem this works
rem start the new DB front end
Start P:AccessMainSplitBENewFrontEndDBMain.accdb
But this code does not.
echo f | xcopy /f/y/ P:AccessMainSplitBENewFrontEndDBMain.accdb c:UsersUserNameDesktopDBMain.accdb
Neither does this:
echo f | xcopy /f/y/ ServerNamefilesP:AccessMainSplitBENewFrontEn dDBMain.accdb c:UsersUserNameDesktopDBMain.accdb
View 2 Replies
View Related
Mar 11, 2013
I use Access 2007.I have a db split in FE(forms, queries, vbcode) & BE(tables only).I want users not to be able to view or explore the tables, the queries, the form design and details, in both Ends.Unfortunately, even disabling via VB code the menus, the db window, the tool & status bars, they appear and are accessible to the users (it only works in a non-split db, turned to an accde).
How can I disable any view on forms, queries, vbcode and tables details and data to users, in both FE and BE and only allow them to add data through specific form?
View 11 Replies
View Related
Feb 10, 2014
I am in Microsoft 2013 and using an .accde file. The problem is that the File menu and Home ribbon are still accessible, and the File menu can be used to change settings that will let the user get into the linked tables (on SQL Server).
View 2 Replies
View Related
Jun 16, 2013
i have created a login form that opens the home page when the correct credentials are entered. i would like to add an 'access level' so that when logging in the database checks the access level and opens the appropriate home page. (i.e. level one has selected options.. level three has admin)
i just need a code that checks what the users level is and then open home lvl#
(i.e. user level 1 - open 'home lvl1', user level 2 - open 'home lvl2 etc)...
View 5 Replies
View Related
Jan 20, 2014
I am currently developing a database to provide a friend with an auction tracking and ordering system.
I will have a number of questions the first is related to the Home Page/Dashboard/Summary form I am creating. I basically have a few sections, one of which is a combo box offering the user to select an auction to view in the summary section. This summary section contains the list of lots but I also hope to to expand on this and create multiple text boxes, each containing the answer to a number of queries (totals etc).
I have written all the queries and can see the results however as the form does not have a record source I would like to know how to make each text box populate with the result of different queries (ideally in vb - I am using ms access 2010)?
I have tried a few things, control source doesn't apply as I have no record source (i guess). I investigated Dlookup/Dcount but am unsure if these apply for the same reason. I understand I am likely to need a recordset etc in vb and have already tried a few things but unfortunately none of them work.
View 1 Replies
View Related
Dec 27, 2006
Howdy!
I split my db last week and put both front end and back end files in a shared network folder. I backup the db every day to a different folder on the network server and also to my laptop. I usually backup right after a form update so that the latest version of the form is available to users who want to update their local copy of the front end. I've been sending email alerts to the users.
My question is this: What is the best way to (1) make sure my backup updates the front end on the network server and (2) how can I automatically alert users to update to the latest version of the front end?
Thanks gurus!
bugleboy:o
View 13 Replies
View Related
Dec 8, 2011
I have created a switchboard 'front page' through which I hope for users to access the forms for inputting data.
Within this front page I have an 'enter' button - successfully created - everything.
However, I am unclear as to how you activate this, or any other button. I have linked it to the appropriate form and stated the action I want it to undertake, but nothing is happening.
What further instructions do I need to provide ...and where?!
View 5 Replies
View Related
Jun 24, 2013
I want to display the message "Processing Record ? of ???..." on the screen while my vba code is running without interruption. Since the msgbox requires the user to click a button to continue, what is the simplest way to display this message on the screen without interrupting the program or requiring user interaction?
View 2 Replies
View Related
Jul 14, 2015
I am trying to build a Multi Search Screen and just do not know how to achieve this. what I want the application to do is:
1) I Created a main form for data entry called 'Orderfrm'
2) The Orderfrm Field EmpNo - I created a Search Button.
3) Users to enter the Employee No or Surname or FirstName (multisearch) and hit the search button to search for the relevant employee.
4) I would like then to open a 'SearchFrm' with the details of the employee.
5) If it is more than one employee - the system to list them all
6) users will select the correct employee details and finally the system to autofill the details in 'OrderFrm'
I am attaching the database.
View 2 Replies
View Related
Nov 21, 2013
I created a form which fits to my screen resolution. When I open it through an another computer which has different screen resolution then my form is opening according to my 1st screen resolution.
I wanted to fit the form resolution to the desktop on which it it opening. Is it possible?
How to set the form the screen resolution on which the form is opening.
View 3 Replies
View Related
Jun 17, 2013
I have just delivered my front end to the user. I have incorpoated a splash screen which uses the timer event and then a sign-in form opens. Trouble is, when the user opens the FE it just sits there on the splash screen. The Access security won't let the above process run because it stops all VBA until the user shift-starts and clicks the 'allow' button. After that it all works fine until I deliver an updated version and it all starts again. All using A2010. what I need to do to avoid the user having to shift-start?
View 5 Replies
View Related
Jul 27, 2006
I have tried to make a login screen, I have also searched for information and tried some of the examples but, I just can't get one to work.
Is there someone or somewhere where I can get information on how to build one step by step in simple easy instructions....(access 2003).
Also, how do you get access to open all the windows, tables, queries etc in full screen mode.
I have expaneded them and shut it down and then reopened it but they still want to open out of full screen mode.
Thanks, everyone has been a great help in creating my first Access program.
View 3 Replies
View Related
Apr 18, 2014
Is there anyway to bring up the on screen keypad or on screen keyboard from Access when running Windows 8 on the desktop? It would really be useful if someone was on a tablet wanting to input data in a text box if could automatically invoke the onscreen keyboard. By default when running applications on the desktop in Windows 8, one has to manually bring it up. I would like to include a touch option so every time wanted to enter data, they would not have to manually touch display keyboard option. A number pad like in excel for iPad would be even better. If text field would bring up keyboard, if number field, it would bring up number pad.
View 6 Replies
View Related
Aug 13, 2014
Our client has about 10 end users on Terminal Serve, and they occasionally get white screen error. The event log show following error message
"The program MSAccess.exe version 14.0.7104.5000 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Problem Reports and Solutions control panel. Process ID: 51cc Start Time: 01cfb681b4d13efe Termination Time: 0" Event ID 1002.
Server has MS Access 2010 (SP2) runtime installed. The error happens randomly, and happen on a particular form. When user has updated form details, click EXIT button, the white screen occur.
View 7 Replies
View Related
Mar 26, 2013
Is there a means of making an application grow/shrink to accommodate different screen sizes? eg. not all users of a distributed application will necessarily have the same screen size.
View 2 Replies
View Related
Mar 3, 2013
I am in the process of updating a database to 2010 (.accdb) and cannot get past a problem. We are using Access 2010.
I updated the back end data to .accdb with no problem. I can't link the front end to that data without updating the front end to .accdb as well. There are no tables in the front end.
I try to update the front end to /accdb and I get the error message 'You are trying to convert an encoded database. Decode the database, then try again.'
How do I decode the database? I tried setting a password and then unsetting it, but that made no difference. I have not previously encoded the database.
can't finish the update to .accdb data. The alternative is to stay with 2003 MDB data. Is that a bad thing?
View 2 Replies
View Related
Dec 3, 2013
What is the best solution for sharing a front end DB as me having the BE installed at my pc, giving all user the FE and then refreshing table link with BE installed at pc but the problem is that the shared FE becoming slow any option ? as only 5 users using this at a time.
View 4 Replies
View Related
Apr 7, 2015
I'm trying to move a couple tables into the Front End of an Access 2010 database because the drop downs take awhile to load. We have horrible servers at work.
I can get some of them to convert to local table but naturally the ones I really need won't. The only table I want to remain in my backend is "project log data final". I don't even get an error message it just doesn't do it. Why would it not let me convert some to a local table. Does it have anything to do with relationships?
View 5 Replies
View Related
Jan 14, 2013
I have a database system into the back end and front end and then created the accde file with the front end file to give this to users on their computer. The back end being placed on a server with a path of type servernamefolder..I have used the Linked Table Manager to point to the tables server name folderfilename.accdb
but in doing this I get a message Windows cannot access servernamefolder..is this to do Network Rights on the server that I don't have permission to access the server and folder.
View 3 Replies
View Related
May 7, 2013
I have (on a company network) a FrontEnd .accde and a backend .accdb - currently ~ 10 users (some over wifi - slow!)The FrontEnd is becoming a rather large file ~ 10 MB and is also becoming slower.I am looking to separate this in to 3 FrontEnd files as to simplify and to lessen the file sizes etc.
My question is - are there any issues around a 3 x FrontEnd databases all connecting to 1 x backend database holding all the tables - over a network?
View 11 Replies
View Related
Dec 30, 2012
I just split my DB into a front end and a back end. I only want the users to have access to 2 forms in the DB because the form already has buttons that link to all other forms and reports needed. How do I customize the front end view so that they only see these 2 forms?
View 6 Replies
View Related
