Read Only Message When Archive Prop Is Checked
Jun 6, 2005I get the 'this is read only you will not be able to make changes, etc..
whe I open my database. How do i fix it? No one else is in making changes.
ADVERTISEMENT
Read Input Value From Message Alert
Nov 9, 2006ok.. i need to add an input textbox to my message alert..
i have this right now..
Option Compare Database
Private Sub Form_Open(Cancel As Integer)
MsgBox ("Enter the date:")
End Sub
i also need the value they enter to be saved as 'formdate'
then i will assign my date field to that value using something like
datefield = formdate
General :: Exporting Queries - Database Is Read Only Error Message?
Apr 16, 2013I routinely export queries etc from my development database to the 'live' master database used by users. Every so often I get the error message 'The database Mydatabase.accdb is read only'. Then I can't export anything to it. I don't know why it should suddenly become read only. How do I make the database changeable, and not read only?
View 3 Replies View RelatedDeleting Records That Have Been Checked Or Adding A Record After A Checked Record
Jul 20, 2005Hi,
I was wondering how to delete records that have been checked (through a checkbox) in a form...
Also, I want to add a record after the record that has been checked. I only want this ability to add records available if only one record is checked. Otherwise, if more than one record is checked, the "Add Record" button would be disabled.
Any help would be much appreciated.
TIA.
"This Database Has Been Opened Read-only." Message And Fix Maybe?
Jan 29, 2008All,
I'm getting the following message in Access and it's causing all kinds of headaches for the user. Any ideas why it's appearing and how to get rid of it?
Thanks,
Archive Question
May 18, 2005I work for an airline, and we use an Access Database to track all baggage claims. The file is getting pretty large, so we want to remove the closed claims from the main table. Is it better to append the closed claims to a new table, or would it be better to export the closed files to an Excel document?
If I choose the option to Append to a new table, can this be done to a second database or just create an additional table in the existing file?
Any help that you can give, I'd greatly appreciate.
thanks!
Archive Question
Feb 2, 2005I have a form with names and addresses on it that gets its information from a querry. On the form tis a button that operates a tick box to Arcive a record. I also have a list box that finds a record on my database when I click on the name.
My problem is that even though I archive the record and the persons details dont appear, the name still appears in the list box. How can I remove/hide the name from the list box as well. I tried a requery but it didnt work?
Archive, Removing Records
Jul 5, 2005hi
i have a form with various fields, on this form i have an archive button that places certain fields in an archive form. however this does not remove the information from the main form. pls see attached
any ideas, as some will know i'm a newbie
Creating A Digital Archive
Dec 3, 2007Here is a question I have been hammering away at for a while but have not come up with an answer yet.
I am trying to come up with a way to make a digital archive in addition to the access database that i have been working on. Right now I have records for customers and all of their reservations, as this is a travel agency. I would like to be able to save all emails, pdf receipts, and any other applicable files that may pertain to that customer and/or on one level lower, their reservation.
Yes, I have heard of the attachment option in Access 2007, but I am getting mixed feelings about using that to solve this problem. One reason is because I have heard that this can make a database absolutely huge very quickly. (One question I have about that is whether or not that large size ends up slowing down the database or not?) My other concern is that after creating everything I would really like to integrate the database into SQL Server and only use access as the front end for forms and reports. And SQL Server 2005 does not work with access's new handy attachment feature in 2007.
This must be a common need with various businesses, so maybe you all have a few ideas out there. I would love to hear them!!! I am open to anything that solves this problem. Thanks for taking the time to read this and help me out.
Dillon
Archive Older Entries?
Jan 12, 2007Hi, we have a database for keeping record of our games (unreal tournament games).... Its just a simple database and we enter our results based on the following fields: -
Opponent:
Game Type:
Players:
Maps:
Date:
Result:
the file has started to get quite big and wondered if it would be possible to automatically move entries say that were older than a month old to a new table, or archive table. Im not a big access genious so i hope i have explained enough for you to understand what im trying to do here.
Thank you for your time, much appreciated.
Archive Data From Tables
Sep 2, 2004How can I remove (delete) a page from a table (the entire row that has that specific data) and have it go into an archive? I don't want to completely delete the information, but I don't want to have it in my current table and have to have all kinds of filters and other criteria to view in my queries and reports.
View 1 Replies View RelatedPersonnel / Document Storage, Archive
Aug 9, 2007Hi
My database is to have a Personnel data area whereby I can store all relevant details for employees within the company.
I plan to incorporate a feature whereby I can alos maintain a history of documentation written and issued including links to the actual documents for that employee during their time with the company.
Has anyone done a similar thing they would be willing to allow me to use?
I figure this would contain links to work documents stored on the hard drive in a specific folder. Selection of a specific item from a historical list - would invoike Word /similar and display the appropriate file...
Any ideas would be gratefully received.
Thank you.
Exporting Records To An Archive Database
Aug 2, 2005I have been trying to figure out how to do this and the transferdatabase function wouldn't do what I needed. I have a table that has a bunch of records, each being a request for cad work somebody wants me to do. I change the status of each one to pending, working, or complete. Anyway I want to only keep the completed task records in the database for 90 days. After that the records will be exported to an archive database and purged from the working database. The problem I face is not getting the records I need “I used date stamps ;)” but getting the records I filtered to append the archive database table and not overwrite it. I made backups ;) of my db and am testing on those and cant figure this out. Below is the code I used to export. Like I said it overides the table rather than append...
DoCmd.TransferDatabase acExport, "Microsoft Access", _
"X:Archive.mdb", acTable, "tRequest", _
"tRequest"
MsgBox "its done"
Any ideas, pointers, stern words and a link to a post I missed, anything to help is appreciated. :o
Thanks,
Eric
Modules & VBA :: Naming New Archive Table
Jan 8, 2014I have a Database in which I would like to archive data once it is now longer actively being used. I have VBA code that does everything i need it to, however I would like to name the new archive table related to the dates in the data being archived. Below is the code I am using to archive and delete the information from the main table.
Code:
Dim strSQLCreate As String
Dim strSQLDelete As String
Dim strArchiveTableName As String
[Code].....
I know it will be in the "strArchiveTableName" variable, I am just not sure how to pull the dates out of the data being moved. The TestData table holds a date and time for each test, and the earliest and latest dates is what i want to append to the table name.
For example: Currently "tblTestData_A102Archive"What I want "tblTestData_A102_1/1/2012-1/1/2013"
Queries :: Archive Database Query
Jul 8, 2013I need to produce a query that will show only one File and location even though there are multiple records contained within that File. To clarify,
In each individual record I have Id_No, Surname, File_Name, DOB, Location.
I need to shred the file once the person is over 25 years old, but some File_Name have different people with different dates of birth. I would like to display the File_Name only if all of other records in that File_Name are over 25 years. I have attached a picture of the query which I use to find the over 25's
Quality System Archive Resolved Records
May 11, 2006I would appreciate any tips as to how I can archive records where the yes no field named "Resolved" is ticked. These records may need to be retrieved (as opposed to deleted). Any deletion would be made at some time later as part of a manual database maintenance process. Unfortuantely the database is 200 Kb larger than permitted to upload however, I can forward a zipped copy if required. Kind regards. Bernard
View 6 Replies View RelatedHow To Archive Files/ Table Queries In Access?
Jul 31, 2006I have created a form in Access updating the files each month but I need to keep the previous month data as historical record . how can I creat and archiving function / command so that the files that have been updated are not lost and will be kept for future use? thank you for your help
View 1 Replies View RelatedCommand Button To Archive Single Record
Dec 21, 2004I would like to develop a command button that archives the current record displayed in the form - my intent is to move that record from one table to another - a sort of automatic cut and paste from one table to another...can anyone help???
View 4 Replies View RelatedForms :: How To Archive Data In Table With Checkbox
Sep 26, 2014I need to archive some data in a table with a checkbox on a form. I have tenants table & property tables. Sometimes tenants move out & new move in but i don't want to delete information from old tenant. But i can't have duplicate property id's assigned to different tenants.
So I made a checkbox on the tenants form that sets the tenant to active or inactive with a status column in the tenant table. how do i delete only the property ID so i don't have duplicates when the new tenant moves in?
Tables :: Appending Changed Records To Archive Table?
Aug 21, 2014I have a single table database for inventory. Every 3 months or so, some records get changed or updated. My manager wants to keep an archive of all of the records that have been changed so we can go back and look at an history of all of the records. So, My thought is to create an "Archive" table, appended all of the current records to it. Then, when changes are made, create an Append Query, or what ever works, to copy just the changed records from the Main to the Archive table. There are only 200 items in the inventory so it is not a large database.
View 1 Replies View RelatedTables :: Keep Track Of Checking In And Out - Where Archive Data Stored
Oct 3, 2014In the case of a system that keeps track of checking in and out (e.g. library books), where is the archive data stored? If a person makes 30 trips to the library, obviously one record will be the current visit - but where do you keep the 29 other visits?
Do you create a separate table for old check-outs: Current_Check_Out and Archive_Check_Out?
Or do you just leave the data in place and as-is: All_Check_Outs?
Queries :: How To Get Only Yes Checked Box
Aug 13, 2013I created a table (contains ID, Name, almost 20 yes/no checkboxes).
I need to create a query where i specify the ID and it returns the id, name and all the yes checkboxes.
What I got is all the check-boxes yes and no.
Value >=1000 If Checkbox Checked
Aug 5, 2005I've been scratching my head all night, can someone tell me why the attached query doesn't work?
Thanks,
Sup
Checked Out With These Check Boxes
Oct 15, 2006Hello Folks.
I can't seem to figure this one out in a continous form. I have checkboxes where I can check them. If I check any of them, I would like to disable another check box. All this works, but what it does is it disables/enables the check box in ALL the rows, instead of just the current row.
I have attached a sample of my setup. Any help/insight would be appreciated.
If Box Not Checked, Gray Out Next Field
Feb 27, 2008I have a form that has a check box. If the box is checked then I would like the next field to be available for data entry, however, if the box is unchecked, then I wish for the next field to be grayed out and not available for data. I suspect that it is a simple bit of VBA, but I am not fluent in VBA and need help everytime, I find something new. Thanks for all your help.
Regards,
Alan
Checked Out With These Check Boxes
Oct 16, 2006Hello Folks.
I can't seem to figure this one out in a continous form. I have checkboxes where I can check them. If I check any of them, I would like to disable another check box. All this works, but what it does is it disables/enables the check box in ALL the rows, instead of just the current row.
I have attached a sample of my setup. Any help/insight would be appreciated.