I have the following set up:A table in access for PurchaseOrders
-A table in access for ShipmentDetails, PK linked to PurchaseOrders OrderNumber
-A table in access for payments, an index linked to the PurchaseOrders OrderNumber
-An SQL database table of purchase order details from our existing system, linked to PurchaseOrders OrderNumber
Now, I create a new record in PurchaseOrders with OrderNumber="ABCD01". All good.I create a new record in ShipmentDetails with OrderRef= "ABCD01". Still good, creating a form and adding fields shows the data is linked correctly.
I now add the CreditorCode field from the linked SQL DB, it automatically shows like it should.I try to use the form to delete the "ABCD01" record from the PurchaseOrders table and it deletes the record FROM THE SQL DATABASE! It's basically acting like Enforce Referential Integrity is turned on with deletes. This backend DB is used by other programs. I don't ever want my app to modify it.
I have deleted certain content from a table. After it I have compressed and repaired the database but later I found out that I need those deleted data. But now they are gone. Is there any possibility to recover it? Are there any tools or something?
I have deleted certain content from a table. After it I have compressed and repaired the database but later I found out that I need those deleted data. But now they are gone. Is there any possibility to recover it? Are there any tools or something?
I had an inquiry from a semi paranoid client regarding retrieval of deleted data within an Access mdb. In Windows if you delete a file from the hard disk then most probably this file is only marked as deleted, but is not actually deleted until something is written over he space that the file occupied and is recoverable.
In an Access mdb file if we delete a record and do not perform any write action, is there any chance that the deleted record is only marked for deletion and can be recovered? Would compact make the deleted record non-recoverable? Is there any other way to make sure that when something is deleted that it is not recoverable?
Am trying to import data into a blank database (MS access 2013). The import operation is successful. But the data in the tables gets deleted after a while. And all I can see are blank tables in Access 2013.
I'm new to form design and do not know any VBA (but that won't stop me from messing with the code when need be).
I'm creating a form that will serve as the user-interface for viewing, adding, and deleteing data.
The product I want is a form with 3 items: a subform that displays data in a table (so users can see all the data), a button that links to a second form for adding data, and a button that allows users to delete data.
I've gotten close to accomplishing this with the exception of the delete option. The hang-up is due to the fact that the subform that displays all the data is the output of a query (can't delete data through the query). A friend who used to work with Access years back was trying to solve this issue by writing code that would identify the primary key of the record selected in the subform/query and then adding code that would use this extracted primary key to delete the record in the original table.
This seems like a slightly convoluted approach. Any suggestions how I can get the product I'm looking for?
I wrote a SQL query that works fine. But when I call a custom function to export it to Excel, my query SQL will get deleted (not consistent). All that is left of the script is SELECT;
MS Access 2007, Windows 7.
Here's how I call the function:
Code: Private Sub exportQryCustStatusAnalysisLite_Click() Call ExcelSmsOutput("Query", "qry_custStatusAnalysisExport", "qry_custStatusAnalysisExport", Forms![frm_main].[filePath]) End Sub
Here's the custom function:
Code: Public Function ExcelSmsOutput(objectType As Variant, prefixFileName As Variant, objectName As Variant, filePath As Variant) Dim outputFileName As String outputFileName = prefixFileName & " " & Format(Now(), "yyyy-mm-dd hhh mmm sss")
On a data entry form bound to a single table, there is a subform displaying all the records in the source table.If the user accidentally adds a record that they didn't mean to add (or if I add a record to test the form's functionality), and then right-click and delete the record, "#Deleted" appears in all the input controls.
I had created a query that I was attempting to reference a text field in a form that was open when the query is run. It wasn't working and whenever I opened the form it would prompt for the parameter before opening the form.
I ended up deleting the query to try again from scratch. But the form still asks for the parameters whenever I open the form. Why is Access still prompting me for the parameters?
I have a main form with several linked by ID worksheet sub-forms. I would like to add a on-click function to delete the main form and all related record on each sub-form. I have tried several methods but nothing is working correctly. The cascading delete function is not available as part of the form relationships. How I can accomplish this?
The BE of my db is located at my PC. FE are then accessed by 3 of my staff on a shared folder. To check how high the security of my dbase is, i opened the folder where the BE lies on one of the user's workstation and tried to delete it. Can't believe IT WAS DELETED!!! Why??? It should have been addressed by "User-Level Security Wizard", right??? I'm using Windows XP, Office 2003.
I am so stupid! I just deleted the whole code for a form!! I had two days of work in it! I was creating a new form similar in layout to the original and had copy-pasted. i then deleted all the code from one of them, and then the other one by mistake!
Does windows store this stuff temporarily anywhere? can someone please help!??
I enter records into MS Access and then when I close it and reopen it, every once in awhile records that I entered previously are deleted. I am new to Access so it may be a simple problem such as saving the database but it is extremely frusturating when I enter customers into a database and then reopen it to find out voila half the customers I entered are not there. If anyone can help me it would be really appreciated. Thank you.
Screen view of Database Diagram (http://64.122.37.190/images/diagram.jpg)
Screen view of problem view (http://64.122.37.190/images/viewshifts.jpg)
I am working with a Access Data Project and MSDE database server. In the image you can see the tables that I am working with. I have a table, tblShifts, that has all of the shifts with clock in and out times for all buildings. I am trying to downsize this list to include only buildings that the user is matched with in tblManagerBuildings by using SUSER_SNAME() to get there current username. Seems easy enough.
Only I can't get it to work. It does give you only shifts in the buildings that you are assigned to. But when you go to delete or insert wierd things happen. If I have the query set up as it is in the "Screen view of problem view" link I get an error "The field 'shiftnum' is read-only" when I try to insert or delete. So I tried another way. First I set up a view that gives you all of the buildings that you have access to.
View all of the user's buildings (http://64.122.37.190/images/viewMyBuildings.jpg)
Then I connect that to tblShifts and get all shifts in the user's buildings:
Shift table connected to user's buildings (http://64.122.37.190/images/viewShifts2.jpg)
If I output the BuildingNum column when you go to delete a record nothing happens. If I output the username column I get the "The field 'shiftnum' is read only" error. If I don't output any of the columns from viewMyBuildings then when I delete a row it Deletes the Building and the User from ALL of the tables. Including all of the shifts associated with the building. AWWW! I know that this is possible. My problem is probably with having a many - to - many relationship, but I have been working on the for a day and a half and I think I took care of the many to many relationship properly. If anyone has any input PLEASE HELP!
Hi everyone I have a problem that I have deleted some records from a table in my database and now after one week I need these records again. Can someone tell me how to get them?
We have a massive db and on one of the screens the users can scroll through the records and view information they can also add new records. When the users enter the new record and go back to it it has been successfully stored in the relevant table even on exitin the form via the exit button (DoCmd.Close). However from time to time when the user enters the new record and closes the for via the close form button the new entry is not stored in the table and seems to have been deleted or not appended to the table.
We have no idea why this is happening as it doesnt happen all the time just from time to time.
Can anyone help please or has anyone come across this before !
Someone created a form and then deleted it. When we try to use the find button on other forms, it keeps looking for the deleted form. When I look in visual basic, I can still see the removed form listed, but it is not visible on the form page for me to delete. How do I get rid of this residue.
Can someone please help me. I was in the code view of my database and accidentally deleted a few lines of code and now everything i do is coming up with the same error message
Module Not Found
For every form I try to open it does this and even my buttons to close form and to exit system do not work.
Has anybody had this problem before?
Would anybody mind taking a look at it if I sent a zipped version? my email and msn is nicholaseary@hotmail.com
Hi I would like to prevent the first 24 rows in a table from being deleted by the user, after these 24 rows they can be deleted. Is there anyway of protecting them etc without putting them in a separate table?
This is my first post here and I imagine there will be many more as I have only just started out using Access to create a database at work and I am sure that I'm breaking many rules along the way.
Anyway, over the weekend, my boss tried to add some information (to the "Memo" field) in a form that I have created from a table, went to close the form and got a message saying something along the lines of "this record cannot be saved, if you close it, information will be deleted.
Now, in the Memo field, is the text "#Deleted" - when I try to overwrite this and come out of the record, it comes up with the message "record is deleted". If I put information in any other field in the record, there is no problem.
Also, in the table, if I try to sort by the Memo field, it comes up with same message, "record is deleted".
Does anyone know what I've done and how I can solve this?
I have a table with a blank record at the begining and populated records thereafter. I used the cmd button wizard to create a delete button for that table. Is there a way to prevent the blank record (record 1) from being deleted by the command button but still allow all other records to be deleted?
Hello, I've got a table that looks something like this: deviceID | name | ... 1 | a 2 | b 3 | c 4 | d 6 | e
where deviceID is an autonumber. Clearly device 5 got deleted, but if I go to "add record" I end up adding record 7. There are still other records in the db which need to link to device5, and I have all the info needed to recreate them, how do I override the autonumber and create a record with a specific deviceID?