My Users Keep Accidentally Closing Access - Need Ideas
Jan 15, 2007
Hello.
I have a fairly complex database with a lot of charts, reports, forms etc.
My problem is that whenever someone chooses to maximize a Pivotchart, a report preview or other things, they usually click the big X button in the top right hand corner and close Access entirely. They don't think to click the smaller x button right below it.
This is frustrating when they just want to go back to the switchboard to performs some other task. They have to restart the database, log in...etc.
I know you can prevent forms and whatnot from being maximized, but I do want them to have that feature for a number of reasons... especially with my Pivotcharts. They are much clearer when expanded to full-size.
Is there a solution to this problem, or do my users just have to be more careful?
Thanks in advance
View Replies
ADVERTISEMENT
Mar 2, 2007
Hi guys,
I've had this problem before.
The debug window will open and stop at a line of code even though it has no breakpoint.
Any suggestions please.
Thanks.
View 2 Replies
View Related
Jun 13, 2005
Has anyone seem the problem when you close an access database and you think it is close but if you open the task manager you will see MSACCESS.EXE still running. Why ????
Jon
View 13 Replies
View Related
Feb 12, 2005
I want to put a button on my form which closes access i.e when i click it the access application closes and I go to desktop directly. Is there anyway I can do that.
Regards
Rahul
View 2 Replies
View Related
Jan 27, 2005
I want it to make it impossible to close my access application (mde file) through
the normal way (the x on top must be shut off)
greetings
Koen
View 4 Replies
View Related
Mar 3, 2005
Is there a way to close access from a form?
I know you can close the database, but is there also a way to close the entire programs with a button on a form?
Thx in advance,
Lion85heart
View 1 Replies
View Related
Sep 27, 2007
I have recently done a fresh install of access 97 to our 2003 server. I load up an access app, it brings up a form with a button...I clidk the button, and it closes the app with no errors, and leaves the ldb file in tact. Checking the event viewer, I get this message:
Faulting application msaccess.exe, version 8.0.0.5903, faulting module unknown, version 0.0.0.0, fault address 0x00202878.
It appears to be on the buttons that open forms / reports, but not those that run queries. Any ideas?
View 8 Replies
View Related
Feb 21, 2007
where do I add a closing string into this code and what do I write? The server said the database is not closing the access database correctly and i don't know what is wrong.
<configuration>
<appSettings>
<add key="connString" value="~/protected/pedalcardb.mdb" />
</appSettings>
<system.web>
<!-- DYNAMIC DEBUG COMPILATION
Set compilation debug="true" to enable ASPX debugging. Otherwise, setting this value to
false will improve runtime performance of this application.
Set compilation debug="true" to insert debugging symbols (.pdb information)
into the compiled page. Because this creates a larger file that executes
more slowly, you should set this value to true only when debugging and to
false at all other times. For more information, refer to the documentation about
debugging ASP.NET files.
-->
<compilation
defaultLanguage="c#"
debug="true"
/>
<!-- CUSTOM ERROR MESSAGES
Set customErrors mode="On" or "RemoteOnly" to enable custom error messages, "Off" to disable.
Add <error> tags for each of the errors you want to handle.
"On" Always display custom (friendly) messages.
"Off" Always display detailed ASP.NET error information.
"RemoteOnly" Display custom (friendly) messages only to users not running
on the local Web server. This setting is recommended for security purposes, so
that you do not display application detail information to remote clients.
-->
<customErrors defaultRedirect="error.htm" mode="RemoteOnly" />
<!-- AUTHENTICATION
This section sets the authentication policies of the application. Possible modes are "Windows",
"Forms", "Passport" and "None"
"None" No authentication is performed.
"Windows" IIS performs authentication (Basic, Digest, or Integrated Windows) according to
its settings for the application. Anonymous access must be disabled in IIS.
"Forms" You provide a custom form (Web page) for users to enter their credentials, and then
you authenticate them in your application. A user credential token is stored in a cookie.
"Passport" Authentication is performed via a centralized authentication service provided
by Microsoft that offers a single logon and core profile services for member sites.
-->
<authentication mode="Forms" />
<!-- AUTHORIZATION
This section sets the authorization policies of the application. You can allow or deny access
to application resources by user or role. Wildcards: "*" mean everyone, "?" means anonymous
(unauthenticated) users.
-->
<authorization>
<allow users="*" /> <!-- Allow all users -->
<!-- <allow users="[comma separated list of users]"
roles="[comma separated list of roles]"/>
<deny users="[comma separated list of users]"
roles="[comma separated list of roles]"/>
-->
</authorization>
<!-- APPLICATION-LEVEL TRACE LOGGING
Application-level tracing enables trace log output for every page within an application.
Set trace enabled="true" to enable application trace logging. If pageOutput="true", the
trace information will be displayed at the bottom of each page. Otherwise, you can view the
application trace log by browsing the "trace.axd" page from your web application
root.
-->
<trace
enabled="true"
requestLimit="10"
pageOutput="false"
traceMode="SortByTime"
localOnly="true"
/>
<!-- SESSION STATE SETTINGS
By default ASP.NET uses cookies to identify which requests belong to a particular session.
If cookies are not available, a session can be tracked by adding a session identifier to the URL.
To disable cookies, set sessionState cookieless="true".
-->
<sessionState
mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes"
cookieless="false"
timeout="20"
/>
<!-- GLOBALIZATION
This section sets the globalization settings of the application.
-->
<globalization
requestEncoding="utf-8"
responseEncoding="utf-8"
/>
</system.web>
</configuration>
View 1 Replies
View Related
Jul 16, 2007
Recently Access has started to suddenly close. Usually when I have been developing although I do not appreas to have lost anything as I Save, Save, Save all the time. Last week I had a report that a live access 2000 is doing the same thing. Users are in the middle of entering data and suddenly the database is gone, with no messages. They can re-open the database and continue.
Anyone else experiencing this problem with Access 2000?
View 4 Replies
View Related
Jul 15, 2015
How do I close a .pdf file using Access code? There has got to be some simple line of code that will do this.
I know the location of the .pdf. There has to be something like:
CloseFile(filePath.pdf)
View 14 Replies
View Related
Apr 17, 2012
I'm using Access 2000 and every time I shut down my database, it takes ages (the screen locks up) and it creates a duplicate copy of the database.
I seem to recall it saying, on a few occasions, that it was something to do with a "Read Only" file;
View 5 Replies
View Related
Aug 30, 2005
Greeting,
- i have a form, that has a List Box coming from a table ,,
This list box when you click on it, it shows that field in the main form
- and i have a front end and a backend to this database,
- When i add a new entry in my main form, it shows in the List Box just fine, but when i click on that list box, it doesn't show the entry on anyone else on the network - works ok locally
here is an eg: my main table has firstName, LastName, PhoneNumber, Address
Form : main form has firstName, LastName, PhoneNumber, Address
List Box inside my Form has: First Name
so i when i click on the firstName in my list box, it will show me the contact person in my main form
as i mentioned i have couple of people has the database open (split Database) anyone on the network, could see the update on the list box , but when they click on the new created name doesn't show in the main form, unless you close access, and reopen it again
i hope i was clear expaling,
any idea on how to have the List Box update itself without closing and opening Ms Access ??
thanks in advance
View 3 Replies
View Related
Feb 14, 2007
server administrators have expressed concern about my website that it is having a negative impact on the server.
He said this typically occurs when a website has a memory leak (where it obtains server resources and doesn't release them) or is opening database connections and not closing them until the point where no more are available.
I'm using asp.net to control Access and open the connections.
I don't know why it isn't closing them? the website is:
pedalcar.com
Any thoughts of what the problem is and what the statement I need to close the connections?
View 2 Replies
View Related
Oct 21, 2013
I have a Access 2010 DB. The mainform have a subform with one table alone.
I have a button who close Access when the user are finish on the mainform. Still I have the upper right corner X-button who also closing the app.
My problem is that when the user use the X-button then a dialog box appear and ask for saving the changes for the table in the subform on the main form. The user must then do the choise 'yes' , 'no' , 'Cancel'.
There is no need for this dialog box, (I take care if it's necessary earlier) but I can't get rid of it.
View 12 Replies
View Related
May 25, 2015
I want to delete an excel file from within access vba. Problem is that if the file is open, it obviously cannot be deleted. so I need to check to see if that specific excel workbook is open and if it is, I want to close it before I can delete it.
All of the answers here involve creating an excel object and opening it before closing it. If I do that all that happens is a second instance of the workbook opens then closes leaving the originally open workbook still open.
Sub xx()
Dim XLapp As New Excel.Application
Dim ObjXL As Excel.Workbook
Set ObjXL = XLapp.Workbooks.Open("C:dropboxexcelimport.xlsx ")
ObjXL.Application.Visible = True
[Code] .....
The above code demonstrates my problem, if the import.xlsx file is already open then the code just opens another instance of this workbook and then closes it again leaving the original workbook open and as such cannot be deleted.
View 3 Replies
View Related
May 8, 2013
On a pop up form I have a list box. The row source for the list box is
Code:
SELECT tblWebOrder.WebOrderId AS [Web Order No], tblWebOrder.CustomerWebOrderNumber, Format([WebOrderDate],"dd/mm/yyyy") AS [Order Date], tblCustomer.CustomerName AS [Customer Name], tblArea.Area FROM (tblCustomer LEFT JOIN tblArea ON tblCustomer.[PhysicalAreaId] = tblArea.[AreaId]) INNER JOIN tblWebOrder ON tblCustomer.CustomerID = tblWebOrder.CustomerId WHERE (((tblWebOrder.Processed) Like [Forms]![frmSelectWebOrderToOpen]![txtOrderStatus]) AND ((tblWebOrder.WebOrderDate) Between [Forms]![frmSelectWebOrderToOpen]![dteStartDate] And [Forms]![frmSelectWebOrderToOpen]![dteEndDate]+1)) ORDER BY tblWebOrder.WebOrderId DESC;
I have the following "On Click"event on the list box
Code:
Private Sub lstWebOrder_Click()
lngWebOrderId = Me.lstWebOrder.Column(0)
DoCmd.Echo False
DoCmd.Close
DoCmd.Echo True
End Sub
When I click on some of the records on the list box the form closes. On some of the records I get a parameter prompt to enter:
Forms!frmSelectWebOrderToOpen!txtOrderStatus
Forms!frmSelectWebOrderToOpen!dteStartDate
Forms!frmSelectWebOrderToOpen!dteEndDate
I inserted the echo commands to prevent this, but this has not worked!
Why am I getting the prompts? How do I prevent them?
View 4 Replies
View Related
Nov 19, 2013
I do not have a split db. I am prompted to enter my password when the db opens which is fine. However, when I close the db it prompts me to enter a password (not normal) and when I enter it it says invalid password. Also, when I try to change my password it says invalid password and when I try to compact and repair my db it say invalid password.
View 1 Replies
View Related
Sep 4, 2014
I have MDB database linked to SQL SERVER through VPN connection.I created links to the sql server Links are dsnless..Everything works fine but when I lost VPN connection or sql connection has been broken I can't refresh links to the tables.I receive message 3146 sql connection failed..I must close database and start again...
I tried different methods like ado,dao, and vba docmd.transferdatabase,aclink... but no success, table cant be relinked.
Only way I can relink is to change ip adress in conn.string
E.g. 192.124.0.2 (1st ip- router server ip) and after connection failed i can use 192.124.0.32 (2nd ip - server local ip) and that's it if i lost connection for the 3rd time... i must restart application.
It seems that access database keep the previous connection..how to reset or drop database connection to the sql server and refresh links to the tables with vba code without closing access database...
View 12 Replies
View Related
Jul 22, 2005
I need some ideas on this new database that I am creating. I'm creating a database that will store employees clock in and clock out times on a weekly basis. The main table has the following fields: ID, employee name, date, clock in time, clock out time. The employee name field source is another table that has the list of all the employees names.
I need to create a form that will allow the user to easily input the clock in an out times during a week for each employee. The user will pick the employee name from a combo box. Then, on this form, I want it to have all the days of the week (sunday thru saturday) in a column format and in front of each day one field for the date and two fields for the user to input the clock in and out times respectively.
The problem that I am having with this right now is that, the form that I created only displays one record at a time, so it only shows the clock in and out times for one record. How can I get the form to diplay several records at a time so the user can add all the days of the week for certain employee on the same page?
Or is there a better idea on how to create this database?
Thanks in advance,
Earl
View 10 Replies
View Related
Jul 13, 2006
i have get data from the sources i dont know yet but i can either import or link using access and create reports that way and or juts use crystal to connect to the data sources...any ideas?
View 1 Replies
View Related
Jul 18, 2007
Hello everyone.
I have just made up a database for work, it is a basic stores system where people have to book in and out the items to update the quantities manualy. I have a tick box for "on demand" which i have linked to a query for all items on demand etc.
I am just wondering if anyone can suggest any good ideas that would make the database even better, more automatic type things would be good.
We have a demands for which is just a word document I was wondering if there was anyway I could use it someway so that with one click the items that requiring demanding are put onto the form?
i am just looking for any ideas that would turn my database from good to great.
I hope that you can help
View 5 Replies
View Related
Mar 25, 2008
Hello all, glad to be here
I wanted to bounce this idea off the members in the forum, its more along the lines of managing multiple databases rather than individual design.
I am a recent incumbent at a position where there are many individual access database files for the department. (Each DB is unique as are the users, usually) I am trying to flesh out ideas on how to consolidate these access files, so there is one central 'hub', where users could log on, and then select the study or project associated with that particular database, and then the DB be opened for them to begin working, rather than the current system, in which there is a rabble of access mdb files in multiple folders
any ideas are appreciated :D
View 9 Replies
View Related
Dec 9, 2004
I have decided to amend a database because my original design was rubbish!!
Why? Currenlty a user selects a ServiceID from a combo:
SELECT tblServices.ServiceID, [ServiceCategory] & "-" & [VehicleType] & "-" & [ServiceType] AS Expr1 FROM tblServices ORDER BY [ServiceCategory] & "-" & [VehicleType] & "-" & [ServiceType];
That produces:
Car-Larger-Wash
I have added a new table to the DB to list car makes and models.
The user will select a car make and model from one field (combo) on a service form.
From the next field they will selct the service to be performed on the selected vehicle i.e. Wash / Vacum / Full Valet
My dilema? I can not think of a relationship for the new table 'tblVehicles'?
Any suggestions?
Should I add a new field to tblServices?
Cheers,
Phil.
View 14 Replies
View Related
Dec 28, 2006
It's been a LONG time since I've designed a database, but it's slowly coming back to me. However, I'm still having a very difficult time deciding the most effective way to setup my tables and queries. Here's what's going on.
The database will be used for FFA livestock shows to enter the exhibitors for market classes and showmanship classes. The database also needs to be able to break a pay scale down showing how much each exhibitor is awarded for their showmanship class and their market class. The database that the club had been using had 2 tables (1 for the exhibitor and 1 for the animals being shown). Then they had 10 different queries that sorted the animals into weight groups (ex. Class 1 is weight between 90lbs and 100lbs); and then they had 10 different queries to breakdown the showmanship classes (ex. Showmanship Class is is age between 5 and 7). This is a LOT of queries! Now, the manager wants to be able to have more than 10 classes, which their current database cannot do. He also likes to be able to enter the parameters to manually break the classes. As of now, he is manually going into each query and editing the criteria for each class, but he wants to be able to do that from a form.
So my question is.... is it best to leave this in the "multi-query" form, or is there some way I could arrange all of this from tables or from a couple queries... and also, what would be the best way to offer the option to add a new class?
Any and ALL advice is greatly appreciated!
~ Audrey
View 10 Replies
View Related
Feb 22, 2005
I am trying to find the best way to program a timeshare inventory. Here is the problem, one unit has the possibility of being sold annually, odd or even years. If the unit is sold for just even or odd, I then need the open inventory to reflect the opposite year that is available. If the unit is sold annually I need it to be removed from open inventory totally. Also, If the unit is returned I need it to show-up back in open inventory.
Does anyone have any ideas of how to make this work simply?
View 1 Replies
View Related
May 11, 2005
last ever question, i need a long hloiday
it errors on: theId = ctl.Column(0, v)
Private Sub Monthly_MD_Report_Click()
'Run a report displaying only the records chosen
'by the user in the form's listbox.
Dim v As Variant
Dim Frm As Form
Dim ctl As Control
Dim theId As Long
Dim WhereCrit As String
'If nothing is selected, notify user...
If Me.List101.ItemsSelected.Count = 0 Then
MsgBox "Please select a month.", vbExclamation, "No Month Selected"
'and then scram.
Exit Sub
End If
'Assign form and control to object variables.
Set Frm = Forms!FrmForm
Set ctl = Frm!List101
'Begin building Where string.
WhereCrit = "Expr2"
'Add each selected item to the WHERE string.
For Each v In ctl.ItemsSelected
'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~
'The first column in the list, holding SupplierID, is hidden.
'See the list's "Column Widths" and "Column Count" properties in
'its property dialog and look up the terms in Help for more info.
'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~
'Coordinates: 1st column (0); row v
'where v changes for each round of the loop.
theId = ctl.Column(0, v)
'Tag on to string.
WhereCrit = WhereCrit & theId & " OR Expr2 "
Next v
'Loop ends; selected items are now accounted for...
'NOTE: To better understand what the code is doing, uncomment the
'next line to print the Where string to the Immediate window.
'Debug.Print WhereCrit
'Clean-up the Where string by removing the trailing text.
WhereCrit = Left(WhereCrit, Len(WhereCrit) - 17)
'Test (see note a few lines above).
'Debug.Print WhereCrit
'By default, the Suppliers Report returns all records from the Suppliers Table.
'Here the Suppliers Report is opened using the 'Where clause' to filter it down
'to only the items selected in the listbox.
DoCmd.OpenReport "MD Form", acViewPreview, , WhereCrit
End Sub
View 4 Replies
View Related
