When I exit my application I sometimes (about 1 in 5 times) get an error message (see attached jpg). This doesnt make any senese to me as I am closing my application NOT opening it. Is this happening because my mdb is corrupted? (I compact and repair on close)
i'm getting an error that i can't source: "you attempted to open a database that is already opened exclusively by user so and so on machine such and such. try again when the db is available."
i'm getting this when i close the db. the default open-option is shared, not exclusive. this is a single home computer. it doesn't happen all the time but (too) often. any ideas to stop this? :confused: (i've seen a few threads that are all network-related).
1/ I occasionally run into this error: "The instruction at "0x77fc823" referenced memory at "0xfffffff8". The memory could not be "read". Click on OK to terminate program."
Do you know if this error message occurr ONLY on certain computers using Access 2000? Since this error popped up on one of my co-worker but NOT on mine. I even tried to re-install Access 2000 again, but the error message still pop up when tried to open a report. Also, the last three digits of instruction number "0x77fcZZZ" change everytime. Please help!!
2/ For some reason, I was coding VBA on one of the procedure on Form_Load, then certainly Access 2k does NOT let me go in the code of any control. WHY!! I am frustrated!! I tried to go in different way, but does not work
Please help. When trying to launch MS Access 2000 I get an error: " Can't find the database you specified, or you didn't specify a database at all. Specify a valid database name in the command line, and include a path if necessary." When I try to open a valid Access file, the application simply doesn't display anything.Please help to fix the problem. Thanks
hi, I am new to this forum and to MS Acess. i am not a software engineer or in the field of software. I had to learn as much as i could about MS Acess because of a project i worked on. I have a standalone MSacess database and one of the forms is giving me trouble when I try to enter a new record
The form is called frm_fragrances and has information about a fragrance. the frm_fragrances has 4 fields in it and a sub form. the sub form has details about the fragrance
In a new record when I enter the 4 fields and attemt to go to the subform which has details about this fragrance I face this error.
an unexpected error haas occurred @2465: application defined or object defined error.
additional information Active form:<frm_fragrances> Active control:<txt_VendorName> Previous control:<frm_fragrances>@Please call the developer for further instructions
I have looked in the FAQ and on this forum for help on error 2465 and cannot find anything to help me. I can work with forms to an extent but cannot write too much code.
I would really appreciate some help in this matter Thank you
I have setup a small application with front/back end in local network. On client machines i have installed access runtime. Although it works fine but it suddenly quit when there is any run time error while working on client machine. Although on server machine ( where full version is running it didn't close the application ).
What i need is an option to not quit the application completely. As i am not expert in coding of try/catch statements I need a simple solution for time being .
it is possible to Open access application like desk application done with java or vb, or install access application as exe or similar methods. My requirements is to giving a access application to customer with data base for printing an invoice. when he running the aplication he can see access open and tables, queries forms left hand. how to hide these thing ?
I got an error msg on form with closing. I have a main form (SalesReturnOrDamaged) and subform (SalesReturnOrDamagedSubform).
i have used a VBA code on main form Close Command button as per shown in Code Tag. But that is not working and shown an error msg as per screenshot. how to change that VBA code for empty form close without save the record?
Code: Private Sub Close_Click() On Error GoTo Err_Close_Click If Forms![SalesReturnOrDamaged]![SalesReturnOrDamagedSubform].Form![ItemCode].Value = "" Then Forms![SalesReturnOrDamaged]![SalesReturnOrDamagedSubform].Form![Product].Value = "" Forms![SalesReturnOrDamaged]![SalesReturnOrDamagedSubform].Form![MRP].Value = 0 Or ""
We have an extensive reporting application in Access and would like it to be available through a web application. I've went down the road of migrating this application to SQL to use SQL Reporting Services; this is a good tool but I am wondering if MS Access has an easier solution for me other than migration to SQL.
I'm looking for a solution that will make these reports available over the web for many users. Price tag is a consideration...need to know if there is any.
Please help...thanks in advance for any thoughts!!!!
Hello, I have the following code and i don`t know what's wrong Private Sub cmdCautare_Click() Dim strSQL As String, strOrder As String, strWhere As String 'Dim dbNm As Database 'Dim qryDef As QueryDef 'Set dbNm = CurrentDb() strSQL = "SELECT DOSARE.DosarID,DOSARE.DenumireDosar,DOSARE.CodDosa r,DOSARE.DataDosar,DOSARE.Denumire,DOSARE.Data,DOS ARE.Stadiu FROM DOSARE" strWhere = "WHERE" strOrder = "ORDER BY DOSARE.DosarID " If Not IsNull(Me.txtDenumire) Then strWhere = strWhere & "(DOSARE.DenumireDosar) Like '*" & Me.txtDenumire & "*' AND" ' " End If If Not IsNull(Me.cmbStadiu) Then strWhere = strWhere & " (DOSARE.Stadiu) Like '*" & Me.cmbStadiu & "*'" End If DoCmd.Close acForm, "frmPrincipal" DoCmd.OpenForm "frmRezultateCautare", acNormal Forms!frmRezultateCautare.RowSource = strSQL & " " & strWhere & "" & strOrder End Sub Here: Forms!frmRezultateCautare.RowSource = strSQL & " " & strWhere & "" & strOrder The error is the following "Application-defined or object-defined error"
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 ????
Current Situation: Right now when I close a form it will save the data and close.
Problem: When somone goes in and messes up on something and they just want to exit without saving they cant do that. The data could have been changed and one may not remember what it was!
Solution Ideas: I am thinking that a pop up window that says "Save Changes?" Yes/No then have it save or not. Could somone give me the details on how to do this or anything else that would solve this issue. Thanks.
I wish to detect is there any opened tables, queries, forms, reports, pages(item that may potentially locked the table), and close them automatically using VBA. How to do this?
3 small questions I need your help about ACCESS 2003 :
Note: I'm using a workgroup for users access through the network and the .mdb located in PC as a server NO Front-end & Back-end .
1. Is there a software that can close the .mdb interfaces or forms in all users PCs ? for design modification in case of a user left the work without closing the DB. 2. Could the users use the internet OR Intranet for fast or better access to the .mdb ? 3.In case of (Front-end & Back-end) strategy , How can I modify the forms since each user has its own ?
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.
Hello, I need to close a subform to update the controls on it (deleting and adding), and without closing the main form; without using the "visible" propriety.
This is related to some advice I received some time ago <a href="http://www.access-programmers.co.uk/forums/showthread.php?t=64818">here<a>
I am runnign some code, it performs some applications, then, if a Count Field is greater than 1, a form opens as a dialog, displaying some information:
Dim A As String A = "NewForm" If Me.[Count] > 0 Then DoCmd.OpenForm A, acNormal, , , , acDialog End If If Me.Continue = "No" Then Exit Sub
End If
The new form opens, and you can either view it, and click continue, which will run the rest of the code, or you can click quit, which updates Me.Continue to "No", and then it exits.
The problem is, when it exits the Sub, it doesn't really stop the code, it just leaves things kind of hanging. When I try to run the code again, I get:
3321 - The database engine could not lock the table 'NewTable' becuase it is already in use by another person or process.
Another symptom - The original form where I click to start running the code, has two date fields. Normally, when this form opens, they are blank, but when I exit the sub, as above, the previous dates I entered are still sitting there.
i have a continuous form, which on it i have an unbound text box which displays a calculated value. Now my form is sorted in descending order based on the value in the unbound text box.
Now, i would like that when i do some changes, i would like to re-sort the form in real-time i.e. not having to close and re-open the form. I thought of using the after update event of the unbound text box, but as far as i am concerned the after update event of a calculated "never occurs".
Is there any way, in which i can sort without having to close the form ?
When a form is open you can also see on the task bar that the form is open If the user right clicks on the form(on the task bar ) they get the following options minimize , maximise , close.
Does any one know how I can stop the user selecting Close please ?
Does anyone know a line of code I could write that would close all other forms, besides the form the user is working on?
I can't stand it when a new form opens up and the old one is still open. I have written individual macros to close the forms, but that is getting rather cumbersome. Any help is greatly appreciated. Thanks!
when i close the form all the fileds in the forms gets saved to the table. i want it should pop up before closing to save it or not. i have a button on the form to save the fields in the table. which has code
If you've run a query, and still got it open on the screen, does that affect re-running it? As I just noticed mine retained the previous results. So I thought it would be sensible practise, to make sure any open queries are automatically closed. So I'm trying to include some code to do this via the form which calls the queries.
But the code I've written won't work. I get the following error - Method or data member not found (Error 461). Can anyone suggest how the code needs amending to work. I think I must have the syntax wrong.
I've written....
Private Sub Form_Load() DoCmd.CloseQuery End Sub
I was hoping this would close whichever query was active when the form was next loaded.